• 利用JDBC及Servlet实现对信息录入注册功能的实现

    利用JDBC及Servlet实现对登录注册功能的实现；

    1.题目要求：

        1、新建一个数据库名为（个人姓名拼音），表（学生所在城市），字段（sid：学号，sname：姓名，sage：年龄，scontent：简介）

        2、实现一个注册页面register.jsp，需包含以上信息的输入

        3、利用Servlet实现对数据的接受及JDBC的保存

        4、实现一个显示页面show.jsp。从数据库中返回以上所有数据（或EL表达式）

    2.实施效果

    3.实施代码

    register.jsp

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2. <html>
    3. <head>
    4.     <link rel="stylesheet" type="text/css" href="styles.css">
    5.     <title>信息录入</title>
    6. </head>
    7. <body>
    8. <%--<h1>学生信息注册</h1>--%>
    9. <form action="${pageContext.request.contextPath}/register" method="post">
    10.     <label>学号:</label>
    11.     <input type="text" name="sid"><br>
    12.     <label>姓名:</label>
    13.     <input type="text" name="sname"><br>
    14.     <label>年龄:</label>
    15.     <input type="text" name="sage"><br>
    16.     <label>简介:</label>
    17.     <input type="text" name="scontent"><br>
    18.     <input type="submit" value="注册">
    19. </form>
    20. </body>
    21. </html>

    style.css

    1. body {
    2.     display: flex;
    3.     justify-content: center;
    4.     align-items: center;
    5.     height: 100vh;
    6. }
    7.  
    8. h1 {
    9.     float: top;
    10.     text-align: center;
    11. }
    12.  
    13. form {
    14.     display: flex;
    15.     flex-direction: column;
    16.     align-items: center;
    17.     width: 300px;
    18.     padding: 20px;
    19.     border: 1px solid #ddd;
    20.     border-radius: 5px;
    21. }
    22.  
    23. input[type=text]{
    24.     width: 100%;
    25.     padding: 12px 20px;
    26.     margin: 8px 0;
    27.     border: 1px solid #ccc;
    28.     box-sizing: border-box;
    29. }
    30.  
    31. input[type=submit] {
    32.     background-color: #4CAF50;
    33.     color: white;
    34.     padding: 14px 20px;
    35.     margin: 8px 0;
    36.     border: none;
    37.     cursor: pointer;
    38.     width: 100%;
    39. }
    40.  
    41. input[type=submit]:hover {
    42.     background-color: #45a049;
    43. }
    44.  
    45. .error {
    46.     color: red;
    47. }
    48.  
    49. .success {
    50.     color: green;
    51. }

    show.jsp

    1. <%@ page import="java.sql.*" %><%--
    2.   Created by IntelliJ IDEA.
    3.   User: ALASIJIA
    4.   Date: 2023/11/16
    5.   Time: 11:29
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%--<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>--%>
    9. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    10. <html>
    11. <head>
    12.     <title>信息展示</title>
    13.     <style>
    14.         body {
    15.             font-family: Arial, sans-serif;
    16.         }
    17.  
    18.         h1 {
    19.             color: #333;
    20.         }
    21.  
    22.         table {
    23.             width: 100%;
    24.             border-collapse: collapse;
    25.         }
    26.  
    27.         th, td {
    28.             border: 1px solid #333;
    29.             padding: 8px;
    30.         }
    31.  
    32.         th {
    33.             background-color: #f2f2f2;
    34.         }
    35.     </style>
    36. </head>
    37. <body>
    38. <h1>学生信息</h1>
    39. <table>
    40.     <tr>
    41.         <th>学号</th>
    42.         <th>姓名</th>
    43.         <th>年龄</th>
    44.         <th>简介</th>
    45.     </tr>
    46.  
    47.     <%
    48.         // 数据库连接信息
    49.         String url = "jdbc:mysql://localhost:3307/person_info?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC";
    50.         String username = "root";
    51.         String password = "123456";
    52.  
    53.         // 建立数据库连接
    54.         Connection con = null;
    55.         Statement stmt = null;
    56.         ResultSet rs = null;
    57.  
    58.         try {
    59.             Class.forName("com.mysql.cj.jdbc.Driver");
    60.             con = DriverManager.getConnection(url, username, password);
    61.  
    62.             // 查询学生信息
    63.             stmt = con.createStatement();
    64.             rs = stmt.executeQuery("SELECT * FROM stu_city");
    65.  
    66.             // 遍历结果集并显示学生信息
    67.             while (rs.next()) {
    68.                 String sid = rs.getString("sid");
    69.                 String sname = rs.getString("sname");
    70.                 String sage = rs.getString("sage");
    71.                 String scontent = rs.getString("scontent");
    72.  
    73.                 out.println("");
    74.                 out.println("" + sid + "");
    75.                 out.println("" + sname + "");
    76.                 out.println("" + sage + "");
    77.                 out.println("" + scontent + "");
    78.                 out.println("");
    79.             }
    80.         } catch (Exception e) {
    81.             e.printStackTrace();
    82.         } finally {
    83.             // 关闭数据库连接和资源
    84.             if (rs != null) {
    85.                 try {
    86.                     rs.close();
    87.                 } catch (SQLException e) {
    88.                     e.printStackTrace();
    89.                 }
    90.             }
    91.             if (stmt != null) {
    92.                 try {
    93.                     stmt.close();
    94.                 } catch (SQLException e) {
    95.                     e.printStackTrace();
    96.                 }
    97.             }
    98.             if (con != null) {
    99.                 try {
    100.                     con.close();
    101.                 } catch (SQLException e) {
    102.                     e.printStackTrace();
    103.                 }
    104.             }
    105.         }
    106.     %>
    107. </table>
    108. </body>
    109. </html>

    JDBCServlet

    1. package com.hjj.servlet.hw10;
    2.  
    3. import javax.servlet.ServletException;
    4. import javax.servlet.annotation.WebServlet;
    5. import javax.servlet.http.HttpServlet;
    6. import javax.servlet.http.HttpServletRequest;
    7. import javax.servlet.http.HttpServletResponse;
    8. import java.io.IOException;
    9. import java.sql.Connection;
    10. import java.sql.DriverManager;
    11. import java.sql.PreparedStatement;
    12. import java.sql.SQLException;
    13. import java.util.TimeZone;
    14.  
    15. /**
    16.  * @author:嘉佳 Date:2023/11/16 10:46
    17.  **/
    18. @WebServlet("/register")
    19. public class JDBCServlet extends HttpServlet {
    20.     @Override
    21.     protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    22.         req.setCharacterEncoding("UTF-8");
    23.         String sid = req.getParameter("sid");
    24.         String sname = req.getParameter("sname");
    25.         String sage = req.getParameter("sage");
    26.         String scontent = req.getParameter("scontent");
    27.  
    28.         Connection connection=null;
    29.         PreparedStatement stmt=null;
    30.  
    31.         String url="jdbc:mysql://localhost:3307/person_info?useSSL=false&useUnicode=true&characterEncoding=UTF8&serverTimezone=UTC";
    32.         String user="root";
    33.         String password="123456";
    34.  
    35.         try {
    36.             Class.forName("com.mysql.cj.jdbc.Driver");
    37.             connection = DriverManager.getConnection(url, user, password);
    38.             String sql = "INSERT INTO stu_city (sid, sname, sage, scontent) VALUES (?, ?, ?, ?)";
    39.             stmt=connection.prepareStatement(sql);
    40.             stmt.setInt(1, Integer.parseInt(sid));
    41.             stmt.setString(2,sname);
    42.             stmt.setInt(3, Integer.parseInt(sage));
    43.             stmt.setString(4,scontent);
    44. //            System.out.println(stmt);
    45.  
    46.             stmt.executeUpdate();
    47. //            if (rs>0)
    48. //                resp.sendRedirect("show.jsp");
    49.             resp.sendRedirect("hw10/show.jsp");
    50.         } catch (ClassNotFoundException | SQLException e) {
    51.             e.printStackTrace();
    52.         }finally {
    53.             if(stmt!=null){
    54.                 try {
    55.                     stmt.close();
    56.                 } catch (SQLException e) {
    57.                     e.printStackTrace();
    58.                 }
    59.             }
    60.             if (connection!=null) {
    61.                 try {
    62.                     connection.close();
    63.                 } catch (SQLException e) {
    64.                     e.printStackTrace();
    65.                 }
    66.             }
    67.         }
    68.  
    69.     }
    70. }

  • 相关阅读:
    2023年：哪些Trello的替代品值得关注？
    postman做接口测试
    Mybatis--动态SQL
    一文看懂推荐系统：排序06：粗排三塔模型，性能介于双塔模型和精排模型之间
    排序算法-堆排序和TopK算法
    手把手教你搭建zookeeper和kafka集群（超级详细）
    以太坊源码笔记-blockchain
    JTS: 12 Descriptions 图形覆盖
    【踩坑及思考】浏览器存储 cookie 最大值超过 4kb，或 http 头 cookie 超过限制值
    LeetCode //C - 77. Combinations
  • 原文地址：https://blog.csdn.net/GANTENJ/article/details/134510091