📄 signaturelist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.io.*,java.text.*,java.util.*,java.sql.*,DBstep.iDBManager2000.*" %>
<html>
<head>
<title>签章管理</title>
<link rel='stylesheet' type='text/css' href='../test.css'>
<script language="javascript">
function ConfirmDel(FileUrl){
if (confirm('是否确定删除该印签！')){
location.href=FileUrl;
}
}
</script>
</head>
<body bgcolor="#ffffff">
<div align="center"><font size=4 color="ff0000">签章管理</font></div>
<hr size=1>
<br>
<table border=0 cellspacing='0' cellpadding='0' width=100% align=center class=TBStyle>
<tr>
<td colspan=2 class="TDTitleStyle" nowrap>
<input type=button name="Add" value="增加签章" onclick="javascript:location.href='SignatureAddFrm.jsp'">
<input type=button name="Return" value="返 回" onclick="javascript:location.href='../DocumentList.jsp';">
</td>
<td colspan=3 class="TDTitleStyle"> </td>
</tr>
<tr>
<td nowrap align=center class="TDTitleStyle" height="26">编号</td>
<td nowrap align=center class="TDTitleStyle">用户名称</td>
<td nowrap align=center class="TDTitleStyle">签章名称</td>
<td nowrap align=center class="TDTitleStyle">签章类型</td>
<td nowrap align=center class="TDTitleStyle">操作</td>
</tr>
<%
DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();
if (DbaObj.OpenConnection())
{
try
{
ResultSet result=DbaObj.ExecuteQuery("select SignatureID,UserName,MarkName,MarkType from Signature order by SignatureID desc") ;
while ( result.next() )
{
String mSignatureID=result.getString("SignatureID");
%>
<tr>
<td class="TDStyle"><%=result.getString("SignatureID")%> </td>
<td class="TDStyle"><%=result.getString("UserName")%> </td>
<td class="TDStyle"><%=result.getString("MarkName")%> </td>
<td class="TDStyle"><%=result.getString("MarkType")%> </td>
<td class="TDStyle" width=148 nowrap>
<input type=button onclick="javascript:location.href='SignatureEditFrm.jsp?SignatureID=<%=mSignatureID%>';" name="Edit" value=" 修 改 ">
<input type=button onclick="javascript:ConfirmDel('SignatureDel.jsp?SignatureID=<%=mSignatureID%>');" name="Del" value=" 删 除 ">
</td>
</tr>
<%
}
result.close() ;
}
catch(Exception e)
{
System.out.println(e.toString());
}
DbaObj.CloseConnection() ;
}
else
{
out.println("OpenDatabase Error") ;
}
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -