代码:如下:
public class DBConnection {
private static String DBurl ="jdbc:mysql://localhost:3306/mMysqlDB?user=root&password=root&useUnicode=true&characterEncoding=utf-8" ;
//myDB为数据库名
private static Connection Connect = null;
/**
* 获取数据库连接
* @author lcg
* @date 2014年9月24日11:48:49
* @return java.sql.Connection;
*/
public static Connection getConnection(){
// com.mysql.jdbc.Driver
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (InstantiationException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (IllegalAccessException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
Connect = DriverManager.getConnection(DBu