Java Jdbc Insert

Question

I'm doing a sample project using jdbc driver. My problem is if I enter a null in my 2 textfield. The null should not be load into the database? Is there anyway how to avoid inserting a empty field in database? Any help will appreciate.

//Execute a query
System.out.println("Creating Statement..");
String query = "INSERT INTO INFO (FIRSTNAME,LASTNAME) VALUES (?,?)";
myStatement = con.prepareStatement(query);

myStatement.setString(1, firstnameTf.getText());
myStatement.setString(2, lastnameTf.getText());
myStatement.executeUpdate();

if (firstnameTf.getText().isEmpty() || lastnameTf.getText().isEmpty()){
    JOptionPane.showMessageDialog(null, "Please Insert");
}

myStatement.close();
con.close();

What is the schema for the table INFO? The simplest way is to declare the names as NOT NULL - you will get an exception if you try to insert null. — Kenney
– Kenney, Commented Feb 27, 2016 at 18:51
Add NOT NULL check in database it will throw an exception and catch it in catch block and print any msg — Mohsin AR
– Mohsin AR, Commented Feb 27, 2016 at 18:54

Mohsin AR · Accepted Answer · 2016-02-27 18:57:37Z

1

You could also use this

if (firstnameTf.getText().isEmpty() || lastnameTf.getText().isEmpty()){
        JOptionPane.showMessageDialog(null, "Please Insert");
    } 



else{
          myStatement =con.prepareStatement(query);

           myStatement.setString(1,firstnameTf.getText());
           myStatement.setString(2, lastnameTf.getText());
           myStatement.executeUpdate();}

answered Feb 27, 2016 at 18:57

Mohsin AR

3,1282 gold badges27 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Java Jdbc Insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related