Java语言链接Oracle数据库

 1 package com.tao.pojo;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.PreparedStatement;
 6 import java.sql.ResultSet;
 7 import java.sql.SQLException;
 8 
 9 public class TestOracle001 {
10     public static void main(String[] args) throws ClassNotFoundException, SQLException {
11         Class.forName("oracle.jdbc.OracleDriver");
12 //        10.96.113.212 是数据库所在的主机的IP地址 users也是该主机的表名(连谁的数据库就用谁数据库里面的表)
13         Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//10.96.113.212:1521/orcl", "scott", "tiger");
14         PreparedStatement ps = conn.prepareStatement("select * from users");
15         ResultSet rs = ps.executeQuery();
16         while(rs.next()) {
17             int id= rs.getInt(1);
18             String name = rs.getString(2);
19             System.out.println(id+","+name);
20         }
21         rs.close();
22         ps.close();
23         conn.close();
24     }
25 
26 }
Java语言 链接Oracle数据库

Java语言链接Oracle数据库
