Druid数据源获取Connection报空指针

druid java.lang.NullPointerException: null

public class JDBCUtils { static DataSource dataSource; //todo 将加载配置文件 构建链接池对象操作 放到静态代码块内 只会执行一次 static { //使用字节输入流读取配置文件 InputStream is = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties"); Properties properties = new Properties(); try { //将流中的数据 加载内 Properties内 properties.load(is); //根据 properties中的数据 构建连接池对象 dataSource = DruidDataSourceFactory.createDataSource(properties); } catch (Exception e) { throw new RuntimeException(e); } } /** * 通过连接池对象 获取连接 * * @return */ public static Connection getConnection() { try { return dataSource.getConnection(); } catch (Exception e) { throw new RuntimeException(e); } }

public class JdbcMytest { static DataSource dataSource; public static void main(String[] args) throws Exception { //DataSource dataSource = new DruidDataSource(); JdbcMytest demo = new JdbcMytest(); demo.test(); //Class.forName("com.mysql.cj.jdbc.Driver"); //Connection connection = DriverManager.getConnection("jdbc:mysql:///atguigu", "root", "123456"); Connection connection = JdbcMytest.getConnection(); String sql = "select e.did,e.ename,e.gender,e.salary from t_employee e join t_department d on e.did = d.did where salary >8000 group by e.gender "; PreparedStatement preparedStatement = connection.prepareStatement(sql); ResultSet resultSet = preparedStatement.executeQuery(); while (resultSet.next()){ int anInt = resultSet.getInt(1); Object ename = resultSet.getObject("ename"); String gender = resultSet.getString("gender"); int anInt1 = resultSet.getInt(4); System.out.println(anInt+"\t"+ename+"\t"+gender+"\t"+anInt1); } resultSet.close(); preparedStatement.close(); connection.close(); } /*创建连接池，使用连接池去拿连接对象连接数据库，就不用每次创建连接对象避免内存开销*/ public void test(){ InputStream resourceAsStream = JdbcUtils.class.getClassLoader().getResourceAsStream("properties"); Properties properties = new Properties(); try { properties.load(resourceAsStream); } catch (IOException e) { throw new RuntimeException(e); } try { dataSource = DruidDataSourceFactory.createDataSource(properties); } catch (Exception e) { throw new RuntimeException(e); } } public static Connection getConnection() { try { return dataSource.getConnection(); } catch (SQLException e) { throw new RuntimeException(e); } } }