📄 jsp2.jsp~249~
字号:
<%@page contentType="text/html; charset=gb2312"%><%@page import="java.sql.*"%>
<%request.setCharacterEncoding("gb2312");%>
<SCRIPT LANGUAGE="JavaScript">
m = new Array()
m[0] = "今日新到教材"
m[1] = "教材购销管理网站通知1"
m[2] = "今日新到教材"
m[3] = "教材购销管理网站通知2"
m[4] = "今日新到教材"
m[5] = "教材购销管理网站通知3"
m[6] = "今日新到教材"
m[7] = "教材购销管理网站通知4"
//修改变换颜色
bagcolor = new Array()
bagcolor[0] = "#CCCCCC"
bagcolor[1] = "#FFFF66"
bagcolor[2] = "#CCFFFF"
bagcolor[3] = "#AAEEFF"
bagcolor[4] = "#CCFF88"
bagcolor[5] = "#FF9933"
bagcolor[6] = "#99AAFF"
bagcolor[7] = "#6699FF"
var i=0;
function Ran(R) {
return Math.floor((R+1)*Math.random())
}
function play_rt()
{
rt1.style.filter="revealTrans(Duration=1.5,Transition=" + Ran(22) + ")";
rt1.filters.revealTrans.apply();
rt1.style.background=bagcolor[Ran(7)];
rt1.innerHTML=m[Ran(6)];
rt1.filters.revealTrans.play();
timer = setTimeout("play_rt()",3000)
}
</SCRIPT>
<%
String Username=request.getParameter("name");
String Password=request.getParameter("Password");
String input= request.getParameter("rand");
if (Username!=null && Password!=null)
{
//把用户名和密码保存在session中
session.setAttribute("user_name",Username);
session.setAttribute("pass_word",Password);
session.setAttribute("input",input);
//验证用户输入的验证码是否正确
if(input.equals(session.getAttribute("random")))
{
//如果正确就跳转到check.jsp验证用户名密码
response.sendRedirect("check.jsp");
}
else
{
//验证码不正确
out.print("验证码错误");
}
}
%>
<script type="text/javascript">
function check()
{
if (form.name.value=="")
{
alert("请输入用户名!!!");
form.name.focus();
return false;
}
if (form.Password.value=="")
{
alert("请输入密码!!!");
form.name.focus();
return false;
}
}
</SCRIPT>
<%!
String file;
%>
<html>
<head>
<title>教材购销管理网页</title>
<link href="css4.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" language="javascript" src="script.js"></script>
</head>
<center>
<body onload="play_rt();menuSlider.init('menu','slide')">
<!--css布局container容器-->
<div id="container">
<!--css布局Sidebar1栏-->
<div id=Sidebar1>
<center>
<table width=100% height=600 border=2 cellpadding=2 cellspacing=8 style="border-collapse:collapse;" bordercolor="threeddarkshadow" >
<TBODY>
<TR>
<TD>
<marquee direction="left" scrollamount="2" scrolldelay="1" width="100" height="100"> <font color="red"> 没书了！别购了！</font></marquee>
</TD>
<TR>
<TD><a href="jsp1.jsp">申请教材1</a></TD></TR>
<TR>
<TD><a href="jsp1.jsp">申请教材2</a></TD></TR>
<TR><TD><a href="jsp1.jsp">申请教材3</a></TD></TR>
<TR><TD><a href="jsp1.jsp">申请教材4</a></TD></TR>
<TR><TD><font color="red" >本站连接</font></TD></TR>
<TR><TD><a href="www.baidu.com">百度</a></TD></TR>
</TBODY></TABLE>
<br>
</center>
</div>
<div id="Header"></div>
<!-- dasasdasd-->
<div id="slide"><div class="menu">
<ul id="menu">
<li><a href="jsp1.jsp">申请教材</a></li>
<li><a href="2.jsp">查看借阅历史</a></li>
<li><a href="jsp3.jsp">查看教材库</a></li>
<li value="1"><a href="#">相册</a></li>
<li><a href="#">论坛</a></li>
<li><a href="#">离开</a></li>
</ul>
<div id="banner">
</div>
<FORM Action="xw.jsp" method="POST" name="myform">
搜索 ：<input type="text" name="sousuo" style="height:18px;width:120px">
<input type="submit" name="sousuo" value="搜 索" >
</FORM></div></div>
<!-- dasasdasd-->
<div id="PageBody">
<form name="form" onsubmit="return check()" action="jsp2.jsp" method="post">
用户
<input type="text" name="name" style="height:18px;width:100px">
密码
<input type="password" name="Password" style="height:18px;width:100px">
认证码：
<input type=text name=rand maxlength=4 value="" size=6>
<img border=1 src="image.jsp">
<input type="submit" name="submit" value=" 登陆"><A href="zc1.jsp">注册新用户</A><br>
</form>
<div id="Sidebar">
新闻发布区
<table height=100 border=2 cellpadding=2 cellspacing=8 >
<TBODY>
<TR>
<TD>
<marquee direction="left" scrollamount="2" scrolldelay="1" width="100" height="100"> <font color="red"> 没书了！别购了！</font></marquee>
</TD></TR></TBODY></TABLE>
<TABLE WIDTH="160" BORDER="1" HEIGHT="82">
<TR >
<TD id="rt1" HEIGHT="82"></TD>
</TR>
</TABLE>
<div id="templayer" style="position:absolute;left:0;top:0;visibility:hidden"></div>
</div>
<div id="MainBody">
教材更新发布区<BR>
<TABLE WIDTH="500" BORDER="0" HEIGHT="120">
<TR >
<td align=center><font color="#309aff">教材名</font></td>
<td align=center><font color="#309aff">单价</font></td>
<td align=center><font color="#309aff">出版社</font></td>
<td align=center><font color="#309aff">教材图片</font></td></tr>
<TR > <%
String sql = "select * from s where xianshi='1'";
Statement stmt=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
//加载JDBC-ODBC桥驱动
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//定义JDBC URL
}catch (Exception e) {
out.println(e.getMessage());
}
try{
String url = "jdbc:odbc:s";
//得到与数据库的连接
Connection con = DriverManager.getConnection(url);
//显示UPL和连接信息
System.out.print("URL:" + url);
System.out.print("Connection:" + con);
//得到一个Statement对象
stmt = con.createStatement();
//执行SQL语句
System.out.print("SQL:" + sql);
rs = stmt.executeQuery(sql);
while(rs.next())
{
file=rs.getString("filename");
out.print("<td align=center><marquee direction='left' scrollamount='2' scrolldelay='1' width='100' height='20'> "+rs.getString("bname")+"</marquee></td>");
out.print("<td align=center> <marquee direction='left' scrollamount='2' scrolldelay='1' width='100' height='20'> "+rs.getString("bjiage")+"元/本</marquee></td>");
out.print("<td align=center> <marquee direction='left' scrollamount='2' scrolldelay='1' width='100' height='20'>"+rs.getString("cbs")+"</marquee></td>");
out.print("<td align='center'><img src='"+file+"' </td></tr>");
}
}catch (Exception e) {}
%>
</TABLE>
<marquee direction="left" scrollamount="2" scrolldelay="1" width="150" height="80"> <img border=1 src="2.gif"><img border=1 src="5.jpg"><img border=1 src="6.jpg">
</marquee>
</div>
</div>
<div id="Footer">
链接
</div>
</div>
<A href="jsp1.jsp?getname;">申请教材</A>
‖
<A href="jsp2.jsp">查看借阅历史</A>
‖
<A href="jsp3.jsp">查看学生记录</A>
‖
<A href="jsp4.jsp">离开教材购销管理系统</A>
‖
<A href="jsp1.jsp"onclick=window.close();>离开</A>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -