jdbcTemplate

jdbcTemplate使用insert时返回主键id

public Integer queryBuildingInfo(Map<String, Object> map) {
    String sql = "INSERT INTO USER(name,sex)VALUES(?,?) ";

    KeyHolder keyHolder1 = new GeneratedKeyHolder();
    jdbc.update(new PreparedStatementCreator() {
        @Override
        public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
            // 设置返回的主键字段名
            PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            ps.setString(1, "1");
            ps.setString(2, "2");
            return ps;
        }
    }, keyHolder1);
    // 获取到插入数据生成的ID
    int num = keyHolder1.getKey().intValue();
    return num ;
}

jdbcTemplate使用like实现模糊查询

• Oracle 可以这样拼LIKE ‘%’||?||’%’

select</