step by step ssh 08

package com.xuzheng.dao.impl; import java.util.ArrayList; import java.util.List; import java.util.Map; import org.hibernate.Criteria; import org.hibernate.criterion.Restrictions; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.xuzheng.dao.IOneDao; import com.xuzheng.model.User; public class OneDaoImpl extends HibernateDaoSupport implements IOneDao{ //1、对类添加继承 HibernateDaoSupport //2、去掉原有注入的DataSource public Map login(Map map) { String name = (String) map.get("name"); String pwd = (String) map.get("pwd"); //3、声明HQL语句，注意其中的:name String sql = "select count(1) from users where name=:name and pwd=:pwd"; //4、使用Session查询 List temp = getSession().createSQLQuery(sql).setString("name", name).setString("pwd", pwd).list(); int i = Integer.parseInt(temp.get(0).toString()); System.out.println("此用户名的用户数量："+i); if(i >= 1){ map.put("result", "1"); } return map; } //查询所有用户列表 public List query() { //5、改写query方法 List list = getSession().createCriteria(User.class).list(); return list; } //保存用户 public void save(Map map) { String[] names = (String[]) map.get("name"); String[] pwds = (String[]) map.get("pwd"); for (int i = 0; i < names.length; i++) { if(!names[i].trim().equals("") && !pwds[i].trim().equals("")){ //用户保存用户 User user = new User(); user.setName(names[i]); user.setPwd(pwds[i]); getSession().save(user); } } } public void del(Map map) { String[] ids = (String[]) map.get("id"); int a = getSession().createSQLQuery("delete from users where id in (:id)") .setParameterList("id", ids) .executeUpdate(); System.out.println("共删除行数："+a); } //条件查询方法 public List query(Map map) { //1、获取参数 String name = (String) map.get("name"); //2、声明List类型的变量 List list = new ArrayList(); //3、创建一个查询对象 Criteria c = getSession().createCriteria(User.class); if(name!=null && !name.trim().equals("")){ //4、设置查询条件 c.add(Restrictions.like("name", "%"+name.trim()+"%")); } //5、获取查询结果 list = c.list(); return list; } }