6.在线考试管理系统ADD

最新推荐文章于 2023-12-28 17:21:55 发布

苏七qaq

最新推荐文章于 2023-12-28 17:21:55 发布

阅读量125

点赞数

分类专栏： Servlet 文章标签：数据库 java

本文链接：https://blog.csdn.net/weixin_45974277/article/details/120596409

版权

Servlet 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

准备工作:
1.建表
create table users(
    userId int primary key auto_increment, #auto_increment,在插入时，如果不给定具体编号，则根据auto_increment值递加
    userName varchar(50),
    password varchar(50),
    sex char(1),
    email varchar(50),
)
2.建表的对应实体类
3.操作数据库工具类util
util:

package util;


import java.sql.*;
// JdbcUtil obj = new JdbcUtil();  obj.getCon()
// JdbcUtil obj = new JdbcUtil();  obj.createStatement();
// JdbcUtil.getCon();
public class JdbcUtil {

     final String URL="jdbc:mysql://localhost:3306/test2";
     final String USERNAME="root";
     final String PASSWORD="18081736467xr";
     PreparedStatement ps= null;
     Connection con = null;

    //将jar包中driver实现类加载到JVM中
    static{
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    //封装连接通道创建细节
    public  Connection   getCon(){
        try {
            con = DriverManager.getConnection(URL, USERNAME, PASSWORD);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return con;
    }

    //封装交通工具创建细节
    public  PreparedStatement createStatement(String sql){

        try {
            ps =  getCon().prepareStatement(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return ps;
    }
    // ps与con销毁细节 insert,update,delete
    public  void close(){
        if(ps!=null){
            try {
                ps.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if(con!=null){
            try {
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

    }

     //select ps,con,rs
    public  void close(ResultSet rs){
        if(rs!=null){
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        close();
    }
}

4.导入jdbc实现jar包，并右键jar包 add as Library

5.画流程图

html:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
        <!--action="/myWeb/user/add" submit提交之后会重定向到/myWeb/user/add-->
    <form action="/myWeb/user/add" method="get">
        <table border="2">
            <tr>
                <td>用户姓名:</td>
                <td><input type="text" name="userName"></td>
            </tr>

            <tr>
                <td>用户密码:</td>
                <td><input type="password" name="userPassword"></td>
            </tr>

            <tr>
                <td>用户性别:</td>
                <td>
                    <input type="radio" name="sex" value='男'>男
                    <input type="radio" name="sex" value='女'>女
                </td>
            </tr>

            <tr>
                <td>用户邮箱:</td>
                <td><input type="text" name="email"></td>
            </tr>
            <tr>
                <td><input type="submit" value="注册"></td>
                <td><input type="reset" value="重置"></td>
            </tr>
        </table>
    </form>
</body>
</html>

servlet:

public class UserAddServlet extends HttpServlet
{
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException
    {
        int result =0;
        UserDao userDao = new UserDao();
        //1.调用请求对象读取请求头参数信息，得到用户的信息
        String userName = req.getParameter("userName");
        String password = req.getParameter("userPassword");
        String sex = req.getParameter("sex");
        String email = req.getParameter("email");
        users users = new users(userName,password,sex,email);
        //2.调用UserDAO将用户信息填充到数据库
        try {
            result = userDao.add(users);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        //3.调用响应对象 将处理结果以二进制形式写入到响应体
        resp.setContentType("text/html;charset=utf-8");
        PrintWriter ps = resp.getWriter();
        if(result==1)
        {
            ps.print("<font style='color:red; font-size:40'>用户信息注册成功</font>");
        }else
        {
            ps.print("<font style='color:red; font-size:40'>用户信息注册失败</font>");
        }
    }
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException
    {

    }
}

UserDao:

package Dao;

import entity.users;
import util.JdbcUtil;

import java.sql.PreparedStatement;
import java.sql.SQLException;

public class UserDao
{
    JdbcUtil jdbcUtil = new JdbcUtil();
    //用户的注册
    public int add(users users) throws SQLException {
        String addSql = "insert into users(userName,password,sex,email) values(?,?,?,?)";
        PreparedStatement ps = jdbcUtil.createStatement(addSql);
        int result = 0;
        try{
            ps.setString(1,users.getUserName());
            ps.setString(2,users.getPassword());
            ps.setString(3,users.getSex());
            ps.setString(4,users.getEmail());
            result = ps.executeUpdate();
        }catch (SQLException e)
        {
            e.printStackTrace();
        } finally
        {
            jdbcUtil.close();
        }
        return result;
    }
}

util工具类：

package util;


import java.sql.*;
// JdbcUtil obj = new JdbcUtil();  obj.getCon()
// JdbcUtil obj = new JdbcUtil();  obj.createStatement();
// JdbcUtil.getCon();
public class JdbcUtil{
     final String URL="jdbc:mysql://localhost:3306/test2?characterEncoding=UTF-8";
     final String USERNAME="root";
     final String PASSWORD="18081736467xr";
     PreparedStatement ps= null;
     Connection con = null;

    //将jar包中driver实现类加载到JVM中
    static{
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    //封装连接通道创建细节
    public  Connection  getCon(){
        try {
            con = DriverManager.getConnection(URL, USERNAME, PASSWORD);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return con;
    }

    //封装交通工具创建细节
    public  PreparedStatement createStatement(String sql){
        try {
            ps =  getCon().prepareStatement(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return ps;
    }
    // ps与con销毁细节 insert,update,delete
    public  void close(){
        if(ps!=null){
            try {
                ps.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if(con!=null){
            try {
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

    }

     //select ps,con,rs
    public  void close(ResultSet rs){
        if(rs!=null){
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        close();
    }
}

苏七qaq

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
6.在线考试管理系统ADD

准备工作:1.建表create table users( userId int primary key auto_increment, #auto_increment,在插入时，如果不给定具体编号，则根据auto_increment值递加 userName varchar(50), password varchar(50), sex char(1), email varchar(50),)2.建表的对应实体类3.操作数据库工具类utilutil:.
复制链接

扫一扫