Insert value into database using jdbc

Question

I am using MS-Access and Java with connection of JDBC-ODBC driver. As the code below, I'm trying to create a registration textbox but when I add the values, I only get the result "null" in the database. How do I get the real value I'm inserting ? Thanks

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    Connection con = DriverManager.getConnection("jdbc:odbc:ADB");

    Statement statement = con.createStatement();

    statement.executeUpdate("insert into Login " + "values  ('"+uname+"','"+pwd+"')"); 

    uname = userTextBox.getText();
    pwd = passTextBox.getText();

score 3 · Answer 1 · answered Apr 18 '13 at 18:00

From the looks of it, your statement code is fine. The problem is that you're initializing uname and pwd AFTER you execute it.

I'm assuming that somewhere above you have initialized these variables to null. So, at the time the statement is executed, the values it has to insert are null.

Pradeep Simha · Answer 2 · 2013-04-19T02:49:31.403

1

With the amount of information you provided, If you show your complete code, I can update my answer accordingly, I assume you need to change this:

statement.executeUpdate("insert into Login " + "values  ('"+uname+"','"+pwd+"')"); 

uname = userTextBox.getText();
pwd = passTextBox.getText();

To:

uname = userTextBox.getText();
pwd = passTextBox.getText();

statement.executeUpdate("insert into Login " + "values  ('"+uname+"','"+pwd+"'")");

Also your query is prone to SQL Injection attacks. Always use parameterized queries similar to below:

insert into Login values (?,?)

edited Apr 19 '13 at 02:49

answered Apr 18 '13 at 18:01

Pradeep Simha

17,683
18
56
107

I did not downvote. You seem to be missing a closing parenthesis in the string you give to `statement.executeUpdate`. – HansUp Apr 18 '13 at 18:14
1

@HansUp, yes you are right, maybe it's a copy paste error, I corrected it. – Pradeep Simha Apr 19 '13 at 02:49

score 0 · Answer 3 · answered Apr 18 '13 at 18:01

0

You need initialize uname and pwd before you excecute the update:

uname = userTextBox.getText();
pwd = passTextBox.getText();
statement.executeUpdate("insert into Login " + "values  ('"+uname+"','"+pwd+"')");

answered Apr 18 '13 at 18:01

0x6C38

6,796
4
35
47

score 0 · Answer 4 · answered Apr 18 '13 at 18:01

You need to switch the line orders from

statement.executeUpdate("insert into Login " + "values  ('"+uname+"','"+pwd+"')"); 
uname = userTextBox.getText();
pwd = passTextBox.getText();

to

uname = userTextBox.getText();
pwd = passTextBox.getText();
statement.executeUpdate("insert into Login " + "values  ('"+uname+"','"+pwd+"')");

otherwise uname and pwd will be null (provided they are not given any values pre this code)

score 0 · Answer 5 · edited May 23 '17 at 10:25

0

Update queries don't return the inserted or modified value. What you can do, is instead of letting the DB automatically generate the ID of the new entry, generate it yourself before inserting, then query the DB using that ID.

You should check this stack overflow post that covers this subject: How to get the insert ID in JDBC?

edited May 23 '17 at 10:25

Community

1
1

answered Apr 18 '13 at 18:04

tbkn23

5,205
8
26
46

score 0 · Answer 6 · answered Apr 18 '13 at 18:26

You Just Need to Fetch the Values First & then Put the Query :)

String uname = userTextBox.getText();
String pwd = passTextBox.getText();

try          
    {     

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    

    Connection con = DriverManager.getConnection("jdbc:odbc:ADB");    

    Statement statement = con.createStatement();     

    statement.executeUpdate("insert into Login " + "values  ('"+uname+"','"+pwd+"')");     
     }
   catch(Exception e)        
    {      
       System.out.println(e);      
    }

score 0 · Answer 7 · answered Apr 18 '13 at 19:06

0

//before using the variables need to initialize 

uname = userTextBox.getText();
pwd = passTextBox.getText();

statement.executeUpdate("insert into Login " + "values  ('"+uname+"','"+pwd+"')");

answered Apr 18 '13 at 19:06

Ahsan

29
1

Insert value into database using jdbc

7 Answers7