我确实很小白,接触JAVA7天
JAVA环境变量我配置好了,后来配置JDBC,我的数据库是oracle10gXE 10.2.0.1.0 JDK是1.7.0_03
工具是eclipse3.7.2 代码是
public class ConnectionDemo01
{
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
public static void main(String[] args)
{
try
{
Class.forName(DBDRIVER);
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}
}
}
提示的错误是
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at ConnectionDemo01.main(ConnectionDemo01.java:12)
希望可以告诉我JAVA和JDBC的环境变量配置的详细步骤和注意事项
3Q
------解决方案--------------------
你没有将oracle的驱动导入的原因
------解决方案--------------------
------解决方案--------------------
嗯,试试吧,好像没导入驱动
------解决方案--------------------
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
没有找到oracle的驱动jar,LZ可以在网上下一个,名字好像是ojdbc14.jar
我简单地说一下配置步骤:
1.注册驱动,2.建立连接,3.创建语句,4.执行语句,5.对结果进行处理,6.关闭连接
- Java code
Connection conn = null; Statement ps = null; ResultSet rs = null; try{ Class.forName("oracle.jdbc.driver.OracleDriver");//注册驱动 //建立连接 conn = DriverManager.getConnection("jdbc:oracle:thin:@10.148.73.67:1521:databaseName"); //创建语句 String sql = "select * from user"; ps = conn.createStatement(); //执行语句 rs = ps.executeQuery(sql); //处理结果 while(rs.next()) { System.out.println("userName:" + rs.getString("user_name")); } }catch(Exception e) { e.printStackTrace(); }finally { //以下为释放连接 try { if (rs != null) try { rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } finally { try { if (ps != null) try { ps.close(); } catch (SQLException e) { e.printStackTrace(); } } finally { if (conn != null) try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }
------解决方案--------------------
楼主肯定没在项目中导入数据库驱动的JAR包!!!
------解决方案--------------------
没有导入驱动包
------解决方案--------------------