checkuserdaoimpl.java

Java协同办公系统。实现公司内部的人事

package com.icss.oa.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;




import com.icss.oa.base.BaseDAO;
import com.icss.oa.base.impl.BaseDAOImpl;
import com.icss.oa.bean.UserSession;
import com.icss.oa.dao.CheckUserDAO;
import com.icss.oa.utils.ConnectionFactory;
import com.icss.oa.utils.DatabaseUtils;

public class CheckUserDAOImpl implements CheckUserDAO{

	public Properties queryUser(UserSession usersession) {
		// TODO Auto-generated method stub
		//UserSession usersession1=null;
		 String sql="select * from person where personid=? and pass=?";
		 Object num[]={usersession.getPersonId(),usersession.getUserPass()};
	    //Connection conn=ConnectionFactory.getConnection();
		BaseDAO baseDAO=new BaseDAOImpl();
	   // UserSession	usersession1=baseDAO.CheckUser(sql, num);
		Properties prop=baseDAO.querySingleObject(sql, num);
	
	   
	 
		return prop;
		
	}

	public Properties queryUserById(int personid) {
		// TODO Auto-generated method stub
		UserSession usersession=null;
		String sql="select * from person where personid=?";
		Object[] num={personid};
		System.out.println("员工号是"+personid);
		BaseDAO baseDAO=new BaseDAOImpl();
		//baseDAO.CheckUser(sql, num);
		Properties prop=baseDAO.querySingleObject(sql,num);
		
		System.out.println("权限是:"+prop.getProperty("OWNER"));
	
		return prop;
		
	}

	
	
	

	
	

}