JDBC基础

package com.yjj.jdbc.quickstart;

import org.junit.Test;

import java.sql.*;

public class JdbcQuickStart {
    @Test
    public void quickstartTest() throws ClassNotFoundException, SQLException {
        //1.注册驱动
        Class.forName("com.mysql.cj.jdbc.Driver");

        //2.连接数据库
        String url = "jdbc:mysql://127.0.0.1:3306/db2?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai";
        Connection conn = DriverManager.getConnection(url, "root", "root");
//    Connection :
//        1.是一个接口
//        2.数据库连接对象


        //3.编写SQl语句
        String sql = "select id, NAME ,gender,salary  from emp" ;

        //4.把SQL语句发送给数据库
        Statement stmt = conn.createStatement();//基于数据库连接对象,创建一个数据库操作对象
        ResultSet rs = stmt.executeQuery(sql);//将sql语句发送给数据库

        //5.处理SQL的执行结果
        while (rs.next()){
            System.out.print(rs.getInt("id")+"\t");
            System.out.print(rs.getString("NAME")+"\t");
            System.out.print(rs.getString("gender")+"\t");
            System.out.print(rs.getInt("salary")+"\t");
            System.out.print("\n"+"===================="+"\n");
        }

        //6.释放资源
        rs.close();
        stmt.close();
        conn.close();

    }
}

最基础的jdbc(参考)