mlogin.java

Jsp做的网络邮件管理系统

/**
 *  
 */
package webMail.module;


/**
 *  引用数据库连接包
 */
import  webMail.DBCommon;
import  java.sql.*;
import  javax.servlet.http.HttpSession;

/**
 * @author up
 *
 */
public class MLogin
{
    public Statement  stmt = null;
    public ResultSet  rs   = null;
    public Connection conn  = null;
    
	public boolean  GetUserInfo(  
			                         HttpSession mySession, 
							         String username, 
							         String password
							       )
		{
				try
				{   
					
				    conn=DBCommon.getDBConnection();
				    stmt = conn.createStatement();
				    String sQuery = "select realname from user "
		                + "where username='" + username + "' "
		                + "and password='" + password +"'";
				    
		            rs = stmt.executeQuery( sQuery );
		            if ( rs.next() )
		            {
		                mySession.setAttribute("username",username);
		                mySession.setAttribute("realname",rs.getString(1) );
		                return true;
		            }
		            else
		            {
		                mySession.setAttribute("errMsg","用户名密码不正确！");
		                return false;
		            }
				}
				catch(Exception ex)
				{
					ex.printStackTrace();
					return  false;
				}
		}
}