DBConn.class的代码如下:
import java.sql.Connection;
import java.sql.DriverManager;
public class DBConn {
Connection dbConn;
String dbUrl = "jdbc:mysql://localhost:3306/gbook";
String dbUser = "root";
String dbPwd = "1225312";
String err;
public DBConn() {
err = "";
dbConn = null;
}
// 连接数据库,返回一个 Connection类型对象
public Connection getConn() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
dbConn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
} catch (Exception ex) {
dbConn = null;
err = ex.toString();
System.out.println(err);
}
return dbConn;
}
// 获得错误信息
public String getErr() {
return err;
}
}