67,513
社区成员
发帖
与我相关
我的任务
分享
public class Test {
public static String getStuID() throws SQLException{
DbManager db=new DbManager();
String garde_id="",calss_id="",student_id="";
RowSet rs=db.executeQuery("select g.gid,c.cid from grade g,class c where g.gid='2008' and c.cid='002'");
while(rs.next()){
garde_id=rs.getString("gid");
calss_id=rs.getString("cid");
}
RowSet rs1=db.executeQuery("select max(id) from student");
while(rs1.next()){
int temp=Integer.parseInt(rs1.getString(1).substring(7, rs1.getString(1).length()));
student_id=garde_id+calss_id+(temp+1);
System.out.println(student_id);
}
return student_id;
}
public static void main(String[] args) {
try {
getStuID();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}