使用ps返回自增id

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);
        }
    }
}

/