String generatedColumns[] = {"pid"};
PreparedStatement ps = con.prepareStatement(sql,generatedColumns);
ps.setObject(1, "1");
ps.setObject(2, "2");
ps.setObject(3, "3");
ps.setObject(4, "4");
ps.setObject(5, "5");
ps.setObject(6, "6");
ps.setDate(7, new Date(2009,10,10));
ps.executeUpdate();
if (ps.executeUpdate() > 0)
{
ResultSet rs = ps.getGeneratedKeys();
if (rs.next())
{
Long id = rs.getLong(1);
System.out.println("id = " + id);
}
}
PreparedStatement ps = con.prepareStatement(sql,generatedColumns);
ps.setObject(1, "1");
ps.setObject(2, "2");
ps.setObject(3, "3");
ps.setObject(4, "4");
ps.setObject(5, "5");
ps.setObject(6, "6");
ps.setDate(7, new Date(2009,10,10));
ps.executeUpdate();
if (ps.executeUpdate() > 0)
{
ResultSet rs = ps.getGeneratedKeys();
if (rs.next())
{
Long id = rs.getLong(1);
System.out.println("id = " + id);
}
}