If and else statement

Home Answers Viewqa JDBC If and else statement

QuestionAsk Questions?

Christopher De Souza

If and else statement
2 Answer(s) 3 years and 9 months ago
Posted in : JDBC

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

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

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 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' Statement - 'else if' style
Java Notes'if' Statement - 'else if' style Series of tests It is common to make a series of tests on a value, where the else part contains only another if statement. If you use indentation for the else

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

'else' Not Required
will learn about if else statement in more detail with example. It is not necessary to have the else part of an if statement. Maybe only 50% of the time there is an else part. Form The if statement

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

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... want. Syntax of PHP if else if Statement if (condition) Execute

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

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

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

Operators; If, Else, Elseif; Loops
be true as it sets $ Studentname to Ajay. 3.9.2. if...else statement.... If..else statement execute the code in both conditions, e.g. It works like... statement ‘He is not Ajay'. 3.9.3. if...elseif....else statement

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 ... with Example The Tutorial illustrate a example from if statement with LOOP statement. In this example we create a procedure display that accept

Mysql Else Condition
Mysql Else Condition Mysql Else Condition evaluate the statements in database to perform... illustrate an example from the 'Mysql Else Condition'.To understand

'if' Statement - if inside if
Java Notes'if' Statement - if inside if if inside if You can put an if statement inside another if statement. Example -- series...) g.setColor(Color.magenta); else if (score < 50) g.setColor

Update statement
,type,make,model,conn,cap,tran,meli,ftype,year,price,per,conta,mobr); } else...,type,make,model,conn,cap,tran,meli,ftype,year,price,per,conta,mobr); } else if(e.getSource()==del) { c.delete(Integer.parseInt(code)); } else

Nested If Statement
Nested If Statement In this section you will study about the Nested-if Statement in jsp. Nested If statement means to use the if statement inside the other if statement

if Statement - Overview
to have the else part of an if statement. Maybe only 50% of the time there is an else part. Form The if statement without... with an if statement without an else clause. public void paintComponent(Graphics g

if Statement - Overview
Java Notesif Statement - Overview Purpose The purpose of the if statement is to make decisions, and execute different parts of your program depending... with if. [The other 1% of the decisions use the switch/case 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"> <

If statement in java 7
if statement with else - If Statement : If statement contains one boolean...) { ...... ......//statements } If -Else Statement : In if-else statement, if statement contains... that means if you want to write if statement inside the else block then you can

'if' Statement - Braces
: if (condition) one statement to do if condition is true else... Java Notes'if' Statement - Braces Braces { } not required for one statement If the true or false part of and if statement has only one

JSTL If- Else
:choose> tag. This tag works like a if- else statement in a java... is standard.jar. We have made a program on if- Else statement using jstl library which...JSTL If- Else

JavaScript Statement Array
JavaScript Statement Array I need JavaScript Statements Examples in an Array. //form <form name="form1" onsubmit="return... == "") { alert("select names"); } else { alert (namelist); } return

using case in update statement
when 10 then 20 when 20 then 30 when 30 then 40 when 40 then 10 else 0 end where... when 20 then 30 when 30 then 40 when 40 then 10 else 0)end; Hello... when deptno= 40 then deptno* 10 else deptno* 0 end Thanks

SQL statement - SQL
SQL statement Hi, i have an sql statement that needs to add... THEN od_shipping_cost = 0 ELSE od_shipping_cost = 10 END FROM tbl_order...; 300 THEN od_shipping_cost = 0 ELSE od_shipping_cost = 10 END FROM tbl_order

Need SQL Statement
of $50,000, then under John Smith, show everyone else who also has a salary... IS THE SQL STATEMENT NEEDED TO ACHIEVE THESE RESULTS

sontrol statement - Java Beginners
; } else if (i > 20) { break

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

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

PHP Conditional Statement
supports if , else, switch case and conditional operator for this purpose. PHP Conditional Statement Example 1: <?php $a=12; if($a>10) ...;$b) echo "\$a is greater than \$b"; else

in string how will write the return statement..........?
in string how will write the return statement..........? import... 256"); } else{ binary(i); } } public static String binary(int i...); else{ l++; for(int k=j; k<=8; k

Understanding jQuery statement chaining
Understanding jQuery statement chaining Understanding jQuery statement chaining JQuery provide statement chaining which can reduce the length of the code

if else condition - Java Beginners
if else condition Please explain the if else condition in Java programming language

Java Switch Statement
Java Switch Statement In java, switch is one of the control statement which turns the normal flow control of the program as per conditions. It's like if-else statement but it can

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

Prepared Statement Example
is used to make the SQL statement execution efficient. In Java, when we use... in implementation. Statement is used to execute the static SQL statement whereas, PreparedStatement corresponds a precompiled SQL statement. When we use

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

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

fibonacci by using if/else - Framework

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

syntax error in SQL Insert Statement - Java Beginners
","",""); Statement stmt=con1.createStatement(); int i..._MESSAGE); //}//end if // else

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics