devxlogo

Get the Keys for Rows Added by an INSERT Statement

Get the Keys for Rows Added by an INSERT Statement

This tip shows how to get the keys generated for the rows added by an INSERT statement.

Statement st=null;PreparedStatement pst=null;Connection conn=null;ResultSet rs=null;ResultSetMetaData rsmd=null;...try {    st= conn.createStatement();    }catch (SQLException e)       {System.out.println(e.getMessage());}try {    pst= new conn.prepareStatement(INSERT INTO table_name (field1, field2, ...) VALUES](?, ?, ...),Statement.RETURN_GENERATED_KEYS);              pst.settype(1,val_1);             pst.settype(2,val_2);             ...            pst.settype(n,val_n);             pst.executeUpdate();             rs =pst.getGeneratedKeys();             if (!rs.next())System.out.println(No keys!);               else               {               rsmd = rs.getMetaData();               while (rs.next())               {               for (int i = 1; i <= rsmd.getColumnCount(); i++)                  {                 String ch = rs.getString(i);                 System.out.println("ch{" + i + "}:" + ch);                 }               }          }     }catch (SQLException e)        {System.out.println(e.getMessage());}...

devx-admin

Share the Post: