jsp连接oracle实例

 

首先加入oracle的Jdbc，jar文件class12.jar
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class MyConnect {
 public static void main(String args[])throws Exception
 {
  Connection con=null;
  Statement stmt=null;
  ResultSet rs=null;
  try{
   Object obj = Class.forName("oracle.jdbc.driver.OracleDriver");
   obj = ((Class) obj).newInstance();
   con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.33.244:1522:db10gr2","users06","users06");
   stmt=con.createStatement();
   rs=stmt.executeQuery("select * from LEO_TEST");
   System.out.println("连接成功");
   while(rs.next() )
   {
    System.out.println("users: "+rs.getString(1)+"      "+"passWord:"+rs.getString(2)) ;
    
   }
  }catch(Exception e){
   e.printStackTrace() ;
  }finally{
   rs.close();
   stmt.close();
   con.close();
  }
 }

}