在用eclipse鏈接資料庫時，出現例外，mysql服務開了，包也匯入了，就是一運行報錯！
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class ss {
private static final String URL = "jdbc:mysql://localhost:3306/test";
private static final String USERNAME = "root";
private static final String PWD = "root";
public static void update() {// 增刪改
Connection connection = null;
Statement stmt = null;
try {
// a.匯入驅動，加載具體的驅動類
Class.forName("com.mysql.jdbc.Driver");// 加載具體的驅動類
// b.與資料庫建立連接
connection = DriverManager.getConnection(URL, USERNAME, PWD);
// c.發送sql，執行(增刪改、查)
stmt = connection.createStatement();
// String sql = "insert into student values(1,'zs',23,'s1')";
// String sql = "update student set STUNAME='ls' where stuno=1";
String sql = "delete from student where stuno=1";
// 執行SQL
int count = stmt.executeUpdate(sql); // 回傳值表示 增刪改 幾條資料
// d.處理結果
if (count > 0) {
System.out.println("操作成功！");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} catch(Exception e) {
e.printStackTrace();
}
finally {
try {
if(stmt!=null) stmt.close();// 物件.方法
if(connection!=null)connection.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
update() ;
}
}
下面時eclipse下的報錯資訊：
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/juli/logging/LogFactory
at org.apache.catalina.util.LifecycleBase.<clinit>(LifecycleBase.java:39)
Caused by: java.lang.ClassNotFoundException: org.apache.juli.logging.LogFactory
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 1 more
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/159554.html
標籤：Eclipse