package Ajdbc1;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class Test7 {
public static void main(String[] args) {
add();
}
public static void add(){
Connection conn=null;
ResultSet rs=null;
PreparedStatement stm=null;
try {
conn=DBUtil.getConn();
String sql1="insert into school(schoolName) values(?)";
stm=conn.prepareStatement(sql1, Statement.RETURN_GENERATED_KEYS);
stm.setString(1,"南大2");
stm.executeUpdate();
rs=stm.getGeneratedKeys();//返回一个结果集,一行一列,就是返回的id
rs.next();
int maxId=rs.getInt(1);
String sql2="insert into student(name,schoolId) values(?,?)";
stm=conn.prepareStatement(sql2);
stm.setString(1,"猪猪");
stm.setInt(2,maxId);
stm.executeUpdate();
}catch (Exception e){
e.printStackTrace();
}finally {
DBUtil.close(rs,stm,conn);
}
}
}
/