如何从数据库中取出最后一行的主键？
我的代码：
public int getLastMemberID() {
int ID=0;
String queryStr = "SELECT * FROM " + tableName;
try{
stmt = conn.prepareStatement(queryStr);
ResultSet rs = stmt.executeQuery();
while(rs.last()){
ID=rs.getInt("MEMBERID");
}
}catch(SQLException ex){
JOptionPane.showMessageDialog(null, ex.getMessage(), "ERROR", JOptionPane.ERROR_MESSAGE);
}
return ID;
}