package com.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBUitl {
private static final String URL="jdbc:oracle:thin:@localhost:1521:ORCL";
private static final String USER="system";//must log on as system, otherwise program can't output correct query result
private static final String PASSWORD="1234";
public static void main(String[] args) throws ClassNotFoundException, SQLException{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);
System.out.println(conn);
Statement st = conn.createStatement();
String sql="select * from USERTEST";
ResultSet rs=st.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getInt("id")+","+rs.getString("username")+","+rs.getInt("age"));
}
}
}
你新建的oracle数据库用户有没有赋相应的查询 修改表的权限啊 ,不赋权限新用户是什么也干不了的
user和password都是改过的,我上面列出的是运行正确的代码,错误的我就没贴了,只是变下登陆名和密码。后面加.newInstance()也不行,报ClassNotFoundException异常,没辙了5555
新建了DBA用户,USER和PASSWORD都要对应的改动
或者在Class.forName("oracle.jdbc.driver.OracleDriver")后面加个.newInstance();试试看