老师这个错误是什么呀
Exception in thread "main" java.lang.NullPointerException
package com.imooc.jdbc.sample;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.imooc.jdbc.common.DbUtils;
import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.UnsupportedEncodingException;
import java.net.URLDecoder;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Date;
import java.util.Properties;
/*
* Druid连接池配置与使用
*
* */
public class DruidSample {
public static void main(String[] args) {
// 1.加载属性文件
Properties properties = new Properties();//利用这个对象来保存我们的配置信息
String propertyFile = DruidSample.class.getResource("druid-config.properties").getPath();
try {
propertyFile = new URLDecoder().decode(propertyFile, "UTF-8");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
//编译的时候会将空格转换为%20
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
properties.load(new FileInputStream(propertyFile));
// 2.获取DataSource数据源对象
DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
// 3.创建数据库的连接
conn = dataSource.getConnection();
pstmt = conn.prepareStatement("select * from goods limit 0,10");
rs = pstmt.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
String ename = rs.getString("ename");
float price = rs.getFloat("price");
String desp = rs.getString("desp");
Date sj = rs.getDate("hiredate");
System.out.println(id + "-" + ename + "-" + price + "-" + desp + "-" + sj);
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DbUtils.closeConnection(conn, pstmt, rs);
}
}
}
18
收起
正在回答 回答被采纳积分+1
2回答
java工程师2020版
- 参与学习 人
- 提交作业 9410 份
- 解答问题 16556 个
综合就业常年第一,编程排行常年霸榜,无需脱产即可学习,北上广深月薪过万 无论你是未就业的学生还是想转行的在职人员,不需要基础,只要你有梦想,想高薪
了解课程

恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星