java连接oracle数据库 -- jdbc连接
a. 倒入oracle的jar包
b. 编写java文件
package com.sp; import java.sql.*; //使用jdbc连接oracle public class MyOra2 { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection cc = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:MyOra1","scott","tiger"); Statement sm = cc.createStatement(); ResultSet rs = sm.executeQuery("select * from emp"); while (rs.next()) { //打印用户名 System.out.println("用户名 :" + rs.getString(2)); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
oracle的jar包下载地址:classes12.jar