📄 default.jsp
字号:
<%@page contentType="text/html;charset=GBK"%>
<%@include file="..\..\const\global.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../../css/style.css" type="text/css">
</head>
<body background="../../image/backg2.gif">
<%
String StrMsg="";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
sqlCon = java.sql.DriverManager.getConnection(ConnStr,ConnUser,ConnPassword);
sqlStmt = sqlCon.createStatement();
String userid="sysadm";
%>
<h5>用户管理</h5>
<p align='center'>【<a href='useradd.jsp'>增加</a>】</p>
<table border="0" width="90%" cellspacing="1" cellpadding="5" class="main" align=center>
<tr align="center">
<td class='top'>用户</td>
<td class='top'>密码</td>
<td class='top'>姓名</td>
<td class='top'>修改</td>
<td class='top'>删除</td>
</tr>
<%
strSQL="select * from userlist";
sqlRst = sqlStmt.executeQuery(strSQL);
while(sqlRst.next()){
%>
<tr align="center" class="bc">
<td><%=sqlRst.getString("userid")%></a></td>
<td><%=sqlRst.getString("pwd")%></td>
<td><%=sqlRst.getString("username")%></td>
<td><a href="usermodi.jsp?userid=<%=sqlRst.getString("userid")%>"><img src="../../image/modify.gif" border="0"></a></td>
<td><a href="javascript:check('<%=sqlRst.getString("userid")%>')"><img src="../../image/del.gif" border="0"></a></td>
</tr>
<%
}
sqlRst.close();
%>
</table>
<%
//关闭SQL语句对象
sqlStmt.close();
//关闭数据库
sqlCon.close();
}catch(SQLException s) {
StrMsg="SQL错误信息："+s.toString()+" "+s.getErrorCode()+" "+s.getSQLState();
}catch(Exception e) {
StrMsg="错误信息："+e.toString()+e.getMessage();
}
if(!StrMsg.equals("")){
out.println("<font color=red>"+StrMsg+"</font>");
}
%>
</body>
</html>
<script language=javascript>
function check(aa)
{
check1(aa);
}
</script>
<script language=vbscript>
function check1(aa)
if MsgBox("你是否要删除这条记录？", vbQuestion + vbYesNo, "提示") = vbYes then
window.location.href ="userdel.jsp?userid=" &aa
end if
end function
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -