public class dbcpDateSuource {
private static final String ConnectionURL="jdbc:mysql://localhost:3306/wbe1?useUnicode=true&characterEncoding=UTF8&serverTimezone=UTC&useSSL=false";
private static final String userName="root";
private static final String password="liupeng.123";
private static BasicDataSource ds;
static {
BasicDataSource ds=new BasicDataSource();
ds.setDriverClassName("com.mysql.cj.jdbc.Driver");
ds.setUrl(ConnectionURL);
ds.setUsername(userName);
ds.setPassword(password);
ds.setInitialSize(5);
ds.setMaxTotal(20);
ds.setMinIdle(3);
}
public static Connection getConnection() {
try {
return ds.getConnection();
}
catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public static void close(ResultSet rs,Statement stmt,Connection con) {
closeResultSet(rs);
closeStatement(stmt);
closeConnection(con);;
}
public static void close(Statement stmt1,Statement stmt2,Connection con) {
closeStatement(stmt1);
closeStatement(stmt2);
closeConnection(con);;
}
private static void closeResultSet(ResultSet rs) {
try {
if(rs!=null)
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private static void closeStatement(Statement stmt) {
try {
if(stmt!=null)
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private static void closeConnection(Connection con) {
try {
if(con!=null)con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
Exception in thread "main" java.lang.NullPointerException
at com.xuexi.jdbc01.dbcpDateSuource.getConnection(dbcpDateSuource.java:39)
at com.xuexi.jdbc01.JDBCDemo01.transferAccounts(JDBCDemo01.java:317)
at com.xuexi.jdbc01.JDBCDemo01.main(JDBCDemo01.java:31)