hd1.jsp
来自「--- --^_^-------------- 广师公寓中心 1.请装上」· JSP 代码 · 共 263 行
JSP
263 行
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
int counter=0;
Cookie cookies[]=request.getCookies();
if(cookies!=null){
for(int i=0;i<cookies.length;i++){
if(cookies[i].getName().equals("counter"))
counter=Integer.parseInt(cookies[i].getValue());
}
}
%>
<%
if(session.getAttribute("login")== null)
{%>
<jsp:forward page="login.jsp"/>
<%}
%>
<%!
String sql="";
String key="";
String del="";
String type="";
%>
<%
request.setCharacterEncoding("gb2312");
key=request.getParameter("m_key");
type=request.getParameter("m_type");
%>
<html>
<head>
<title>后台管理>工作人员</title>
<style type="text/css">
<!--
table {
font-family: "宋体";
font-size: 14px;
color: #000000;
}
.unnamed1 {
border-right-width: thin;
border-right-style: dashed;
border-right-color: #000000;
}
.unnamed2 {
border-bottom-width: thin;
border-bottom-style: dashed;
border-bottom-color: #000000;
}
.unnamed3 {
border-left-width: thin;
border-left-style: dashed;
border-left-color: #000000;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="images/background.gif">
<!-- ImageReady Slices (glry) -->
<table id="__01" width="680" height="338" border="0" cellpadding="0" cellspacing="0" align="center" background="images/glry_11.gif">
<!--DWLayoutTable-->
<tr>
<td height="55" colspan="6">
<img src="images/glry_01.gif" width="680" height="55" alt=""></td>
</tr>
<tr>
<td height="46" colspan="6">
<img src="images/glry_02.gif" width="680" height="46" alt=""></td>
</tr>
<tr>
<td height="41" colspan="6">
<img src="images/glry_03.gif" width="680" height="41" alt=""></td>
</tr>
<tr>
<td colspan="6" background="images/glry_04.gif" height="20" alt="">
<font color="#FF0000" size="2"><jsp:include page="time.htm"/>
<%
if(counter==0){
//if(session.getAttribute("counter1") == null){
out.print("欢迎首次光临！");
}
else{
out.print("今天您已经光临了"+counter+"次！");
//out.print("您已经光临了"+session.getAttribute("counter1")+"次！");
}
%></font></td>
</tr>
<tr>
<td width="115" height="19">
<a href="gongyu.jsp"><img src="images/glry_05.gif" alt="" width="115" height="19" border="0"></a></td>
<td width="113">
<a href="ry.jsp"><img src="images/glry_06.gif" alt="" width="113" height="19" border="0"></a></td>
<td width="112">
<a href="xszs.jsp"><img src="images/glry_07.gif" alt="" width="112" height="19" border="0"></a></td>
<td width="113">
<a href="wh.jsp"><img src="images/glry_08.gif" alt="" width="113" height="19" border="0"></a></td>
<td width="113">
<a href="lx.jsp"><img src="images/glry_09.gif" alt="" width="113" height="19" border="0"></a></td>
<td width="114">
<a href="hd.jsp"><img src="images/glry_10.gif" alt="" width="114" height="19" border="0"></a></td>
</tr>
<tr>
<td colspan="6" background="images/glry_04.gif" height="20" alt="" bordercolorlight="#009999" class="unnamed2"><a href="gongyu.jsp">首页</a>>>后台管理>工作人员 <a href="zhexiao.jsp">注销<%=session.getAttribute("username")%></a></td>
</tr>
<tr>
<td height="123" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="113" height="3"></td>
</tr>
<tr>
<td height="22" valign="top"><a href="hd1.jsp"><img src="images/glry_06.gif" alt="" width="113" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td height="20" valign="top"><a href="zs.jsp"><img src="images/glry_07.gif" alt="" width="112" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td height="23" valign="top"><a href="hd3.jsp"><img src="images/glry_08.gif" alt="" width="113" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td height="23" valign="top"><a href="hd4.jsp"><img src="images/glry_09.gif" alt="" width="113" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td height="23" valign="top"><a href="hd6.jsp"><img src="images/glry_13.gif" alt="" width="113" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
</table></td>
<td colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="unnamed3">
<!--DWLayoutTable-->
<tr>
<td height="26" colspan="8" valign="top"><form action="hd1.jsp" method="post">
<div align="center">查询关键字：
<input type="text" name="m_key" width="75">
请选择查找操作字段：
<select name="m_type">
<option value="name">姓名</option>
<option value="age">年龄</option>
<option value="sex">性别</option>
<option value="zhiwu">职务</option>
<option value="xueli">学历</option>
<option value="phone">电话号码</option>
<option value="email">电子邮箱</option>
</select>
<input name="image" type="image" src="images/chakan.gif">
</div>
</form></td>
</tr>
<tr>
<td height="30" colspan="8" valign="top"><div align="center">全部工作人员</div></td>
</tr>
<tr>
<td width="70" height="31" valign="top"> 姓名</td>
<td width="48" valign="top">年龄</td>
<td width="44" valign="top">性别</td>
<td width="69" valign="top">职务</td>
<td width="71" valign="top">学历</td>
<td width="82" valign="top">电话号码</td>
<td width="91" valign="top">电子邮箱</td>
<td width="88" valign="top">
<div align="center"><a href="addhd1.jsp">添加管理人员</a></div></td>
</tr>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
try{
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
strDirPath=application.getRealPath("ODBC/gongyu.mdb");
//out.println(application.getRealPath("ODBC/test.mdb"));
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath;
//String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:\\学习\\试试\\test.mdb";
//out.println(url);
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
if(request.getParameter("del")!=null)stmt.executeUpdate("delete * FROM manage where id="+request.getParameter("del"));
sql="SELECT * FROM manage ";
if(key != null && type != null)
sql+="where " +type+ " like '%"+key+"%'";
ResultSet rs = stmt.executeQuery(sql);
int id=1;
String name="";
int age=0;
String sex="";
String zhiwu="";
String xueli="";
int phone=0;
String email="";
//out.println("User-list"+"<br>");
while(rs.next()){
id=rs.getInt("id");
name=rs.getString("name");
age=rs.getInt("age");
sex=rs.getString("sex");
zhiwu=rs.getString("zhiwu");
xueli=rs.getString("xueli");
phone=rs.getInt("phone");
email=rs.getString("email");
%>
<tr>
<td height="36" valign="top"> <%=name%></td>
<td valign="top"><%=age%></td>
<td valign="top"><%=sex%></td>
<td valign="top"><%=zhiwu%></td>
<td valign="top"><%=xueli%></td>
<td valign="top"><%=phone%></td>
<td valign="top"><%=email%></td>
<td valign="top">
<div align="center"><a href=edithd1.jsp?edit=<%=id%>> 编辑</a> <a href=hd1.jsp?del=<%=id%>>删除</a></div></td>
</tr>
<tr>
<td height="0"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<%}
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex)
{
out.print(ex);
}
%>
</table></td>
</tr>
<tr>
<td height="48" colspan="6">
<img src="images/glry_12.gif" width="680" height="48" alt=""></td>
</tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?