在这里插入代码片@TOC
package 工具类;
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
/*
* JDBC的工具类
* */
public class JdbcUtils {
private static final String driverclass;
private static final String url;
private static final String username;
private static final String password;
static {
//加载属性文件
Properties pro=new Properties();
InputStream inputStream = JdbcUtils.class.getResourceAsStream("/db.properties");
try {
pro.load(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
//给常量赋值
driverclass=pro.getProperty("driverclass");
url=pro.getProperty("url");
username=pro.getProperty("username");
password=pro.getProperty("");
}
/*
* 加载驱动
* */
public static void loadDriver(){
try {
Class.forName(driverclass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
/*
* 加载完驱动,获取到连接,返回连接对象
* */
public static Connection getConnection(){
//加载驱动
loadDriver();
//获取到连接对象,返回
Connection conn=null;
try {
//获取到连接
conn= DriverManager.getConnection(url,username,password);
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
//关闭资源
public static void close(Connection conn, Statement sata, ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(sata!=null){
try {
sata.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void close(Connection conn, Statement sata){
if(sata!=null){
try {
sata.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
帮忙看看写的jdbc工具类到底是啥问题一直报错