Jsp同时连接mysql和oracle_java连接oracle数据库 -- 直接用jsp访问连接

1. 创建jsp文件

2. import加入sql包

3. 编写主要的jsp文件

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

My JSP 'index.jsp' starting page

oracle的分页案例

用户名

薪水

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

Connection cc = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:MyOra1","scott","tiger");

Statement sm = cc.createStatement();

//接受分页信息

String s_pageNow = (String)request.getParameter("pageNow");

int pageNow =1;

if(s_pageNow!=null){

pageNow = Integer.parseInt(s_pageNow);

}

//显示页数

int pageCount=0;

int rowCount=0;

int countSize=4;

ResultSet rs = sm.executeQuery("select count(*) from emp");

if(rs.next()){

rowCount = rs.getInt(1);

if(rowCount%countSize==0){

pageCount = rowCount/countSize;

}else{

pageCount = rowCount/countSize + 1 ;

}

}

rs = sm.executeQuery("select * from (select a1.*,rownum rn from (select * from emp) a1 where rownum<="+pageNow*countSize+") where rn>="+((pageNow-1)*countSize+1)+"");

while(rs.next()){

out.print("

");

out.println("

" + rs.getString(2)+"");

out.println("

" + rs.getString(6)+"");

out.print("

");

}

for(int i=1;i<=pageCount;i++){

out.print("["+i+"]");

}

//打印总页数

rs.close();

sm.close();

cc.close();

%>