If and else statement

If and else statement

View Answers

September 6, 2009 at 11:53 AM

Additional details:

The word is referring to the word column.

September 7, 2009 at 10:43 AM

Hi Friend,

Try the following code:

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;

public class SearchWord extends JFrame{
JTextField text1,text2;
JLabel label1,label2;
JButton button;
static JPanel panel;
JTextArea area;
JScrollPane pane;
public SearchWord(){
text1=new JTextField(10);
label1=new JLabel("Enter word");
text2=new JTextField(10);
label2=new JLabel("Enter Description");
button=new JButton("Submit");
panel=new JPanel(new GridLayout(3,2));
panel.add(label1);
panel.add(text1);
panel.add(label2);
panel.add(text2);
panel.add(button);
button.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String word = text1.getText();
String description = text2.getText();
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "test";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
Statement st = con.createStatement();
ResultSet rs=st.executeQuery("select * from search where word='"+word+"'");
String w="";
if(rs.next()){
w=rs.getString(2);

}
if(word.equals(w)){
System.out.println(w);
JOptionPane.showMessageDialog(null, "Word already exist.");
}
else{

int i=st.executeUpdate("insert into search(word,description) values('"+word+"','"+description+"')");
JOptionPane.showMessageDialog(null, "Word is successfully added");
}

rs.close();
}
catch(Exception ex){}
}
});
}
public static void main(String[]args){
SearchWord search=new SearchWord();
search.add(panel);
search.setVisible(true);
search.setSize(300,100);
}
}

Thanks









Related Tutorials/Questions & Answers:
if else statement in java
if else statement in java  if else statement in java explain with example
if else statement in java
if else statement in java  explain about simple if else statement and complex if else statement in java with an example
Advertisements
ELSE STATEMENT!! - Java Beginners
ELSE STATEMENT!!  Hi! I just want to know why doesn't my else statement works? Else statement is there in the code below which is: else JOptionPane.showMessageDialog(null, n+ " is not in the array!");//doesn't work
If and else statement - JDBC
If and else statement  Dear Sir, I had created a statement...); ======================================================= how to create a if and else statement...: ====================================================== Connection c = null; Statement stmt2 = null; try{ //Load the driver
IF-Else Conditional Statement
IF-Else Conditional Statement Conditional Statements are used to carry out actions based on condition. If-Else is also a conditional statement used... the following conditional statement : if statement if...else statement
IF - PHP If and else Statement
IF - PHP If and else Statement in PHP “IF” is a conditional... uses if else statement as a conditional operator. Lets take an example... as many times as you want. Syntax of PHP if else if Statement if (condition
Java if else
Java if else       The if-else statement is one of the widely used control flow statements while... to the programmer to handle the condition based programming. Syntax for if-else:ADS
The else Keyword
The else Keyword        The else is the one more keyword of Java. It is used to specify a statement..., the code after the else keyword is executed. It is an optional part of a branching
If and else if ladder
If and else if ladder  How we can use if and else if statement?  ...) System.out.println("Grater than 100"); else if(i < 50) System.out.println("Grater than 50"); else
if/else statements
if/else statements  I'm having a hard time programming this question: code an if/else statement that test the value of a string variable named.... If the value is "UPS," code another if/else statement that tests the value
for statement
for statement  for(int i=0;i<5;i++); { system.out.println("The value of i is :"+i); } if i end for statement what will be the output   got the answer.. it displays only the last iteration that is "The value of i
If-else not working
If-else not working  <%@ page contentType="text/html; charset..."); Statement stmt=conn.createStatement(); ResultSet rs=null...="SELECT REGNO,SNAME FROM sub_comb WHERE L_category='Lab'"; } else if (Lab
If-else not working
If-else not working  <%@ page contentType="text/html; charset..."); Statement stmt=conn.createStatement(); ResultSet rs=null...="SELECT REGNO,SNAME FROM sub_comb WHERE L_category='Lab'"; } else if (Lab
if else in javascript function
if else in javascript function  How can i write the else statement in JavaScript to check if the web browser is IE or not? Is there any other way to validate this way ..? Thanks
programes on if....else
or not write a program to find minimum of 3 nos using nested if else. write... a program to input score of a student out of 100 and print grades using else...){ System.out.println("Leap Year!"); } else{ System.out.println("Not a Leap
Objective C if else statements syntax
Objective C if else statements syntax  What is the syntax of if else statements in Objective C?   Using of if else statement in Objective C There is no changes in the syntax format of if else statement. You can write
PHP Else Construct
does not met, it means that we place the else construct after if statement and if  'if statement' does not met, then the else part... else part only when if statement is false, it is also true that we can not use
if else condition - Java Beginners
if else condition  Please explain the if else condition in Java programming language
IF-ELSE In JSTL
. In JSTL if-else tag is not implemented directly like the if-else statement... are used as an if-else statement in JSTL programming. Sample code given below... which will demonstrate you how to use the if-else conditional statement in JSTL
switch case instead of if else
switch case instead of if else  How to write code in switch case instead of if else in Java
Java if else condition
Java if else condition  its there any similar condition for (X<=5 || y<=10) please post the answer as soon as possible.... TQ
check condition in if-else block
check condition in if-else block  Hi, I want to update database with following query int i= st.executeUpdate("Insert into text_editor(words) values('"+words+"')"); how can I give a check option so only valid words are inserted
Statement block
Statement block  What is the purpose of a statement block
Nested If Statement
Nested If Statement       In this section you will study about the Nested-if Statement in jsp.ADS_TO_REPLACE_1 Nested If statement means to use the if statement inside the other
using if and else if statments
using if and else if statments  Hello everyone Hope all are well Just new here & already have a question. I have a little veg shop it sells 6... if and nested if and else if This has my head in bits for days I have the below done x6
The Switch statement
it becomes cumbersome to write lengthy programs using if and if-else statements. To avoid this we can use Switch statements in Java. The switch statement is used... of a variable or expression. The switch statement in Java is the best way to test
Use if statement with LOOP statement
Use if statement with LOOP statement   ... if statement with LOOP statement. In this example we create a procedure display... Statement include  a declare keyword that define the variable and its data
jstl if else
like if-else statement in a java programming. It performs conditional operations...In this section we have discussed about how to implement if-else tag in JSTL..., as their is not default value. Hence, if-else tag is not implemented directly but is implemented
Operators; If, Else, Elseif; Loops
3.9.2. if...else statement This statement is used in the statement to check the condition is either true or false. If..else statement execute the code in both... 3.9.3. if...elseif....else statement This statement is used for executing
if statement in php
if statement in php  Correct way of writing if statement in PHP
java if statement
java if statement  If statement in Java
If statement in java 7
if statement with else - If Statement :ADS_TO_REPLACE_1  If statement...) { ...... ......//statements }ADS_TO_REPLACE_2 If -Else Statement : In if-else... that means if you want to write if statement inside the else block then you can
Control Tags-If / Else If / Else
Control Tags-If / Else If / Else      ... are used for flow control such as if, else and iterate.)  'If' tag could be used by itself or with 'Else If' Tag and/or single/multiple 'Else' Tag. Create
PHP Conditional Statement
supports if , else, switch case and conditional operator for this purpose. PHP Conditional Statement Example 1:ADS_TO_REPLACE_1 <?php $a=12; if($a>..._TO_REPLACE_5     echo "\$a is greater than \$b"; else
ModuleNotFoundError: No module named 'maybe-else'
ModuleNotFoundError: No module named 'maybe-else'  Hi, My Python... 'maybe-else' How to remove the ModuleNotFoundError: No module named 'maybe-else' error? Thanks   Hi, In your python environment you
prepare statement
prepare statement  sir i want example of prepare statement
javascript statement alert
;/script> JavaScript Alert else if Statement <script type="text/javascript...javascript statement alert  JavaScript Alert If Statement   JavaScript Alert if Statement <script type="text/javascript"> <
else if (selection = * 'M'); - Java Beginners
else if (selection = * 'M');  I am trying to get 2 numbers 2 multiply and i keep getting this error illegal start of expression else... + number2)); else if (selection = - 'S') System.out.println(number1
difference between prepared statement and statement
difference between prepared statement and statement  i mean in prepared statement we write insert command as INSERT INTO tablename VALUES(?,?) but in normal statement we write insert into tablename(jtextfiled1.gettext
Print a statement
Print a statement  hello what would we output for this statement System.out.println ("5"+"A" + 3);   helloADS_TO_REPLACE_1 output will be 5A3
switch statement
switch statement   i want to write a java program that computes Fibonacci,factorial,string reversal and ackerman using switch case to run as a single program
Mysql Else Condition
Mysql Else Condition       Mysql Else Condition evaluate the statements in database to perform..._TO_REPLACE_1 The Tutorial illustrate an example from the 'Mysql Else Condition
Switch Statement
switches to statement by testing the value. import java.io.BufferedReader; import... switch case statement. The program displays the name of the days according to user
cONDITIONAL STATEMENT
cONDITIONAL STATEMENT    Write a program that computes and assesses the tuition fee of the students in one trimester, based on the given mode of payment below: Plan (Key) Discount (-) or Interest (+) Cash (1) 10% Discount Two
JSP IF Statement
if statement, it may be used with the ELSE statement as well like IF-ELSE statement and/or as the IF-ELSE statement and/or IF-ELSE ladder statement. In Java we can use the standalone IF statement, nested IF statement, IF-ELSE statement
SQL And Statement
SQL AND Statement       The SQL AND operator is used to show you the filter records... AND Statement. In this Tutorial  first we create a Table 'Stu_Table
Update statement
,price,per,conta,mobr); } else if(e.getSource()==update) { c.update...,per,conta,mobr); } else if(e.getSource()==del) { c.delete(Integer.parseInt(code)); } else if(e.getSource()==Clear) { t1.setText
jdbc-prepare statement
jdbc-prepare statement   explain about prepared statement with example
Switch Statement with Strings in Java
Switch Statement with Strings in Java  Switch Statement with Strings in Java
What is the difference between a break statement and a continue statement?
What is the difference between a break statement and a continue statement?   Hi, What is the difference between a break statement and a continue statement? Thanks,   Hello, In Java programming language supports 3

Ads