registermanageimpl.java

本代码是一个权限管理系统源代码

package com.seavision.PermissionManage.components;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import net.sf.hibernate.HibernateException;

import com.seavision.PermissionManage.help.HibernateUtil;
import com.seavision.PermissionManage.vo.CompanyVO;
import com.seavision.PermissionManage.vo.DepartmentVO;
import com.seavision.PermissionManage.vo.RegisterVO;
import com.seavision.PermissionManage.vo.UserVO;

public class RegisterManageImpl implements RegisterManage {

	public boolean register(RegisterVO registerVO) {
		String company = "";
		String register = "";
		String user = "";
		String department = "";
		String netName = "";
		int unitId = 0;
		int departmentId = 0;
		int userId = 0;
		String name = "";
		String password = "";
		String email = "";
		boolean bn = false;
		CompanyVO companyVO = new CompanyVO();
		DepartmentVO departmentVO = new DepartmentVO();
		UserVO userVO = new UserVO();

		netName = registerVO.getNetName();
		name = registerVO.getName();
		password = registerVO.getPassword();
		email = registerVO.getEmail();
		
		companyVO.setCompanyName(netName);
		companyVO.setCompanyAuthority("0");
		departmentVO.setDepartmentName("网站维护");
		userVO.setUserName(name);
		userVO.setUserPassWord(password);
		userVO.setEmail(email);
		userVO.setMk(2);
		userVO.setSex("1");
		userVO.setDuty("网站站长");

		try {
			HibernateUtil.beginTransaction();
			company = HibernateUtil.saveAndcommit(companyVO);
			department = HibernateUtil.saveAndcommit(departmentVO);
			unitId = companyVO.getCompanyId();
			departmentId = departmentVO.getDepartmentId();
			registerVO.setUnitId(unitId);
			userVO.setCompanyId(unitId);
			userVO.setDepartmentId(departmentId);
			departmentVO.setCompanyId(unitId);
			register = HibernateUtil.saveAndcommit(registerVO);
			user = HibernateUtil.saveAndcommit(userVO);
			userId = userVO.getUserId();
			if (register.trim().equals("success") && company.trim().equals("success") && user.trim().equals("success") && department.trim().equals("success")) {			
				bn = true;
			}
			HibernateUtil.endTransaction(bn);
			//在关系表里添加数据
			Connection connection = HibernateUtil.getConnection();
			try {
				Statement sta = connection.createStatement();
				sta.execute("insert into userandrole (userId,roleId) values(" + userId + "," + 2 + ")");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return bn;
	}

	public boolean checkUserName(String name) {
		boolean bn = false;
		List list = new ArrayList();
		String sql = "from UserVO user where user.userName = '" + name + "'";
		try {
			list = HibernateUtil.queryHQL(sql);
			if(list == null || list.size() == 0){
				bn = true;
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return bn;
	}
	
	public boolean findAccount(String userName, String email,String[] password){
		boolean bn = true;
		List list = new ArrayList();
		String sql = "from UserVO user where user.userName = '" + userName + "' and Email = '" + email + "'";
		try {
			list = HibernateUtil.queryHQL(sql);
			if(list == null || list.size() == 0){
				bn = false;
			}else{
				for(int i = 0; i < list.size(); i ++){
					UserVO userVO = new UserVO();
					userVO = (UserVO)list.get(i);
					password[0] = userVO.getUserPassWord();
					System.out.println("password===con====="+password);
				}
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return bn;
	}

}