JDBC工具类

package com.atguigu.api.statement;
import com.mysql.jdbc.Driver;
import java.sql.*;
public class StatementQueryPart {

    public static void main(String[] args) throws SQLException {
        try{
            //1.注册驱动
        /*
        驱动版本：8+com.mysql.cj.jdbc.Driver
                5+com.mysql.jdbc.Driver
        */
            DriverManager.registerDriver(new Driver());
            //创建连接
        /*
            参数1：url
                    jdbc:数据库厂商名：//ip地址：port/数据库名
                    jdbc:mysql://127.0.0.1:3306/test
         */
            //java.sql下的接口=实现类
            Connection connection=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root","123456");
            //3.创建statement(发送sql语句的小车)
            Statement statement=connection.createStatement();
            //4.发送sql语句，并且获得返回结果
            String sql="select * from users;";
            ResultSet resultSet=statement.executeQuery(sql);
            //5.结果解析
            while(resultSet.next())
            {
                int id=resultSet.getInt("user_id");
                String name= resultSet.getNString("user_name");
                String password=resultSet.getNString("user_password");
                int age=resultSet.getInt("age");
                String sex=resultSet.getNString("sex");
                System.out.println(id+"---"+name+"---"+password+"---"+age+"---"+sex+"---");
            }
            //6.关闭资源
            resultSet.close();
            statement.close();
            connection.close();
        }catch (Exception e)
        {
            System.out.println(e.toString());
        }
        if(System.out.printf("A")==null) {
            System.out.print("A");
        }
        else  {
            System.out.print("B");
        }
    }
}

JDBC工具类

package com.it.util;
import java.sql.*;
public class DBUtil {
    public static Connection getConn(){ //返回链接对象
        Connection conn=null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
        } catch (Exception e) {
            System.out.println(e.toString());
        }
       return conn;
    }
    public static void closes(Connection conn, Statement stm, ResultSet rs){//关闭资源
        try {if(conn!=null){
                conn.close();}
            if(stm!=null){
                stm.close();}
            if(rs!=null){
                rs.close();}
        } catch (Exception e) {
            System.out.println(e.toString());
        }
    }
}