userserviceimpl.java

struts2+spring2.0+hibernate3.2与acegi 1.0.7整合实现登陆验证

package com.test.service.impl;

import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.List;

import org.acegisecurity.GrantedAuthority;
import org.acegisecurity.userdetails.UserDetails;
import org.acegisecurity.userdetails.UserDetailsService;
import org.acegisecurity.userdetails.UsernameNotFoundException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.dao.DataAccessException;

import com.test.bean.UserBean;
import com.test.dao.UserDAO;
import com.test.page.PageTool;
import com.test.service.UserService;

public class UserServiceImpl implements UserService{

	private UserDAO userDAO;

	private GrantedAuthority[] grantedAuthArray;
	
	public List<UserBean> findAllUsers() {
		// TODO Auto-generated method stub
		return (List<UserBean>)userDAO.findAllUsers();
	}

	public List<UserBean> findAllUsers(PageTool pageInfo) {
		// TODO Auto-generated method stub

		return (List<UserBean>) userDAO.findAllUsers(pageInfo);
	}

	public UserBean findUserById(String userId) {
		// TODO Auto-generated method stub

		return (UserBean) userDAO.findUserById(userId);
	}

	public void removeUser(UserBean userBean) {
		// TODO Auto-generated method stub
		userDAO.removeUser(userBean);
	}

	public void saveUser(UserBean userBean) {
		// TODO Auto-generated method stub

		userDAO.saveUser(userBean);
	}

	public void updateUser(UserBean userBean) {
		// TODO Auto-generated method stub
		userDAO.updateUser(userBean);
	}

	
	
	public GrantedAuthority[] getGrantedAuthArray() {
		return grantedAuthArray;
	}

	public void setGrantedAuthArray(GrantedAuthority[] grantedAuthArray) {
		this.grantedAuthArray = grantedAuthArray;
	}

	public InputStream downLoadAsExcel() {
		HSSFWorkbook wb = new HSSFWorkbook();
		HSSFSheet sheet = wb.createSheet("sheet");
		HSSFRow row = sheet.createRow((short) 0);

		HSSFCell cell = row.createCell((short) 0);
		cell.setEncoding(HSSFCell.ENCODING_UTF_16);
		cell.setCellValue("用户编号");

		cell = row.createCell((short) 1);
		cell.setEncoding(HSSFCell.ENCODING_UTF_16);
		cell.setCellValue("用户姓名");

		cell = row.createCell((short) 2);
		cell.setEncoding(HSSFCell.ENCODING_UTF_16);
		cell.setCellValue("用户密码");

		cell = row.createCell((short) 3);
		cell.setEncoding(HSSFCell.ENCODING_UTF_16);
		cell.setCellValue("用户年龄");
		
		cell = row.createCell((short) 4);
		cell.setEncoding(HSSFCell.ENCODING_UTF_16);
		cell.setCellValue("用户角色");

		List<UserBean> userBeanList = userDAO.findAllUsers();

		for (int i = 0; i < userBeanList.size(); i++) {
			UserBean userBean = userBeanList.get(i);

			row = sheet.createRow((short) (i + 1));

			cell = row.createCell((short) 0);
			cell.setEncoding(HSSFCell.ENCODING_UTF_16);
			cell.setCellValue(userBean.getUserId());

			cell = row.createCell((short) 1);
			cell.setEncoding(HSSFCell.ENCODING_UTF_16);
			cell.setCellValue(userBean.getFirstName());

			cell = row.createCell((short) 2);
			cell.setEncoding(HSSFCell.ENCODING_UTF_16);
			cell.setCellValue(userBean.getLastName());

			cell = row.createCell((short) 3);
			cell.setEncoding(HSSFCell.ENCODING_UTF_16);
			cell.setCellValue(userBean.getAge());
			
			cell = row.createCell((short) 4);
			cell.setEncoding(HSSFCell.ENCODING_UTF_16);
			cell.setCellValue(userBean.getRoleName());

		}

		ByteArrayOutputStream os = new ByteArrayOutputStream();

		try {
			wb.write(os);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		byte[] byteArray = os.toByteArray();

		ByteArrayInputStream is = new ByteArrayInputStream(byteArray);

		return is;

		/*
		 * final File file = new File(new StringBuffer(RandomStringUtils
		 * .randomAlphanumeric(10)).append(".xls").toString()); try {
		 * OutputStream os = new FileOutputStream(file);
		 * 
		 * wb.write(os);
		 * 
		 * os.close(); } catch (IOException e) { e.printStackTrace(); }
		 * 
		 * InputStream is = null; try { is = new FileInputStream(file); } catch
		 * (IOException e) { e.printStackTrace(); }
		 * 
		 * new Thread(new Runnable(){
		 * 
		 * public void run() { // TODO Auto-generated method stub try{
		 * Thread.sleep(15000); }catch(InterruptedException e){
		 * e.printStackTrace(); }
		 * 
		 * file.delete(); }
		 * 
		 * 
		 * }).start();
		 */

	}

	public boolean loginJugeMent(String firstName, String lastName) {
		// TODO Auto-generated method stub

		System.out.println("userServiceImpl_userDAO=" + this.userDAO);

		List<UserBean> userBeanList = userDAO.findUserByFirstNameAndLastName(
				firstName, lastName);

		for (UserBean userBean : userBeanList) {

			if (userBean.getFirstName().equals(firstName)
					&& userBean.getLastName().equals(lastName)) {

				return true;
			} else {

				continue;
			}

		}

		return false;

	}

	public UserDAO getUserDAO() {
		return userDAO;
	}

	public void setUserDAO(UserDAO userDAO) {
		this.userDAO = userDAO;
	}

	public boolean jugePasswordCorrect(String lastName) {
		// TODO Auto-generated method stub
		List<UserBean> userBeanList = userDAO.findUserByLastName(lastName);

		for (UserBean userBean : userBeanList) {

			if (userBean.getLastName().equals(lastName)) {

				return true;
			} else {

				continue;
			}

		}

		return false;
	}

	public boolean jugeUserNameCorrect(String firstName) {
		// TODO Auto-generated method stub
		List<UserBean> userBeanList = userDAO.findUserByFirstName(firstName);

		for (UserBean userBean : userBeanList) {

			if (userBean.getFirstName().equals(firstName)
					&& userBean.getFirstName().equals(firstName)) {

				return true;
			} else {

				continue;
			}

		}

		return false;
	}
	
	public void upLoadAsExcel(HSSFWorkbook workBook){
		
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd:HH:mm:ss");
		
		HSSFSheet sheet = workBook.getSheet("sheet");
		int rows = sheet.getPhysicalNumberOfRows();
		int columns = 3;
		
		System.out.println("UserServiceImpl_rows="+rows);
		
		for(int i=1;i<=rows-1;i++){
			
				UserBean userBean = new UserBean();
				HSSFRow row = sheet.getRow(i);
				
				
				HSSFCell cell = row.getCell((short)1);
				
				String firstName = null;
				try{
					 firstName = cell.getStringCellValue();
					 System.out.println("UserServiceImpl_testHere=");
				}catch(NumberFormatException e1){
					firstName = sdf.format(cell.getDateCellValue());
					
				}catch(Exception e2){
					
					firstName = new Integer(new Double(cell.getNumericCellValue()).intValue()).toString();
				}
				
				System.out.println("UserServiceImpl_firstName="+firstName);
				
				userBean.setFirstName(firstName);
				
				
				cell = row.getCell((short)2);
				String lastName = null;
				try{
					 lastName = cell.getStringCellValue();
					
				}catch(NumberFormatException e1){
					lastName = sdf.format(cell.getDateCellValue());
				}catch(Exception e2){
					
					lastName = new Integer(new Double(cell.getNumericCellValue()).intValue()).toString();
				}
				
				
				
				userBean.setLastName(lastName);
				
				
				cell = row.getCell((short)3);
				int age = new Double(cell.getNumericCellValue()).intValue();
				
				userBean.setAge(age);
				
				cell = row.getCell((short)4);
				String roleName = null;
				try{
					roleName = cell.getStringCellValue();
					
				}catch(NumberFormatException e1){
					roleName = sdf.format(cell.getDateCellValue());
				}catch(Exception e2){
					
					roleName = new Integer(new Double(cell.getNumericCellValue()).intValue()).toString();
				}
				
				
				
				userBean.setRoleName(roleName);
				
				this.saveUser(userBean);
				
				
			
		}
	}

	

}