systemuserdao.java

来自「用JAVA环境开发的人力资源管理系统」· Java 代码 · 共 62 行

package com.liyu.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ResultSetExtractor;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.liyu.beans.UserInfo;


public class SystemUserDao extends JdbcDaoSupport{
	public static final String SYSROLEFLG ="systemUser";
	public static final String BUSROLEFLG ="businessUser";
	public static final String HREROLEFLG ="huResManUser";
	
	private static final String SYSUSERNAME= "系统用户";
	private static final String BUSUSERNAME= "业务用户";
	private static final String HREROLENAME= "人力资源管理用户";
	
	private static final String GET_USERINFO_SQL = "SELECT * FROM USER_INFO";
	private static final String DEL_USERINFO_SQL = "DELETE FROM USER_INFO WHERE USER_NAME=? AND USER_PASSWORD=? AND USER_ROLE =?";
	//庢摼悢悩揑??
	public List getUserInfo(){
		return (List)this.getJdbcTemplate().query(GET_USERINFO_SQL,new userManagerListExtractor());
		
	}//?彍悢悩拞憡?揑??
	public int delUserInfo(String USER_NAME,String USER_PASSWORD,String USER_ROLE){
		return this.getJdbcTemplate().
		update(DEL_USERINFO_SQL,new Object[]{USER_NAME,USER_PASSWORD,USER_ROLE});
	}
	
	private static class userManagerListExtractor implements ResultSetExtractor {
		public Object extractData(ResultSet rs) throws SQLException,
				DataAccessException {
			UserInfo userInfo = new UserInfo();
			List list = new ArrayList();
			while(rs.next()) {
				userInfo = new UserInfo();			
				userInfo.setUserName(StringUtils.defaultString(rs.getString("USER_NAME")));
				userInfo.setUserPassword (StringUtils.defaultString(rs.getString("USER_PASSWORD")));
				userInfo.setUserRole (StringUtils.defaultString(rs.getString("USER_ROLE")));
				if (userInfo.getUserRole().equals(SYSROLEFLG)){
					userInfo.setUserRoleName(SYSUSERNAME);
				}else if (userInfo.getUserRole().equals(BUSROLEFLG)){
					userInfo.setUserRoleName(BUSUSERNAME);
				}else if (userInfo.getUserRole().equals(HREROLEFLG)){
					userInfo.setUserRoleName(HREROLENAME);
				}
				list.add(userInfo);
			}
			return list;
		}


	}
}