@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public Page<RoncooUser> queryForPage(int pageCurrent, int pageSize, String name){ // 确定参数 /*String sql = "select * from roncoo_user where name=?"; return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class, name);*/ // 若name可能为空,则要进行判定,如下 /*StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isNullOrEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name = '").append(Sql.checkSql(name)).append("' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class);*/ // 若要like查询,如下 StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name like '%").append(Sql.checkSql(name)).append("%' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public Page<RoncooUser> queryForPage(int pageCurrent, int pageSize, String name){ // 确定参数 /*String sql = "select * from roncoo_user where name=?"; return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class, name);*/ // 若name可能为空,则要进行判定,如下 /*StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isNullOrEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name = '").append(Sql.checkSql(name)).append("' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class);*/ // 若要like查询,如下 StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name like '%").append(Sql.checkSql(name)).append("%' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public Page<RoncooUser> queryForPage(int pageCurrent, int pageSize, String name){ // 确定参数 /*String sql = "select * from roncoo_user where name=?"; return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class, name);*/ // 若name可能为空,则要进行判定,如下 /*StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isNullOrEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name = '").append(Sql.checkSql(name)).append("' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class);*/ // 若要like查询,如下 StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name like '%").append(Sql.checkSql(name)).append("%' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public Page<RoncooUser> queryForPage(int pageCurrent, int pageSize, String name){ // 确定参数 /*String sql = "select * from roncoo_user where name=?"; return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class, name);*/ // 若name可能为空,则要进行判定,如下 /*StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isNullOrEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name = '").append(Sql.checkSql(name)).append("' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class);*/ // 若要like查询,如下 StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name like '%").append(Sql.checkSql(name)).append("%' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public Page<RoncooUser> queryForPage(int pageCurrent, int pageSize, String name){ // 确定参数 /*String sql = "select * from roncoo_user where name=?"; return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class, name);*/ // 若name可能为空,则要进行判定,如下 /*StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isNullOrEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name = '").append(Sql.checkSql(name)).append("' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class);*/ // 若要like查询,如下 StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name like '%").append(Sql.checkSql(name)).append("%' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public Page<RoncooUser> queryForPage(int pageCurrent, int pageSize, String name){ // 确定参数 /*String sql = "select * from roncoo_user where name=?"; return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class, name);*/ // 若name可能为空,则要进行判定,如下 /*StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isNullOrEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name = '").append(Sql.checkSql(name)).append("' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class);*/ // 若要like查询,如下 StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name like '%").append(Sql.checkSql(name)).append("%' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public Page<RoncooUser> queryForPage(int pageCurrent, int pageSize, String name){ // 确定参数 /*String sql = "select * from roncoo_user where name=?"; return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class, name);*/ // 若name可能为空,则要进行判定,如下 /*StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isNullOrEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name = '").append(Sql.checkSql(name)).append("' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class);*/ // 若要like查询,如下 StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name like '%").append(Sql.checkSql(name)).append("%' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public Page<RoncooUser> queryForPage(int pageCurrent, int pageSize, String name){ // 确定参数 /*String sql = "select * from roncoo_user where name=?"; return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class, name);*/ // 若name可能为空,则要进行判定,如下 /*StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isNullOrEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name = '").append(Sql.checkSql(name)).append("' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class);*/ // 若要like查询,如下 StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name like '%").append(Sql.checkSql(name)).append("%' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public Page<RoncooUser> queryForPage(int pageCurrent, int pageSize, String name){ // 确定参数 /*String sql = "select * from roncoo_user where name=?"; return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class, name);*/ // 若name可能为空,则要进行判定,如下 /*StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isNullOrEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name = '").append(Sql.checkSql(name)).append("' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class);*/ // 若要like查询,如下 StringBuffer sql = new StringBuffer("select * from roncoo_user where 1"); if(!StringUtils.isEmpty(name)){ // Sql.checkSql 的作用是防止sql注入 sql.append(" and name like '%").append(Sql.checkSql(name)).append("%' "); } return queryForPage(sql.toString(), pageCurrent, pageSize, RoncooUser.class); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }
@Override public RoncooUser selectById(int id) { String sql = "select * from roncoo_user where id=?"; /*return jdbcTemplate.queryForObject(sql, new RowMapper<RoncooUser>() { @Override public RoncooUser mapRow(ResultSet rs, int rowNum) throws SQLException { RoncooUser roncooUser = new RoncooUser(); roncooUser.setId(rs.getInt("id")); roncooUser.setName(rs.getString("name")); roncooUser.setCreateTime(rs.getDate("create_time")); return roncooUser; } }, id);*/ return queryForObject(sql, RoncooUser.class, id); }