📄 content.jsp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<%@ page language="java" pageEncoding="gb2312"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="alogin" class="login.jdbcBean" scope="page"/>
<link href="myCss.css" rel="stylesheet" type="text/css" />
<link href="mytable.css" rel="stylesheet" type="text/css" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-image: url(images/bg.gif);
}
-->
</style>
</head>
<body class="myCss">
<table width="830" border="1" cellpadding="1" cellspacing="0" bordercolor="#009999" class="mytable">
<tr>
<td class="mytable"><table width="830" border="0">
<tr>
<td colspan="3">程序设计----------></td>
<td width="50" colspan="2"><div align="right"><a href="displayByType.jsp?type=1" >More>></a></div></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr bordercolor="#0099CC" border="1">
<%ResultSet rs;
rs=alogin.executeQuery("select bookID,bookName,frontPage from books where typeID = '1'");
String bookID,bookName,frontPage;
int count=1;
while(rs.next()&&count<=5){
count++;
bookID=rs.getString("bookID");
bookName=rs.getString("bookName");
frontPage=rs.getString("frontPage");
if(frontPage==null){frontPage=("pic/wutu.gif");}
%>
<td width="768"><div align="center">
<p><a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><img src=<%=frontPage %> width="90" height="120" /></a></p>
<p> <a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><%=bookName %></a></p>
</div></td>
<% }%>
</tr>
</table></td>
</tr>
<tr>
<td class="mytable"><table width="830" border="0">
<tr>
<td colspan="3">数据库开发----------></td>
<td colspan="2"><div align="right"><a href="displayByType.jsp?type=2" >More>></a></div></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr bordercolor="#0099CC" border="1">
<%
rs=alogin.ReExecuteQuery("select bookID,bookName,frontPage from books where typeID = '2'");
count=1;
while(rs.next()&&count<=5){
count++;
bookID=rs.getString("bookID");
bookName=rs.getString("bookName");
frontPage=rs.getString("frontPage");
if(frontPage==null){frontPage=("pic/wutu.gif");}
%>
<td width="820"><div align="center">
<p><a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><img src=<%=frontPage %> width="90" height="120" /></a></p>
<p> <a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><%=bookName %></a></p>
</div></td>
<% }%>
</tr>
</table></td>
</tr>
<tr>
<td class="mytable"><table width="830" border="0">
<tr>
<td colspan="3">图形图像处理----------></td>
<td colspan="2"><div align="right"><a href="displayByType.jsp?type=3" >More>></a></div></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr bordercolor="#0099CC" border="1">
<%
rs=alogin.ReExecuteQuery("select bookID,bookName,frontPage from books where typeID = '3'");
count=1;
while(rs.next()&&count<=5){
count++;
bookID=rs.getString("bookID");
bookName=rs.getString("bookName");
frontPage=rs.getString("frontPage");
if(frontPage==null){frontPage=("pic/wutu.gif");}
%>
<td width="820"><div align="center">
<p><a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><img src=<%=frontPage %> width="90" height="120" /></a></p>
<p> <a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><%=bookName %></a></p>
</div></td>
<% }%>
</tr>
</table></td>
</tr>
<tr>
<td class="mytable"><table width="830" border="0">
<tr>
<td colspan="3">办公自动化----------></td>
<td colspan="2"><div align="right"><a href="displayByType.jsp?type=4" >More>></a></div></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr bordercolor="#0099CC" border="1">
<%
rs=alogin.ReExecuteQuery("select bookID,bookName,frontPage from books where typeID = '4'");
count=1;
while(rs.next()&&count<=5){
count++;
bookID=rs.getString("bookID");
bookName=rs.getString("bookName");
frontPage=rs.getString("frontPage");
if(frontPage==null){frontPage=("pic/wutu.gif");}
%>
<td width="820"><div align="center">
<p><a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><img src=<%=frontPage %> width="90" height="120" /></a></p>
<p> <a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><%=bookName %></a></p>
</div></td>
<% }%>
</tr>
</table></td>
</tr>
<tr>
<td class="mytable"><table width="830" border="0">
<tr>
<td colspan="3">网络管理----------></td>
<td colspan="2"><div align="right"><a href="displayByType.jsp?type=5" >More>></a></div></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr bordercolor="#0099CC" border="1">
<%
rs=alogin.ReExecuteQuery("select bookID,bookName,frontPage from books where typeID = '5'");
count=1;
while(rs.next()&&count<=5){
count++;
bookID=rs.getString("bookID");
bookName=rs.getString("bookName");
frontPage=rs.getString("frontPage");
if(frontPage==null){frontPage=("pic/wutu.gif");}
%>
<td width="820"><div align="center">
<p><a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><img src=<%=frontPage %> width="90" height="120" /></a></p>
<p> <a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><%=bookName %></a></p>
</div></td>
<% }%>
</tr>
</table></td>
</tr>
<tr>
<td class="mytable"><table width="830" border="0">
<tr>
<td colspan="3">计算机硬件----------></td>
<td colspan="2"><div align="right"><a href="displayByType.jsp?type=6" >More>></a></div></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr bordercolor="#0099CC" border="1">
<%
rs=alogin.ReExecuteQuery("select bookID,bookName,frontPage from books where typeID = '6'");
count=1;
while(rs.next()&&count<=5){
count++;
bookID=rs.getString("bookID");
bookName=rs.getString("bookName");
frontPage=rs.getString("frontPage");
if(frontPage==null){frontPage=("pic/wutu.gif");}
%>
<td width="820"><div align="center">
<p><a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><img src=<%=frontPage %> width="90" height="120" /></a></p>
<p> <a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><%=bookName %></a></p>
</div></td>
<% }%>
</tr>
</table></td>
</tr>
<tr>
<td class="mytable"><table width="830" border="0">
<tr>
<td colspan="3">计算机辅助设计----------></td>
<td colspan="2"><div align="right"><a href="displayByType.jsp?type=7" >More>></a></div></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr bordercolor="#0099CC" border="1">
<%
rs=alogin.ReExecuteQuery("select bookID,bookName,frontPage from books where typeID = '7'");
count=1;
while(rs.next()&&count<=5){
count++;
bookID=rs.getString("bookID");
bookName=rs.getString("bookName");
frontPage=rs.getString("frontPage");
if(frontPage==null){frontPage=("pic/wutu.gif");}
%>
<td width="820"><div align="center">
<p><a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><img src=<%=frontPage %> width="90" height="120" /></a></p>
<p> <a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><%=bookName %></a></p>
</div></td>
<% }%>
</tr>
</table></td>
</tr>
<tr>
<td class="mytable"><table width="830" border="0">
<tr>
<td colspan="3">其他----------></td>
<td colspan="2"><div align="right"><a href="displayByType.jsp?type=8" >More>></a></div></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr bordercolor="#0099CC" border="1">
<%
rs=alogin.ReExecuteQuery("select bookID,bookName,frontPage from books where typeID = '8'");
count=1;
while(rs.next()&&count<=5){
count++;
bookID=rs.getString("bookID");
bookName=rs.getString("bookName");
frontPage=rs.getString("frontPage");
if(frontPage==null){frontPage=("pic/wutu.gif");}
%>
<td width="820"><div align="center">
<p><a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><img src=<%=frontPage %> width="90" height="120" /></a></p>
<p> <a href="bookDetail.jsp?bookID=<%=bookID%>"target="mainFrame"><%=bookName %></a></p>
</div></td>
<% }
alogin.closeDateBase();
%>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -