如何修改jdbc用thin方式连接Oracle数据库时运行产生的错误
package com.jdbc.oracleTest;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class OracleJdbcConnectionTest {
public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url ="jdbc:oracle:thin:@10.80.10.180:1521:zjhc";
try {
Connection conn = DriverManager.getConnection(url,"train","train");
Statement st = conn.createStatement();
String sqlStr= "select * from BIZ_USER_SYSUSER";
ResultSet rs = st.executeQuery(sqlStr);
while (rs.next()) {
System.out.println(rs.getString(1));
}
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}
运行结果为
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.jdbc.oracleTest.OracleJdbcConnectionTest.main(OracleJdbcConnectionTest.java:11)
还请各位高手帮忙指点一下，最好能详细点，不胜感激
最新回答
灼灼
2024-11-04 15:03:47
这个类。。应该是你的驱动包没有导进去。。如果需要的话。。我传给你哈。。
安陵忻美
2024-11-04 14:39:17
冬瑾凉桉
2024-11-04 13:03:11
紫萌雨
2024-11-04 09:40:47
热门标签
