java 连接oracle 实例,Java连接Oracle实例代码

import java.sql.*;

try

{

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

Connection con=DriverManager.getConnection("Jdbc:Oracle:thin:@219.146.78.66:1521:oucsei","oucsei","oucsei");

Statement st=con.createStatement();

String sql="select * from student";

ResultSetrs=st.executeQuery(sql);

String name="",age="",rollno="";

while(rs.next())

{

name=rs.getString("name");

age=rs.getString("age");

rollno=rs.getString("rollno");

System.out.println("name:"+name+",age:"+age+",rollno:"+rollno);

}

rs.close();

st.close();

con.close();

}

catch(Exception e)

{

System.out.println(e.toString());

}

需要用到：

(1)ojdbc5_g.jar

(2)ojdbc5.jar

(3)ojdbc6_g.jar

(4)ojdbc6.jar