error message: java.sql.SQLException: Invalid column index [duplicate]

Question

Im getting INVALID COLUMN INDEX when trying to insert data in table.

This is my DAO. Not sure why there is invalid column index.

    try{  
            currentCon = JavaConnectionDB.getConnection();
            PreparedStatement ps=currentCon.prepareStatement("insert into lecturer (lecturerID,lecturerFullname,lecturerPassword) values'"
                    + lecturerID + "','" + lecturerFullname + "','" + lecturerPassword +"'");  
            ps.setString(1,Lbean.getLecturerID());  
            ps.setString(2,Lbean.getLecturerFullname());  
            ps.setString(3,Lbean.getLecturerPassword());  
            ps.executeUpdate();  

           }

Is there anything i missed??? Thank you in advance! :)

Learn about prepared statements.show your table definition

Jens
– Jens

2016-02-05 07:49:06 +00:00
Commented Feb 5, 2016 at 7:49 — Jens
– Jens, Commented Feb 5, 2016 at 7:49

Abdelhak · Accepted Answer · 2016-02-05 08:04:11Z

2

You need to write your query like this:

  insert into lecturer (lecturerID,lecturerFullname,lecturerPassword) values(? , ? , ?);

The question marks are placeholders for fixed values that you must set before executing an SQL statement.

edited Feb 5, 2016 at 8:04

answered Feb 5, 2016 at 7:53

Abdelhak

8,4154 gold badges25 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

error message: java.sql.SQLException: Invalid column index [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related