JSP 期末考试复习试题
|
2,620
|
0
|
Web
|
mondayice

5945 字
|
25 分钟
本文最后更新于1014天前，其中的信息可能已经有所发展或是发生改变。
注意：DbConnection和JspUser根据自己数据库调整

MySQL表结构

Snipaste_2021-06-14_20-58-12

MySQL数据生成[Python]

然后复制结果扔SQL里面执行，懒得整python的链接数据库直接插数据 

#!/usr/bin/env python
# -*- coding:utf-8 -*-
# @Author:Mondayice
# @Date 2021年06月14日
# 
​
#insert into users(username,email,password) Values(?,?,?);
​
for i in range(6,26):
    print("insert into users(username,email,password) Values(\'test{}\',\'test{}@lyu.edu.cn\',\'lyuedu{}\');".format(i,i,i))

101九九乘法表

完成一个jsp页面，在页面上以表格的形式输出九九乘法表。

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ page import="java.io.*,java.util.*,java.lang.String" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>101</title>
</head>
<body>
<%
int c = 1;
​
out.println("<table align='center' border='6'>");
out.println("<caption><h1>九九乘法表</h1></caption>");
//out.println("<tr><th>id</th><th>username</th><th>email</th><th>password</th><th>详细</th></tr>");
for(int a = 1;a<=9;a++){
    out.print("<tr>");
    for(int b = 1;b<=a;b++){
        c = a*b;
        out.print("<td>"+b+"*"+a+"="+c+"</td>");
    }
    out.print("</tr>");
}
%>
</body>
</html>

102早、中、晚好

利用Date类的函数读取系统当前时间，根据不同的时间段，在浏览器输出不同的问候语，例如上午0-12点之间输出“早上好”，下午12-18点输出“下午好”，19-24点输出“晚上好”。

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ page import="java.io.*,java.util.*,java.lang.String" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>102</title>
</head>
<body>
    <%
        Date date = new Date();
​
        Calendar c = Calendar.getInstance();
        @SuppressWarnings("deprecation")
        int hour = date.getHours();
        if (hour >= 0 && hour < 12) {
            out.println("早上好！");
    %>
    <br />
    <%
        } else if (hour >= 12 && hour < 19) {
            out.println("下午好！");
    %>
    <br />
    <%
        } else {
            out.println("晚上好！");
        }
    %>
    <br />
​
</body>
</html>

103 include 计算

加载动态文件，制作一个JSP文件a，计算给定一个数的平方，然后再制作一个JSP文件b，应用jsp:include动作插入上述的JSP文件a，并且要求向所包含页面a传递参数，指定需要计算的数。

a.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ page import="java.io.*,java.util.*,java.lang.String" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
    <%
        int num = Integer.parseInt(request.getParameter("num"));
        out.println(num+"的平方是："+num*num);
     %>
</body>
</html>

b.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ page import="java.io.*,java.util.*,java.lang.String" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
     <jsp:include page="103a.jsp">
        <jsp:param value="19" name="num"/>
     </jsp:include>
</body>
</html>

104 四个判断跳转

页面跳转，制作一个jsp页面a，页面上要求有一个表单，表单包含两个单选按钮和一个提交按钮，表单提交到页面b，在b页面中根据用户选择的单选按钮分别用“jsp:forward”语句将页面跳转到页面c或页面d。

a.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ page import="java.io.*,java.util.*,java.lang.String" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
    <form action="104b.jsp" method="post">
​
        <input type="radio"  name="a"  value="male" >男&nbsp;
        <input type="radio"  name="a"  value="female" >女&nbsp;
​
        <input type="submit" value="登录">
    </form>
</body>
</html>

b.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ page import="java.io.*,java.util.*,java.lang.String" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
    <%String b = request.getParameter("a");%>
     <%if(b.equals("male")){%>
     <jsp:include page="104c.jsp"/>
     <% }else if(b.equals("female")){%>
     <jsp:include page="104d.jsp"/>
     <%   }  %>
</body>
</html>

c.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ page import="java.io.*,java.util.*,java.lang.String" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
male 男性
</body>
</html>

d.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ page import="java.io.*,java.util.*,java.lang.String" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
female 女性
</body>
</html>

201session内置对象的应用。

（1）设计第1个JSP网页(index1.jsp)，页面中为一表单，有2个文本框和一个提交按钮，用于输入姓名、班级，表单提交给第2个网页进行处理。表单中应有相应的标题，如：“请输入学生信息”，文本框前有相应的标签，如：“姓名：”、“班级：”等。 （2）设计第2个JSP网页(readStudent1.jsp)，获取第1个网页中用户输入的信息，并将其保存在会话上下文中。网页中添加到第3个JSP网页的链接。 （3）设计第3个JSP网页(showStudent.jsp)，获取会话上下文中的2个属性值，并在页面中显示其内容。

index1.jsp

<%@ page language="java" contentType="text/html; charset=GB2312"
    pageEncoding="GB2312"%>
<!DOCTYPE html>
<html>
<head>
<meta charset=GB2312>
<title>Insert title here</title>
</head>
<body>
<h1>Please Input Student's Information</h1>
<form method=post action=" readStudent1.jsp"> 
<table align=" center">
<tr>
​
<td>name:</td>
<td><input type=text name=name></td>
</tr>
<tr>
<td>class:</td>
<td><input type=text name=class></td>
<tr>
</tr>
<td colspan=2 align= "center">
<input  type=submit value="submint">
​
</td>
</table>
</form>
</body>
</html>
​

readStudent1.jsp

<%@ page language="java" contentType="text/html; charset=GB2312"
    pageEncoding="GB2312"%>
<!DOCTYPE html>
<html>
<head>
<meta charset=GB2312>
<title>readStudent1</title>
</head>
<body>
<%
    String name=request.getParameter("name");
    String classm=request.getParameter("class");
    out.println(name);
    session.setAttribute("name", new String(name.getBytes("ISO-8859-1")));
    session.setAttribute("class", classm);
    
    //response.sendRedirect("showStudent.jsp");
//              String userName = request.getParameter("userName");
//              String password = request.getParameter("password");
//              out.println("表单输入userName的值:" + new String(userName.getBytes("ISO-8859-1"), "gb2312")+ "<br>");
//              out.println("表单输入password的值:" + new String(password.getBytes("ISO-8859-1"), "gb2312")+ "<br>");
​
    %>
<a href="showStudent.jsp">showStudent.jsp</a>
​
​
</body>
</html>

showStudent.jsp

<%@ page language="java" contentType="text/html; charset=GB2312"
    pageEncoding="GB2312"%>
<!DOCTYPE html>
<html>
<head>
<meta charset=GB2312>
<title>Insert title here</title>
</head>
<body>
<h1>Student's Information</h1>
<%
String name = (String)session.getAttribute("name");
String classm = (String)session.getAttribute("class");
​
%>
<div> <%=name %></div>
​
<div> <%=classm %></div>
<%session.invalidate(); %>
<br>
方法一：销毁Session对象使用session.invalidate();方法，这样可以销毁当前浏览器的Session对象及其中存放的属性；<br>
方法二：因为判断用户是否登录是将某个属性通过session.setAttribute(fieldName);方法放入session中，然后在其他地方看取出是否是null值。<br>
所以可以使用session.removeAttribute(fieldName);方法清除该属性，从而达到退出的效果，但该方法未真正将Session对象销毁。<br>
​
关于Session的认识：Session在服务器上创建，且在创建之后会在服务器存在一段时间，当在这段时间内用户无操作的话，则Session会被销毁，<br>
否则Session会重新计算Session在这段时间是否有操作。<br>
当用户登录后且未退出，此时关闭浏览器。当再次打开浏览器，访问之前的页面，发现需要重新登录。<br>
这个现象并不是说关闭浏览器后Session就被销毁了，而是现在的浏览器已经找不到之前的那个Session对象了，<br>
此时需要再次登录，登录后又会创建一个新的Session对象，而之前的Session对象只能等他在生命周期结束后由服务器自动销毁。
​
</body>
</html>

202Cookie操作

（1）设计第1个JSP网页(cookie.jsp)，在其中保存一个Cookie，内容为当前日期时间，至少精确到秒。显示保存Cookie的文本提示信息和到第2个网页(readCookie.jsp)的链接。 （2）设计第2个JSP网页(readCookie.jsp)，获取上边第1个网页中保存的Cookie，并在页面中显示其内容。

cookie.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.io.*,java.util.*,java.lang.String" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Cookie</title>
</head>
<body>
<%
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd-HH:mm:ss");
java.util.Date currentTime = new java.util.Date();//
String str_date1 = formatter.format(currentTime); //••
String str_date2 = currentTime.toString(); //•
Cookie cookie = new Cookie("SESSION_LOGIN_USERNAME",str_date1); // 
cookie.setMaxAge(99999999);
response.addCookie(cookie);  
cookie.setMaxAge(14*24*60*60);
response.addCookie(cookie);
%>
<div>
<%=str_date1 %>
</div>
<a href = 'readCookie.jsp' >readCookie</a>
​
</body>
</html>

readCookie.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Read Cookie</title>
</head>
<body>
<h1> Cookie </h1>
​
<%
String TimeCookie = null;
Cookie[] cookies = request.getCookies();
for (Cookie cookie : cookies) {
    if ("SESSION_LOGIN_USERNAME".equals(cookie.getName())) {
      TimeCookie = cookie.getValue(); // 徕啰cookie畕畨敷啕
    }
  }
​
%>
​
<div>
</div>
​
<div><%=TimeCookie %>
</div>
​
</body>
</html>

203 Servlet设计

（1）设计第1个JSP网页(index2.jsp)，页面中为一表单，有2个文本框和一个提交按钮，用于输入姓名、班级，表单提交给下面的Servlet进行处理。表单中应有相应的标题，如：“请输入学生信息”，文本框前有相应的标签，如：“姓名：”、“班级：”等。 （2）设计1个Servlet(命名为StudentServlet.java)，获取第1个网页中用户输入的信息，并将其保存在请求上下文中，转到第2个JSP网页readStudent2.jsp。 （3）设计第2个JSP网页(readStudent2.jsp)，获取请求上下文中的2个属性值，并在页面中显示其内容。

index2.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form method=post action="/202/StudentServlet"> 
<table align="center" cellpadding="4" cellspacing="4"> 
<tr> 
<td colspan="2" align="center"><h3>input</h3></td> 
</tr> 
<tr> 
<td align="right">Name:</td> 
<td><input type="text" name="name"></td> 
</tr> 
<tr> 
<td align="right">Class:</td> 
<td><input type="text" name="classm"></td> 
</tr> 
<tr> 
<td colspan=2 align="center"> 
<input type="submit" value="submit">&nbsp;&nbsp;&nbsp; 
</tr> 
</table> 
</form> 
</body>
</html>

readStudent2.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%  
    String name = (String)session.getAttribute("name");
    String classm = (String)session.getAttribute("classm"); 
    %>
    <div><%=name %></div>
    <div><%=classm %></div>
</body>
</html>

StudentServlet.java

package StudentServlet;
​
import java.io.IOException;
import java.io.PrintWriter;
​
import javax.servlet.ServletException;
import javax.servlet.annotation.WebInitParam;
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;
​
/**
 * Servlet implementation class StudentServlet
 */
@WebServlet("/StudentServlet")
public class StudentServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    String classm; 
    String name; 
      
//  public void init() throws ServletException { 
//  //TODO Auto-generated method stub 
//  classm=getInitParameter("classm"); 
//  name=getInitParameter("name"); 
//  } 
    /**
     * @see HttpServlet#HttpServlet()
     */
    public StudentServlet() {
        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
        doPost(request, response);          
    }
​
    /**
     * @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);
        String name = request.getParameter("name");
        String classm = request.getParameter("classm");
        HttpSession session = request.getSession();
        session.setAttribute("name", name);
        session.setAttribute("classm", classm);
        response.sendRedirect("readStudent2.jsp");
        
        
​
    }
​
}
​

204 Servlet设计

（1）设计第1个JSP网页，页面中为一表单，有2个文本框和一个提交按钮，用于输入用户名、密码，表单提交给下面的Servlet进行处理。 表单中应有相应的标题，如：“信息录入页面”，文本框前有相应的标签，如：“用户名：”、“密码：”等。 （2）设计1个Servlet，前面的JSP网页提交后必须转向此Servlet；获取第1个网页中用户输入的信息并显示出来。 Servlet中配置2个初始化参数，参数名自定义，参数值分别为你的姓名、学号，在Servlet中获取初始化参数的值并显示出来。

index3.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form method=post action="/204/ShowStudent"> 
<table align="center" cellpadding="4" cellspacing="4"> 
<tr> 
<td colspan="2" align="center"><h3>input</h3></td> 
</tr> 
<tr> 
<td align="right">Name:</td> 
<td><input type="text" name="name"></td> 
</tr> 
<tr> 
<td align="right">Class:</td> 
<td><input type="text" name="classm"></td> 
</tr> 
<tr> 
<td colspan=2 align="center"> 
<input type="submit" value="submit">&nbsp;&nbsp;&nbsp; 
</tr> 
</table> 
</form> 
</body>
</html>

ShowStudent.java

​
​
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;
​
/**
 * Servlet implementation class ShowStudent
 */
@WebServlet("/ShowStudent")
public class ShowStudent extends HttpServlet {
    private static final long serialVersionUID = 1L;
    String classm; 
    String name; 
    
    
    
    
    
    public void init() throws ServletException { 
    //TODO Auto-generated method stub 
    classm=getInitParameter("classm"); 
    name=getInitParameter("name"); 
    } 
    /**
     * @see HttpServlet#HttpServlet()
     */
    public ShowStudent() {
        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"); 
        String name=request.getParameter("name"); 
        String classm=request.getParameter("classm"); 
        response.setContentType("text/html;charset=UTF-8"); 
        PrintWriter out = response .getWriter(); 
        out.println("<html>"); 
        out.println("<head>"); 
        out.println("<title>Second Servlet</title>"); 
        out.println("</head>"); 
        out.println("<body>"); 
        out.println("<div style='width:280px;margin:auto;padding:8px'>"); 
        out.println("<h3>Servlet输出</h3>"); 
        out.println("<hr/>"); 
        out.println("客户端提交的请求参数：<br/>"); 
        out.println("username = " + name + "<br/>"); 
        out.println("password = " + classm + "<br/>"); 
        out.println("<hr/>"); 
    }
    /**
     * @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);
    }
​
}
​

301用户登录功能设计

MySQL数据库服务器为本地localhost；数据库名为：jsptest；其中有一保存用户信息的数据表：jspuser，表结构与保存的用户信息见附图；MySQL用户可使用数据库的管理帐户root，密码为空。要求设计具有简易登录功能的JSP网页，具体内容与要求如下：

  1. 实体JavaBean，文件名为：JspUser.java；包结构为“yzs（姓名全拼的首字母）.test.jsp”；属性与数据表jspuser中的字段一致，用于保存输入的用户信息。
  2. 连接JavaBean，文件名为：DbConnection.java；包结构同上；实现与数据库连接的静态方法，方法名自定，返回Connection类型的对象。
  3. 数据访问JavaBean，文件名为：JspUserDao.java；包结构同上；实现登录功能的方法，方法名自定，调用DbConnection.java的静态方法建立与数据库的连接，然后查询数据库检查用户名与密码是否正确，返回boolean类型的值，确定是否登录成功。用户名与密码信息由方法的参数（JspUser.java类型的对象）提供。方法结束前需关闭数据库连接。
  4. 登录页面，文件名为login.jsp。在页面中设计一表单，有两个文本框和一个提交按钮，用于输入用户名与密码，表单提交给login_act.jsp进行处理。表单下方，根据页面跳转流程中传递的参数，显示相应的提示信息。要求网页中有相应的标题，如：“系统登录”，文本框前有相应的标签，如：“用户名：”、“密码：”等。
  5. 登录处理页面login_act.jsp，将login.jsp表单中用户输入的信息赋予JspUser Bean对象的相应属性中，判断用户名是否为空，如果为空，转回到login.jsp，在表单下方显示提示信息“Please enter the username！”或者“请输入用户名！”；用户名不为空，以JspUser Bean对象为参数调用JspUserDao对象的方法进行登录，登录不成功，转回到login.jsp，在表单下方显示提示信息“Wrong username or password ！”或者“用户名与密码错误！”；登录成功，转到下一个页面main.jsp。转向与参数传递方法自定。
  6. 目标页面main.jsp，该页面只有登录以后才能显示，在未登录的情况下访问该网页，会转到login.jsp，并在表单下方显示提示信息“Please login！”或者“请登录！”；登录后该页面显示用户名及其它标题信息，如：“登录成功”；在页面适当的位置设计“注销”按钮，点击该按钮，注销用户的登录信息，并转到login.jsp页面。页面访问保护控制代码可写在页面中，也可分离出来写在一个单独的文件中，包含到页面内；

login_act.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body> 
<jsp:useBean id="JspUserDao" class="sxj.test.JspUserDao" />
<jps:setProperty name = "JspUserDao"  property = "*"/>
<%
String name = request.getParameter("username");
​
String password = request.getParameter("password");
System.out.println(name);
if (name != null || name != "")
​
{
    boolean user = JspUserDao.login(name,password);
    if(user){
    
        //session.setAttribute("loginId", user.getId());
        session.setAttribute("loginUser", name);
        %>
        <jsp:forward page="main.jsp" />     
        <%
    }else{
        session.setAttribute("error","1");
    %>
    <jsp:forward page="login.jsp" />
    <%}
}else{
    session.setAttribute("error","2");
%>
<jsp:forward page="login.jsp" />
<%}%>
​
</body>
</html>

login.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<form method=post action="login_act.jsp">
<table align="center">
  <tr>
    <td>username</td>
    <td><input type=text name="username"></td>
  </tr>
  <tr>
    <td>password</td>
    <td><input type="password" name="password"></td>
  </tr>
  <tr>
    <td colspan=2 align="center">
      <input type=submit value="Login">&nbsp;&nbsp;&nbsp;&nbsp;
      <input type=reset value="Cancel">
    </td>
  </tr>
</table>
<%
String errorcode=(String)session.getAttribute("error");
if("1".equals(errorcode)){
    out.println("Wrong username or password");
    session.setAttribute("error","0");
}
if("2".equals(errorcode))
{   
    out.println("Please enter the username");
    session.setAttribute("error","0");
}
if("3".equals(errorcode))
{   
    out.println("Please login!");
    session.setAttribute("error","0");
}
%>
</form>
</body>
</html>

main.jsp

<!-- 
​
暂不实现
 -->
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Login Success</title>
</head>
<body>
<br>
<hr width="380">
<center>
<h1>
<%
String strlogin=(String)session.getAttribute("loginUser");
if(strlogin==null){
    session.setAttribute("error","3");
    response.sendRedirect("login.jsp");   
}
%>
<%out.print(strlogin);%>
Welcome
</h1>
<h2>
Login Success!!!<%= strlogin %> 
</h2>
</center>
​
</body>
</html>

DbConnection.java

package sxj.test;
​
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
​
public class DbConnection {
​
    public static Connection getConnection() {
        // TODO Auto-generated method stub
        Connection con = null;
        String drivername = "com.mysql.jdbc.Driver";
        String urlstr = "jdbc:mysql://localhost:3306/jsptest";
        String username = "root";
        String password = "";
        try{
            Class.forName(drivername);
        } catch (Exception e){
            System.out.println("error");
            System.out.println(e);
        }
        try{
            con = DriverManager.getConnection(urlstr,username,password);
        } catch (SQLException e){
            System.out.println("error");
            System.out.println(e);
        }
        return con;
    }
​
​
}
​

JspUser.java

package sxj.test;
​
public class JspUser {
​
    public int id;
    public String username;
    public String email;
    public String password;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
​
    
}
​

JspUserDao.java

package sxj.test;
​
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
​
//import com.jspdev.experiment.DbConnection;
//import com.jspdev.experiment.UserBean;
​
import sxj.test.*;
​
public class JspUserDao {
​
    // 定义私有变量保存连接对象
    private Connection con;
    // 增加一个用户，传递一个UserBean对象的参数
    // 该对象中存储了用户记录的信息
    public void addUser(JspUser user) throws Exception {
    con = DbConnection.getConnection();
    PreparedStatement pstmt = con.prepareStatement("insert into users(name,pwd)values(?,?)");
    pstmt.setString(1, user.getUsername());
    pstmt.setString(2, user.getPassword());
    pstmt.executeUpdate();
    pstmt.close();
    con.close();
    }
    // 验证登录，传递用户名和密码参数
    // 返回保存相应用户信息的UserBean对象，或者null
    public boolean login(String Username , String Password) throws Exception {
        con = DbConnection.getConnection();
        Statement stmt = con.createStatement();
        String strSql = "select * from users where username='" +Username+ "' and password='" +Password+ "';";
        System.out.println(strSql);
        ResultSet rs = stmt.executeQuery(strSql);
        JspUser item = null;
        while (rs.next()) {
            item = new JspUser();
            //item.setId(rs.getInt("id"));
            item.setUsername(rs.getString("username"));
            item.setPassword(rs.getString("password"));
            if(Username.equals(rs.getString("username"))&& Password.equals(rs.getString("password"))){
                rs.close();
                stmt.close();
                con.close();
                return true;
            }
        }
        return false;
​
        //return item;
        }
}
​

302数据插入操作。

具体内容与要求如下：

  1. 实体JavaBean，文件名为：JspUser.java；包结构为“yzs（你姓名全拼的首字母）.test.jsp”；属性与数据表jspuser中的字段一致，用于保存输入的用户信息。sxj.test.jsp
  2. 连接JavaBean，文件名为：DbConnection.java；包结构同上；实现与数据库连接的静态方法，方法名自定，返回Connection类型的对象。
  3. 数据访问JavaBean，文件名为：JspUserDao.java；包结构同上；实现两个方法，第1个方法，方法名自定，参数为JspUser类型的对象。该方法调用DbConnection.java的静态方法建立与数据库的连接，然后查询数据库检查用户名或者电子邮箱是否已存在，返回boolean类型的值。 select * from jspuser where username=? or email=? boolean a=false; if(rs.next()) a=true; return a;

第2个方法，参数同第1个函数，返回整数值，实现注册功能 int a=pt.executeUpate(); return a;

  1. 注册页面，文件名为register.jsp。在页面中设计一表单，有四个文本框和一个提交按钮，用于输入用户名、电子邮箱、密码与密码确认，表单提交给reg_act.jsp进行处理。表单下方，根据页面运行流程中传递的参数，显示相应的提示信息。要求网页中有相应的标题，如：“用户注册”，文本框前有相应的标签，如：“用户名：”、“电子邮箱：”、“密码：”、“密码确认：”等。
  2. 注册处理页面reg_act.jsp，将register.jsp表单中用户输入的信息赋予JspUser Bean对象的相应属性中，以JspUser Bean对象为参数调用JspUserDao对象的第1个方法检查用户名或者电子邮箱是否存在，如果存在，转回到register.jsp，在表单下方显示提示信息“The username has existed or email address has already registered!”或者“用户名已存在或者电子邮箱已注册！”；否则，调用JspUserDao对象的第2个方法进行注册，注册成功，转到下一个页面userinfo.jsp；否则，转回到register.jsp，在表单下方显示提示信息“Error occured in database operation! Please tyr again!”或者“数据库操作错误，请重试！”。转向与参数传递方法自定。

(不要求必须实现：在调用JspUserDao的方法之前，最好加上验证，判断用户名、电子邮箱、密码与密码确认是否为空，如果验证未通过，转回到main.jsp，在表单下方显示提示信息“You must input username, email, password and confirm passord!”或者“用户名、电子邮箱、密码和密码确认都必须输入，不能为空！”；否则，继续判断用户名、电子邮箱、密码与密码格式以及长度是否小于数据库中相应字段的长度，如果验证未通过，转回到imain.jsp，在表单下方显示提示信息“You must input username, email, password and confirm passord with english letter, digits or underscore character, and their length must be less 20!”或者“用户名、电子邮箱、密码和密码确认都必须输入字母、数字、下划线，且长度应小于20！”；否则，继续判断电子邮箱格式是否正确（邮箱地址包含@字符），如果不正确，转回到main.jsp，在表单下方显示提示信息“Incorrect email address!”或者“电子邮箱格式不正确！”；否则，继续判断密码与确认密码是否一致，如果不一致，转回到main.jsp，在表单下方显示提示信息“The password and confirm passord are not same!”“两次输入的密码不一致！”。验证部分不作要求，可用客户端JavaScript实现。)

  1. 注册信息页面userinfo.jsp，在页面显示注册成功提示，并显示用户名、电子邮箱、密码。

DbConnection.java

package sxj.test;
​
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
​
public class DbConnection {
​
    public static Connection getConnection() {
        // TODO Auto-generated method stub
        Connection con = null;
        String drivername = "com.mysql.jdbc.Driver";
        String urlstr = "jdbc:mysql://localhost:3306/jsptest";
        String username = "root";
        String password = "";
        try{
            Class.forName(drivername);
        } catch (Exception e){
            System.out.println("error");
            System.out.println(e);
        }
        try{
            con = DriverManager.getConnection(urlstr,username,password);
        } catch (SQLException e){
            System.out.println("error");
            System.out.println(e);
        }
        return con;
    }
​
​
}
​

JspUser.java

package sxj.test;
​
public class JspUser {
​
    public int id;
    public String username;
    public String email;
    public String password;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
​
    
}
​

JspUserDao.java

package sxj.test;
​
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import sxj.test.*;
​
public class JspUserDao {
    private Connection con;
    public int add(JspUser user)throws Exception {
        //boolean isLogin = false;
        con = DbConnection.getConnection();
        //      String sql = "inset into users(username,email,password) Values(?,?,?)";
        PreparedStatement pstmt = con.prepareStatement("insert into users(username,email,password) Values(?,?,?)");
        pstmt.setString(1, user.getUsername());
        pstmt.setString(2, user.getEmail());
        pstmt.setString(3, user.getPassword());
        int i = pstmt.executeUpdate();
        pstmt.close();
        con.close();
        //返回更新数据的数量
        return i;
    }
    public boolean login(String Username , String Password) throws Exception {
        boolean isLogin = false;
        con = DbConnection.getConnection();
        Statement stmt = con.createStatement();
        String strSql = "select * from users where username='" +Username+ "' and password='" +Password+ "';";
        System.out.println(strSql);
        ResultSet rs = stmt.executeQuery(strSql);
//      JspUser item = null;
//      while (rs.next()) {
//          item = new JspUser();
//          //item.setId(rs.getInt("id"));
//          item.setUsername(rs.getString("username"));
//          item.setPassword(rs.getString("password"));
//          if(Username.equals(rs.getString("username"))&& Password.equals(rs.getString("password"))){
//              rs.close();
//              stmt.close();
//              con.close();
//              return true;
//          }
//      }
//      return false;
        //session.invalidate();销毁Session
​
        if(rs.next()){
            isLogin=true;
        }
        rs.close();
        stmt.close();
        con.close();
        return isLogin;
        //return item;
        }
    public boolean check(JspUser user)throws Exception{
        boolean isLogin = false;
        String username= user.getUsername();
        String email= user.getEmail();
        con = DbConnection.getConnection();
        Statement stmt = con.createStatement();
        String strSql = "select * from users where username='" +username+ "' or email='" +email+ "';";
        System.out.println(strSql);
        ResultSet rs = stmt.executeQuery(strSql);
​
        if(rs.next()){
            isLogin=true;
        }
        rs.close();
        stmt.close();
        con.close();
        return isLogin;
    }
}
​

main.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
​
<%
String strlogin=(String)session.getAttribute("loginUser");
if(strlogin==null){
    session.setAttribute("error","3");
    response.sendRedirect("login.jsp");
}
%>
<%out.print(strlogin);%>
Welcome••
</h1>
<h2>Login Success!!!<%= strlogin %></h2>
</center>
​
</body>
</html>

reg_act.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ page import="sxj.test.JspUserDao"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="JspUserDao" class="sxj.test.JspUserDao" />
<jsp:useBean id="JspUser" scope="page" class="sxj.test.JspUser" />
<%String name = request.getParameter("username");
String password = request.getParameter("password");
String email = request.getParameter("email");%>
<jsp:setProperty name="JspUser" property="*" />
​
<%
// javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
//You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 
//'inset into users(username,email,password) Values('test3','test3@123.com','123')' at line 1
//if(name == null || name == ""|| password == null || password == ""||email == null || email == ""){    }
String info = "";
if(JspUserDao.check(JspUser)){
    info = "用户名已存在或者电子邮箱已注册！";
    request.setAttribute("info",info);%>
    <jsp:forward page="register.jsp" />
    
<%}else{
    if(JspUserDao.add(JspUser)>0){
        session.setAttribute("name", name);
        session.setAttribute("password", password);
        session.setAttribute("email", email);
        %><jsp:forward page="userinfo.jsp" /><%
    }else{
        info = "数据库操作错误，请重试！";
        request.setAttribute("info",info);
        %>
        <jsp:forward page="register.jsp" />
    <%  
    }
}%>
</body>
</html>

register.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<form method=post action="reg_act.jsp">
​
​
<table align="center">
    <tr>
    <td colspan=2 align="center">
    <h1>register</h1>
    </td>
  </tr>
  <tr>
    <td>username</td>
    <td><input type=text name="username"></td>
  </tr>
    <tr>
    <td>email</td>
    <td><input type=text name="email"></td>
  </tr>
  <tr>
    <td>password</td>
    <td><input type="password" name="password" id="password"></td>
  </tr>
  
    <tr>
    <td>Password Confirm:</td>
    <td>
    <input type="password" name="password1" id="password1"  onkeyup="validate()" >
    <span id="tishi"></span>
    </td>
  </tr>
  
  <tr>
    <td colspan=2 align="center">
      <input type=submit value="Login" id="button" style="width: 108px">&nbsp;&nbsp;&nbsp;&nbsp;
      <!-- <input type=reset value="Cancel"> -->
    </td>
  </tr>
    <tr>
    <td colspan=2 align="center">
    <%=request.getAttribute("info")==null?"":request.getAttribute("info")%>
    </td>
  </tr>
  
</table>
​
</form>
<script>
function validate() {
    var pwd1 = document.getElementById("password").value;
    var pwd2 = document.getElementById("password1").value;
<!-- 对比两次输入的密码 -->
    if(pwd1 == pwd2)
     {
        document.getElementById("tishi").innerHTML="<font color='green'>两次密码相同</font>";
        document.getElementById("button").disabled = false;
     }
else {
        document.getElementById("tishi").innerHTML="<font color='red'>两次密码不相同</font>";
​
        document.getElementById("button").disabled = true;
     }
}
</script>
​
</body>
</html>

userinfo.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<style type="text/css">
ul {
    list-style: none; /*设置不显示项目符号*/
    margin: 0px; /*设置外边距*/
    padding: 5px; /*设置内边距*/
}
 
li {
    padding: 5px; /*设置内边距*/
}
</style>
​
<jsp:useBean id="JspUser" scope="page" class="sxj.test.JspUser" />
<table align="center" style="width: 320px; ">
    <tr>
    <td colspan=2 align="center">
    <h1>UserInfo</h1>
    </td>
  </tr>
  <tr>
    <td>username</td>
    <td><%=session.getAttribute("name")%></td>
  </tr>
    <tr>
    <td>email</td>
    <td><%=session.getAttribute("email")%></td>
  </tr>
  <tr>
    <td>password</td>
    <td><%=session.getAttribute("password")%></td>
  </tr>
</table>
​
</body>
</html>

303数据库查询。

要求设计查询数据库，浏览用户信息的JSP网页，具体内容与要求如下：

  1. 实体JavaBean，文件名为：JspUser.java；包结构为“yzs（你姓名全拼的首字母）.test.jsp”；属性与数据表jspuser中的字段一致，用于保存输入的用户信息。
  2. 连接JavaBean，文件名为：DbConnection.java；包结构同上；实现与数据库连接的静态方法，方法名自定，返回Connection类型的对象。
  3. 数据访问JavaBean，文件名为：JspUserDao.java；包结构同上；实现三个方法，第1个方法，方法名自定，无参数。该方法调用DbConnection.java的静态方法建立与数据库的连接，然后查询数据库检索jspuser表中的所有记录，每条记录的数据封装在一个JspUser Bean中，所有的JspUser Bean对象组成一个List对象，返回List对象。第2个方法，参数为用户ID，整数类型，从jspuser表中查询指定ID的用户记录，将记录中的用户信息封装到JspUser Bean中，返回该JspUser Bean对象。第3个方法，参数为字符串，查询jspuser数据表中用户名包含字符串参数的所有记录，每条记录的数据封装在一个JspUser Bean中，所有的JspUser Bean对象组成一个List对象，返回List对象。方法结束前需关闭数据库连接。import java.util.*; public ArrayList<JspUser> getAllUser() throws Exception {Statement stmt = con.createStatement();
    ArrayList<JspUser> data = new ArrayList<JspUser>();
    String strSql = "select * from jspuser";
    ResultSet rs = stmt.executeQuery(strSql);
    while (rs.next()) {
    JspUser item = new JspUser();
    item.setId(rs.getInt("id"));
    item.setUsername(rs.getString("username"));
    item.setPassword(rs.getString("password"));
    item.setEmail(rs.getString("email"));
    data.add(item);
    }
    ​
       rs.close();
       stmt.close();
       con.close();
       return data;
    }
    ​
    ​
    ​PreparedStatement ptmt = con.prepareStatement("select * from jspuser where username like ?");
    ptmt.setString(1, "%" + name + "%");
  4. 用户信息浏览页面，文件名为main.jsp。在页面中引入JspUserDao Bean，调用其第1个方法，获取保存所有用户信息的List对象，循环遍历List对象中所有的元素和每个元素（JspUser 对象）中的所有属性，用表格显示出来，每条记录（JspUser 中保存的用户信息）为一行，每个字段（JspUser Bean中的每个属性）为一列，每行的最后一列为“详细”链接，链接到detail.jsp页面，传递用户ID参数。用户信息列表下面为一表单，有一文本框和提交按钮，表单提交给search.jsp，模糊查询用户名包含文本框中用户输入内容的所有用户。
ArrayList<JspUser> data = jspexdb.getAllUser();
Iterator<JspUser> it = data.iterator();
while (it.hasNext()) {
JspUser temp =  it.next();
​
int id=temp.getId();
out.println("<td>"+"<a href=detail.jsp?id="+id+">详细</a>"+"</td>");}
或者for(int i=0; i<data.size(); i++) {
    JspUser item =data.get(i);
  1. 用户详细信息页面detail.jsp，获取main.jsp传递的用户ID参数，引入JspUserDao Bean，调用其第2个方法，获取id为参数值的记录，返回保存该用户信息的JspUser对象，用表格显示用户信息，每个字段为一行。
  2. 用户模糊查询页面search.jsp，获取main.jsp提交的用户在文本框中输入的参数，引入JspUserDao Bean，调用其第3个方法，查询用户名包含main.jsp提交的参数的所有用户，返回封装用户数据的List对象，循环遍历List对象中所有的元素和每个元素（JspUser对象）中的所有属性，用表格显示出来，每条记录（JspUser中保存的用户信息）为一行，每个字段（JspUser Bean中的每个属性）为一列。

DbConnection.java

package sxj.test;
​
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
​
public class DbConnection {
​
    public static Connection getConnection() {
        // TODO Auto-generated method stub
        Connection con = null;
        String drivername = "com.mysql.jdbc.Driver";
        String urlstr = "jdbc:mysql://localhost:3306/jsptest";
        String username = "root";
        String password = "";
        try{
            Class.forName(drivername);
        } catch (Exception e){
            System.out.println("error");
            System.out.println(e);
        }
        try{
            con = DriverManager.getConnection(urlstr,username,password);
        } catch (SQLException e){
            System.out.println("error");
            System.out.println(e);
        }
        return con;
    }
​
​
}

JspUser.java

package sxj.test;
​
public class JspUser {
​
    public int id;
    public String username;
    public String email;
    public String password;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
​
    
}
​

JspUserDao.java

package sxj.test.jsp;
​
​
import java.sql.Connection;
import java.util.*;
​
import sxj.test.jsp.DbConnection;
import sxj.test.jsp.*;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
​
​
public class JspUserDao {
    private Connection con;
    public ArrayList<JspUser> getAllUser() throws Exception {
        
            con = DbConnection.getConnection();
            Statement stmt = con.createStatement();
            //con = DbConnection.getConnection();
            //Statement stmt = con.createStatement();
            ArrayList<JspUser> data = new ArrayList<JspUser>();
            String strSql = "select * from users";
            ResultSet rs = stmt.executeQuery(strSql);
            while (rs.next()) {
                JspUser item = new JspUser();
                item.setId(rs.getInt("id"));
                item.setUsername(rs.getString("username"));
                item.setPassword(rs.getString("password"));
                item.setEmail(rs.getString("email"));
                data.add(item);
            }
            rs.close();
            stmt.close();
            con.close();
            return data;
        }
​
    public JspUser getuser(int id)throws Exception{
    
        JspUser item = new JspUser();
//      ArrayList<JspUser> data = new ArrayList<JspUser>();
        
        con = DbConnection.getConnection();
        PreparedStatement ptmt = con.prepareStatement("select * from users where id=?");
        ptmt.setString(1,Integer.toString(id));
        ResultSet rs=ptmt.executeQuery();
        
        while (rs.next()) {
            item.setId(rs.getInt("id"));
            item.setUsername(rs.getString("username"));
            item.setPassword(rs.getString("password"));
            item.setEmail(rs.getString("email"));
        }
        rs.close();
        ptmt.close();
        con.close();
        return item;
    }
    
    
    public ArrayList<JspUser> userAll(String name)throws Exception{
        ArrayList<JspUser> data = new ArrayList<JspUser>();
        
        con = DbConnection.getConnection();
        PreparedStatement ptmt = con.prepareStatement("select * from users where username like ?");
        ptmt.setString(1, "%" + name + "%");
        ResultSet rs=ptmt.executeQuery();
        while (rs.next()) {
            JspUser item = new JspUser();
            item.setId(rs.getInt("id"));
            item.setUsername(rs.getString("username"));
            item.setPassword(rs.getString("password"));
            item.setEmail(rs.getString("email"));
            data.add(item);
        }
        return data;
    }
}
​

detail.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="sxj.test.jsp.JspUserDao"%>
    <%@ page import="sxj.test.jsp.JspUser"%>
    <%@ page import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="JspUser" scope="page" class="sxj.test.jsp.JspUser" />
<jsp:useBean id="JspUserDao" class="sxj.test.jsp.JspUserDao" />
<%
String id = "1";
id = request.getParameter("id");
JspUser data = JspUserDao.getuser(Integer.parseInt(id));
int idu =data.getId();
String username = data.getUsername();
String email = data.getEmail();
String password = data.getPassword();
​
out.println("<table align='center' border='6'>");
out.println("<caption><h1>UserInfo</h1></caption>");
out.println("<tr><td>id</td><td>"+id+"</td></tr>");
out.println("<tr><td>username</td><td>"+username+"</td></tr>");
out.println("<tr><td>email</td><td>"+email+"</td></tr>");
out.println("<tr><td>password</td><td>"+password+"</td></tr>");
out.println("</table>");
​
​
%>
​
​
​
</body>
</html>

main.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="sxj.test.jsp.JspUserDao"%>
    <%@ page import="sxj.test.jsp.JspUser"%>
    <%@ page import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="JspUser" scope="page" class="sxj.test.jsp.JspUser" />
<jsp:useBean id="JspUserDao" class="sxj.test.jsp.JspUserDao" />
<%
List<JspUser> data = JspUserDao.getAllUser();
Iterator<JspUser> it = data.iterator();
out.println("<table align='center' border='6'>");
out.println("<caption><h1>UserList</h1></caption>");
out.println("<tr><th>id</th><th>username</th><th>email</th><th>password</th><th>详细</th></tr>");
​
while (it.hasNext()) {
    JspUser temp =  it.next();
    int id=temp.getId();
    String username = temp.getUsername();
    String email = temp.getEmail();
    String password = temp.getPassword();
//  out.println(id+" | ");
//  out.println(username+" | ");
//  out.println(email+" | ");
//  out.println(password+" | ");
//  out.println("<tr><td>id</td><td>"+id+"</td></tr>");
​
    out.println("<tr><td>"+id+"</td><td>"+username+"</td><td>"+email+"</td><td>"+password+"</td><td>"+"<a href=detail.jsp?id="+id+">详细</a>"+"</td></tr>");
​
    //  out.println("<tr><td>email</td><td>"+email+"</td></tr>");
//  out.println("<tr><td>password</td><td>"+password+"</td></tr>");
//  out.println("<td>"+"<a href=detail.jsp?id="+id+">详细</a>"+"</td>");
    //out.println("<br>");
}
out.println("</table>");
%>
<form method=post action="search.jsp" >
<br>
<div align='center'>
    用户名搜索：
    <input type=text name="username">
    <input type=submit value="Search" id="button" style="width: 108px; ">
</div>
​
</form>
</body>
</html>

search.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="sxj.test.jsp.JspUserDao"%>
    <%@ page import="sxj.test.jsp.JspUser"%>
    <%@ page import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="JspUser" scope="page" class="sxj.test.jsp.JspUser" />
<jsp:useBean id="JspUserDao" class="sxj.test.jsp.JspUserDao" />
<%
String username = "test";
username = request.getParameter("username");
//JspUser data = JspUserDao.getuser(Integer.parseInt(id));
List<JspUser> data = JspUserDao.userAll(username);
Iterator<JspUser> it = data.iterator();
out.println("<table align='center' border='6'>");
out.println("<caption><h1>Search Result</h1></caption>");
out.println("<tr><th>id</th><th>username</th><th>email</th><th>password</th><th>详细</th></tr>");
​
while (it.hasNext()) {
    JspUser temp =  it.next();
    int id=temp.getId();
    String usernamef = temp.getUsername();
    String email = temp.getEmail();
    String password = temp.getPassword();
//  out.println(id+" | ");
//  out.println(username+" | ");
//  out.println(email+" | ");
//  out.println(password+" | ");
//  out.println("<tr><td>id</td><td>"+id+"</td></tr>");
​
    out.println("<tr><td>"+id+"</td><td>"+usernamef+"</td><td>"+email+"</td><td>"+password+"</td><td>"+"<a href=detail.jsp?id="+id+">详细</a>"+"</td></tr>");
​
    //  out.println("<tr><td>email</td><td>"+email+"</td></tr>");
//  out.println("<tr><td>password</td><td>"+password+"</td></tr>");
//  out.println("<td>"+"<a href=detail.jsp?id="+id+">详细</a>"+"</td>");
    //out.println("<br>");
}
out.println("</table>");
%>
</body>
</html>

304数据更新操作。

具体内容与要求如下：

  1. 实体JavaBean，文件名为：JspUser.java；包结构为“yzs（你姓名全拼的首字母）.test.jsp”；属性与数据表jspuser中的字段一致，用于保存输入的用户信息。
  2. 连接JavaBean，文件名为：DbConnection.java；包结构同上；实现与数据库连接的静态方法，方法名自定，返回Connection类型的对象。
  3. 数据访问JavaBean，文件名为：JspUserDao.java；包结构同上；实现三个方法，第1个方法，方法名自定，无参数。该方法调用DbConnection.java的静态方法建立与数据库的连接，然后查询数据库检索jspuser表中的所有记录，每条记录的数据封装在一个JspUser Bean中，所有的JspUser Bean对象组成一个List对象，返回List对象。第2个方法，参数为用户ID，整数类型，从jspuser表中查询指定ID的用户记录，将记录中的用户信息封装到JspUser Bean中，返回该JspUser Bean对象。第3个方法，参数为JspUser Bean对象，返回整数值，实现该用户信息的更新功能。
  4. 用户信息浏览页面，文件名为main.jsp。在页面中引入JspUserDao Bean，调用其第1个方法，获取保存所有用户信息的List对象，循环遍历List对象中所有的元素和每个元素（JspUser 对象）中的所有属性，用表格显示出来，每条记录（JspUser 中保存的用户信息）为一行，每个字段（JspUser Bean中的每个属性）为一列，每行的最后一列为修改链接，链接到userupdate.jsp页面，传递用户ID参数。
  5. 更新页面userupdate.jsp，获取main.jsp传递的用户ID参数，引入JspUserDao Bean，调用其第2个方法，获取保存要更新的用户信息的User对象，在页面中设计一表单，有四个文本框和一个提交按钮，用于输入用户名、电子邮箱、密码与密码确认，用JspUser对象的属性值填充相应的文本框。表单提交给update_act.jsp进行处理。要求网页中有相应的标题，如：“用户信息更新”，文本框前有相应的标签，如：“用户名：”、“电子邮箱：”、“密码：”、“密码确认：”等<%
    String id=request.getParameter("id");
    JspUser udata=dbop.getUserById(id);
    %>
    <input type="hidden" name="id" value="<%=udata.getId() %>">

最好加上验证，判断用户名、电子邮箱、密码与密码确认是否为空,如果验证未通过，转回到userupdate.jsp，在表单下方显示提示信息“You must input username, email, password and confirm passord!”或者“用户名、电子邮箱、密码和密码确认都必须输入，不能为空！”；否则，继续判断用户名、电子邮箱、密码与密码格式以及长度是否小于数据库中相应字段的长度，如果验证未通过，转回到userupdate.jsp，在表单下方显示提示信息“You must input username, email, password and confirm passord with english letter, digits or underscore character, and their length must be less 20!”或者“用户名、电子邮箱、密码和密码确认都必须输入字母、数字、下划线，且长度应小于20！”；否则，继续判断电子邮箱格式是否正确（邮箱地址包含@字符），如果不正确，转回到userupdate.jsp，在表单下方显示提示信息“Incorrect email address!”或者“电子邮箱格式不正确！”；否则，继续判断密码与确认密码是否一致，如果不一致，转回到userupdate.jsp，在表单下方显示提示信息“The password and confirm passord are not same!”“两次输入的密码不一致！”。验证部分不作要求，也可用客户端JavaScript实现。

  1. 更新处理页面update_act.jsp，将userupdate.jsp表单中用户输入的信息赋予JspUser Bean对象中，以JspUser Bean对象为参数调用JspUserDao对象的第3个方法更新用户信息，更新成功，转到main.jsp，否则，转回到userupdate.jsp，在表单下方显示提示信息“Error occured in database operation! Please tyr again!”或者“数据库操作错误，请重试！” <jsp:useBean id="user" class="yzs.test.jsp.JspUser" scope="request" /> <jsp:setProperty name="user" property="*" /> <jsp:useBean id="dbop" class="yzs.test.jsp.JspUserDao" /> if (dbop.modifyUser(user) > 0) {}

DbConnection.java

package sxj.test;
​
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
​
public class DbConnection {
​
    public static Connection getConnection() {
        // TODO Auto-generated method stub
        Connection con = null;
        String drivername = "com.mysql.jdbc.Driver";
        String urlstr = "jdbc:mysql://localhost:3306/jsptest";
        String username = "root";
        String password = "";
        try{
            Class.forName(drivername);
        } catch (Exception e){
            System.out.println("error");
            System.out.println(e);
        }
        try{
            con = DriverManager.getConnection(urlstr,username,password);
        } catch (SQLException e){
            System.out.println("error");
            System.out.println(e);
        }
        return con;
    }
​
​
}
​

JspUser.java

package sxj.test;
​
public class JspUser {
​
    public int id;
    public String username;
    public String email;
    public String password;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
​
    
}
​

JspUserDao.java

package sxj.test.jsp;
​
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
​
import sxj.test.jsp.DbConnection;
import sxj.test.jsp.JspUser;
​
public class JspUserDao {
​
    private Connection con;
    public ArrayList<JspUser> getAllUser() throws Exception {
        
            con = DbConnection.getConnection();
            Statement stmt = con.createStatement();
            //con = DbConnection.getConnection();
            //Statement stmt = con.createStatement();
            ArrayList<JspUser> data = new ArrayList<JspUser>();
            String strSql = "select * from users";
            ResultSet rs = stmt.executeQuery(strSql);
            while (rs.next()) {
                JspUser item = new JspUser();
                item.setId(rs.getInt("id"));
                item.setUsername(rs.getString("username"));
                item.setPassword(rs.getString("password"));
                item.setEmail(rs.getString("email"));
                data.add(item);
            }
            rs.close();
            stmt.close();
            con.close();
            return data;
        }
    public JspUser getuser(int id)throws Exception{
        
        JspUser item = new JspUser();
//      ArrayList<JspUser> data = new ArrayList<JspUser>();
        
        con = DbConnection.getConnection();
        PreparedStatement ptmt = con.prepareStatement("select * from users where id=?");
        ptmt.setString(1,Integer.toString(id));
        ResultSet rs=ptmt.executeQuery();
        
        while (rs.next()) {
            item.setId(rs.getInt("id"));
            item.setUsername(rs.getString("username"));
            item.setPassword(rs.getString("password"));
            item.setEmail(rs.getString("email"));
        }
        rs.close();
        ptmt.close();
        con.close();
        return item;
    }
​
    public ArrayList<JspUser> userAll(String name)throws Exception{
        ArrayList<JspUser> data = new ArrayList<JspUser>();
        
        con = DbConnection.getConnection();
        PreparedStatement ptmt = con.prepareStatement("select * from users where username like ?");
        ptmt.setString(1, "%" + name + "%");
        ResultSet rs=ptmt.executeQuery();
        while (rs.next()) {
            JspUser item = new JspUser();
            item.setId(rs.getInt("id"));
            item.setUsername(rs.getString("username"));
            item.setPassword(rs.getString("password"));
            item.setEmail(rs.getString("email"));
            data.add(item);
        }
        return data;
    }
    public int upDate(JspUser user)throws Exception {
        //boolean isLogin = false;
        con = DbConnection.getConnection();
        //      String sql = "inset into users(username,email,password) Values(?,?,?)";  UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson' 
        PreparedStatement pstmt = con.prepareStatement("UPDATE users SET username=?,email=?,password=? WHERE id = ?");
        pstmt.setString(1, user.getUsername());
        pstmt.setString(2, user.getEmail());
        pstmt.setString(3, user.getPassword());
        pstmt.setString(4, Integer.toString(user.getId()));
        int i = pstmt.executeUpdate();
        pstmt.close();
        con.close();
        //返回更新数据的数量
        return i;
    }
    public boolean FormatEmail(String str)throws Exception{
        //String str = "";
        String pattern = "\\w[-\\w.+]*@([A-Za-z0-9][-A-Za-z0-9]+\\.)+[A-Za-z]{2,14}";
​
        Pattern r = Pattern.compile(pattern);
        Matcher m = r.matcher(str);
        if(m.matches()) {
            return true;
        }else {
            return false;           
        }
​
    }
//  public int getcolength(String columns)throws Exception{
//      ///select length('fdasfsafasf');
//      int length = 0;
//      con = DbConnection.getConnection();
//      PreparedStatement ptmt = con.prepareStatement("select length(?) from users");
//      ptmt.setString(1,columns);
//      ResultSet rs=ptmt.executeQuery();
//      
//      
//      
//      return length;
//  }
    
​
}
​

main.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="sxj.test.jsp.JspUserDao"%>
    <%@ page import="sxj.test.jsp.JspUser"%>
    <%@ page import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="JspUser" scope="page" class="sxj.test.jsp.JspUser" />
<jsp:useBean id="JspUserDao" class="sxj.test.jsp.JspUserDao" />
​
<%
List<JspUser> data = JspUserDao.getAllUser();
Iterator<JspUser> it = data.iterator();
out.println("<table align='center' border='6'>");
out.println("<caption><h1>UserList</h1></caption>");
out.println("<tr><th>id</th><th>username</th><th>email</th><th>password</th><th>详细</th></tr>");
​
while (it.hasNext()) {
    JspUser temp =  it.next();
    int id=temp.getId();
    String username = temp.getUsername();
    String email = temp.getEmail();
    String password = temp.getPassword();
//  out.println(id+" | ");
//  out.println(username+" | ");
//  out.println(email+" | ");
//  out.println(password+" | ");
//  out.println("<tr><td>id</td><td>"+id+"</td></tr>");
    out.println("<tr><td>"+id+"</td><td>"+username+"</td><td>"+email+"</td><td>"+password+"</td><td>"+"<a href=userupdate.jsp?id="+id+">修改</a>"+"</td></tr>");
    //  out.println("<tr><td>email</td><td>"+email+"</td></tr>");
//  out.println("<tr><td>password</td><td>"+password+"</td></tr>");
//  out.println("<td>"+"<a href=detail.jsp?id="+id+">详细</a>"+"</td>");
    //out.println("<br>");
}
out.println("</table>");
%>
​
</body>
</html>

update_act.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="sxj.test.jsp.JspUserDao"%>
    <%@ page import="sxj.test.jsp.JspUser"%>
    <%@ page import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="JspUser" scope="page" class="sxj.test.jsp.JspUser" />
<jsp:useBean id="JspUserDao" class="sxj.test.jsp.JspUserDao" />
<jsp:setProperty name="JspUser" property="*" />
<%
String id = request.getParameter("id");
String name = request.getParameter("username");
String password = request.getParameter("password");
String email = request.getParameter("email");
String info = "";%>
<%
//select length('fdasfsafasf');
// String format = "\\p{Alpha}\\w{2,15}[@][a-z0-9]{3,}[.]\\p{Lower}{2,}";
//email.matches(format)
String format = "\\p{Alpha}\\w{2,15}[@][a-z0-9]{3,}[.]\\p{Lower}{2,}";
​
if(name == null || name == ""|| password == null || password == ""||email == null || email == ""){
    info = "用户名、电子邮箱、密码和密码确认都必须输入，不能为空！";
    request.setAttribute("info",info);%>
    <jsp:forward page="userupdate.jsp" /><%
}else if(name.length()>20||password.length()>20||email.length()>20){
    info = "用户名、电子邮箱、密码和密码确认都必须输入字母、数字、下划线，且长度应小于20！";
    request.setAttribute("info",info);
    %><jsp:forward page="userupdate.jsp" /> 
    <%
}else if(JspUserDao.FormatEmail(email)){
    //id = request.getParameter("id");
    int a = JspUserDao.upDate(JspUser);
    out.println(name);
    out.println(a); 
    %><jsp:forward page="main.jsp" />   
    <%
}else{
    info = "电子邮箱格式不正确！";
    request.setAttribute("info",info);
    %><jsp:forward page="userupdate.jsp" /> 
    <%
    
    
}
%>
</body>
</html>

userupdate.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="sxj.test.jsp.JspUserDao"%>
    <%@ page import="sxj.test.jsp.JspUser"%>
    <%@ page import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="JspUser" scope="page" class="sxj.test.jsp.JspUser" />
<jsp:useBean id="JspUserDao" class="sxj.test.jsp.JspUserDao" />
​
<%
String id = "1";
id = request.getParameter("id");
JspUser data = JspUserDao.getuser(Integer.parseInt(id));
int idu =data.getId();
String username = data.getUsername();
String email = data.getEmail();
String password = data.getPassword();
/*
out.println("<table align='center' border='6'>");
out.println("<caption><h1>UserInfo</h1></caption>");
out.println("<tr><td>id</td><td>"+id+"</td></tr>");
out.println("<tr><td>username</td><td>"+username+"</td></tr>");
out.println("<tr><td>email</td><td>"+email+"</td></tr>");
out.println("<tr><td>password</td><td>"+password+"</td></tr>");
out.println("</table>");*/
​
%>
​
<form method=post action="update_act.jsp">
<table align="center">
    <tr>
    <td colspan=2 align="center">
    <h1>Updata</h1>
    </td>
  </tr>
  <tr>
    <td>id</td>
    <td><input type=text name="id" value="<%=id %>" readonly="readonly" ></td>
  </tr>
  <tr>
    <td>username</td>
    <td><input type=text name="username" value="<%=username %>"></td>
  </tr>
    <tr>
    <td>email</td>
    <td><input type=text name="email" value="<%=email %>"></td>
  </tr>
  <tr>
    <td>password</td>
    <td><input type="password" name="password" id="password" value="<%=password %>"></td>
  </tr>
  
    <tr>
    <td>Password Confirm:</td>
    <td>
    <input type="password" name="password1" id="password1"  value="<%=password %>"  onkeyup="validate()">
    <span id="tishi"></span>
    </td>
  </tr>
  
  <tr>
    <td colspan=2 align="center">
      <input type=submit value="UpDate" id="button" style="width: 108px">&nbsp;&nbsp;&nbsp;&nbsp;
      <!-- <input type=reset value="Cancel"> -->
    </td>
      <tr>
    <td colspan=2 align="center">
    <%=request.getAttribute("info")==null?"":request.getAttribute("info")%>
    </td>
  </tr>
</table>
​
</form>
<script>
function validate() {
    var pwd1 = document.getElementById("password").value;
    var pwd2 = document.getElementById("password1").value;
<!-- 对比两次输入的密码 -->
    if(pwd1 == pwd2)
     {
        document.getElementById("tishi").innerHTML="<font color='green'>两次密码相同</font>";
        document.getElementById("button").disabled = false;
     }
else {
        document.getElementById("tishi").innerHTML="<font color='red'>两次密码不相同</font>";
​
        document.getElementById("button").disabled = true;
     }
}
</script>
​
</body>
</html>

305数据删除操作

具体内容与要求如下：

  1. 实体JavaBean，文件名为：JspUser.java；包结构为“yzs（你姓名全拼的首字母）.test.jsp”；属性与数据表jspuser中的字段一致，用于保存输入的用户信息。
  2. 连接JavaBean，文件名为：DbConnection.java；包结构同上；实现与数据库连接的静态方法，方法名自定，返回Connection类型的对象。
  3. 数据访问JavaBean，文件名为：JspUserDao.java；包结构同上；实现两个方法，第1个方法，方法名自定，无参数。该方法调用DbConnection.java的静态方法建立与数据库的连接，然后查询数据库检索jspuser表中的所有记录，每条记录的数据封装在一个JspUser Bean中，所有的JspUser Bean对象组成一个List对象，返回List对象。第2个方法，参数为用户ID，整数类型，从jspuser表中删除指定ID的用户记录，返回整数类型。
  4. 用户信息浏览页面，文件名为main.jsp。在页面中引入JspUserDao Bean，调用其第1个方法，获取保存所有用户信息的List对象，循环遍历List对象中所有的元素和每个元素（JspUser对象）中的所有属性，用表格显示出来，每条记录（JspUser中保存的用户信息）为一行，每个字段（JspUser Bean中的每个属性）为一列，每行的最后一列为删除链接，链接到userdelete.jsp页面，传递用户ID参数。
  5. 链接的click事件弹出确认对话框，只有点击确定按钮才进行转向，执行删除操作，点击取消按钮则取消转向操作，并不执行删除操作。<%
     ArrayList<JspUser> udata= dbop.getAllUser();
     for(int i=0; i<udata.size(); i++) {
    JspUser item =udata.get(i);
    %>
    <tr align="center">  
    <td><%=item.getId() %></td>
    <td><%=item.getUsername()%></td>
    <td><%=item.getEmail() %></td>
    <td><%=item.getPassword()%></td>
    <td><a href="userdelete.jsp?id=<%=item.getId()%>" onclick="return confirm('确定要删除该用户吗？')">删除</a></td>
    </tr>
    <% } %>
  6. 删除页面userdelete.jsp，获取main.jsp传递的用户ID参数，引JspUserDao Bean，调用其第2个方法，删除指定ID的用户信息，转回到main.jsp。

DbConnection.java

package sxj.test;
​
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
​
public class DbConnection {
​
    public static Connection getConnection() {
        // TODO Auto-generated method stub
        Connection con = null;
        String drivername = "com.mysql.jdbc.Driver";
        String urlstr = "jdbc:mysql://localhost:3306/jsptest";
        String username = "root";
        String password = "";
        try{
            Class.forName(drivername);
        } catch (Exception e){
            System.out.println("error");
            System.out.println(e);
        }
        try{
            con = DriverManager.getConnection(urlstr,username,password);
        } catch (SQLException e){
            System.out.println("error");
            System.out.println(e);
        }
        return con;
    }
​
​
}
​

JspUser.java

package sxj.test;
​
public class JspUser {
​
    public int id;
    public String username;
    public String email;
    public String password;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
​
    
}
​

JspUserDao.java

package sxj.test.jsp;
​
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
​
public class JspUserDao {
​
    private Connection con;
    public ArrayList<JspUser> getAllUser() throws Exception {
        
            con = DbConnection.getConnection();
            Statement stmt = con.createStatement();
            //con = DbConnection.getConnection();
            //Statement stmt = con.createStatement();
            ArrayList<JspUser> data = new ArrayList<JspUser>();
            String strSql = "select * from users";
            ResultSet rs = stmt.executeQuery(strSql);
            while (rs.next()) {
                JspUser item = new JspUser();
                item.setId(rs.getInt("id"));
                item.setUsername(rs.getString("username"));
                item.setPassword(rs.getString("password"));
                item.setEmail(rs.getString("email"));
                data.add(item);
            }
            rs.close();
            stmt.close();
            con.close();
            return data;
        }
    public JspUser getuser(int id)throws Exception{
        
        JspUser item = new JspUser();
//      ArrayList<JspUser> data = new ArrayList<JspUser>();
        
        con = DbConnection.getConnection();
        PreparedStatement ptmt = con.prepareStatement("select * from users where id=?");
        ptmt.setString(1,Integer.toString(id));
        ResultSet rs=ptmt.executeQuery();
        
        while (rs.next()) {
            item.setId(rs.getInt("id"));
            item.setUsername(rs.getString("username"));
            item.setPassword(rs.getString("password"));
            item.setEmail(rs.getString("email"));
        }
        rs.close();
        ptmt.close();
        con.close();
        return item;
    }
​
    public ArrayList<JspUser> userAll(String name)throws Exception{
        ArrayList<JspUser> data = new ArrayList<JspUser>();
        
        con = DbConnection.getConnection();
        PreparedStatement ptmt = con.prepareStatement("select * from users where username like ?");
        ptmt.setString(1, "%" + name + "%");
        ResultSet rs=ptmt.executeQuery();
        while (rs.next()) {
            JspUser item = new JspUser();
            item.setId(rs.getInt("id"));
            item.setUsername(rs.getString("username"));
            item.setPassword(rs.getString("password"));
            item.setEmail(rs.getString("email"));
            data.add(item);
        }
        return data;
    }
    public int upDate(JspUser user)throws Exception {
        //boolean isLogin = false;
        con = DbConnection.getConnection();
        //      String sql = "inset into users(username,email,password) Values(?,?,?)";  UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson' 
        PreparedStatement pstmt = con.prepareStatement("UPDATE users SET username=?,email=?,password=? WHERE id = ?");
        pstmt.setString(1, user.getUsername());
        pstmt.setString(2, user.getEmail());
        pstmt.setString(3, user.getPassword());
        pstmt.setString(4, Integer.toString(user.getId()));
        int i = pstmt.executeUpdate();
        pstmt.close();
        con.close();
        //返回更新数据的数量
        return i;
    }
    public boolean FormatEmail(String str)throws Exception{
        //String str = "";
        String pattern = "\\w[-\\w.+]*@([A-Za-z0-9][-A-Za-z0-9]+\\.)+[A-Za-z]{2,14}";
​
        Pattern r = Pattern.compile(pattern);
        Matcher m = r.matcher(str);
        if(m.matches()) {
            return true;
        }else {
            return false;           
        }
    }
    public int DeleteUser(int id)throws Exception{
        //boolean isLogin = false;
        //DELETE FROM w3cschool_tbl WHERE w3cschool_id=3;
        con = DbConnection.getConnection();
        //      String sql = "inset into users(username,email,password) Values(?,?,?)";  UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson' 
        PreparedStatement pstmt = con.prepareStatement("DELETE FROM users WHERE id=?");
//      pstmt.setString(4, Integer.toString(user.getId()));
        pstmt.setString(1, Integer.toString(id));
        int i = pstmt.executeUpdate();
        pstmt.close();
        con.close();
        //返回更新数据的数量
        return i;
    }
    
}
​

main.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="sxj.test.jsp.JspUserDao"%>
    <%@ page import="sxj.test.jsp.JspUser"%>
    <%@ page import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="JspUser" scope="page" class="sxj.test.jsp.JspUser" />
<jsp:useBean id="JspUserDao" class="sxj.test.jsp.JspUserDao" />
​
<%
List<JspUser> data = JspUserDao.getAllUser();
Iterator<JspUser> it = data.iterator();
out.println("<table align='center' border='6'>");
out.println("<caption><h1>UserList</h1></caption>");
out.println("<tr><th>id</th><th>username</th><th>email</th><th>password</th><th>详细</th></tr>");
​
while (it.hasNext()) {
    JspUser temp =  it.next();
    int id=temp.getId();
    String username = temp.getUsername();
    String email = temp.getEmail();
    String password = temp.getPassword();
//  out.println(id+" | ");
//  out.println(username+" | ");
//  out.println(email+" | ");
//  out.println(password+" | ");               
//  out.println("<tr><td>id</td><td>"+id+"</td></tr>");
    out.println("<tr><td>"+id+"</td><td>"+username+"</td><td>"+email+"</td><td>"+password+"</td><td>"+"<a href=userdelete.jsp?id="+id+" onclick=\"return confirm('确定要删除该用户吗？')\">删除</a>"+"</td></tr>");
    //  out.println("<tr><td>email</td><td>"+email+"</td></tr>");
//  out.println("<tr><td>password</td><td>"+password+"</td></tr>");
//  out.println("<td>"+"<a href=detail.jsp?id="+id+">详细</a>"+"</td>");
    //out.println("<br>");
}
out.println("</table>");
%>
<div align = "center"><%=request.getAttribute("info")==null?"":request.getAttribute("info")%></div>
</body>
</html>

userdelete.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="sxj.test.jsp.JspUserDao"%>
    <%@ page import="sxj.test.jsp.JspUser"%>
    <%@ page import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="JspUser" scope="page" class="sxj.test.jsp.JspUser" />
<jsp:useBean id="JspUserDao" class="sxj.test.jsp.JspUserDao" />
​
<%
String id = "1";
String info = "";
id = request.getParameter("id");
int result = JspUserDao.DeleteUser(Integer.parseInt(id));
if(result>0){
    
    info = "删除成功！";
    request.setAttribute("info",info);
    %><jsp:forward page="main.jsp" />   
    <%
}else{
    info = "删除失败！";
    request.setAttribute("info",info);
    %><jsp:forward page="main.jsp" />   
    <%
}
/*
out.println("<table align='center' border='6'>");
out.println("<caption><h1>UserInfo</h1></caption>");
out.println("<tr><td>id</td><td>"+id+"</td></tr>");
out.println("<tr><td>username</td><td>"+username+"</td></tr>");
out.println("<tr><td>email</td><td>"+email+"</td></tr>");
out.println("<tr><td>password</td><td>"+password+"</td></tr>");
out.println("</table>");*/
%>
</body>
</html>

点击数：302

    JSP
    暂无评论

    发送评论 编辑评论 

    
				
    
			
    
						
    
				
    
					
    
						
    
							
    
								
							
    
							
						
    
					
    
				
    
				
    
					
    
						
    
							
    
								
							
    
							
						
    
					
    
				
    
				
    
					
    
						
    
							
    
								
							
    
							
							
													
    
					
    
				
    
			
    
			
			
    
				
    
					
				
    
			
    
				
    
											
    
							
							
						
    
																
    
							
							
						
    
																
    
							
							
						
    
										
					
											
						
    
	
    
		
    |´・ω・)ノ
    ヾ(≧∇≦*)ゝ
    (☆ω☆)
    （╯‵□′）╯︵┴─┴
    ￣﹃￣
    (/ω＼)
    ∠( ᐛ 」∠)＿
    (๑•̀ㅁ•́ฅ)
    →_→
    ୧(๑•̀⌄•́๑)૭
    ٩(ˊᗜˋ*)و
    (ノ°ο°)ノ
    (´இ皿இ｀)
    ⌇●﹏●⌇
    (ฅ´ω`ฅ)
    (╯°A°)╯︵○○○
    φ(￣∇￣o)
    ヾ(´･ ･｀｡)ノ"
    ( ง ᵒ̌皿ᵒ̌)ง⁼³₌₃
    (ó﹏ò｡)
    Σ(っ °Д °;)っ
    ( ,,´･ω･)ﾉ"(´っω･｀｡)
    ╮(╯▽╰)╭
    o(*////▽////*)q
    ＞﹏＜
    ( ๑´•ω•) "(ㆆᴗㆆ)
    😂
    😀
    😅
    😊
    🙂
    🙃
    😌
    😍
    😘
    😜
    😝
    😏
    😒
    🙄
    😳
    😡
    😔
    😫
    😱
    😭
    💩
    👻
    🙌
    🖕
    👍
    👫
    👬
    👭
    🌚
    🌝
    🙈
    💊
    😶
    🙏
    🍦
    🍉
    😣
    Source: github.com/k4yt3x/flowerhd
    	
    
	
    
		
    颜文字
    Emoji
    小恐龙
    花!
    	
    

    									
    
			
    
			
			
		
    
	
    

    



    上一篇
    下一篇 
    
                    
    
                    
			        推荐文章
		            
    
		            
    
							
    子域名枚举&收集
    
							
							
    
							
    Flask-jinja2 SSTI
    
							
							
    
							
    Vulnhub 靶机实战系列：DC -4
    
							
							
    
							
    Vulnhub-BlueMoon-WriteUp
    
							
							
    
							
    Vulnhub ADMX 1.0.1 WriteUp
    
							
							
    
							
    通达OA漏洞整理
    
							
							
    
							
    蓝凌OA任意写入漏洞
    
							
							
    
							
    PHP弱类型
    
							
							
    
							
    CTF刷题[待更新]
    
							
							
    
							
    OAuth2.0 原理流程