老师我这个导包应该没问题吧，但还是无法初始化类，请老师指点
报错信息
源码：
package jdbcDemo2;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestJdbc {
public void InsertDepartments(String department_name , int location_id){
Connection conn=null;
Statement state=null;
ResultSet rs=null;
try{
conn=JdbcUtilPro.getConnection();
String sql="insert into departments values(default,department_name'"+department_name+"',location_id'"+location_id+"')";
state=conn.createStatement();
int flat=state.executeUpdate(sql);
System.out.println(flat);
}catch(SQLException e){
e.printStackTrace();
}finally{
JdbcUtilPro.closeResource(state, conn,null);
}
}
public static void main(String[] args){
TestJdbc test=new TestJdbc();
test.InsertDepartments("aaa", 22);
}
}
jdbc.properties如下
package jdbcDemo2;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;
public class JdbcUtilPro {
//抽取常量串
private static String driver;
private static String url;
private static String username;
private static String password;
static{
ResourceBundle bundle=ResourceBundle.getBundle("jdbc");
driver=bundle.getString(driver);
url=bundle.getString(url);
username=bundle.getString(username);
password=bundle.getString(password);
try {
//注册驱动
Class.forName(driver);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//获取Connection对象
public static Connection getConnection(){
Connection conn=null;
try{
//建立连接
conn=DriverManager.getConnection(url, username, password);
}catch(SQLException e){
e.printStackTrace();
}
return conn;
}
//关闭Statement对象
public static void closeStatement(Statement state){
try{
if(state!=null){
state.close();
}
}catch(SQLException e){
e.printStackTrace();
}
}
//关闭Connection对象
public static void closeConnection(Connection conn){
try{
if(conn!=null){
conn.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
//关闭ResultSet对象
public static void closeResultSet(ResultSet rs){
try{
if(rs!=null){
rs.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
//关闭资源
public static void closeResource(Statement state,Connection conn,ResultSet rs){
closeStatement(state);
closeConnection(conn);
closeResultSet(rs);
}
}
京公网安备 11011402011233号