return r;
}
// 生成自增id
rs = ps.getGeneratedKeys();
if (!rs.next()) {
throw new GeneratedKeysException("please check whether the table has auto increment key");
}
return rs.getInt(1);
} catch (SQLException e) {
throw new UncheckedSQLException(e.getMessage(), e);
} finally {