文件:database.properties
代码:
#shu ju ku qu dong
db.driver=org.gjt.mm.mysql.Driver
#shu ju ku di zhi
db.url=jdbc:mysql://localhost:3306/tang?useUnicode=true&characterEncoding=gb2312
#shu ju ku yong hu ming
db.user=root
#shu ju ku mi ma
db.pass=admin
文件:DataBaseConnection
代码 :
package org.tang.dbc;
import java.sql.*;
import java.util.*;
public class DataBaseConnection
{
public static Connetion conn = null ;
//数据库连接
static {
try
{
ResourceBundle rb = ResourceBundle.getBundle("database");
//加载驱动程序
Class.forName(rb.getString("db.driver"));
//取得数据库连接
conn = DriverManager.getConnection(rb.getString("db.url"),rb.getString("db.user"),rb.getString("db.pass"))
}
catch (Exception e)
{
System.out.println("数据库连接失败");
}
}
//获取连接
public static Connection getConnection()
{
return this.conn ;
}
//关闭连接
public static void close()
{
try
{
conn.close() ;
}
catch (Exception e)
{
e.getStackTrace() ;
}
}
}
注:要把database.properties文件放在class的根目录中