上代码:
后端代码:
package servlets;
import javax.servlet.*;
import javax.servlet.annotation.WebFilter;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
@WebFilter("/*")
public class filter01 implements Filter {
@Override
public void init(FilterConfig filterConfig) throws ServletException {
}
public void doFilter(ServletRequest arg0, ServletResponse arg1, FilterChain
chain) throws IOException, ServletException {
HttpServletRequest request = (HttpServletRequest) arg0;
HttpServletResponse response = (HttpServletResponse) arg1;
String path = request.getRequestURI();
if (path.contains("/logoin.jsp") || path.contains("/registered.jsp")||
path.contains("/admin.jsp") ) {
chain.doFilter(request, response);
return;
}
// 2、放行
if (path.contains("/filter01")) {
chain.doFilter(request, response);
return;
}
// 3、放行
if (path.contains("/s0")) {
chain.doFilter(request, response);
return;
}
// 4、登
HttpSession session = request.getSession();
String user01 = (String) session.getAttribute("name01");
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
if (userid001 != -1) {
chain.doFilter(request, response);
return;
}
response.sendRedirect("registered.jsp");
return;
}
@Override
public void destroy() {
}
}
servlet01.java;
package servlets;
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.io.PrintWriter;
import java.sql.*;
@WebServlet("/s01")
public class Servlet01 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
String id = request.getParameter("delettext");
HttpSession session = request.getSession();
String user01 = (String) session.getAttribute("name01");
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String un = "root"; //MySql用户名
String pa = "cjd"; //MySql密码
Connection con = DriverManager.getConnection(url, un, pa);
Statement st = con.createStatement();
System.out.println("delete Successful!");
String sql = "DELETE FROM we WHERe class =? and userid = ?";
// pst = con.prepareStatement(sql);
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, id);
pstmt.setInt(2, userid001);
int flag = pstmt.executeUpdate();
PrintWriter out = response.getWriter();
if (flag > 0) {
out.write("删除成功!");
out.write("返回首页 a>");
} else {
out.write("删除失败!");
out.write("返回首页 a>");
}
con.close();
st.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
servlet02.java
package servlets;
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.io.PrintWriter;
import java.sql.*;
@WebServlet("/s02")
public class Servlet02 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
String id = request.getParameter("delettext1");
HttpSession session = request.getSession();
String user01 = (String) session.getAttribute("name01");
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String un = "root"; //MySql用户名
String pa = "cjd"; //MySql密码
Connection con = DriverManager.getConnection(url, un, pa);
Statement st = con.createStatement();
// PreparedStatement pst = null;
System.out.println("delete Successful!");
String sql = "DELETE FROM we WHERe place =? and userid = ?";
// pst = con.prepareStatement(sql);
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, id);
pstmt.setInt(2, userid001);
int flag = pstmt.executeUpdate();
PrintWriter out = response.getWriter();
if (flag > 0) {
out.println("删除成功!");
out.print("返回首页 a>");
} else {
out.println("删除失败!");
out.print("返回首页 a>");
}
con.close();
st.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
servlet03.java
package servlets;
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.io.PrintWriter;
import java.sql.*;
@WebServlet("/s03")
public class Servlet03 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
PrintWriter out = response.getWriter();
//获取用户输入信息
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("UTF-8");
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
HttpSession session = request.getSession();
String u11 = request.getParameter("username");
System.out.println(u11);
session.setAttribute("name01", u11);
System.out.println(session.getAttribute("name01"));
Connection conn = null;
Statement stmt = null;
try {
//连接驱动
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//建立数据库连接
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
//数据库账号
String uname = "root";
//数据库密码
String upwd = "cjd";
try {
conn = DriverManager.getConnection(url, uname, upwd);
//创建发射器
stmt = conn.createStatement();
//创建sql语句
String sql = "select*from test.yonghu where username='" + username + "' and userpwd='" + userpwd + "'";
//发送sql语句并接收结果
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
out.write("登陆成功");
response.sendRedirect("testform01.jsp");
} else {
out.write("登陆失败");
out.write("返回注册 a>");
}
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
servlet04.java
package servlets;
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.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
@WebServlet("/s04")
public class Servlet04 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html; charset=UTF-8");
PrintWriter out = response.getWriter();
//获取用户输入信息
// request.setCharacterEncoding("utf-8");
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
String cuserpwd = request.getParameter("cuserpwd");
String code = request.getParameter("code");
//获取session中的验证码
HttpSession session = request.getSession();
String randStr = (String) session.getAttribute("randStr");
// response.setCharacterEncoding("UTF-8");
//判断两次密码是否相同
String regex = "[1][34578][0-9]{9}"; //手机号码的格式:第一位只能为1,第二位可以是3,4,5,7,8,第三位到第十一位可以为0-9中任意一个数字
System.out.println("请输入11位手机号码");
boolean flag;
String number = username;
if (number.matches(regex)) {
flag = true;
} else {
flag = false;
}
if (cuserpwd.equals(userpwd) && code.equals(randStr) && username != null && !username.equals("") &&
userpwd != null && !userpwd.equals("") && cuserpwd != null && !cuserpwd.equals("") || flag == true) {
Connection conn = null;
Statement stmt = null;
try {
//连接驱动
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//建立数据库连接
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
;
//数据库账号
String user = "root";
//数据库密码
String upwd = "cjd";
try {
conn = DriverManager.getConnection(url, user, upwd);
//创建发射器
stmt = conn.createStatement();
//创建sql语句
String sql = "insert into yonghu(username,userpwd) value ('" + username + "','" + userpwd + "')";
//发送sql语句并接收结果
int count = stmt.executeUpdate(sql);
if (count > 0) {
out.write("注册成功");
out.write("登录 a>");
} else {
out.write("验证码或者密码不一致或者账号错误导致注册失败");
out.write("返回注册界面 a>");
}
//关闭资源
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
} else {
out.write("注册失败" + "
");
out.write("返回注册界面 a>");
}
}
}
servlet05.java
package servlets;
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.io.PrintWriter;
import java.sql.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
@WebServlet("/s05")
public class Servlet05 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
PrintWriter out = response.getWriter();
String name = request.getParameter("textname");
String pwd = request.getParameter("u1");
String place = request.getParameter("place");
String time = request.getParameter("time1");
SimpleDateFormat format = new SimpleDateFormat("yyyy-mm-dd");
Date date = null;
// HttpSession session = request.getSession();
// String userid01 = (String) request.getSession().getAttribute("userid001");
// int userid001 = Integer.parseInt(userid01);
HttpSession session = request.getSession();
String user01 = (String) session.getAttribute("name01");
// int userid001 = Integer.parseInt(user01);
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
// int userid001 = Integer.parseInt(user01);
try {
date = new Date(format.parse(time).getTime());
} catch (ParseException e) {
e.printStackTrace();
}
int num = Integer.parseInt(request.getParameter("classuser"));
String textname1 = request.getParameter("textname1");
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String un = "root"; //MySql用户名
String pa = "cjd"; //MySql密码
Connection con = DriverManager.getConnection(url, un, pa);
Statement st = con.createStatement();
// String sql = "select * from we";
System.out.println("Connection Successful!");
String sql = "Insert into we(name,sex,class,topic,rtime,place,userid) values(?,?,?,?,?,?,?)";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, pwd);
pstmt.setInt(3, num);
pstmt.setString(4, textname1);
pstmt.setDate(5,date);
pstmt.setString(6,place);
pstmt.setInt(7, userid001);
int n = pstmt.executeUpdate();
if (n == 1) {out.write("数据插入成功!
");} else {out.write("数据插入失败!");
}
out.write("返回首页 a>");
con.close();
st.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
servlet06.java
package servlets;
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.io.PrintWriter;
import java.sql.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
@WebServlet("/s06")
public class Servlet06 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession();
String user01 = (String) session.getAttribute("name01");
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
PrintWriter out = response.getWriter();
String name1 = request.getParameter("updatetext");
String sex1 = request.getParameter("updatesex");
int num1 = Integer.parseInt(request.getParameter("updateclass"));
String topic1 = request.getParameter("updatetopic");
String place = request.getParameter("place1");
String time = request.getParameter("date1");
SimpleDateFormat format = new SimpleDateFormat("yyyy-mm-dd");
try {
Date date = new Date(format.parse(time).getTime());
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String un = "root"; //MySql用户名
String pa = "cjd"; //MySql密码
Connection con = DriverManager.getConnection(url, un, pa);
Statement st = con.createStatement();
System.out.println("update Successful!");
// String sql ="update we set sex=?,class=?,topic=? where name=?";
String sql = "update we set sex=?,name=?,topic=?,rtime=?,place=? where class=? and userid = ?";
// pst = con.prepareStatement(sql);
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, sex1);
pstmt.setInt(6, num1);
pstmt.setString(3, topic1);
pstmt.setString(2, name1);
pstmt.setDate(4, date);
pstmt.setString(5, place);
pstmt.setInt(7, userid001);
int flag = pstmt.executeUpdate();
if (flag > 0) {
out.write("修改成功!");
out.write("返回主页面 a>");
} else {
out.write("修改失败");
out.write("返回主页面 a>");
}
con.close();
st.close();
} catch (ParseException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
servlet08.java
package servlets;
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.io.PrintWriter;
import java.sql.*;
@WebServlet("/s08")
public class Servlet08 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
PrintWriter out = response.getWriter();
//获取用户输入信息
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("UTF-8");
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
HttpSession session = request.getSession();
String u11 = request.getParameter("username");
System.out.println(u11);
session.setAttribute("name01", u11);
System.out.println(session.getAttribute("name01"));
Connection conn = null;
Statement stmt = null;
try {
//连接驱动
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//建立数据库连接
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
//数据库账号
String uname = "root";
//数据库密码
String upwd = "cjd";
try {
conn = DriverManager.getConnection(url, uname, upwd);
//创建发射器
stmt = conn.createStatement();
//创建sql语句
String sql = "select*from test.adminn where username='" + username + "' and userpwd='" + userpwd + "'";
//发送sql语句并接收结果
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
out.write("登陆成功");
response.sendRedirect("admin01.jsp");
} else {
out.write("登陆失败");
out.write("返回 a>");
}
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
servlet09.java
package servlets;
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.io.PrintWriter;
import java.sql.*;
@WebServlet("/s09")
public class Servlet09 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
String id01 = request.getParameter("delettext");
// int id = Integer.parseInt(id01);
HttpSession session = request.getSession();
String user01 = (String) session.getAttribute("name01");
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String un = "root"; //MySql用户名
String pa = "cjd"; //MySql密码
Connection con = DriverManager.getConnection(url, un, pa);
Statement st = con.createStatement();
System.out.println("delete Successful!");
String sql = "DELETE FROM yonghu WHERe username =? ";
// pst = con.prepareStatement(sql);
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1,id01 );
// pstmt.setInt(2, userid001);
int flag = pstmt.executeUpdate();
PrintWriter out = response.getWriter();
if (flag > 0) {
out.write("删除成功!");
out.write("返回首页 a>");
} else {
out.write("删除失败!");
out.write("返回首页 a>");
}
con.close();
st.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
servlet010.java
package servlets;
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.io.PrintWriter;
import java.sql.*;
@WebServlet("/s010")
public class Servlet010 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
String id01 = request.getParameter("delettext");
int id = Integer.parseInt(id01);
HttpSession session = request.getSession();
String user01 = (String) session.getAttribute("name01");
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String un = "root"; //MySql用户名
String pa = "cjd"; //MySql密码
Connection con = DriverManager.getConnection(url, un, pa);
Statement st = con.createStatement();
System.out.println("delete Successful!");
String sql = "DELETE FROM we WHERe userid =? ";
// pst = con.prepareStatement(sql);
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setInt(1,id );
// pstmt.setInt(2, userid001);
int flag = pstmt.executeUpdate();
PrintWriter out = response.getWriter();
if (flag > 0) {
out.write("删除成功!");
out.write("返回首页 a>");
} else {
out.write("删除失败!");
out.write("返回首页 a>");
}
con.close();
st.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
servlet011.java
package servlets;
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.io.PrintWriter;
import java.sql.*;
@WebServlet("/s011")
public class Servlet011 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html; charset=UTF-8");
PrintWriter out = response.getWriter();
//获取用户输入信息
// request.setCharacterEncoding("utf-8");
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
String cuserpwd = request.getParameter("cuserpwd");
String code = request.getParameter("code");
//获取session中的验证码
HttpSession session = request.getSession();
String randStr = (String) session.getAttribute("randStr");
// response.setCharacterEncoding("UTF-8");
//判断两次密码是否相同
String regex = "[1][34578][0-9]{9}"; //手机号码的格式:第一位只能为1,第二位可以是3,4,5,7,8,第三位到第十一位可以为0-9中任意一个数字
System.out.println("请输入11位手机号码");
boolean flag;
String number = username;
if (number.matches(regex)) {
flag = true;
} else {
flag = false;
}
if (cuserpwd.equals(userpwd) && code.equals(randStr) && username != null && !username.equals("") &&
userpwd != null && !userpwd.equals("") && cuserpwd != null && !cuserpwd.equals("") || flag == true) {
Connection conn = null;
Statement stmt = null;
try {
//连接驱动
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//建立数据库连接
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
;
//数据库账号
String user = "root";
//数据库密码
String upwd = "cjd";
try {
conn = DriverManager.getConnection(url, user, upwd);
//创建发射器
stmt = conn.createStatement();
//创建sql语句
String sql = "insert into adminn(username,userpwd) value ('" + username + "','" + userpwd + "')";
//发送sql语句并接收结果
int count = stmt.executeUpdate(sql);
if (count > 0) {
out.write("注册成功");
out.write("登录 a>");
} else {
out.write("验证码或者密码不一致或者账号错误导致注册失败");
out.write("返回注册界面 a>");
}
//关闭资源
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
} else {
out.write("注册失败" + "
");
out.write("返回注册界面 a>");
}
}
}
servlet012.java
package servlets;
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.io.PrintWriter;
import java.sql.*;
@WebServlet("/s012")
public class Servlet012 extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
String id01 = request.getParameter("delettext");
// int id = Integer.parseInt(id01);
HttpSession session = request.getSession();
String user01 = (String) session.getAttribute("name01");
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String un = "root"; //MySql用户名
String pa = "cjd"; //MySql密码
Connection con = DriverManager.getConnection(url, un, pa);
Statement st = con.createStatement();
System.out.println("delete Successful!");
String sql = "DELETE FROM adminn WHERe username =? ";
// pst = con.prepareStatement(sql);
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1,id01 );
// pstmt.setInt(2, userid001);
int flag = pstmt.executeUpdate();
PrintWriter out = response.getWriter();
if (flag > 0) {
out.write("删除成功!");
out.write("返回首页 a>");
} else {
out.write("删除失败!");
out.write("返回首页 a>");
}
con.close();
st.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
前端部分:
validate.jsp
<%@ page language="java"
import="java.awt.*"
import="java.awt.image.BufferedImage"
import="java.util.*"
import="javax.imageio.ImageIO"
pageEncoding="utf-8" contentType="text/html;charset=UTF-8"
%>
<%
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
response.setHeader("Cache-Control","no-cache");
// 在内存中创建图象
int width = 60, height = 20;
BufferedImage image = new BufferedImage(width, height,
BufferedImage.TYPE_INT_RGB);
//获取画笔
Graphics g = image.getGraphics();
//设定背景色
g.setColor(new Color(200, 200, 200));
g.fillRect(0, 0, width, height);
//取随机产生的验证码(4位数字)
Random rnd = new Random();
int randNum = rnd.nextInt(8999) + 1000;
String randStr = String.valueOf(randNum);
//将验证码存入session
session.setAttribute("randStr", randStr);
//将验证码显示到图象中
g.setColor(Color.black);
g.setFont(new Font("", Font.PLAIN, 20));
g.drawString(randStr, 10, 17);
// 随机产生100个干扰点,使图象中的验证码不易被其他程序探测到
for (int i = 0; i < 100; i++){
int x = rnd.nextInt(width);
int y = rnd.nextInt(height);
g.drawOval(x, y, 1, 1);
}
// 输出图象到页面
ImageIO.write(image, "jpg", response.getOutputStream());
out.clear();
out = pageContext.pushBody();
%>
admin.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/6/4
Time: 11:26
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
Title
个人云博客管理员入口
admin01.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/6/4
Time: 11:33
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
Title
个人云博客在线平台管理员主页面
admin05.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/6/4
Time: 11:37
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
import="java.sql.*"
%>
Title
admin06.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/6/4
Time: 11:37
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
import="java.sql.*"
%>
Title
个人云博客在线平台管理员添加主页面
admin07.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/6/4
Time: 14:14
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
Title
敬请期待。。。。。。。。
<%
out.print("返回首页 a>");
%>
admin08.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/6/4
Time: 11:37
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
import="java.sql.*"
%>
Title
delete01.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/5/29
Time: 11:37
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
Title
个人云博客在线平台
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
%>
help.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/5/29
Time: 14:49
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
Title
敬请期待。。。。。。。。
<%
out.print("返回首页 a>");
%>
logoin.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
logoin
个人云博客在线平台
registered.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
注册
个人云博客在线平台
Show.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
import="java.sql.*"
%>
Insert title here
个人云博客在线平台
<%
//star
// HttpSession session = request.getSession();
String user01 = (String) session.getAttribute("name01");
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
String name5 = request.getParameter("showtext");
Class.forName("com.mysql.jdbc.Driver");
String url ="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String un = "root"; //MySql用户名
String pa = "cjd"; //MySql密码
Connection con = DriverManager.getConnection(url, un, pa);
request.setCharacterEncoding("UTF-8");
// Statement st = con.createStatement();
// WHERe name ="+name5;
// out.print(name5);
String sql = "SELECT * FROM we where class =? and userid = ?";
PreparedStatement preparedStatement = con.prepareStatement(sql);
preparedStatement.setString(1,name5);
preparedStatement.setInt(2, userid001);
ResultSet resultSet = preparedStatement.executeQuery();
resultSet.last();
%>
你要查询的日志数据表中共有
<%=resultSet.getRow()%>条
记录条数
日志题目
天气
日志序号
日志内容
时间
地区
<%
resultSet.beforeFirst();
while (resultSet.next()){
%>
<%=resultSet.getRow()%>
<%=resultSet.getString("name")%>
<%=resultSet.getString("sex")%>
<%=resultSet.getInt("class")%>
<%=resultSet.getString("topic")%>
<%=resultSet.getString("rtime")%>
<%=resultSet.getString("place")%>
<%}%>
<%
if (resultSet!=null){
resultSet.close();
}
if (preparedStatement!=null){
preparedStatement.close();
}
if (con!=null){
con.close();
}
%>
<%
out.print(" "+" "+" "+" "+"返回首页 a>");
%>
Show01.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/5/29
Time: 11:43
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
Title
个人云博客在线平台
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
%>
Show02.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/5/30
Time: 13:16
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java"
pageEncoding="UTF-8"
import="java.sql.*"
%>
Title
个人云博客在线平台
<%
String user01 = (String) session.getAttribute("name01");
int userid001 = user01 == null || user01.equals("") ? -1 : Integer.parseInt(user01);
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
String name5 = request.getParameter("showtext1");
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String un = "root"; //MySql用户名
String pa = "cjd"; //MySql密码
Connection con = DriverManager.getConnection(url, un, pa);
request.setCharacterEncoding("UTF-8");
//out.print(name5);
String sql = "SELECt * FROM `we`WHERe place = ? and userid = ?";
PreparedStatement preparedStatement = con.prepareStatement(sql);
preparedStatement.setString(1, name5);
preparedStatement.setInt(2, userid001);
ResultSet resultSet = preparedStatement.executeQuery();
resultSet.last();
%>
你要查询的日志数据表中共有
<%=resultSet.getRow()%>
条
记录条数
日志题目
天气
地区
时间
日志序号
日志内容
<%
resultSet.beforeFirst();
while (resultSet.next()) {
%>
<%=resultSet.getRow()%>
<%=resultSet.getString("name")%>
<%=resultSet.getString("sex")%>
<%=resultSet.getInt("class")%>
<%=resultSet.getString("topic")%>
<%=resultSet.getString("rtime")%>
<%=resultSet.getString("place")%>
<%}%>
<%
if (resultSet != null) {
resultSet.close();
}
if (preparedStatement != null) {
preparedStatement.close();
}
if (con != null) {
con.close();
}
%>
<%
out.print(" " + " " + " " + " " + "返回首页 a>");
%>
test01.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/5/29
Time: 11:28
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
Title
个人云博客在线平台
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
%>
testform01.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/5/29
Time: 11:18
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
Title
个人云博客在线平台主页面
Update101.jsp
<%--
Created by IntelliJ IDEA.
User: ${陈平安}
Date: 2022/5/29
Time: 11:46
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
Title
个人云博客在线平台
<%
request.setCharacterEncoding("UTF-8");
%>
因为自己上传资源,各位看官需要冲会员,为了节约,咱就手动上传资源,全部开源。
可能会有个别文件的名称对不上,但是别担心,对吗是对的,都还是按照顺序发的代码。可以比对一下,有问题的可以留言,会及时回复的。
以下是数据库的表
我通过百度网盘分享的文件:exam.zip
链接:https://pan.baidu.com/s/14akL0ZtVye101tWxI7Syxw
提取码:t5ax
复制这段内容打开「百度网盘APP 即可获取」
这是全部资源文件



