oracle怎么做jsp,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)) ; 字串7

}

}catch(Exception e){

e.printStackTrace() ;

}finally{

rs.close();

stmt.close();

con.close();

}

}

}

另一例：

String url="jdbc:oracle:thin:@localhost:1521:orcl";

//orcl为你的数据库的SID

String user="scott";

String password="tiger";

Connection conn= DriverManager.getConnection(url,user,password);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * fro