JDBC连接oracle数据库

引入ojdbc14.jar(或ojdbc.jar，视数据库版本定，这里是oracle11g)包

代码如下

import java.sql.DriverManager;import java.sql.Connection;import java.sql.Statement;import java.sql.ResultSet;import java.sql.SQLException;public class LinkData {public static void main(String args[]){try{Class.forName("oracle.jdbc.driver.OracleDriver");String url="jdbc:oracle:thin:@192.168.1.121:1521:test";Connection conn= DriverManager.getConnection(url,"test","test");Statement stmt= conn.createStatement();ResultSet rs =stmt.executeQuery("select * from userinfo");while(rs.next()){System.out.println("name:"+rs.getString(2));}rs.close();stmt.close();conn.close();}catch(ClassNotFoundException e){e.printStackTrace();System.out.println("Its a Jdbc Connection!");}catch (SQLException e){e.printStackTrace();}}}