logindao.java

JAVA实现的中小型企业CRM客户关系管理系统

package com.crm.login;

import java.util.Date;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import com.crm.dao.CommonDAO;
import com.crm.user.po.UserInfo;

public class LoginDAO extends CommonDAO implements ILoginDAO {

	public int login(UserInfo user,HttpServletRequest request) {
		String username = user.getEmployee_name();
		String password = user.getPassword();
		UserInfo checkUser = (UserInfo) this.getSqlMapClientTemplate().queryForObject(
				"Login.selectlogin", user);

		int iReturn = -1;
		if (null == checkUser || null == checkUser.getEmployee_name()) {
			iReturn = -1;// 用户名不存在
		} else {
//			System.out.println("user.getPassword()="+user.getPassword());
//			System.out.println(checkUser.getPassword());
			
			if (null != user.getPassword()
					&& user.getPassword().equals(checkUser.getPassword())) {
				

				 
					request.getSession().setAttribute("user", checkUser);				
					String modulelist = getModulelist(checkUser.getId());
					request.getSession().setAttribute("modulelist", modulelist);
		
				iReturn = 1;
			} else {
				iReturn = -2;// 密码不正确
			}
		}
		//0409升级，下次升级删除
		try{
//			this.getJdbcTemplate().execute(" alter table cust_service alter column CONTENT varchar(4000");
//			this.getJdbcTemplate().execute(" alter table CUST_INFO alter column product varchar(4000");
			
//			this.getJdbcTemplate().execute(" alter table cust_info add custaccount varchar(50)");
//			this.getJdbcTemplate().execute(" alter table cust_info add custpassword varchar(50)");
//			this.getJdbcTemplate().execute(" alter table cust_info add message_start_date datetime");
//			this.getJdbcTemplate().execute(" alter table cust_info add message_end_date datetime");
//			this.getJdbcTemplate().execute(" alter table cust_info add product varchar(100)");
			
		}catch(Exception e){
			
		}
		
		return iReturn;
	}
	public String getModulelist(String sId){
		 List list = this.getSqlMapClientTemplate().queryForList("Login.getmodulelist", sId);
		 StringBuffer sb = new StringBuffer();
		 for(int i=0;i<list.size();i++){
			 sb.append(","); 
			 sb.append(list.get(i)); 
		 }
		 if(sb.length()>0){
			 sb.deleteCharAt(0);
		 }
		 
		 return sb.toString();
	}
}