📄 test_fy2.jsp
字号:
<%@page language="java" contentType="text/html;charset=gb2312" %>
<%@page import="com.vstsoft.std.*" %>
<%@page import="java.sql.*" %>
<%@page import="java.lang.*"%>
<%@page import="sun.jdbc.rowset.*"%>
<jsp:useBean id="PageList" class="com.vstsoft.std.PageList" scope = "session" />
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires",0);
vststd vst = new vststd();
String dmm = "",dm = "";
String Sql = "",Sqlwhere = "";
String key ="";
key = vst.getValue(request,"key");
if(key.equals("query")){
dmm = vst.getValue(request,"dmm");
dm = vst.getValue(request,"dm");
Sql = "select dmm,dm,mc from dm_mx where 1=1";
if (!dmm.equals("")){
Sqlwhere = Sqlwhere + " and dmm = '"+dmm+"'";
}
if (!dm.equals("")){
Sqlwhere = Sqlwhere + " and dm = '"+dm+"'";
}
Sql = Sql + Sqlwhere;
System.out.println(Sql);
PageList.setJndi("jc");
PageList.setPagenum(1);
PageList.setListnum(20);
PageList.setLink("test_fy2.jsp");
PageList.setSql(Sql);
}else{
String pagen = vst.getValue(request,"p");
int pagenum = Integer.parseInt(pagen);
PageList.setPagenum(pagenum);
}
CachedRowSet crs = new CachedRowSet();
crs = PageList.getRs();
crs.beforeFirst();
%>
<html>
<head>
<title>欢迎！</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
<div id="submit">
<table align=center border=1 bordercolordark=#ffffff bordercolorlight=#666699
cellpadding=0 cellspacing=0 width=750>
<tbody>
<tr align=middle height=25>
<td bgcolor=#174ca3 align="center" height="40"><font color=white>代码名</font></td>
<td bgcolor=#174ca3 align="center" ><font color=white>代码名称</font></td>
<td bgcolor=#174ca3 align="center" ><font color=white>名称</font></td>
</tr>
<%
while(crs.next()){
%>
<tr align=center bgcolor="#FFFFFF">
<td height=25><font color="#105781"><%=crs.getString(1)%></font></td>
<td><font color="#105781"><%=crs.getString(2)%></font></td>
<td><font color="#105781"><%=crs.getString(3)%></font></td>
</tr>
<%}%>
</tbody>
</table>
<br>
<table align=center border=0 cellpadding=2 cellspacing=0 width=750 bgcolor="#FFF8CC">
<tbody>
<tr>
<td height=10 width=30> </td>
<td height=10 width=670> <%=PageList.getLink()%></td>
</tr>
</tbody>
</table>
<table align=center border=0 cellpadding=2 cellspacing=0 width=750 bgcolor="#FFF8CC">
<tbody>
<tr>
<td height=10 width=30> </td>
<td height=10 width=670> <%=PageList.getLink()%></td>
</tr>
</tbody>
</table>
</div>
<script language="JavaScript">
window.parent.document.all("show").innerHTML=document.all("submit").innerHTML;
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -