📄 ry.jsp
字号:
<%@ 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());
}
}
%>
<%!
String sql="";
String key="";
String type="";
%>
<%
request.setCharacterEncoding("gb2312");
sql="SELECT * FROM manage ";
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;
}
-->
</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">
<SCRIPT LANGUAGE=JavaScript>
<!-- Begin
if (window.print) {
document.write('<form>'
+ '<input type=button name=print value=打印 '
+ 'onClick=javascript:window.print()></form>');
}
// End -->
</script>
<!-- ImageReady Slices (glry) -->
<table id="__01" width="680" height="425" 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"><a href="gongyu.jsp">首页</a>>>工作人员</td>
</tr>
<tr>
<td height="185" colspan="6" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="78" height="14"> </td>
<td width="533"> </td>
<td width="69"> </td>
</tr>
<tr>
<td height="43" colspan="3"><div align="center"><form action="ry.jsp" method="post">
查询关键字：<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 type="image" src="images/chakan.gif">
</form></div></td>
</tr>
<tr>
<td height="14"> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="96"> </td>
<td valign="top">
<table width="100%" cellpadding="0" cellspacing="0" bordercolordark="#0033FF" bordercolorlight="#0033FF">
<!--DWLayoutTable-->
<tr>
<td height="31" colspan="7" valign="top"><div align="center">工作管理人员：</div></td>
</tr>
<tr>
<td width="74" height="31" valign="top">姓名</td>
<td width="56" valign="top">年龄</td>
<td width="60" valign="top">性别</td>
<td width="80" valign="top">职务</td>
<td width="64" valign="top">学历</td>
<td width="79" valign="top">电话号码</td>
<td width="98" valign="top">电子邮箱</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(key != null && type != null)
sql+="where " +type+ " like '%"+key+"%'";
ResultSet rs = stmt.executeQuery(sql);
String name="";
int age=0;
String sex="";
String zhiwu="";
String xueli="";
int phone=0;
String email="";
//out.println("User-list"+"<br>");
while(rs.next()){
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="31" 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>
</tr>
<tr>
<td height="1"></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>
<td> </td>
</tr>
<tr>
<td height="18"> </td>
<td> </td>
<td> </td>
</tr>
</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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -