?? area_3.jsp
字號:
<%@ 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();
%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -