栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

《云博客》------version.3.0---------------封笔之作---全部开源

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

《云博客》------version.3.0---------------封笔之作---全部开源

 

 

 

 上代码:

后端代码:

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("返回首页 ");
            } else {
                out.write("删除失败!");
                out.write("返回首页 ");
            }
            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("返回首页 ");
            } else {
                out.println("删除失败!");
                out.print("返回首页 ");
            }
            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("返回注册 ");
            }
            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("登录 ");
                } else {
                    out.write("验证码或者密码不一致或者账号错误导致注册失败");
                    out.write("返回注册界面 ");
                }
                //关闭资源
                stmt.close();
                conn.close();

            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else {
            out.write("注册失败" + "
"); out.write("返回注册界面 "); } } }

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("返回首页 "); 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("返回主页面 ");
            } else {
                out.write("修改失败");
                out.write("返回主页面  ");
            }
            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("返回 ");
            }
            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("返回首页 ");
            } else {
                out.write("删除失败!");
                out.write("返回首页 ");
            }
            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("返回首页 ");
            } else {
                out.write("删除失败!");
                out.write("返回首页 ");
            }
            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("登录 ");
                } else {
                    out.write("验证码或者密码不一致或者账号错误导致注册失败");
                    out.write("返回注册界面 ");
                }
                //关闭资源
                stmt.close();
                conn.close();

            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else {
            out.write("注册失败" + "
"); out.write("返回注册界面 "); } } }

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("返回首页 ");
            } else {
                out.write("删除失败!");
                out.write("返回首页 ");
            }
            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


个人云博客在线平台管理员主页面





<% request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); out.println("查看用户 "+" "+" "+" "); out.println("查看用户日志 "+" "+" "+" "); out.println("删除用户 "+" "+" "+" "); out.println("删除用户日志 "+" "+" "+" "); out.println("退出 "+" "+" "+" "); out.println("增加管理员 "+" "+" "); out.println("删除管理员 "+" "+" "); out.println("更多 "+" "+" "); %>

admin02.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


<%


    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 yonghu ";
    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()){ %> <%}%>
记录条数 用户id 用户姓名 用户密码
<%=resultSet.getRow()%> <%=resultSet.getInt("user_id")%> <%=resultSet.getString("username")%> <%=resultSet.getString("userpwd")%>
<% if (resultSet!=null){ resultSet.close(); } if (preparedStatement!=null){ preparedStatement.close(); } if (con!=null){ con.close(); } %>
<% out.print(" "+" "+" "+" "+"返回首页 "); %>

admin03.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


<%


    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 ";
    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()){ %> <%}%>
记录条数 日志题目 天气 日志序号 日志内容 时间 地区 用户id
<%=resultSet.getRow()%> <%=resultSet.getString("name")%> <%=resultSet.getString("sex")%> <%=resultSet.getInt("class")%> <%=resultSet.getString("topic")%> <%=resultSet.getString("rtime")%> <%=resultSet.getString("place")%> <%=resultSet.getInt("userid")%>
<% if (resultSet!=null){ resultSet.close(); } if (preparedStatement!=null){ preparedStatement.close(); } if (con!=null){ con.close(); } %>
<% out.print(" "+" "+" "+" "+"返回首页 "); %>

admin04.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



    输入你要删除的用户id:   
    
    

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("返回首页 "); %>

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


输入你要删除的管理员id:   

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("返回首页 "); %>

logoin.jsp

    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    
    
        logoin
    
    
    
    

个人云博客在线平台





账号:
密码:

registered.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    注册



个人云博客在线平台
输入账号:
输入密码:
确认密码:
请输入验证码:

<% out.print("已有账号,"+"→→→→→→→→→→登录 "+"
"); out.print("已经是管理员,"+"→→→→→→登录 "+"
"); %>

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(" "+" "+" "+" "+"返回首页 "); %>

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(" " + " " + " " + " " + "返回首页 "); %>

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


个人云博客在线平台主页面





<% request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); out.println("增加日志 "+" "+" "+" "); out.println("删除日志 "+" "+" "+" "); out.println("查询日志 "+" "+" "+" "); out.println("修改日志 "+" "+" "+" "); out.println("退出 "+" "+" "+" "); out.println("更多 "+" "+" "); %>

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 即可获取」

这是全部资源文件 

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/950825.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号