一:准备工作
1.需要你建立的我在下图已经全部展开,格外注意一下需要三个jar包,我会发给大家
链接:https://pan.baidu.com/s/1877WF7AcQD8lK1lzByK7Bg
提取码:c7s1
复制这段内容后打开百度网盘手机App,操作更方便哦
对了,图中朱丽是我最近看的《都挺好》中的一个女演员,甚是喜欢啊
2.接着放一张总体效果图,有兴趣的可以做一做。
二.数据库的表
1.这是完成的表
2.建表方法
三.JSP中的代码
1.先进行 jsp/login.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>登录</title>
</head>
<body>
<%
String name="";
//从cookie中获取名字name
Cookie[] cookies = request.getCookies();
System.out.println(cookies);
if(cookies!=null) {
for (Cookie cookie : cookies) {
if ("name".equals(cookie.getName())) {
name = cookie.getValue();
System.out.println("name="+name);
}
}
}
%>
${requestScope.info}
<form action="${pageContext.request.contextPath}/userServlet?type=login" method="post">
<input type="text" name="username" value="<%=name%>"/><br/>
<input type="password" name="password"/><br/>
<input type="submit" value="登录"/>
<input type="reset" value="重置"/>
</form>
</body>
</html>
2. 提交表单到Servlet配置文件中 WEB-INF/web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<session-config>
<session-timeout>1</session-timeout>
</session-config>
<servlet>
<servlet-name>userServlet</servlet-name>
<servlet-class>servlet.UserServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>userServlet</servlet-name>
<url-pattern>/userServlet</url-pattern>
</servlet-mapping>
</web-app>
3.通过映射找到Servlet的路径,进而到Servlet文件
package servlet;
import DAO.UserDao;
import pojo.User;
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 javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.List;
public class UserServlet extends HttpServlet {
UserDao userDao=new UserDao();
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//解决post方式下乱码问题
request.setCharacterEncoding("utf-8");
//派发 操作类型type
String type = request.getParameter("type");
if ("login".equals(type)) {
login(request,response);
}else if("add".equals(type)){
add(request,response);
}else if("queryall".equals(type)){
queryAll(request,response);
}else if("delete".equals(type)){
delete(request,response);
}else if("querybyid".equals(type)){
queryById(request,response);
}else if("edit".equals(type)){
edit(request,response);
}
}
private void edit(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
//从表单接收各个参数
int id=Integer.parseInt(request.getParameter("id"));
String username = request.getParameter("username");
String password = request.getParameter("password");
String gender = request.getParameter("gender");
int age = Integer.parseInt(request.getParamet