signin.java

mail sent and revesive system jsp+mysql

package fengyun.Fastmail.beans;

import javax.mail.Session;
import java.util.Properties;
import javax.mail.Store;
import javax.mail.URLName;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * 系统登陆
 * @author sanware & fengyun
 * @version 1.01
 */
public class SignIn {

	/**
	 * 检查用户登陆
	 * @param request Http请求
	 * @return int
	 */
	public static int check(HttpServletRequest request) {
		
		BeansConstants CONST = BeansConstants.getInstance();				//常量集

		HttpSession httpsession = request.getSession(false);

		String userid = request.getParameter(CONST.userid);
		String passwd = request.getParameter(CONST.passwd);

		String sql = "SELECT userid,password,home FROM mailbox WHERE userid=? AND password = PASSWORD(?)";
		
		try {
			Mysql mysql = new Mysql(sql);
			mysql.setString(1,userid);
			mysql.setString(2,passwd);
			ResultSet RS = mysql.executeQuery();
			
			if (RS.next()) {

				String maildir = RS.getString(CONST.dbhome) + CONST.separator + CONST.maildir;
				
				httpsession.setAttribute(CONST.FastmailUserid,userid);
				httpsession.setAttribute(CONST.FastmailAddress,userid + '@' + CONST.domain);

				Properties props = System.getProperties();
				Session mailsession = Session.getDefaultInstance(props, null);
				mailsession.setDebug(CONST.debug);
				URLName urln = new URLName(CONST.maildir,CONST.mailhost,8008,maildir,userid,passwd);
				Store store = mailsession.getStore(urln);
				httpsession.setAttribute(CONST.FastmailStore,store);
				httpsession.setAttribute(CONST.FastmailMysql,mysql);

				if (mailsession.getDebug()) System.out.println("----------------getStore ok--------------");

				RS.close();
				RS = null;

				return CONST.OK;
			}
			RS.close();
			RS = null;
			return CONST.PASS_ERROR;
		}
		catch(Exception e) {
			e.printStackTrace();
			if (e instanceof SQLException) {
				return CONST.SQL_ERROR;
			}
			else {
				return CONST.DRIVER_ERROR;
			}
		}
	}
}