SSH（spring，struts2.x,spring +mysql+toncat）登录实例

package com.ssh.daoimpl; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import org.hibernate.HibernateException; import org.hibernate.Session; import org.springframework.orm.hibernate3.HibernateCallback; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import org.springframework.orm.hibernate3.HibernateTemplate; import com.opensymphony.xwork2.ActionSupport; import com.ssh.bean.User; import com.ssh.dao.UserDao; public class UserDaoImpl extends HibernateDaoSupport implements UserDao { @SuppressWarnings("unchecked") @Override public int getUser(String userName, String userPassword) { // TODO Auto-generated method stub // System.out.println("---------here1-----------"); final String s1 = userName; final String s2 = userPassword; List<User> list = new ArrayList<User>(); list = (ArrayList<User>)this.getHibernateTemplate().execute(new HibernateCallback() { @Override public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub // System.out.println("-----------here2------"); // System.out.println("=======>"+ session.createQuery("from User u where u.username='"+s1+"' ").list()); return session.createQuery("from User u where u.username='"+s1+"' ").list(); } }); //System.out.println("-----用户不存在测试-----"); if(null == list || 0 == list.size()){ return -1; //用户不存在 } list = (ArrayList<User>)this.getHibernateTemplate().executeFind(new HibernateCallback() { @Override public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub // System.out.println("=======>"+session.createQuery("from User u where u.username='"+s1+"' and u.password='"+s2+"'").list()); return session.createQuery("from User u where u.username = '"+s1+"' and u.password = '"+s2+"'").list(); } }); //System.out.println("------密码不正确测试-----"); if(null == list || 0 == list.size()){ return -2; //密码不正确 } return 1; } @Override public void saveUser(String userName, String userPassword) { // TODO Auto-generated method stub final String s1=userName; final String s2=userPassword; User user = new User(); user.setUsername(userName); user.setPassword(userPassword); this.getHibernateTemplate().save(user); } @SuppressWarnings("unchecked") @Override public boolean isExist(String userName, String userPassword) { // TODO Auto-generated method stub final String s1=userName; final String s2=userPassword; //System.out.println("------here is UserDaoImpl-------------"); List<User> list = new ArrayList<User>(); list = (ArrayList<User>)this.getHibernateTemplate().executeFind(new HibernateCallback() { @Override public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub //System.out.println("========>"+session.createQuery("from User u where u.username='"+s1+"'").list()); return session.createQuery("from User u where u.username='"+s1+"'").list(); } }); if(0 == list.size() || null == list) { return false; //该用户不存在，该用户名可用 }else{ return true; //该用户已经存在，不可用 } } }