area_3.jsp

来自「bbs设计是一个论坛方面的设计 基于jsp的系统设计」· JSP 代码 · 共 26 行

<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="work" scope="page" class="dbcon.mydb" />
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />

<%
ResultSet sqlRst=work.executeQuery("SELECT * FROM AREA ORDER BY INT_AREASIDE,INT_ARTICLENUMB DESC" );

int a_id,a_side;
String a_name,a_master;
String strAll="";
while(sqlRst.next())
{ 
a_id=sqlRst.getInt("INT_AREAID");
a_side=sqlRst.getInt("INT_AREASIDE");
a_name=sqlRst.getString("STR_AREANAME");  
a_master=sqlRst.getString("STR_AREAMASTER");
strAll=strAll+"x("+ a_id +","+ a_side +",'"+ a_name +"','"+ a_master +"');\n";

}
out.print(strAll);

sqlRst.close();

%>