Spring JDBC SqlParameterSource

 BeanPropertySqlParameterSource,MapSqlParameterSource提供了对SqlParameterSource的实现，

允许使用javabean或者Map来实现对命名参数传递。

@Component public class UserInfoDaoJdbcImpl extends SimpleJdbcDaoSupport implements UserInfoDao {     public int deleteEntity(UserInfo t) throws DataAccessException {         if (null != t.getId()) {             return super.getSimpleJdbcTemplate().update("delete from user_info where id=:id", t.getId());         } else if (null != t.getMap().get("ids")) {             return super.getSimpleJdbcTemplate().update(                     "delete from user_info where id in (" + t.getMap().get("ids") + ")", t.getId());         } else {             return -1;         }     }     public Integer insertEntity(UserInfo t) throws DataAccessException {         String sql = "insert into user_info (user_name, password, birthday, age) values (:user_name, :password, :birthday, :age)";         return super.getSimpleJdbcTemplate().update(sql, new BeanPropertySqlParameterSource(t));     }     public UserInfo selectEntity(UserInfo t) throws DataAccessException {         List<String> sqls = new ArrayList<String>();         sqls.add("select * from user_info where 1=1");         if (null != t.getId()) {             sqls.add("and id=:id");         }         if (null != t.getUser_name()) {             sqls.add("and login_name=:login_name");         }         if (null != t.getPassword()) {             sqls.add("and password=:password");         }         String sql = StringUtils.join(sqls, " ");         List<UserInfo> userInfoList = super.getSimpleJdbcTemplate().query(sql,                 ParameterizedBeanPropertyRowMapper.newInstance(UserInfo.class), new BeanPropertySqlParameterSource(t));         int listSize = userInfoList.size();         if (1 == listSize) {             return userInfoList.get(0);         } else {             return null;         }     }     public Long selectEntityCount(UserInfo t) throws DataAccessException {         List<String> sqls = new ArrayList<String>();         sqls.add("select count(*) from user_info where 1=1");         if (null != t.getId()) {             sqls.add("and id=:id");         }         if (null != t.getUser_name()) {             sqls.add("and login_name=:login_name");         }         if (null != t.getPassword()) {             sqls.add("and password=:password");         }         String sql = StringUtils.join(sqls, " ");         return super.getSimpleJdbcTemplate().queryForLong(sql, new BeanPropertySqlParameterSource(t));     }     public List<UserInfo> selectEntityList(UserInfo t) throws DataAccessException {         List<String> sqls = new ArrayList<String>();         sqls.add("select * from user_info where 1=1");         if (null != t.getId()) {             sqls.add("and id=:id");         }         if (null != t.getUser_name()) {             sqls.add("and login_name=:login_name");         }         if (null != t.getPassword()) {             sqls.add("and password=:password");         }         String sql = StringUtils.join(sqls, " ");         return super.getSimpleJdbcTemplate().query(sql, ParameterizedBeanPropertyRowMapper.newInstance(UserInfo.class),                 new BeanPropertySqlParameterSource(t));     }     public List<UserInfo> selectEntityPaginatedList(UserInfo t) throws DataAccessException {         // TODO Auto-generated method stub         return null;     }     public int updateEntity(UserInfo t) throws DataAccessException {         List<String> sqls = new ArrayList<String>();         if (null != t.getAge()) {             sqls.add(" age=:age");         }         if (null != t.getBirthday()) {             sqls.add(" birthday=:birthday");         }         String sql = StringUtils.join(new String[] { "update user_info set ", StringUtils.join(sqls.toArray(), ","),                 " where id=:id" });         return super.getSimpleJdbcTemplate().update(sql, new BeanPropertySqlParameterSource(t));     } } 

import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;import org.springframework.jdbc.core.namedparam.SqlParameterSource;public class FormJdbcDao2  extends NamedParameterJdbcDaoSupport{  public void addForm(final Form form){   final String sql  = "insert into tb_user(userName) values(:userName)";   //BeanPropertySqlParameterSource该类实现了一个JavaBean的对象，封装成一个参数源，   //以便通过JavaBean属性名和SQL语句中的命名参数匹配方式绑定参数   SqlParameterSource sps  = new BeanPropertySqlParameterSource(form);   getNamedParameterJdbcTemplate().update(sql, sps);     }  public void addForm1(final Form form){   final String sql  = "insert into tb_user(userName) values(:userName)";   //MapSqlParameterSource该类内部通过一个Map存储参数，可以通过addValue(String paramName,Object value)或者   //addValues(Map values)添加参数。如果表记录没有对应的领域对象，用户可以直接通过使用MapSqlParameterSource的方式进行参数绑定。   MapSqlParameterSource  sps  = new MapSqlParameterSource().addValue("userName", form.getUserName());   getNamedParameterJdbcTemplate().update(sql, sps);     } }