package com.bjsxt;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcTest {
public void insertDepartment(String department_name, int location_id,float salary ){
Connection con=null;
Statement str=null;
try {
// con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test_2?useUnicode=true&characterEncoding=utf-8","root","root");
con=jdbcUtil.getConnection();
String sql="insert into department values(default,'"+department_name+"',"+location_id+","+salary+")";
str=con.createStatement();
int flag=str.executeUpdate(sql);
System.out.println(flag);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
jdbcUtil.closeResource(str, con);
}
}
public static void updateDepartments(String department_name,int location_id,int department_id){
Connection con=null;
Statement str=null;
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test_2?useUnicode=true&characterEncoding=utf-8","root","root");
str=con.createStatement();
String sql="UPDATE department d SET d.department_name='"+department_name+"',d.location_id="+location_id+" WHERE department_id="+department_id+"";
int flag=str.executeUpdate(sql);
System.out.println(flag);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
if(str!=null){
try {
str.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(con!=null){
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public static void main(String[] args) {
JdbcTest st=new JdbcTest();
//st.insertDepartment("研发部",8,4500);
//updateDepartments("教学楼",31,2);
st.insertDepartment("学习部",9,4500);
}
}
package com.bjsxt;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;
import javax.sql.DataSource;
public class jdbcUtil {
/*private static String driver="com.mysql.jdbc.Driver";
private static String url="jdbc:mysql://localhost/3306/test_2?useUnicode=true&characterEncoding=utf-8";
private static String username="root";
private static String password="root";*/
private static String driver;
private static String url;
private static String username;
private static String password;
private static DataSource ds;
static {
ResourceBundle bundle=ResourceBundle.getBundle("jdbc.properties");
driver=bundle.getString("driver");
url=bundle.getString("url");
username=bundle.getString("username");
password=bundle.getString("password");
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection con=null;;
try {
con = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
//关闭 statement;
public static void closeStatement(Statement state){
if(state!=null){
try {
state.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
//关闭Connection
public static void closeConenection(Connection con){
if(con!=null){
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void closeResource(Statement str,Connection con){
closeStatement(str);
closeConenection(con);
}
}
程序异常如下：
Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class com.bjsxt.jdbcUtil
at com.bjsxt.JdbcTest.insertDepartment(JdbcTest.java:25)
at com.bjsxt.JdbcTest.main(JdbcTest.java:86)
请问 老师 如何解决 ？
（.top_a）
京公网安备 11011402011233号