使用jdbc连接数据库遍历输出

Mxhlin

已于 2022-10-17 22:37:24 修改

阅读量154

点赞数

分类专栏：方法 mysql 文章标签：数据库 java junit

于 2022-10-17 22:37:20 首次发布

本文链接：https://blog.csdn.net/nidimyger/article/details/127378754

版权

方法同时被 2 个专栏收录

15 篇文章 0 订阅

订阅专栏

mysql

5 篇文章 0 订阅

订阅专栏

import org.junit.jupiter.api.AfterEach;
import org.junit.jupiter.api.BeforeAll;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;

import java.sql.*;

/**
 * @author Mxhlin
 * @Email fuhua277@163.com
 * @Date 2022/10/17/22:08
 * @Version
 * @Description
 */
public class TR {
    Connection conn;

    @BeforeAll
    public static void after() {
        System.out.println("加载驱动中...");
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
    }

    @Test
    public void conn() {
        try {
            PreparedStatement p = conn.prepareStatement("select * from book");
            ResultSet resultSet = p.executeQuery();
            while (resultSet.next()){
                System.out.println(resultSet.getInt(1)+" "+resultSet.getString(2)+" "+resultSet.getString(3)+" "+resultSet.getDouble(4)+" "+resultSet.getString(5)+" "+resultSet.getDate(6)+" "+resultSet.getDate(7)+" "+resultSet.getDate(8));
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    @BeforeEach
    public void db() {
        System.out.println("建立连接...");
        String url = "jdbc:mysql:/db_book?user=root";
        try {
            conn = DriverManager.getConnection(url);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }


    @AfterEach
    public void close() {
        try {
            conn.close();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}