Insert values to mysql Java [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 6 months ago.

Improve this question

It gives this error:

"java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). "

This is the code:

public void insertData(int id,String name, String status, String age){



     String sql = "INSERT INTO student_table (id,name,satus,age) VALUES  (id,name,status,age)";

     try (Connection conn1 = this.connects();PreparedStatement Prepst= conn1.prepareStatement(sql)){

     Prepst.setInt(1, id);
     Prepst.setString(2, name);
     Prepst.setString(3, status);
     Prepst.setString(4, age);
     Prepst.executeUpdate();

     }catch(Exception e){
            System.err.println(e);

      }

If I change the parameter index to another value i.e.:

Prepst.setInt(0, id);

then it gives this error:

" java.sql.SQLException: Parameter index out of range (0 < 1 ). "

----UPDATE -----

I inserted this code:

String sql = "INSERT INTO student_table (id,name,satus,age) VALUES  (?,?,?,?)";

It produces the same:

RESULT

Table Structure:

HERE

Please have a look at Java naming conventions: oracle.com/technetwork/java/codeconventions-135099.html — Felix Gaebler
– Felix Gaebler, Commented Apr 5, 2018 at 11:15
The version with (?,?,?,?) is correct, but the first parameter is at position 1, not 0. — khelwood
– khelwood, Commented Apr 5, 2018 at 11:27
ok sorry my bad for that i was trying different ways. After correcting it it gives this --> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'satus' in 'field list' — Klayd Pro
– Klayd Pro, Commented Apr 5, 2018 at 11:29
@KlaydPro Maybe status, not satus? Anyway, your question is answered. Please don't extend it with "help me debug my code until I get the correct result" comments. — lexicore
– lexicore, Commented Apr 5, 2018 at 11:32

lexicore · Accepted Answer · 2018-04-05 11:14:59Z

3

Your SQL expression

INSERT INTO student_table (id,name,satus,age) VALUES  (id,name,status,age)

actually does not have any parameters. Try with:

INSERT INTO student_table (id,name,satus,age) VALUES  (?,?,?,?)

answered Apr 5, 2018 at 11:14

lexicore

43.9k17 gold badges142 silver badges228 bronze badges

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

1 Comment

lexicore Over a year ago

@KlaydPro Please read JavaDocs of PreparedStatement. In PreparedStatement indexing of parameters starts with 1, not 0.

Gayathri Rajan · Accepted Answer · 2018-04-05 11:38:11Z

0

Try this...

public void insertData(int id,String name, String status, String age){



     String sql = "INSERT INTO student_table (id,name,satus,age) VALUES  (?,?,?,?)";

     try (Connection conn1 = this.connection;PreparedStatement Prepst= conn1.prepareStatement(sql)){

     Prepst.setInt(1, id);
     Prepst.setString(2, name);
     Prepst.setString(3, status);
     Prepst.setString(4, age);
     Prepst.executeUpdate();

     }catch(Exception e){
            System.err.println(e);

      }
}

answered Apr 5, 2018 at 11:38

Gayathri Rajan

4691 gold badge7 silver badges18 bronze badges

Collectives™ on Stack Overflow

Insert values to mysql Java [closed]

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related