import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class DBManager{

String url = "jdbc:mysql://localhost:3306/testDatabase";

String user = "root";

String password = "1123";

public DBManager() {} public Connection getConnection() throws SQLException, Exception { Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException cnfe) {
cnfe.printStackTrace();
} catch (InstantiationException ie) {
ie.printStackTrace();
} catch (IllegalAccessException iae) {
iae.printStackTrace();
} catch (SQLException sqle) {
sqle.printStackTrace();
} catch (Exception e){
e.printStackTrace();
return conn;
}
return conn;
} private void executeSQL(String sql, Connection conn, Statement stmt, ResultSet rs) throws SQLException { try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
System.out.println(rs.getInt(3));
System.out.println(rs.getString(4));
System.out.println(rs.getString(5));
System.out.println(rs.getInt(6));
System.out.println(rs.getString(7));
}
} catch (SQLException sqle) {
sqle.printStackTrace();
}
}

public void closeAll(ResultSet rs, Statement stmt, Connection conn){

try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
}catch (SQLException e) {
e.printStackTrace();
}
}

public static void main(String[] args) throws SQLException, Exception {

Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql = "Select * from info;";
DBManager dbManager = new DBManager();

conn = dbManager.getConnection();
dbManager.executeSQL(sql, conn, stmt, rs);
dbManager.closeAll(rs, stmt, conn);

}
}
运行后:前面很长很长一串,贴不出来,贴后面的部分:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'testdatabase'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:562)
at java.sql.DriverManager.getConnection(DriverManager.java:186)
at DBManager.getConnection(DBManager.java:23)
at DBManager.main(DBManager.java:83)
Exception in thread "main" java.lang.NullPointerException
at DBManager.executeSQL(DBManager.java:42)
at DBManager.main(DBManager.java:84)