Java链接Oracle

---

首先在安装oracle的途径找到ojdbc6这个jar包。

---

---

 将它复制到项目的lib目录下（lib自己建）

---

下面是完整的代码

---

  public static void main(String[]args) throws Exception {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        String url="jdbc:oracle:thin:@localhost:1521:orcl";
        String uname ="scott";
        String pwd = "123";
        Connection con = DriverManager.getConnection(url,uname,pwd);
        System.out.println(con.getClass().getName());
        
        Statement stmt = con.createStatement();
        String sql = "select t.*  from TYPE t";
        ResultSet rs = stmt.executeQuery(sql);
        while(rs.next()) {
            System.out.println("姓名:"+rs.getObject("job")+","+"薪资:"+rs.getObject("ename"));
        }
        con.close();
        stmt.close();
        rs.close();
        
    }

对应的oracle如下

---

---

控制台输出

---

---

希望能帮到各位小伙伴