📄 index.jsp~34~
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@page contentType="text/html; charset=GB2312"%>
<%@ page session="true" %>
<%@page errorPage="error.jsp"%>
<jsp:useBean id="index1bean" scope="page" class="bookmanager.Index1Bean"></jsp:useBean>
<%request.setCharacterEncoding("gb2312");%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>图书管理系统</title>
<style type="text/css">
<!--
@import url("images/s.css");
-->
</style>
<style type="text/css">
<!--
a {
font-family: Arial, Helvetica, sans-serif;
font-size: 11px;
}
a:link {
text-decoration: none;
color: #0066FF;
}
a:visited {
text-decoration: none;
color: #999966;
}
a:hover {
text-decoration: none;
color: #33FF00;
}
a:active {
text-decoration: none;
color: #00CC33;
}
.style1 { color: #FFFF00;
font-weight: bold;
}
.style2 { color: #00FF00;
font-weight: bold;
}
body,td,th {
color: #FF0000;
font-size: 13px;
}
.style3 {
font-size: 13px;
color: #996633;
}
-->
</style>
<script language="javascript">
function openScript(url,name, width, height){
var Win = window.open(url,name,'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
function checkform() {
if (document.form1.username.value==""){
alert("用户名不能为空");
document.form1.username.focus();
return false;
}
if (document.form1.password.value==""){
alert("用户密码不能为空");
document.form1.password.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="100" colspan="5">
<p align="center">
<img src="images/head.gif" width="707" height="100">
</p>
</td>
</tr>
<tr align="center" valign="middle">
<td width="700" height="22">
<img src="images/009.gif" width="28" height="22">
<a href="index.jsp">
<strong>首页</strong>
</a>
</td>
<td width="700" height="22">
<img src="images/009.gif" width="28" height="22">
<span class="style1">
<a href="userlogin.jsp">用户注册</a>
</span>
</td>
<td width="700" height="22">
<img src="images/009.gif" width="28" height="22">
<span class="style2">
<a href="introduction.jsp">系统简介</a>
</span>
</td>
<td width="700" height="22">
<img src="images/009.gif" width="28" height="22">
<strong class="style2">
<a href="admin/admin.jsp">管理员入口</a>
</strong>
</td>
<td width="700" height="22">
<img src="images/009.gif" width="28" height="22">
<strong>
<a href="logout.jsp">退出系统</a>
</strong>
</td>
</tr>
<tr>
<td colspan="5">
<table width="740" border="0" cellpadding="0" cellspacing="0" background="images/0008.gif">
<tr>
<td height="2" colspan="2">
<hr width="702" size="2">
</td>
</tr>
<tr background="images/0008.gif">
<td width="180" valign="top">
<form name="form1" method="post" action="login.jsp">
<table width="170" border="0" cellpadding="1" cellspacing="1" background="images/0008.gif" bgcolor="#CCFFFF">
<tr>
<td colspan="2">
<table width="177" border="0" cellspacing="1" cellpadding="1">
<tr>
<td width="28" align="center" valign="middle">
<img src="images/starbullet.gif" width="11" height="11">
</td>
<td width="142">
<img src="images/login1.gif" width="130" height="30">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10" colspan="2">
<hr>
</td>
</tr>
<tr>
<td width="45" height="20">
<img src="images/t1.gif" width="40" height="20">
</td>
<td width="80">
<input name="username" type="text" size="16">
</td>
</tr>
<tr>
<td>
<img src="images/t2.gif" width="40" height="20">
</td>
<td>
<input name="password" type="password" size="16">
</td>
</tr>
<tr>
<td colspan="2">
<table width="180" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="center" valign="middle">
<input type="submit" name="Submit" value="提交" onclick="javascript:return(checkform());">
<input type="reset" name="Submit" value="重置">
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</td>
<td width="560" rowspan="3" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="280" height="32">
<img src="images/01.gif" width="280" height="32">
</td>
<td width="280">
<img src="images/02.gif" width="280" height="30">
</td>
</tr>
<%out.print(index1bean.printHtml("all", "SELECT TOP 5 book.bkname FROM borrow INNER JOIN book ON borrow.bkid = book.bkid GROUP BY book.bkname ORDER BY COUNT(*) DESC")); %>
<tr>
<td>
<img src="images/04.gif" width="280" height="32">
</td>
<td>
<img src="images/03.gif" width="280" height="32">
</td>
</tr>
<%out.print(index1bean.printHtml("use bookdb if exists(SELECT * FROM sysobjects where name ="+"'"+"temp"+"'"+") drop table temp select * into temp from book WHERE (bkcid != 315003) order by regdate desc select distinct top 5 bkname from temp", " use bookdb if exists(SELECT * FROM sysobjects where name ="+"'"+"temp"+"'"+") drop table temp select * into temp from book WHERE (bkcid = 315003) order by regdate desc select distinct top 5 bkname from temp")); %>
</table>
</td>
</tr>
<tr background="images/0008.gif">
<td> </td>
</tr>
<tr background="images/0008.gif">
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -