JDBC配置文件和工具类

来源:互联网 发布:淘宝如果设置1元换购 编辑:程序博客网 时间:2024/05/16 18:18

db.properties

driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/newsuser=rootpassword=admin

jdbcUtil.java

package cn.itcast.souhu.util;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import java.util.Properties;/** * 工具类 */public class JdbcUtil {    private static String driver;    private static String url;    private static String user;    private static String password;    private JdbcUtil(){}    //加载src/db.properties文件    static{        try {            InputStream is = JdbcUtil.class.getClassLoader().getResourceAsStream("db.properties");            Properties props = new Properties();            props.load(is);            driver = props.getProperty("driver");            url = props.getProperty("url");            user = props.getProperty("user");            password = props.getProperty("password");        } catch (Exception e) {            e.printStackTrace();            throw new RuntimeException(e);        }    }    //通过反射注册数据库驱动    static{        try {            Class.forName(driver);        } catch (Exception e) {            e.printStackTrace();            throw new RuntimeException(e);        }    }    //获取与数据库服务器的连接    public static Connection getConnection(){        try {            return DriverManager.getConnection(url,user,password);        } catch (Exception e) {            e.printStackTrace();            throw new RuntimeException(e);        }    }    //关闭三个数据库连接对象    public static void close(Connection conn){        if(conn!=null){            try {                conn.close();            } catch (Exception e) {                e.printStackTrace();                throw new RuntimeException(e);            }        }    }    public static void close(Statement stmt){        if(stmt!=null){            try {                stmt.close();            } catch (Exception e) {                e.printStackTrace();                throw new RuntimeException(e);            }        }    }    public static void close(ResultSet rs){        if(rs!=null){            try {                rs.close();            } catch (Exception e) {                e.printStackTrace();                throw new RuntimeException(e);            }        }    }}
0 0