这个类使用起来很方便，而且也较安全一些。欢迎大家提意见。
package cn.ijser.utils;
import java.io.File;
import java.sql.*;
import com.mysql.jdbc.Statement;
public class DB {
String dbUrl = "";
String dbPort = "";
String dbName = "";
String dbUser = "";
String dbPass = "";
private static Connection conn = null;
private static String tablePrefix;
public DB() {
try {
/* 获取配置文件 */
File cfgUrl = FilePathUtil.getFileByRelativePath("/config.properties");
Configuration cfg = new Configuration(cfgUrl.toString());
dbUrl = cfg.getValue("DatabaseUrl", "localhost");
dbPort = cfg.getValue("DatabasePort", "3306");
dbName = cfg.getValue("DatabaseName", "kexie51");
dbUser = cfg.getValue("DatabaseUserName", "kexie51");
dbPass = cfg.getValue("DatabasePassword", "kexie51");
DB.tablePrefix = cfg.getValue("TablePrefix", "kx_");
} catch (ConfigurationException e) {
e.printStackTrace();
}
}
public PreparedStatement prepare(String sql) {
PreparedStatement ps = null;
try {
/* 获得Connection */
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://" + dbUrl + ":"
+ dbPort + "/" + dbName, dbUser, dbPass);
ps = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return ps;
}
@Override
protected void finalize() throws Throwable {
System.out.println("db connection closed...");
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
conn = null;
}
super.finalize();
}
public void close(PreparedStatement stmt) {
try {
if (stmt != null) {
stmt.close();
stmt = null;
}
if (conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public void close(ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
}
public String getTablePrefix() {
return tablePrefix;
}
}