java连接oracle linux,[tips]java连接oracle通过jdbc方法

windows:

1 . dowload JDK1.7

2   解压缩到F:\jdk1.7

3   设置环境变量 PATH=F:\jdk1.7\bin;CLASSPATH=.;F:\jdk1.7\lib\tools.jar;F:\jdk1.7\lib\dt.jar;F:\oracle\product\10.2.0\db_1\jdbc\lib\classes12.jar

划红线的代表用jdbc与oracle连接的jar包

4   测试

java -version  ---看JDK版本

5 HellWorld.java

public class HelloWorld {

public static void main(String args[]) {

System.out.println("Hello World!");

}

}

javac C:\helloWorld.java

java   HelloWorld

6 连接数据库的测试

C:\OraclTest.java

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class OraclTest

{

public static void main(String[] args)

{

try

{

//oracle具体配置

Class.forName("oracle.jdbc.driver.OracleDriver");

//oracle IP地址+端口号/SID

String url = "jdbc:oracle:thin:@192.168.64.200:1521:zhou1";

Connection con = DriverManager.getConnection(url,"scott","oracle");

Statement stat = con.createStatement();

ResultSet rs = stat.executeQuery("select * from test");

while(rs.next())

{

System.out.println(rs.getString(1)+rs.getString(2));

}

rs.close();

stat.close();

con.close();

}

catch (ClassNotFoundException e)

{

e.printStackTrace();

}

catch (SQLException e)

{

e.printStackTrace();

}

}

}

CMD: javac c:\OraclTest.java

java OraclTest