JDBC简化书写案例

JDBC工具类
抽取jdbc工具类：JDBCUtils
目的：简化书写
分析：①抽取一个方法获取链接对象（在此之前也抽取注册驱动）
②抽取方法释放资源
简化书写方法体

package util;

import java.io.FileReader;
import java.io.IOException;
import java.net.URL;
import java.sql.*;
import java.util.Properties;

public  class JdbcUtils {
private static String url;
private static String user;
private static String password;
    private static String driver;
    static {

        try {
            Properties pro = new Properties();

            ClassLoader classLoader = JdbcUtils.class.getClassLoader();
            URL resource = classLoader.getResource("jdbc.properties");
             String path = resource.getPath();

            pro.load(new FileReader(path));
            url = pro.getProperty("url");
            user = pro.getProperty("user");
            password = pro.getProperty("password");
            driver = pro.getProperty("driver");
            try {
                Class.forName( driver );
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static Connection getConnection(){
        try {
            return DriverManager.getConnection(url, user, password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return  null;
    }

    public static void close(ResultSet rs, Statement stmt, Connection conn) {
   				 if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
        if (stmt != null) {
            
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }


        }
    }
    public static void close( Statement stmt, Connection conn) {

                try {
                    stmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                if (conn != null) {
                    try {
                        conn.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
            }


        }

配置文件
src下建立文档
键入

url = jdbc:mysql:///db3
user = root
password = root
driver = com.mysql.jdbc.Driver 

这种造轮子的思路给我很大启发。