Jdbc连接mysql数据库

db.properties的配置文件

public class JdbcUtil {

static String driver;
static String url;
static String user;

static String pwd;

   //静态方法

static {

try {
// 通过类加载器来加载db.properties
InputStream inputStream = JdbcUtil.class.getClassLoader()
            .getResourceAsStream("db.properties");
// 创建一个properties的实例
Properties properties = new Properties();
// 加载配置文件

properties.load(inputStream);

driver = properties.getProperty("jdbc.driver");
url = properties.getProperty("jdbc.url");
user = properties.getProperty("jdbc.username");
pwd = properties.getProperty("jdbc.password");
Class.forName(driver);// 加载驱动类


} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


}


/*
* 创建mysql数据库的连接
*/
public static Connection openConnection() throws SQLException {
return DriverManager.getConnection(url, user, pwd);


}

//关闭连接

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

      
public static void close(PreparedStatement stmt) {
if (null != stmt) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}


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