<%@ 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>
<%@ 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>
解决方案 »
- jsp传递对象到applet
- 困扰很久的sql异常!java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Inv
- org.apache.jasper.JasperException: Exception in JSP: /author/updateUserInfo.jsp:25
- jsp页面,怎么出现保存文件对话框
- JDBC连接SQL实例问题
- 在jsp中,它是怎么定义application这个内嵌对象的?如果我在一个class里面要使用,该怎么做?
- 我尝试写的一个上传文件的程序老是报myupload.upload();行有错,请帮忙看看,谢谢!
- 高分诚求有关物资管理方面资料,回者有分!在线等待!!!
- TOMCAT 怎样配置?
- jsp如何将音频文件存入到数据库
- 大家说:“在javabean里写逻辑好不好”?
- 怎么从servlet中获取数据
%>
<td> <font size=1> </font> </td>
<%
i=i-1;
}
你的i初始为0,i减1后是负数,所以while循环永远为真,死循环。自己好好检查一下就能发现