<%@ page  contentType="text/html; charset=gb2312" language="java" %>
<%@   page   import= "java.sql.* "   %> 
<html> 
<head> <title> JDBC建立数据库连接 </title> 
</head> 
<body> <center> 
<font   size   =   5   color   =   blue>   在线测试 </font> <hr>   
<% 
    //加载驱动程序 
   Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
   String url="jdbc:oracle:thin:@192.168.12.222:1521:rlzy";
String user="rlzy";
String password="ffffff";
Connection conn1= DriverManager.getConnection(url,user,password);
Statement stmt1=conn1.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql1="select * from rs_dept where dept_id=12  ";
Statement stmt2=conn1.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
int i =0;
try{ ResultSet rs1=stmt1.executeQuery(sql1);
   
%> 
<table   border=3> 
    
<% 
        //利用while循环将数据表中的记录列出 
    while   (rs1.next()){ 
%> 
    <tr> 
          <td> id: <font   size=1> <%=   rs1.getString(1)   %> </font> </td> 
          <td> <font   size=1> <%=   rs1.getString(2)   %> </font> </td> 
          
<%
String sql2 = "select * from rs_section_office  where upper_dept_id = "+rs1.getString(1);
    ResultSet rs2=stmt2.executeQuery(sql2);
while (rs2.next()){
%>
  <td> <input   type=radio   name= <%=   rs1.getString(1)   %>   value= <%=   rs2.getString(1)   %>    > 
  <font   size=1>  </font> </td>  
<%
}
while(10-i>0){
%>
<td>   <font   size=1>  </font> </td>  
<% 
 i=i-1;
}
rs2.close();
%>    </tr> </font> 
<%
    } 

    rs1.close();   //关闭ResultSet对象 
    } 
    catch(Exception   e){ 
    out.println(e.getMessage()); 
    } 
    stmt1.close();   //关闭Statement对象 
stmt2.close();   //关闭Statement对象 
    conn1.close();     //关闭Connection对象 
%> 
</table> </center> 
</body> </html>