Thread: Error in updating database

Statement stm=con.createStatement();
PreparedStatement ps=conn.prepareStatement("insert into regis values(?,?,?,?,?,?,?,?,?,?)");
ps.setString(2, username);
ps.setString(3, password);
ps.setString(4, confirmpassword);
ps.setString(5, firstname);
ps.setString(6, lastname);
ps.setInt(7, age);
ps.setDate(8, new java.sql.Date(date.getTime()));
ps.setString(9, teamname);
ps.setString(10, designation);

my index 1 is declared as int auto increment not null but while i am upting from servlet it didnt update properly even still it show emptyset .
what i have to do?

i found that error. we have to insert this one unless the database will not auto increment
ps.setObject(1,null);

If you don't want to to set all the values of a newly-inserted row, use this form of the INSERT statement:

INSERT INTO regis (columnb, columnc, columnd) VALUES (?, ?, ?)

to set only those columns of the new row that aren't generated by triggers/auto-increments etc.