JDBC的工具类

来源：互联网发布：服务器安装mysql数据库编辑：程序博客网时间：2024/05/16 09:00
package com.myjdbc.jdbc.utils;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;/** * JDBC的工具类 * */public class JDBCUtils {    private static final String driverClassName;    private static final String url;    private static final String username;    private static final String password;    static{        // 获取属性文件中的内容：        Properties properties = new Properties();        try {            properties.load(new FileInputStream("src/db.properties"));        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }        driverClassName=properties.getProperty("driverClassName");        url=properties.getProperty("url");        username=properties.getProperty("username");        password=properties.getProperty("password");    }    /**     * 注册驱动的方法     */    public static void loadDriver(){        try {            Class.forName(driverClassName);        } catch (ClassNotFoundException e) {            e.printStackTrace();        }    }    /**     * 获得连接的方法     */    public static Connection getConnection(){        Connection conn = null;        try{            // 将驱动一并注册:            loadDriver();            // 获得连接            conn = DriverManager.getConnection(url,username, password);        }catch(Exception e){            e.printStackTrace();        }        return conn;    }    /**     * 释放资源的方法     */    public static void release(Statement stmt,Connection conn){        if(stmt != null){            try {                stmt.close();            } catch (SQLException e) {                e.printStackTrace();            }            stmt = null;        }        if(conn != null){            try {                conn.close();            } catch (SQLException e) {                e.printStackTrace();            }            conn = null;        }    }    public static void release(ResultSet rs,Statement stmt,Connection conn){        // 资源释放：        if(rs != null){            try {                rs.close();            } catch (SQLException e) {                e.printStackTrace();            }            rs = null;        }        if(stmt != null){            try {                stmt.close();            } catch (SQLException e) {                e.printStackTrace();            }            stmt = null;        }        if(conn != null){            try {                conn.close();            } catch (SQLException e) {                e.printStackTrace();            }            conn = null;        }    }}
阅读全文
0 0