JDBUtil的封装
异常
java.lang.NoClassDefFoundError: Could not initialize class com.baizhi.util.JDBCUtil
at com.baizhi.dao.UserDAOImpl.query(UserDAOImpl.java:70)
at com.baizhi.service.UserServiceImpl.login(UserServiceImpl.java:18)
at com.baizhi.test.UserTest.TestLogin(UserTest.java:21)
解决
// 相对路径 src下的路径 最前面的 / 忘写了
InputStream is = JDBCUtil.class.getResourceAsStream("/com/baizhi/util/jdbc.properties");
异常
java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:190)
at com.baizhi.util.JDBCUtil.getConnection(JDBCUtil.java:51)
解决
// 通过Properties集合获得值
Class.forName(p.getProperty(p.getProperty(“driver”)));
多写了一层p.getProperty()
异常
java.sql.SQLException: 调用中无效的参数
at com.baizhi.util.JDBCUtil.getConnection(JDBCUtil.java:53)
at com.baizhi.dao.UserDAOImpl.query(UserDAOImpl.java:50)
at com.baizhi.service.UserServiceImpl.login(UserServiceImpl.java:18)
at com.baizhi.test.UserTest.TestLogin(UserTest.java:21)
解决
conn = DriverManager.getConnection(p.getProperty(“url”), p.getProperty(“user”), p.getProperty(“password”));
是username 不是user
异常
java.sql.SQLException: ORA-00933: SQL 命令未正确结束
at com.baizhi.dao.UserDAOImpl.query(UserDAOImpl.java:55)
at com.baizhi.service.UserServiceImpl.login(UserServiceImpl.java:18)
at com.baizhi.test.UserTest.TestLogin(UserTest.java:21)
解决
String sql = “select * from users where u_username = ?andu_password = ?”;
and 后面和u_password连着了
要空开