String mysql = "select max(zsid) from zs";
rs = mysqlconn.getResult(mysql);
if(rs.next()){
System.out.println("--------------------"+rs.getString("max(zsid)"));
int oldId = rs.getInt("max(zsid)");
int newId = Integer.parseInt((year+"10001"));
if(oldId<newId){
mysqlconn.executeSql("alter table zs auto_increment = "+newId);
}
}
今天在写这段时出现的一点小问题,在这里记录一下。
当sql语句为select max(zsid) from zs时,结果集对象取得具体字段时应该用rs.getInt("max(zsid)"),而不是rs.getInt("zsid"),否则会报找不到该列的异常