简单的Servlet请求和响应服务
实现功能
1.注册页面添加登录链接
2.登录页面添加注册链接
3.注册成功跳转到 登录页面
4.注册失败跳转到 注册页面
5.登陆成功跳转到 用户列表页面
6.登录失败跳转到 登录页面
一,项目结构
1.登录服务LoginServletJava代码
package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.servlet.util.DBUtil;
public class LoginServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 1. 将编码全部设为utf-8设置响应格式
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
// 2.处理请求
String pwd = request.getParameter("pwd");
String userName = request.getParameter("userName");
boolean isTrue = false;
Connection conn = DBUtil.getConn();
String sql = "SELECT * FROM users WHERE user_name=? AND pwd=?";
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement(sql);
ps.setString(1, userName);
ps.setString(2, pwd);
rs = ps.executeQuery();
if (rs.next()) {
isTrue = true;
} else {
isTrue = false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
DBUtil.close(conn, ps, rs);
// 处理响应
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
if (isTrue) {
out.println("登录成功");
} else {
out.println("登录失败");
response.sendRedirect("login.jsp");
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
}
2.注册服务RegServlet代码
package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.servlet.util.DBUtil;
public class