user.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.bean;
import com.db.ProxoolAction;
import java.sql.*;

import org.apache.commons.logging.*;
public class User
 {
	private static final Log logger = LogFactory.getLog(User.class);
    Connection conn=null;
	UserInfor   u_for=null;
	public User() throws SQLException 
	{
		conn=ProxoolAction.getConnection();
	}
	public boolean isSystemUser(String username,String userpwd,String userclass)
	{
		PreparedStatement stmt=null;
		ResultSet rs=null;
		int userid=0;
		boolean flag=false;
	   	String sqlStr="";
	   	if(userclass.equals("1"))
	   	{
	   	  sqlStr="select jsid from m_teacher where jszh=? and jsmm=? and jszt='1'";	
	   	}else if(userclass.equals("2"))
	   	{
	   	  sqlStr="select xsid from m_student where xszh=? and xsmm=? and xszt='1'";	
	   	}else if(userclass.equals("3"))
	   	{
	   		
	   	}
	   	logger.info(sqlStr);
	   	try
	   	{
	   		stmt=conn.prepareStatement(sqlStr);
	   		stmt.setString(1,username);
	   		stmt.setString(2,userpwd);
	   		rs=stmt.executeQuery();
	   		if(rs.next())
	   		{
	   			userid=rs.getInt(1);
	   		}
	   		logger.info("userid:"+userid);
	   		
	        rs.close();
	   		stmt.close();
	   		if(userid!=0)
	   		{
	   			u_for=getUserInfor(userid,userclass);
	   			flag=true;
	   		}else
	   		{
	   			logger.info(username+",密码错误或没有该用户");
	   		}
	   	}catch(Exception e)
	   	{
	   		
	   	}finally
	   	{
	   		ProxoolAction.closeResultSet(rs);
	   		ProxoolAction.closeStatement(stmt);
	   		ProxoolAction.closeConnection(conn);
	   		
	   	}
		return flag;
	}
	
	public UserInfor getUserInfor()
	{
		return u_for;
	}
    public UserInfor  getUserInfor(int userid,String userclass)
    {
    	PreparedStatement stmt=null;
    	ResultSet rs=null;
    	u_for=new UserInfor();
    	try
    	{
            String u_class="";  //身份标识
    		String sqlStr="";
            logger.info("------------------------->:"+userclass);
    		if(userclass.equals("1"))        //查教师表
            {
               sqlStr="select jsid,jszh,jsxm,xxbh from m_teacher a,ms_school b where jsid=? and a.xxbh=b.ms_xxid";
               u_class="1";
            }else if(userclass.equals("2"))  //查学生表
            {
               sqlStr="select xsid,xszh,xsxm,xxbh from m_student a,ms_school b where xsid=? and a.xxbh=b.ms_xxid";
               u_class="2";
            }else if(userclass.equals("3"))   //管理人员
            {
               sqlStr="";	
            }
    		stmt=conn.prepareStatement(sqlStr);
    		stmt.setInt(1,userid);
    		
    		rs=stmt.executeQuery();
            if(rs.next())
            {
            	u_for.setUserid(rs.getInt(1));              //编号ID
            	u_for.setUsername(rs.getString(2));         //账号
            	u_for.setUserxm(rs.getString(3));           //用户姓名
            	u_for.setUserxxbh(rs.getInt(4));            //学校编号
            	u_for.setUserclass(u_class);                //用户身份  1为教师  2 为学生
            }
    	}catch(Exception e)
    	{
    		logger.error("用户登录出现异常:",e);
    	}finally
    	{
    		ProxoolAction.closeResultSet(rs);
    		ProxoolAction.closeStatement(stmt);;
    	}
    	return u_for;
    }
}