📄 displaymultiinfo.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
String database="multiMedia";
String userName="root";
String password="";
Connection cnn=null;
Statement stm=null;
ResultSet rs=null;
String sql="";
int intRowCount=0;
int intPageCount=0;
int intPageSize=5;
int intPage=1; //当前的页码
if(request.getParameter("page")!=null) intPage=Integer.parseInt(request.getParameter("page"));
String getMMT=(String)request.getParameter("mmt");
String getST=(String)request.getParameter("st");
getST=new String(getST.getBytes("ISO8859-1"));
try
{
Class.forName("com.mysql.jdbc.Driver");
cnn=DriverManager.getConnection("jdbc:mysql://localhost/"+database+"?useUnicode=true&characterEncoding=gb2312",userName,password);
stm=cnn.createStatement();
sql = "select * from "+getMMT+" where SubjectType='"+getST+"'";
rs = stm.executeQuery(sql); //执行SQL语句并获取结果集
rs.last(); //获取记录总数
intRowCount = rs.getRow();
}
catch(Exception e)
{
out.println("数据读取失败!");
}
intPageCount = (intRowCount+intPageSize-1) / intPageSize; //记算总页数
if(intPage>intPageCount) intPage = intPageCount; //调整待显示的页码
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>资源库系统媒体素材库下载</title>
<style type="text/css">
</style>
</head>
<body>
<%
out.println("共"+intPageCount+"页 ");
for(int k=1;k<=intPageCount;k++)
{
out.println("<a href=displayMultiInfo.jsp?mmt="+getMMT+"&st="+getST+"&page="+k+">第"+k+"页</a> ");
}
%>
<table width="696" border="1" cellpadding="2" cellspacing="0" bordercolor="#000000" style="border-collapse:collapse;font-size: 12px; ">
<tr>
<th width="75">学科类别</th> <th width="62">适用对象</th><th width="128">内容简介</th><th width="87">编写时间</th>
<th width="88">素材编著者</th><th width="81">素材的大小</th><th width="60">文件格式</th><th width="65">下载地址</th>
</tr>
<%
try
{
if(intPageCount>0)
{
rs.absolute((intPage-1) * intPageSize + 1); //将记录指针定位到待显示页的第一条记录上
int i = 0; //显示数据
while(i<intPageSize && !rs.isAfterLast())
{
out.println("<tr>");
out.println("<td>"+rs.getString("SubjectType")+"</td> ");
out.println("<td>"+rs.getString("ObjectType")+"</td> ");
out.println("<td>"+rs.getString("Description")+"</td> ");
out.println("<td>"+rs.getString("WriteTime")+"</td> ");
out.println("<td>"+rs.getString("Writer")+"</td> ");
out.println("<td>"+rs.getString("Size")+"k</td> ");
out.println("<td>"+rs.getString("FileType")+"</td> ");
out.println("<td><a href="+rs.getString("SavePath")+">下载</a></td> ");
out.println("</tr> ");
rs.next();
i++;
}
}
}
catch(Exception e2)
{
out.println("数据显示失败!");
}
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -