他自己练可以但是我用下面的语句练就不行
java.sql.Connection conn = java.sql.DriverManager.getConnection(
"jdbc:oracle:thin:@10.168.0.199:1521:orcl", "hhuser", "hhsoft");谢谢
java.sql.Connection conn = java.sql.DriverManager.getConnection(
"jdbc:oracle:thin:@10.168.0.199:1521:orcl", "hhuser", "hhsoft");谢谢
import oracle.jdbc.*;
import oracle.jdbc.driver.*;public class select{
public static void main(String args[]) throws Exception{
Connection conn=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@10.168.0.199:1521:orcl", "hhuser", "hhsoft");
.....
这样试试
import oracle.jdbc.*;
import oracle.jdbc.driver.*;public class select{
public static void main(String args[]) throws Exception{
Connection conn=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:ora11", "scott", "oracle"); 这里的连接字符串换成你自己的试试看,我的已经调试通过了 Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select empno,ename,job,hiredate,sal from emp");
System.out.println("empno ename job hiredate sal");
System.out.println("----- ----- --- ----------- ---");
while(rs.next()){
System.out.println(rs.getInt("empno")+" "+rs.getString("ename")+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5));
}
rs.close();
stmt.close();
}catch(SQLException sqle){
sqle.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}finally{
conn.close();
}
}
}C:\Documents and Settings\Administrator\java>javac select.javaC:\Documents and Settings\Administrator\java>java select
empno ename job hiredate sal
----- ----- --- ----------- ---
7369 SMITH CLERK 1980-12-17 00:00:00.0 800
7499 ALLEN SALESMAN 1981-02-20 00:00:00.0 1600
7521 WARD SALESMAN 1981-02-22 00:00:00.0 1250
7566 JONES MANAGER 1981-04-02 00:00:00.0 2975
7654 MARTIN SALESMAN 1981-09-28 00:00:00.0 1250
7698 BLAKE MANAGER 1981-05-01 00:00:00.0 2850
7782 CLARK MANAGER 1981-06-09 00:00:00.0 2450
7788 SCOTT ANALYST 1987-04-19 00:00:00.0 3000
7839 KING PRESIDENT 1981-11-17 00:00:00.0 5000
7844 TURNER SALESMAN 1981-09-08 00:00:00.0 1500
7876 ADAMS CLERK 1987-05-23 00:00:00.0 1100
7900 JAMES CLERK 1981-12-03 00:00:00.0 950
7902 FORD ANALYST 1981-12-03 00:00:00.0 3000
7934 MILLER CLERK 1982-01-23 00:00:00.0 1300C:\Documents and Settings\Administrator\java>
可是我换成Class.forName("oracle.jdbc.driver.OracleDriver"); 还是不行。
换成conn=DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:ora11", "scott", "oracle");是可以的。
但是现在同事想连我的oracle,怎么改都不行,不知道是什么原因
conn=DriverManager.getConnection( "jdbc:oracle:thin:@10.168.0.199:1521:ora11", "scott", "oracle");
如果不是IP的问题,检查一下你的listener.ora里面的HOST=后面是IP还是localhost。
hhuser用户的权限不够?
你在同事哪里用客户端用hhuser用户进去试下。