这样写不对吗？为什么总取不出数据来呢？＜％这个符号和{}之间怎么搭救用啊？我一用就乱，有什么规律可循吗？

wwwdw 2003-12-05 02:36:09

//怎么样才能从库里提出所有数据，整齐地放在表格中，我动态的更改数据，这个表格也随着增大减小？

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java"%>
<%@ page import ="java.util.*,java.sql.*"%>

<html>
<title>京政网</title>
<head>
</head>
<body>
<form name="blzt" method="post" action="">
<table border="1" width="100%">
<div align="center"><font size="5">文件来源维护</font></div>
<tr> </tr>
<tr>
<td width="9%" height="12"> <div align="center"><font size="2">
<input type="checkbox" name="all" onClick="selectall()" value="0"><div align="reght">选择</div></font></div></td>

<td width="13%"><font size="2"><div align="center">办理状态标识</div></font></td>
<td width="19%"><font size="2"><div align="center">办理状态</div></font></td>
<td width="20%"><font size="2"><div align="center">排序号</div></font></td>
<td width="22%"><font size="2"><div align="center">描述信息</div></font></td>
<td width="22%"><font size="2"><div align="center">有效性标识</div></font></td>
</tr>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.1.4.10:1521:bgtgw";
//orcl为你的数据库的SID
String user="szfbgt";
String password="1";

Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
//String sql_query="select * from dic_blztb";
//String sql_add="insert into dic_blztb(blzt_id,blzt,pxh,msxx,yxxbs)values('10','办理中','10','10','1')";
//String sql_update="update dic_blztb set blzt_id='9999' where blzt_id='2'";
// String sql_delete="delete dic_blztb where blzt_id=6";
//ResultSet rs=stmt.executeQuery(sql_query);
// stmt.executeQuery(sql_delete);
//stmt.executeQuery(sql_update);
//stmt.executeUpdate(sql_add);
//out.println("添加成功！<br><br>");

//out.println("更新成功！<br><br>");
// out.println("删除成功！<br><br>");

String sql_query="select * from dic_blztb";
ResultSet rs=stmt.executeQuery(sql_query);
/* while(rs.next()){
//int blzt_id=rs.getInt("blzt_id");
//String blzt=rs.getString("blzt");
//String pxh=rs.getString("pxh");
//String msxx=rs.getString("msxx");
//String yxxbs=rs.getString("yxxbs");
// out.println("插入成功");
out.println(rs.getString("blzt"));
out.println("<br>");
out.println(rs.getString("blzt_id"));
}*/while(rs.next()){
String blzt_id=rs.getString("blzt_id");
String blzt=rs.getString("blzt");
String pxh=rs.getString("pxh");
String msxx=rs.getString("msxx");
String yxxbs=rs.getString("yxxbs");

}

%>
<td height="20"> <div align="center"> <font size="2">

</font></div></td>
<td width="13%"><font size="2"><div align="center"><%=blzt_id%></div></font></td>
<td width="19%"><font size="2"><div align="center"><%=blzt%></div></font></td>
<td width="20%"><font size="2"><div align="center"><%=pxh%></div></font></td>
<td width="22%"><font size="2"><div align="center"><%=msxx%></div></font></td>
<td width="22%"><font size="2"><div align="center"><%=yxxbs%></div></font></td>
</tr>
</table>
<table width="70%" align="center" border="1"><div align="center">
<input type="button" name="add" value="增加" onclick="fun_add()">
<input type="button" name="modify" value="修改" onclick="fun_modify()">
<input type="button" name="del" value="删除" onclick="fun_del()"></div>

</table>

</form>

</body>
</html>

...全文