使用JdbcTemplate模板时传递的参数Map和Object []数组

来源：互联网发布：android 打开淘宝链接编辑：程序博客网时间：2024/06/01 10:18

// 用户登录检测
public Map findUser(String username, String password) {
//String sql = "select u.* from tbUser u where lower(u.UserName)=:UserName";
String sql = "select u.* from tbUser u where u.UserName=:UserName";

if ("".equals(password)) {
sql += " and (u.PassWord='d41d8cd98f00b204e9800998ecf8427e' or u.PassWord is null)";
} else {
sql += " and u.PassWord=:PassWord";
}

HashMap<String, String> paramMap = new HashMap<String, String>();
paramMap.put("UserName", username);
paramMap.put("PassWord", password);

Map map = null;
try {
map = baseDAO.getNamedParameterJdbcTemplate().queryForMap(sql,paramMap);
} catch (Exception e) {
}

-------------------------------------
UserName 和 Password 是事先定义的 Map中的键,在之后HashMap<String, String> paramMap 才定义的。
然后把map作为queryFormap()方法的参数

---------------------------------------
另一种方法是传递Object[]Object数组
public void modifyCommunity(Object[] args){
String sql = " update tbForumSubject set TITLE=?,USERID=?,CONTENT=?,SN=? where ForumSID=? "; //去掉,CREATOR=?
baseDao.getJdbcTemplate().update(sql, args);

}

转自：http://1055592535.iteye.com/blog/1669736

0 0