Latest Tutorials| Questions and Answers|Ask Questions?|Site Map

Home Answers Viewqa JDBC If and else statement

Have Programming Question? Ask it here!

Christopher De Souza
If and else statement
2 Answer(s)      5 years 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));
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";
con = DriverManager.getConnection(url+db, user, pass);
Statement st = con.createStatement();
ResultSet rs=st.executeQuery("select * from search where word='"+word+"'");
String w="";

JOptionPane.showMessageDialog(null, "Word already exist.");

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

catch(Exception ex){}
public static void main(String[]args){
SearchWord search=new SearchWord();


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
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... want. Syntax of PHP if else if Statement if (condition)   Execute
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
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
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
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
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
if else condition - Java Beginners
if else condition  Please explain the if else condition in Java programming language
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
. In JSTL if-else tag is not implemented directly like the if-else statement... as an if-else statement in JSTL programming. Sample code given below expresses you how... to use the if-else conditional statement in JSTL. In this example we will create
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
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
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
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
jstl if else
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 with the help of some tags: <c:choose> tag : works like if-else
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
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
Statement block
Statement block  What is the purpose of a statement block
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
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
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
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
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
prepare statement
prepare statement  sir i want example of prepare statement
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
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);   hello 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
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
Switch Statement
switches to statement by testing the value. import; import... switch case statement. The program displays the name of the days according to user
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
SQL And Statement
SQL AND Statement       The SQL AND operator is used to show you the filter records... with Example The Tutorial illustrates an example from SQL AND Statement
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
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"> <
Need Help Like No one Else Please
Need Help Like No one Else Please   write a program that computes miles per gallon for an automobile. The program should ask for the beginning mileage first. For each fill-up, the program should ask for the mileage and number
convert the following Pseudocode to java if/else structure
convert the following Pseudocode to java if/else structure   dirfrom=D:/processimagessoftware/software/images dirto=D:/processimagessoftware/software/processed/ dirto=D:/imagevideodb/ author=3 country=100 state=34
Java sample using - for loop, if then else etc etc
Java sample using - for loop, if then else etc etc  sample program to produce summary information on sales report. The program will input Data of Salesman Id, Item code, and number of cuestomer. Sales id is 5digit long
JSP 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, nested IF-ELSE
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