loginbean.java

教师办公管理系统

package to.model.Login;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import to.model.*;

public class LoginBean 
{
    Connection con=null;
    PreparedStatement ps=null;
    ResultSet rs=null;
    DBConnection db=new DBConnection("CollegePool",500);
    public String getPeople(String username,String userpwd)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("select * from kjc_People where UserName=? and UserPwd=?");
        ps.setString(1,username);
        ps.setString(2,userpwd);
        rs=ps.executeQuery();
        if(rs.next())
        {
          return "true";
        }
        else
        {
          return "false";
        }
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return "false";
      }//end block catch
    }//end method getPeople()
    
    
    public loginItem getUser(String username,String userpwd)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("select kjc_People.PeopleID,kjc_People.UserName,kjc_People.UserPwd,kjc_People.PeopleName,kjc_Role.RoleName from kjc_People,kjc_Role where kjc_Role.RoleID=kjc_People.RoleID and UserName=? and UserPwd=?");
        ps.setString(1,username);
        ps.setString(2,userpwd);
        rs=ps.executeQuery();
        loginItem li=new loginItem();
        while(rs.next())
        {
          li.setPeopleID(rs.getInt("PeopleID"));
          li.setUserName(rs.getString("UserName"));
          li.setPeopleName(rs.getString("PeopleName"));
          li.setRoleName(rs.getString("RoleName"));
        }
        return li;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end method getUser
}