DBUtils 插入数据 返回主键

假设待插入数据的表为：

插入单条数据

//返回新插入数据的主键值
public int insertDept2(Dept dept) throws SQLException {
    QueryRunner queryRunner = new QueryRunner(DBUtil.getDataSource());
    String sql = "insert into tb_dept (dname, loc) values (?, ?)";
    BigInteger res = queryRunner.insert(sql, new ScalarHandler(), dept.getDname(), dept.getLoc());
    return res.intValue();
}

批量插入多条数据

//返回新插入数据的主键值
public int[] insertDept2(List list) throws SQLException {
    QueryRunner queryRunner = new QueryRunner(DBUtil.getDataSource());
    String sql = "insert into tb_dept (dname, loc) values (?, ?)";

	Objec[][] params = new Object[list.size][2];
	for(int i =0;i