【课堂笔记】javaweb的查询代码

旧人23

已于 2023-10-14 11:26:18 修改

阅读量187

点赞数

文章标签：笔记 python 数据库

于 2023-10-14 11:15:51 首次发布

本文链接：https://blog.csdn.net/2301_79585673/article/details/133822766

版权

javaweb的增删改查

实验准备

建立数据库sxy
在sxy的数据库建立表user
创建JavaEE项目

实现代码

代码架构：
请添加图片描述

数据库的建立，并填入数据。（填入数据略）

请添加图片描述

com.ym.demo -> DButils

package com.ym.demo;

import java.sql.*;
import java.util.ResourceBundle;

import static java.lang.Class.forName;

public class DButils {
    private static String  driverClass;
    private static String  url;
    private static String  username;
    private static String  password;

    static {
        ResourceBundle rb = ResourceBundle.getBundle("dbinfo");
        driverClass = rb.getString("driverClass");
        url = rb.getString("url");
        username = rb.getString("username");
        password = rb.getString("password");
        try {
            Class.forName(driverClass);
        } catch (ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
    }

    public static Connection getConnection() throws Exception {
        return DriverManager.getConnection(url, username, password);
    }

    public static void closeALL(ResultSet rs, Statement stmt, Connection conjn){
        if (rs != null){
            try {
                rs.close();
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
        rs = null;

        if (stmt != null){
            try {
                stmt.close();
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
        stmt = null;

        if (conjn != null){
            try {
                conjn.close();
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
        conjn = null;
    }
}

com.ym.demo -> testCRUD

public class testCRUD {
    public void testSelect(){
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        ArrayList<User> list = new ArrayList<>();
        try {
            conn = DButils.getConnection();
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from user");
            while ( rs.next() ) {
                User u = new User();
                u.setId(rs.getInt(1));
                u.setName(rs.getString(2));
                u.setPassword(rs.getString(3));
                list.add(u);
            }
            for (User user : list) {
                System.out.printf("user");
            }
        }catch (Exception e) {
            e.printStackTrace();
        }finally {
            DButils.closeALL(rs, stmt, conn);
        }


    }
}

com.ym.demo -> User

public class User {

    private int id;
    private String name;
    private String password;

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                '}';
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

1.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<p><marquee>13456780</marquee></p>
</body>
</html>

dbinfo.properties

driverClass = com.mysql.cj.jdbc.Driver
url = jdbc:mysql:///sxy
username = root
password = 123456

注意事项

jdk8链接数据库用 cj.jdbc ; jdk7用jdbc

旧人23

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
【课堂笔记】javaweb的查询代码

javaweb的查询代码
复制链接

扫一扫