冲刺第十三天

今日完成功能：登录注册后端处理

登录：

package servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.Information;
import dao.Dao;

/**
 * Servlet implementation class LoginServlet
 */
@WebServlet("/LoginServlet")
public class LoginServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public LoginServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		String account=request.getParameter("account");
		String password=request.getParameter("password");
		Information data=new Information(account,password,"");
		Dao dao=new Dao();
		String result=dao.InformationQuery(data);
		PrintWriter out=response.getWriter();
		out.println(result);
		out.flush();
		out.close();
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

　　注册：

package servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.Information;
import dao.Dao;

/**
 * Servlet implementation class RegisterServlet
 */
@WebServlet("/RegisterServlet")
public class RegisterServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public RegisterServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		String account=request.getParameter("account");
		String password=request.getParameter("password");
		String email=request.getParameter("email");
		Information data=new Information(account,password,email);
		Dao dao=new Dao();
		String result=dao.Insertlogin(data);
		PrintWriter out=response.getWriter();
		out.println(result);
		out.flush();
		out.close();
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

　　数据库操作：

//登录验证
	public String InformationQuery(Information data) {
		String result="无此用户";
		String sql="select * from information";
		try {
			Connection con = Util.getConnection();
			PreparedStatement pa=con.prepareStatement(sql);
			ResultSet rs=pa.executeQuery();
			while(rs.next()) {
				String account=rs.getString("account");
				String password=rs.getString("password");
				if(data.getAccount().equals(account)&&data.getPassword().equals(password)) {
					result="登录成功";
				}
				else if(data.getAccount().equals(account)&&!data.getPassword().equals(password)) {
					result="密码错误";
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return result;
	}
	//登录
	public String Insertlogin(Information data) {
		String result;
		String sql="insert into information(account,password,email) values(?,?,?)";
		Dao dao=new Dao();
		result=dao.Query(data);
		if(result.equals("注册成功")) {
		 Connection con;
		 try {
			  	con = Util.getConnection();
			  	PreparedStatement pa=con.prepareStatement(sql);
			  	pa.setString(1,data.getAccount());
			  	pa.setString(2,data.getPassword());
			  	pa.setString(3,data.getEmail());
			  	pa.execute();
		     } catch (SQLException e) {
			// TODO Auto-generated catch block
		    	 e.printStackTrace();
		     }
	}
		return result;
	}
	//注册验证
	public String Query(Information data) {
		String result="注册成功";
		String sql="select * from information";
		try {
			Connection con = Util.getConnection();
			PreparedStatement pa=con.prepareStatement(sql);
			ResultSet rs=pa.executeQuery();
			while(rs.next()) {
				String account=rs.getString("account");
				String email=rs.getString("email");
				if(data.getAccount().equals(account)) {
					result="用户名已存在";
				}
				else if(data.getEmail().equals(email)) {
					result="邮箱已被注册";
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return result;
	}