JDBC--封装工具类以及使用

JDBC–封装工具类以及使用

工具类

package util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;

public class JdbcUtil {
    //定义成员变量用来保存四大参数
    private static String driverName;
    private static String url;
    private static String username;
    private static String password;

    static {
        try {
            //读取配置文件到输入流
            InputStream in = JdbcUtil.class.getResourceAsStream("/jdbc.properties");
            Properties properties = new Properties();
            //加载配置文件中的数据到Properties中
            properties.load(in);

            //获取四大参数
            driverName = properties.getProperty("driverName");
            url = properties.getProperty("url");
            username = properties.getProperty("username");
            password = properties.getProperty("password");

            //加载驱动
            Class.forName(driverName);
        } catch (IOException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    //获取连接
    public static Connection getConnection() {
        Connection connection = null;
        try {
            connection = DriverManager.getConnection(url, username, password);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

        return connection;
    }

    //释放资源
    public static void close(Connection connection, Statement statement, ResultSet rSet) {
        try {
            if(rSet != null) {
                rSet.close();
            }

            if(statement != null) {
                statement.close();
            }

            if(connection != null) {
                connection.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
}

配置文件

driverName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mydbjdbc?useSSL=false
username=root
password=1234

使用工具类 **

package Jdbc1;

import util.JdbcUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class MyTest4 {
    public static void main(String[] args) {
        String sql = "select * from `tb_stu` where sgender=?";
        Connection conn =null;
        PreparedStatement pst = null;
        ResultSet rst = null;


        try {
            conn= JdbcUtil.getConnection();
            pst = conn.prepareStatement(sql);
            pst.setString(1, "male");
            rst = pst.executeQuery();

            while (rst.next()) {
                int sid = rst.getInt("sid");
                String sname = rst.getString("sname");
                int sage = rst.getInt("sage");
                String sgender = rst.getString("sgender");
                System.out.println(sid + ";" + sname + ";" +sage + ";" + sgender);
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        JdbcUtil.close(conn, pst, rst);

    }
}