Java链接Access工具类

短命女 2022-08-03 05:08 178阅读 0赞

Java链接Access工具类

import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.util.Properties;
    
    public final class JdbcUtils {
    
        private static String url = "jdbc:odbc:MyAccess";
        private static String user = "";
        private static String password = "";
    
        // 私有的构造函数，是该类在其他类中不能new出来
        private JdbcUtils() {
        }
    
        // 静态代码块，类加载的时候被加载
        static {
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            }
        }
    
        // 获得链接
        public static Connection getConnection() {
            Connection conn = null;
    
            try {
                // 防止中文乱码          
                Properties prop=new Properties();
                prop.put("charSet", "gbk");
                conn = DriverManager.getConnection(url, prop);
            } catch (SQLException e) {
                e.printStackTrace();
            }
    
            return conn;
        }
    
        // 释放资源
        public static void free(Connection conn, PreparedStatement ps, ResultSet rs) {
            try {
                if (rs != null) {
                    rs.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                try {
                    if (ps != null) {
                        ps.close();
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                } finally {
                    try {
                        if (conn != null) {
                            conn.close();
                        }
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
            }
        }
    }