JDBC_oracle

 

 

 1 package com.cn.test20;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.ResultSet;
 6 import java.sql.SQLException;
 7 import java.sql.Statement;
 8 
 9 public class TestJdbc {
10 
11     /**
12      * @param args
13      */
14     
15     public static void main(String[] args) {
16         String user="system";
17         String password="123456";
18         String host="localhost";
19         String port="1521";
20         String SID="XE";
21         
22         String url="jdbc:oracle:thin:@"+host+":"+port+":"+SID;//url 3
23         try 
24         {
25         
26             //Loading DriverManager
27             Class.forName("oracle.jdbc.OracleDriver"); //Type-4 for Oracle
28             
29             //Establishing Connection
30             //Connection con=DriverManager.getConnection(url);//url 1 & 2
31             Connection con=DriverManager.getConnection(url,user,password);//url 3
32             
33             //Creating Statement
34             Statement stmt=con.createStatement();
35             
36             //Creating Query
37             String Query="Select * from  SampleTable";
38             
39             //Executing Query
40             ResultSet rs=stmt.executeQuery(Query);
41             
42             //traversing ResultSet
43             System.out.println("EmpID   EmpName   Department   EmpSalary");
44             while(rs.next()){
45                 System.out.println(rs.getInt("EmpID")+"\t"+rs.getString("EmpName")+"\t"+rs.getString("Department")+"\t"+rs.getInt("EmpSalary"));
46             }
47             
48         } catch(ClassNotFoundException cnfe) {
49             cnfe.printStackTrace();
50         } catch (SQLException e) {
51             e.printStackTrace();
52         }
53     }
54 }

 

怎样将oracle的驱动jar包导入到eclipse?

右键单击“Test_Java_Project”项目，找到Build Path -- Add External Archives...，并将其左键打开

在新弹出的窗口中，前往oracle安装目录，找到如下路径(小编的安装路径)：D:\Oracle\app\oracle\product\11.2.0\server\jdbc\lib\

找到ojdbc6.jar这以jar文件，并选中，然后单击“打开”。

posted on 2014-08-20 16:11  @冰糖  阅读(131)  评论(0)  编辑  收藏  举报

导航