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());}...

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.