IDEA搭建JavaWeb项目，JDBC和Servlet-JSP技术实现注册功能

秒速五厘米 2024-04-08 11:46 55阅读 0赞

#### 文章目录 ####

*  使用IDEA搭建JavaWeb项目
 *  一、IDEA新建JavaWeb项目
 *   *  1、新建java项目
     *  2、修改项目配置
     *  3、项目部署到Tomcat
 *  二、使用JDBC和Servlet-JSP技术实现注册功能
 *   *  1.引入jar包
     *  2.搭建项目结构
     *  3.后端实现
     *  4.前端页面的处理
 *  总结

--------------------

## 使用IDEA搭建JavaWeb项目 ##

本篇主要讲怎么使用IDEA搭建JavaWeb项目，并且使用JDBC和JSP-Servlet实现一个简单的注册功能。

## 一、IDEA新建JavaWeb项目 ##

这里以idea2021.3.2版本为例。idea是不可以直接创建一个JavaWeb项目的，我们需要新建一个普通的java项目，然后手动修改。

### 1、新建java项目 ###

![在这里插入图片描述][8a6a6869608e48db9a1437f2e299ac75.png]  
![在这里插入图片描述][6b77c4d68dd84031923a96fa4bdb2042.png]  
![在这里插入图片描述][f1c14a043b84457680aaca7f12526b56.png]  
![在这里插入图片描述][05a6853ab7634f879ecf2fcaea6c5772.png]

> 新建完成如下

![在这里插入图片描述][b931b4f1f7fe4d5595430657ffdc3ff8.png]

### 2、修改项目配置 ###

![在这里插入图片描述][f93b0919069c4061bc8df0c96354c4b5.png]

> JavaEE的版本默认的即可，有特殊要求的自行修改

![在这里插入图片描述][69d957dcd5c34ff08bc519157d4c0d9e.png]  
![在这里插入图片描述][20fe8b444e0e4eddbaf682312fcad83d.png]

> 此时我们的项目就已经初步的修改为JavaWeb项目了，有了JavaWeb项目的目录层级

![在这里插入图片描述][55af9c6b2e324816bbe7c4ef96f4f65e.png]

> 配置Tomcat服务器

![在这里插入图片描述][71e79a7cffe74298bc42aa1872236404.png]  
![在这里插入图片描述][7e4e59efe2bf48d8aabeb9a9db26b8e6.png]  
![!\[在这里插入图片描述\](https://img-blog.csdnimg.cn/501de599c10f49f1a58ab019f2d17b32.png][https_img-blog.csdnimg.cn_501de599c10f49f1a58ab019f2d17b32.png]  
![!\[在这里插入图片描述\](https://img-blog.csdnimg.cn/bfd1ff0cf0bb4d6a9ebe63d0d43b24be.png>][https_img-blog.csdnimg.cn_bfd1ff0cf0bb4d6a9ebe63d0d43b24be.png]

> 注意这里的Tomcat需要预先下载好，才能识别出来

![在这里插入图片描述][99d9dc9957b54a8c990be7f58ca397b1.png]

> 到此，基本配置已经完成，JavaWeb项目已经新建完毕  
> 接着，需要我们把项目部署在Tomcat

### 3、项目部署到Tomcat ###

![在这里插入图片描述][7a3f748d881b4694a8c4d3731cc97c89.png]  
![在这里插入图片描述][7cf08fbc18f2460a972b4290be33121e.png]  
![在这里插入图片描述][2e042c8023824eaab785c69eec2b06a5.png]  
![在这里插入图片描述][17fa293041f444a28d344c60de33ea8d.png]  
![在这里插入图片描述][bf31610ba19145fc83bdc3a79a080da9.png]

> 至此项目部署完成，可以运行了

![在这里插入图片描述][aca84c44b8dc44c296b3956f29df1054.png]

> 默认访问的是index.jsp

## 二、使用JDBC和Servlet-JSP技术实现注册功能 ##

### 1.引入jar包 ###

> 需要在WEB-INF下新建一个lib目录，注意，和普通的java项目不同，普通的java项目lib建在项目的根目录下，但是JavaWeb项目lib目录必须配置在WEB-INF下，否则Tomcat会无法找到jar包资源，从而导致报错。

![在这里插入图片描述][0697e8d98991453db66ae07633ba9cca.png]  
![在这里插入图片描述][e0324394eafe43558483a1cae1ebd7e0.png]

> 接着将我们的jar全部复制过来，这里我导入了两个jar包，mysql.jar和gosn.jar

![在这里插入图片描述][0c47d61e096249cca5940ac3d5e92bac.png]

> 接着选中lib点击add as library

![在这里插入图片描述][6171a884b3c1413193bdbf5f253da856.png]

> jar包导入完成。

### 2.搭建项目结构 ###

> 我们在项目中将我们需要的目录结构新建出来

![在这里插入图片描述][5c0f6b8cb0a34f27bbeb687c1c81c2cf.png]

> 将我们需要的工具类导入

![在这里插入图片描述][5e7704be839c483caba3bdbbbe08d578.png]

### 3.后端实现 ###

**（1）. 建表，根据业务需求，我们需要在数据建设一个存储用户信息的数据表**

SET FOREIGN_KEY_CHECKS=0;
    
    -- ----------------------------
    -- Table structure for user1
    -- ----------------------------
    DROP TABLE IF EXISTS `user1`;
    CREATE TABLE `user1` (
      `uid` int(3) NOT NULL AUTO_INCREMENT,
      `uname` varchar(8) NOT NULL,
      `uphone` varchar(11) NOT NULL,
      `ugender` char(1) NOT NULL,
      `uage` int(3) NOT NULL,
      `IDcardType` varchar(10) NOT NULL,
      `IDcard` varchar(20) NOT NULL,
      `password` varchar(12) NOT NULL,
      PRIMARY KEY (`uid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

**（2）. 编写实体类**

package com.web.entity;
    
    public class User {
        
        private Integer uid;
        private String uname;
        private String password;
        private String uphone;
        private String ugender;
        private Integer uage;
        private String IDcardType;
        private String IDcard;
    
        public User() {
        
        }
    
        public User(Integer uid, String uname, String password, String uphone, String ugender, Integer uage, String IDcardType, String IDcard) {
        
            this.uid = uid;
            this.uname = uname;
            this.password = password;
            this.uphone = uphone;
            this.ugender = ugender;
            this.uage = uage;
            this.IDcardType = IDcardType;
            this.IDcard = IDcard;
        }
    
        public Integer getUid() {
        
            return uid;
        }
    
        public void setUid(Integer uid) {
        
            this.uid = uid;
        }
    
        public String getUname() {
        
            return uname;
        }
    
        public void setUname(String uname) {
        
            this.uname = uname;
        }
    
        public String getPassword() {
        
            return password;
        }
    
        public void setPassword(String password) {
        
            this.password = password;
        }
    
        public String getUphone() {
        
            return uphone;
        }
    
        public void setUphone(String uphone) {
        
            this.uphone = uphone;
        }
    
        public String getUgender() {
        
            return ugender;
        }
    
        public void setUgender(String ugender) {
        
            this.ugender = ugender;
        }
    
        public Integer getUage() {
        
            return uage;
        }
    
        public void setUage(Integer uage) {
        
            this.uage = uage;
        }
    
        public String getIDcardType() {
        
            return IDcardType;
        }
    
        public void setIDcardType(String IDcardType) {
        
            this.IDcardType = IDcardType;
        }
    
        public String getIDcard() {
        
            return IDcard;
        }
    
        public void setIDcard(String IDcard) {
        
            this.IDcard = IDcard;
        }
    
        @Override
        public String toString() {
        
            return "User{" +
                    "uid=" + uid +
                    ", uname='" + uname + '\'' +
                    ", password='" + password + '\'' +
                    ", uphone='" + uphone + '\'' +
                    ", ugender='" + ugender + '\'' +
                    ", uage=" + uage +
                    ", IDcardType='" + IDcardType + '\'' +
                    ", IDcard='" + IDcard + '\'' +
                    '}';
        }
    }

**（3）. 编写dao接口**

package com.web.dao;
    
    import java.util.Map;
    
    public interface RegisterDao {
        
        /**
         * 注册用户
         * @param map
         * @return 受影响行数
         */
        Integer registerUser(Map<String,Object> map);
    }

**（4）. 编写daoimpl实现类**

package com.web.daoimpl;
    
    import com.web.dao.RegisterDao;
    import com.web.util.DBUtil;
    
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.util.Map;
    
    public class RegisterDaoImpl implements RegisterDao {
        
        //获得连接
        private Connection conn = null;
        //预编译处理对象
        private PreparedStatement pst = null;
        //结果集
        private ResultSet rts = null;
        /**
         * 注册用户
         * @param map
         * @return 受影响行数
         */
        @Override
        public Integer registerUser(Map<String, Object> map) {
        
            int key = 0;
            try {
        
                conn = DBUtil.getConnection();
                String sql = "insert into user1(uname,uphone,ugender,uage," +
                        "IDcardType,IDcard,password) values(?,?,?,?,?,?,?)";
                pst = conn.prepareStatement(sql);
                pst.setObject(1, map.get("uname"));
                pst.setObject(2, map.get("uphone"));
                pst.setObject(3, map.get("ugender"));
                pst.setObject(4, map.get("uage"));
                pst.setObject(5, map.get("IDcardType"));
                pst.setObject(6, map.get("IDcard"));
                pst.setObject(7, map.get("password"));
                key = pst.executeUpdate();
            } catch (SQLException e) {
        
                e.printStackTrace();
            }finally {
        
                DBUtil.closeAll(conn,pst,rts);
            }
            return key;
        }
    }

**（5）. 编写servlet**

package com.web.servlet;
    
    import com.web.dao.RegisterDao;
    import com.web.daoimpl.RegisterDaoImpl;
    import com.web.util.BaseServlet;
    import com.web.util.Result;
    
    import javax.servlet.ServletException;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    import java.io.IOException;
    import java.io.PrintWriter;
    import java.util.HashMap;
    import java.util.Map;
    
    public class RegisterServlet extends BaseServlet {
        
        //调用daoimpl
        private RegisterDao impl = new RegisterDaoImpl();
        public void register(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        
            //接收参数
            Map<String, Object> map = new HashMap<>();
            map.put("uname",req.getParameter("uname"));
            map.put("uphone",req.getParameter("uphone"));
            map.put("ugender",req.getParameter("ugender"));
            map.put("uage",req.getParameter("uage"));
            map.put("IDcardType",req.getParameter("IDcardType"));
            map.put("IDcard",req.getParameter("IDcard"));
            map.put("password",req.getParameter("password"));
            System.out.println(map);
            //设置流
            PrintWriter out = resp.getWriter();
            //调用方法
            Integer key =  impl.registerUser(map);
            //输出流
            if (key>0){
        
                out.write(Result.toClient("1","注册成功！"));
            }else {
        
                out.write(Result.toClient("0","注册失败！"));
            }
            out.flush();
            out.close();
        }
    }

**（6）. 修改web.xml文件配置servlet全局访问路径**  
![在这里插入图片描述][7c8970be9e614b5884ef9fe5da35f117.png]

<display-name>UserRegister</display-name>
        <welcome-file-list>
            <welcome-file>index.jsp</welcome-file>
            <welcome-file>default.html</welcome-file>
            <welcome-file>default.htm</welcome-file>
            <welcome-file>default.jsp</welcome-file>
        </welcome-file-list>
        <servlet>
            <description></description>
            <display-name>RegisterServlet</display-name>
            <servlet-name>RegisterServlet</servlet-name>
            <servlet-class>com.lzl.servlet.RegisterServlet</servlet-class>
        </servlet>
        <servlet-mapping>
            <servlet-name>RegisterServlet</servlet-name>
            <url-pattern>/RegisterServlet</url-pattern>
        </servlet-mapping>

### 4.前端页面的处理 ###

前端的页面我使用HbuilderX纯手敲一个注册页，由于不是专业前端，效果比较拉跨

<%--
      Created by IntelliJ IDEA.
      User: 我是谁
      Date: 2022/8/23
      Time: 15:55
      To change this template use File | Settings | File Templates.
    --%>
    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <!DOCTYPE html>
    <html>
    <head>
      <meta charset="utf-8">
      <title></title>
      <style type="text/css">
        body{
          
          background-image: url(static/img/champion-galio-splash.jpg);
          background-repeat: no-repeat;
          background-position:top left;
          background-size: 100%;
        }
    
        #right{
          
          border: solid chartreuse 5px;
          width: 450px;
          border-radius: 20px;
        }
    
        th{
          
          width: 150px;
        }
        .verity{
          
          width: 70px;
          font-size: large;
        }
        #queren{
          
          color: red;
          font-size: small;
        }
        td{
          
          width: 6.125rem;
        }
        #content{
          
          position: absolute;
          margin-left: 230px;
          margin-top: -20px;
          background-color: #000b0b;
          z-index: 1;
          background-color: rgb(30, 24, 18,0.5);
          border-radius: 20px;
        }
        .areDiv{
          
          float: left;
          display: inline-block;
          margin: 30px;
          color: chartreuse;
          /* opacity: 1; */
        }
        #middle{
          
          width: 5px;
          height: 450px;
          background-color: #FFC0CB;
        }
        #top{
          
          font-size: 30px;
          text-align: center;
          color: gold;
        }
        #top>h1{
          
          width: 650px;
          border-radius: 20px;
          display: block;
          margin-left: 425px;
        }
        select{
          
          width: 170px;
          font-size:large;
          text-align: center;
        }
        span{
          
          color: #FF0000;
        }
        a{
          
          text-decoration: none;
          color: blueviolet;
        }
        #sgender{
          
          width: 165px;
        }
        .title{
          
          text-align: right;
        }
        #uage{
          
          width: 165px;
        }
        #IDcard{
          
          width: 165px;
        }
      </style>
      <link rel="stylesheet" type="text/css" href="./static/css/date.css"/>
    </head>
    <body>
    <div id="top">
      <h1>League Of Lengends</h1>
    </div>
    <div id="content">
      <div id="left" class="areDiv">
        <h1>英勇的召唤师，欢迎您的加入！
          <br>面如霜下雪
          <br>吻如雪上霜
          <br>谁知我知你
          <br>我知你之深
        </h1>
      </div>
      <div id="middle" class="areDiv">
      </div>
      <div id="right" class="areDiv">
        <form  id="dataform">
          <table border="0" cellspacing="0" cellpadding="10">
            <tr><th colspan="3">注册用户</th></tr>
            <tr>
              <td class="title"><span>*</span>用户名：</td>
              <td><input type="text"  required="required" placeholder="3~8位字符" name="uname" id="username" value="" /></td>
              <td><div id="unameverity" class="verity"></div></td>
            </tr>
            <tr>
              <td class="title"><span>*</span>手机号码：</td>
              <td><input type="number"  required="required" placeholder="必须是合法手机号" name="uphone" id="uphone" value="" /></td>
              <td><div id="pnumber" class="verity"></div></td>
            </tr>
            <tr>
              <td class="title"><span>*</span>性别：</td>
              <td>
                <input type="radio"  required="required" name="ugender" value="男" checked="checked">男
                <input type="radio" name="ugender" value="女">女
              </td>
              <td></td>
            </tr>
            <tr>
              <td class="title"><span>*</span>年龄：</td>
              <td>
                <input type="text" class="verity" name="uage" id="uage" value="" />
              </td>
              <td></td>
            </tr>
            <tr>
              <td class="title"><span>*</span>证件类型：</td>
              <td>
                <select name="IDcardType"  required="required">
                  <option value="">---请选择---</option>
                  <option value="二代居民身份证">二代居民身份证</option>
                  <option value="港澳台通行证">港澳台通行证</option>
                </select>
              </td>
              <td></td>
            </tr>
            <tr>
              <td class="title"><span>*</span>身份证号：</td>
              <td>
                <input type="text"placeholder="输入正确的身份证号码"required="required" name="IDcard" id="IDcard" value="" />
              </td>
              <td><div id="yidcard" class="verity"></div></td>
            </tr>
            <tr>
              <td class="title"><span>*</span>密码：</td>
              <td><input type="password"  required="required" placeholder="6~12位字母数字符号组合" name="password" id="pwd" value="" /></td>
              <td><div id="qiangdu" class="verity"></div></td>
            </tr>
            <tr>
              <td class="title"><span>*</span>确认密码：</td>
              <td><input type="password"  required="required" placeholder="和密码输入保持一致" name="rpwd" id="rpwd" value="" /></td>
              <td><div id="queren"></div></td>
            </tr>
            <tr>
              <td colspan="3">
                <input type="radio"  required="required" name="xieyi" value="" />
                我已阅读并同意遵守
                <a href="http://game.qq.com/contract.shtml">《腾讯游戏许可及服务协议》</a>
              </td>
            </tr>
            <tr>
              <td colspan="3" align="center">
                <input type="button" id="register" value="注册"/>
                <input type="reset" value="重置"/>
              </td>
            </tr>
          </table>
        </form>
      </div>
    </div>
    </body>
    <script src="static/js/jquery-1.12.4.min.js" type="text/javascript" charset="utf-8"></script>
    <script type="text/javascript">
      $("#username").keyup(function(){
          
        $p = $("#username").val();
        var reg = /^[A-Za-z0-9_-]{3,8}$/;
        if(reg.test($p)){
          
          $("#unameverity").attr("style","color: lawngreen");
          $("#unameverity").text("√");
        }else{
          
          $("#unameverity").attr("style","color: red");
          $("#unameverity").text("×");
        }
        if($p==""){
          
          $("#unameverity").text("");
        }
      });
      //IDcard
      $("#IDcard").keyup(function(){
          
        $p = $("#IDcard").val();
        var reg = /^[1-9]\d{5}(18|19|20|(3\d))\d{2}((0[1-9])|(1[0-2]))(([0-2][1-9])|10|20|30|31)\d{3}[0-9Xx]$/;
        if(reg.test($p)){
          
          $("#yidcard").attr("style","color: lawngreen");
          $("#yidcard").text("√");
        }else{
          
          $("#yidcard").attr("style","color: red");
          $("#yidcard").text("×");
        }
        if($p==""){
          
          $("#yidcard").text("");
        }
      });
      $("#uphone").keyup(function(){
          
        $p = $("#uphone").val();
        var reg = /^1(?:3\d|4[4-9]|5[0-35-9]|6[67]|7[013-8]|8\d|9\d)\d{8}$/;
        if(reg.test($p)){
          
          $("#pnumber").attr("style","color: lawngreen");
          $("#pnumber").text("√");
        }else{
          
          $("#pnumber").attr("style","color: red");
          $("#pnumber").text("×");
        }
        if($p==""){
          
          $("#pnumber").text("");
        }
      });
      $("#pwd").keyup(function(){
          
        $p = $("#pwd").val();
        var reg = /^[A-Za-z0-9_-]{6,12}$/;
        if(reg.test($p)){
          
          $("#qiangdu").attr("style","color: lawngreen");
          $("#qiangdu").text("√");
        }else{
          
          $("#qiangdu").attr("style","color: red");
          $("#qiangdu").text("×");
        }
        if($p==""){
          
          $("#qiangdu").text("");
        }
      });
      $("#rpwd").keyup(function(){
          
        $p = $("#pwd").val();
        $rp = $("#rpwd").val();
        if($p!=$rp){
          
          $("#queren").text("密码不一致！");
        }else{
          
          $("#queren").text("");
          $("#queren").attr("style","color: lawngreen");
          $("#queren").text("密码一致");
        }
    
      });
      $('input:radio').click(function(){
          
        var $radio = $(this);
        if ($radio.data('checked')){
          
          $radio.prop('checked', false);
          $radio.data('checked', false);
        } else {
          
          $radio.prop('checked', true);
          $radio.data('checked', true);
        }
      });
    
      $("#register").click(function(){
          
        $.post("RegisterServlet?method=register",
                $("#dataform").serialize(),
                function (res){
          
                if(res.code=="1"){
          
                    alert(res.msg);
                }else{
          
                    alert(res.msg);
                }
        },"json")
    
      })
    </script>
    </html>

> 然后，需要在web下边新建static文件夹，存放我们的静态资源，例如img，js等等

![在这里插入图片描述][e83f57fece174e96ba1412701781109d.png]  
运行项目  
![在这里插入图片描述][3a2a37f5bd5c4623856d1c0d05b6ecf2.png]  
资源已经上传，有需要的可以下载  
[JSP+Servlet+JDBC+MySQL注册功能实现][JSP_Servlet_JDBC_MySQL]

## 总结 ##

使用JDBC和Servlet-JSP技术是JavaWeb开发的一个重要台阶，这意味着，已经迈出了后端开发的第一步，与诸君共勉。功能有个bug，用户名可以重复注册，但由于只是演示，所以这个bug我就不修了。下一篇再见

[8a6a6869608e48db9a1437f2e299ac75.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/87d78b150ab947aea5ca379b5dfa9406.png
[6b77c4d68dd84031923a96fa4bdb2042.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/5deae3b52d534abfb595d49318bde4d4.png
[f1c14a043b84457680aaca7f12526b56.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/426eec4447ce4a3b9686cb44a8d03699.png
[05a6853ab7634f879ecf2fcaea6c5772.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/b149d372f1934e82aec494bc14aa4883.png
[b931b4f1f7fe4d5595430657ffdc3ff8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/9bf551962b6c45c49b3407bc425bdace.png
[f93b0919069c4061bc8df0c96354c4b5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/d978e6b7a432437799bda613d999fa26.png
[69d957dcd5c34ff08bc519157d4c0d9e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/fb3686bc282742d3b352265a31325a90.png
[20fe8b444e0e4eddbaf682312fcad83d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/af65940507fa4a75a3be1dad7e806286.png
[55af9c6b2e324816bbe7c4ef96f4f65e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/983c88f7faed4fdcbf472fef9470a5f9.png
[71e79a7cffe74298bc42aa1872236404.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/61ee11841b76480eb15147958c93eb10.png
[7e4e59efe2bf48d8aabeb9a9db26b8e6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/09c4a8472a444c468012530d126e1df1.png
[https_img-blog.csdnimg.cn_501de599c10f49f1a58ab019f2d17b32.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/ca13286af6024234aaf3d6e258e45271.png
[https_img-blog.csdnimg.cn_bfd1ff0cf0bb4d6a9ebe63d0d43b24be.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/7375d21e157d45df943212a47e39cafd.png
[99d9dc9957b54a8c990be7f58ca397b1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/267fb9f8997142dbb83a30856c430cc9.png
[7a3f748d881b4694a8c4d3731cc97c89.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/7498aef00fe54485924296d8abf16494.png
[7cf08fbc18f2460a972b4290be33121e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/a444d30d217d4280a4dfa8d2e38be3ad.png
[2e042c8023824eaab785c69eec2b06a5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/1b6a6d68c65d4935be9d117e661d7377.png
[17fa293041f444a28d344c60de33ea8d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/2319d84696be46b4af10ee13c316a1b5.png
[bf31610ba19145fc83bdc3a79a080da9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/489292e38c6e41b4b6e56f576db3ac26.png
[aca84c44b8dc44c296b3956f29df1054.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/17e86e75ccee470bb6ea9ffc78061e65.png
[0697e8d98991453db66ae07633ba9cca.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/e5821406c2c2458b9544647c7aa7ea2f.png
[e0324394eafe43558483a1cae1ebd7e0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/0c7c2403855a48d09e6a7f953c590509.png
[0c47d61e096249cca5940ac3d5e92bac.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/25da8e0e866843169399530a5800f487.png
[6171a884b3c1413193bdbf5f253da856.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/5395d47140cc420093d792c3a6143be5.png
[5c0f6b8cb0a34f27bbeb687c1c81c2cf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/a2f23d0a40ac4be7bd7bbacaf6a8e719.png
[5e7704be839c483caba3bdbbbe08d578.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/b3ae18ed860644a085c53dee04fcfa50.png
[7c8970be9e614b5884ef9fe5da35f117.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/f0419f4bde65425da5590e02b37a93ae.png
[e83f57fece174e96ba1412701781109d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/711d62a2236645fda09eb7759b019f4f.png
[3a2a37f5bd5c4623856d1c0d05b6ecf2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/143e603100604e8b8d928bab9a085117.png
[JSP_Servlet_JDBC_MySQL]: https://download.csdn.net/download/l_zl2021/86468322