<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<style type="text/css">
<!--
body,td {
font-size: 14px;
color: #000000;
}
th {
font-size: 14px;
color: #ffffff;
}
a:link {
color: #000000;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #000000;
}
a:hover {
text-decoration: underline;
color: #0033FF;
}
a:active {
text-decoration: none;
color: #0033FF;
}
-->
</style>
<script language="javascript">
function newwin(url) {
var
newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=600,height=450");
newwin.focus();
return false;
}
function subb() {
document.form1.action="search.jsp";
form1.submit();
}
</script>
<script LANGUAGE="javascript">
function submit10()
{
self.location.replace("searchfiles.jsp")
}
</script>
<%//变量声明
java.sql.Connection sqlCon; //数据库连接对象
java.sql.Statement sqlStmt; //SQL语句对象
java.sql.ResultSet sqlRst; //结果集对象
java.lang.String strCon; //数据库连接字符串
java.lang.String strSQL; //SQL语句
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
java.lang.String strPage;
int i;
//设置一页显示的记录数
intPageSize = 10;
//取得待显示页码
strPage = request.getParameter("page");
String keyword=request.getParameter("keyword");
String keyparagh=request.getParameter("keyparagh");
String firDir=request.getParameter("anclassid");
String secDir=request.getParameter("nclassid");
if(strPage==null){//表明在QueryString中没有page这一个参数,此时显示第一页数据
intPage = 1;
session.setAttribute("keywordtemp",keyword);
session.setAttribute("keyparaghtemp",keyparagh);
session.setAttribute("firdirtemp",firDir);
session.setAttribute("secdirtemp",secDir);
}
else{//将字符串转换成整型
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
//装载JDBC驱动程序
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//设置数据库连接字符串
strCon = "jdbc:odbc:filesmag";
//连接数据库
sqlCon = java.sql.DriverManager.getConnection(strCon,"sa","");
//创建一个可以滚动的只读的SQL语句对象
sqlStmt =
sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);//准备SQL语句
keyword=(String)session.getAttribute("keywordtemp");
keyparagh=(String)session.getAttribute("keyparaghtemp");
firDir=(String)session.getAttribute("firdirtemp");
secDir=(String)session.getAttribute("secdirtemp");
System.out.println("firdir:(new#####################)"+firDir);
System.out.println("firdir:(new#####################)"+secDir);
if(keyparagh.equals("all")){
if(firDir.equals("")){
strSQL = "select * from filelist where FileName like '%"+keyword+"%' or Writer like '%"+keyword+"%' or Keyword like '%"+keyword+"%' or Upcourse like '%"+keyword+"%' or FileSource like '%"+keyword+"%' or Department like '%"+keyword+"%' or Remark like '%"+keyword+"%'";
System.out.println("error corporation"+strSQL);
sqlRst = sqlStmt.executeQuery(strSQL);
}
else if(secDir.equals("")){
strSQL = "select * from filelist where FirDirect='"+firDir+"' and (FileName like '%"+keyword+"%' or Writer like '%"+keyword+"%' or Keyword like '%"+keyword+"%' or Upcourse like '%"+keyword+"%' or FileSource like '%"+keyword+"%' or Department like '%"+keyword+"%' or Remark like '%"+keyword+"%') " ;
System.out.println("correct corporation"+strSQL);
sqlRst = sqlStmt.executeQuery(strSQL);
}
else{
strSQL = "select * from filelist where FirDirect='"+firDir+"' and SecDirect='"+secDir+"' and (FileName like '%"+keyword+"%' or Writer like '%"+keyword+"%' or Keyword like '%"+keyword+"%' or Upcourse like '%"+keyword+"%' or FileSource like '%"+keyword+"%' or Department like '%"+keyword+"%' or Remark like '%"+keyword+"%')";
//执行SQL语句并获取结果集
sqlRst = sqlStmt.executeQuery(strSQL);
}
}
else{
if(keyword.equals("")){
if(secDir.equals("")){
strSQL = "select * from filelist where FirDirect='"+firDir+"'";
//执行SQL语句并获取结果集
sqlRst = sqlStmt.executeQuery(strSQL);
}
else{
strSQL = "select * from filelist where FirDirect='"+firDir+"' and SecDirect='"+secDir+"'";
//执行SQL语句并获取结果集
sqlRst = sqlStmt.executeQuery(strSQL);
}
}
else{
if(firDir.equals("")){
strSQL = "select * from filelist where "+keyparagh+" like '%"+keyword+"%'";
System.out.println("strSQL:"+strSQL);
sqlRst = sqlStmt.executeQuery(strSQL);
}
else if(secDir.equals("")){
strSQL = "select * from filelist where "+keyparagh+" like '%"+keyword+"%' and FirDirect='"+firDir+"'" ;
sqlRst = sqlStmt.executeQuery(strSQL);
}
else{
strSQL = "select * from filelist where "+keyparagh+" like '%"+keyword+"%' and FirDirect='"+firDir+"' and SecDirect='"+secDir+"'";
sqlRst = sqlStmt.executeQuery(strSQL);
}
}
}
//获取记录总数
sqlRst.last();//??光标在最后一行
intRowCount = sqlRst.getRow();//获得当前行号
System.out.println("查询结果集:"+intRowCount);
//记算总页数
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询列表</title>
</head>
<body bgcolor="#FFFFFF" >
<table align=center bgcolor=#ffffff border=0 cellpadding=0 cellspacing=0
height=57 width=760>
<tbody>
<tr>
<td width="506" height="57" background="newpage/images/in_01.jpg">
<table width="100%" border="0" cellspacing="0" cellpadding="1" height="57">
<tr>
<td width="20"> </td>
<td><font color="#FFFFFF" size="5"><b>查询列表</b></font></td>
<td width="20"> </td>
</tr>
</table>
<font size=6> </font></td>
<td width="254" background="newpage/images/in_02.jpg"> </td>
</tr>
</tbody>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="1" align="center" bgcolor="#0066B3">
<tr>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="20">
<tr>
<td valign="top">
<table width="715">
<form method="POST" action="searchfiles.jsp" name="form1">
<td >第<%=intPage%>页 共<%=intPageCount%>页
<%if(intPage<intPageCount){%><a href="searchfiles.jsp?page=<%=intPage+1%>">下一页
</a><%}%> <%if(intPage>1){%><a href="searchfiles.jsp?page=<%=intPage-1%>">
上一页</a><%}%>
转到第:<input type="text" name="page" size="8"> 页
<span><input class=buttonface type="submit" value="GO" name="cndok"></span></td>
<td align="right"><input type="button" name="Submit" value="返回" onClick="subb()"></td>
</form>
</table>
<table width="715" border="0" cellspacing="1" cellpadding="0" align="center">
<tr>
<th width="44%" height="30" align="center" bgcolor="#1681c8">文件名称</th>
<th width="13%" height="30" align="center" bgcolor="#1681c8">文件作者</th>
<th width="13%" height="30" align="center" bgcolor="#1681c8">建立日期</th>
<th colspan="2" height="30" align="center" bgcolor="#1681c8">操作</th>
</tr>
<%
if(intPageCount>0){
//将记录指针定位到待显示页的第一条记录上
sqlRst.absolute((intPage-1) * intPageSize + 1);
//显示数据
i = 0;
int id;
String fileName,writerName,firDirect,secDirect,Keyword,Year,Term,createDate,UpCourse,FileSource,Department,Remark;
boolean found=sqlRst.isAfterLast();
while(i<intPageSize && !found){
id=sqlRst.getInt(1);
fileName=sqlRst.getString(2);
writerName=sqlRst.getString(3);
firDirect=sqlRst.getString(4);
secDirect=sqlRst.getString(5);
Keyword=sqlRst.getString(6);
Year=sqlRst.getString(7);
Term=sqlRst.getString(8);
createDate=sqlRst.getString(9);
UpCourse=sqlRst.getString(10);
FileSource=sqlRst.getString(11);
Department=sqlRst.getString(12);
Remark=sqlRst.getString(13);
if(i%2!=0){
%>
<tr>
<td width="44%" height="25" align="left" bgcolor="#DDE3EC"><a href="do_download.jsp?filename=<%=id%>"><%=fileName%></td>
<td width="13%" height="25" align="left" bgcolor="#DDE3EC"><%=writerName%></td>
<td width="13%" height="25" align="left" bgcolor="#DDE3EC"><%=createDate%></td>
<td width="15%" height="25" align="center" bgcolor="#DDE3EC"><a href="detailinfo.jsp?id=<%=id%>&page=<%=intPage%>">详细信息</a></td>
<td width="15%" height="25" align="center" bgcolor="#DDE3EC"> <a href="CreateDeletefile.jsp?id=<%=id%>&page=<%=intPage%>&attributeName=<%=id%>&doid=1" onClick="return confirm('您确定删除吗?')">删除</a></td>
</tr>
<%
}
else{
%>
<tr>
<td width="44%" height="25" align="left"><a href="do_download.jsp?filename=<%=id%>"><%=fileName%></td>
<td width="13%" height="25" align="left"><%=writerName%></td>
<td width="13%" height="25" align="left"><%=createDate%></td>
<td width="15%" height="25" align="center"><a href="detailinfo.jsp?id=<%=id%>&page=<%=intPage%>">详细信息</a></td>
<td width="15%" height="25" align="center"><a href="CreateDeletefile.jsp?id=<%=id%>&page=<%=intPage%>&attributeName=<%=id%>&doid=1" onClick="return confirm('您确定删除吗?')">删除</a></td>
</tr>
<%
}
sqlRst.next();
found=sqlRst.isAfterLast();
System.out.println("@@@@@@@@@@@show whether is the last record:"+found);
i++;
}
}
%>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="3" align="center" bgcolor="#FFFFFF">
<tr>
<td align="center">
<table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="p9" nowrap align="center"><font color="#0066B3">版权所有©
中国传媒大学 </font></td>
</tr>
<tr>
<td class="p9" align="center"> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<%
//关闭结果集
sqlRst.close();
//关闭SQL语句对象
sqlStmt.close();
//关闭数据库
sqlCon.close();
%>