registercontrollservlet.java

该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索

package ynuServlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import ynuBean.ConnectDataBase;
import ynuBean.GetDate;
import ynuBean.StrClass;
import ynuBean.User;

public class RegisterControllServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String toJsp = "/registerSuccess.jsp";
		User errInf = new User();
		StrClass str = new StrClass();

		/* 获取表单数据并存储在user类中 */
		String userId = request.getParameter("useralise").trim();
		String realName = request.getParameter("username").trim();
		String pwd = request.getParameter("userpassword");
		String checkPwd = request.getParameter("userrepawd");
		String email = request.getParameter("email").trim();
		String account = request.getParameter("account").trim();
		User user = new User(userId, pwd, realName, email, account);

		/* 检验申请帐号是否合法 */
		if (userId.equals("")) {
			errInf.setUsername("*本项必须填写!");
			toJsp = "/register.jsp";
		} else if (userId.length() > 10 || userId.length() < 4) {
			errInf.setUsername("*长度不符合要求!");
			user.setUsername("");
			toJsp = "/register.jsp";
		} else if (isExist(userId)) {
			errInf.setUsername("*帐号已经存在!");
			user.setUsername("");
			toJsp = "/register.jsp";
		}

		/* 检验申请密码是否合法 */
		if (pwd.equals("")) {
			errInf.setPwd("*本项必须填写!");
			toJsp = "/register.jsp";
		} else if (pwd.length() > 12 || pwd.length() < 6) {
			errInf.setPwd("*长度不符合要求!");
			user.setPwd("");
			toJsp = "/register.jsp";
		} else if (!pwd.equals(checkPwd)) {
			errInf.setPwd("*与确认密码不符!");
			user.setPwd("");
			toJsp = "/register.jsp";
		}

		/* 检验用户姓名是否合法 */
		if (realName.equals("")) {
			errInf.setRealname("*本项必须填写!");
			toJsp = "/register.jsp";
		}

		/* 检验帐号是否合法 */
		if (account.equals("")) {
			errInf.setAccountNum("*本项必须填写!");
			toJsp = "/register.jsp";
		} else {
			str.setStr(account);
			if (!str.isNum()) {
				errInf.setAccountNum("*电话号码应该为数字!");
				user.setAccountNum("");
				toJsp = "/register.jsp";
			}
		}

		/* 检验E-mail是否合法 */
		if (email.equals("")) {
			errInf.setEmail("*本项必须填写!");
			toJsp = "/register.jsp";
		} else {
			str.setStr(email);
			if (!str.isEmail()) {
				errInf.setEmail("*E-mial地址有误!");
				user.setEmail("");
				toJsp = "/register.jsp";
			}
		}
		/* 如果没有不合法项则将注册信息写入数据库 */
		if (!toJsp.equals("/register.jsp")) {
			String addUser = "INSERT INTO userinfo values('" + userId+"','" + realName+ "'," +
					"'" + email + "','" + account + "')";
			try {

				ConnectDataBase aConnect = new ConnectDataBase();
				Connection con = aConnect.getconnection();
				Statement sqlstatement = con.createStatement();
				sqlstatement.executeUpdate(addUser);

				String addPWD ="insert into login values('"+userId+"','"+pwd+"','user')";
				sqlstatement.executeUpdate(addPWD);
				
				con.close();
			} catch (SQLException e) {
				System.out.println(e.toString());
			} catch (Exception e) {
				System.out.println(e.toString());
			}
		}
		request.setAttribute("errInf", errInf);
		request.setAttribute("userInf", user);
		RequestDispatcher dispatcher = request.getRequestDispatcher(toJsp);
		dispatcher.forward(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

	public boolean isExist(String id) {
		boolean bool = false;
		String query = "SELECT * FROM userinfo WHERE UserName=" + "\'" + id
				+ "\'";
		try {
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			ResultSet resultset = sqlstatement.executeQuery(query);

			if (resultset.next()) {
				bool = true;
			}
			con.close();
		} catch (SQLException sqle) {
			System.out.println(sqle.toString());
		} catch (Exception e) {
			System.out.println(e.toString());
		}

		return bool;
	}
}