?? serachres.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.Rsserach" %>
<%@ page import="com.zh.conpool.Condata,com.bwm.string.Str;"%>
<% request.setCharacterEncoding("gb2312"); %>
<html>
<head>
<title>Untitled</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/style1.css" rel="stylesheet">
</head>
<body>
<jsp:include page="top.htm"></jsp:include>
<jsp:useBean id="ben" scope="page" class="com.Rsserbean"></jsp:useBean>
<jsp:setProperty name="ben" property="*" />
<table bgcolor="#FFFFFF" border=0 cellpadding=0 cellspacing=0 width="100%">
<tr bgcolor="#EFEFEF">
<td height="24"><nobr>員工名稱</nobr></td>
<td height="24"><nobr>日志類型</nobr></td>
<td height="24"><nobr>日志內容</nobr></td>
<td height="24"><nobr>日志時間</nobr></td>
<td height="24"><nobr>日志詳情</nobr></td>
</tr>
<%
Str str=new Str();
Rsserach rsst=new Rsserach();
String rssql=rsst.toSQL(ben.getName(),ben.getState(),str.toChinese(ben.getTime()),str.toChinese(ben.getOver()));
Condata con=new Condata();
Connection conn=con.getConnection();
ResultSet rs=con.executeQuery(rssql);
int rsn=0;
while(rs.next()){
rsn++;
String ID=rs.getString("ID");
String Name=rs.getString("Name");
Date DateTime=rs.getDate("DateTime");
String Content=rs.getString("Content");
String Contenttext=rs.getString("Contenttext");
String Sign=rs.getString("Sign");
%>
<tr bgcolor="#EFEFEF">
<td height="24"><nobr><%=Name%></nobr></td>
<td height="24"><nobr><%=DateTime%></nobr></td>
<td height="24"><nobr><%=Content%></nobr></td>
<td height="24"><nobr><%=Contenttext%></nobr></td>
<td height="24"><nobr><%=Sign%></nobr></td>
</tr>
<% }
if(rsn==0)
{
%>
<tr>
<td height="120"><nobr>無記錄</nobr></td>
</tr>
<%
}
try{
conn.close();
conn=null;
}catch(Exception e){
}
try{
con.close();
con=null;
}catch(Exception e){
}
%>
<tr bgcolor="#EFEFEF">
<td height="24" colspan=7><p> </p> </td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -