本次我们项目连接数据库暂时用jdbc
package net.m;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBUtil {
private static final String DRIVER_CLASS = ProUtil.getDriver();
private static final String USERNAME = ProUtil.getUser();
private static final String PASSWORD = ProUtil.getPwd();
private static final String URL = ProUtil.getUrl();
static {
try {
Class.forName(DRIVER_CLASS);
System.out.println("ok");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//建立连接
public static Connection getConnection() throws SQLException{
return DriverManager.getConnection(URL, USERNAME, PASSWORD);
}
/*java.sql
* 1,DriverManager 负责 驱动的管理者 类
* 2,Connection 连接数据库 接口
* 3, Statement 执行SQL语句 接口
* 4, ResultSet 存放结果 接口
*/
public static void closeALL(ResultSet rst, Statement stmt, Connection conn) {
//关闭
if(rst != null) {
try {
rst.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
rst = null;
}
if(stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
stmt = null;
}
}
if(conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn = null;
}
}
}
}
再创建一个类
package net.m;
import java.util.ResourceBundle;
//创建ProUtil目的是解析我们自己定义的属性文件
public class ProUtil {
public static final ResourceBundle rb = ResourceBundle.getBundle("db");
public static String getUser() {
//user是属性文件中的Key
return rb.getString("username");
}
public static String getPwd() {
//通过解析属性文件,获取属性文件中的值
return rb.getString("pwd");
}
public static String getDriver() {
return rb.getString("driver");
}
public static String getUrl() {
//属性文件中的数据是以 键=值(键值对)的形式存放数据的
return rb.getString("url");
}
}