📄 jsp2_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
public final class jsp2_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
String file;
private static java.util.Vector _jspx_dependants;
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write('\r');
out.write('\n');
request.setCharacterEncoding("gb2312");
out.write("\r\n");
out.write("<SCRIPT LANGUAGE=\"JavaScript\">\r\n");
out.write("m = new Array()\r\n");
out.write("m[0] = \"今日新到教材\"\r\n");
out.write("m[1] = \"教材购销管理网站通知1\"\r\n");
out.write("m[2] = \"今日新到教材\"\r\n");
out.write("m[3] = \"教材购销管理网站通知2\"\r\n");
out.write("m[4] = \"今日新到教材\"\r\n");
out.write("m[5] = \"教材购销管理网站通知3\"\r\n");
out.write("m[6] = \"今日新到教材\"\r\n");
out.write("m[7] = \"教材购销管理网站通知4\"\r\n");
out.write("//修改变换颜色\r\n");
out.write("bagcolor = new Array()\r\n");
out.write("bagcolor[0] = \"#CCCCCC\"\r\n");
out.write("bagcolor[1] = \"#FFFF66\"\r\n");
out.write("bagcolor[2] = \"#CCFFFF\"\r\n");
out.write("bagcolor[3] = \"#AAEEFF\"\r\n");
out.write("bagcolor[4] = \"#CCFF88\"\r\n");
out.write("bagcolor[5] = \"#FF9933\"\r\n");
out.write("bagcolor[6] = \"#99AAFF\"\r\n");
out.write("bagcolor[7] = \"#6699FF\"\r\n");
out.write("var i=0;\r\n");
out.write("\r\n");
out.write("function Ran(R) {\r\n");
out.write("\treturn Math.floor((R+1)*Math.random())\r\n");
out.write("}\r\n");
out.write("\r\n");
out.write("function play_rt()\r\n");
out.write("{\r\n");
out.write("\trt1.style.filter=\"revealTrans(Duration=1.5,Transition=\" + Ran(22) + \")\";\r\n");
out.write(" rt1.filters.revealTrans.apply();\r\n");
out.write("\trt1.style.background=bagcolor[Ran(7)];\r\n");
out.write("\trt1.innerHTML=m[Ran(6)];\r\n");
out.write(" rt1.filters.revealTrans.play();\r\n");
out.write(" timer = setTimeout(\"play_rt()\",3000)\r\n");
out.write("}\r\n");
out.write("</SCRIPT>\r\n");
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("验证码错误");
}
}
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("<script type=\"text/javascript\">\r\n");
out.write("function check()\r\n");
out.write("{\r\n");
out.write(" if (form.name.value==\"\")\r\n");
out.write(" {\r\n");
out.write(" alert(\"请输入用户名!!!\");\r\n");
out.write(" form.name.focus();\r\n");
out.write(" return false;\r\n");
out.write(" }\r\n");
out.write(" if (form.Password.value==\"\")\r\n");
out.write(" {\r\n");
out.write(" alert(\"请输入密码!!!\");\r\n");
out.write(" form.name.focus();\r\n");
out.write(" return false;\r\n");
out.write(" }\r\n");
out.write("}\r\n");
out.write("</SCRIPT>\r\n");
out.write("\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<title>教材购销管理网页</title>\r\n");
out.write("\r\n");
out.write("<link href=\"css4.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n");
out.write("<script type=\"text/javascript\" language=\"javascript\" src=\"script.js\"></script>\r\n");
out.write("</head>\r\n");
out.write("<center>\r\n");
out.write("<body onload=\"play_rt();menuSlider.init('menu','slide')\">\r\n");
out.write("<!--css布局container容器-->\r\n");
out.write("<div id=\"container\">\r\n");
out.write("<!--css布局Sidebar1栏-->\r\n");
out.write("<div id=Sidebar1>\r\n");
out.write("<center>\r\n");
out.write("<table width=100% height=600 border=2 cellpadding=2 cellspacing=8 style=\"border-collapse:collapse;\" bordercolor=\"threeddarkshadow\" >\r\n");
out.write("<TBODY>\r\n");
out.write("<TR>\r\n");
out.write("<TD>\r\n");
out.write("<marquee direction=\"left\" scrollamount=\"2\" scrolldelay=\"1\" width=\"100\" height=\"100\"> <font color=\"red\"> 没书了!别购了!</font></marquee>\r\n");
out.write("</TD>\r\n");
out.write("<TR>\r\n");
out.write("<TD><a href=\"jsp1.jsp\">申请教材1</a></TD></TR>\r\n");
out.write("<TR>\r\n");
out.write("<TD><a href=\"jsp1.jsp\">申请教材2</a></TD></TR>\r\n");
out.write("<TR><TD><a href=\"jsp1.jsp\">申请教材3</a></TD></TR>\r\n");
out.write("<TR><TD><a href=\"jsp1.jsp\">申请教材4</a></TD></TR>\r\n");
out.write("<TR><TD><font color=\"red\" >本站连接</font></TD></TR>\r\n");
out.write("<TR><TD><a href=\"www.baidu.com\">百度</a></TD></TR>\r\n");
out.write("</TBODY></TABLE>\r\n");
out.write("<br>\r\n");
out.write("\r\n");
out.write("</center>\r\n");
out.write("</div>\r\n");
out.write(" <div id=\"Header\"></div>\r\n");
out.write("<!-- dasasdasd-->\r\n");
out.write(" <div id=\"slide\"><div class=\"menu\">\r\n");
out.write(" <ul id=\"menu\">\r\n");
out.write(" <li><a href=\"jsp1.jsp\">申请教材</a></li>\r\n");
out.write(" <li><a href=\"2.jsp\">查看借阅历史</a></li>\r\n");
out.write(" <li><a href=\"jsp3.jsp\">查看教材库</a></li>\r\n");
out.write(" <li value=\"1\"><a href=\"#\">相册</a></li>\r\n");
out.write(" <li><a href=\"#\">论坛</a></li>\r\n");
out.write(" <li><a href=\"#\">离开</a></li>\r\n");
out.write(" </ul> \r\n");
out.write(" <div id=\"banner\">\r\n");
out.write("\r\n");
out.write(" </div>\r\n");
out.write("<FORM Action=\"ss.jsp\" method=\"POST\" name=\"myform\">\r\n");
out.write("搜索 :<input type=\"text\" name=\"sousuo\" style=\"height:18px;width:120px\">\r\n");
out.write("<input type=\"submit\" name=\"sousuo\" value=\"搜 索\" >\r\n");
out.write("</FORM></div></div>\r\n");
out.write("<!-- dasasdasd-->\r\n");
out.write(" <div id=\"PageBody\">\r\n");
out.write("<form name=\"form\" onsubmit=\"return check()\" action=\"jsp2.jsp\" method=\"post\">\r\n");
out.write("\r\n");
out.write("用户\r\n");
out.write("<input type=\"text\" name=\"name\" style=\"height:18px;width:100px\">\r\n");
out.write("密码\r\n");
out.write("<input type=\"password\" name=\"Password\" style=\"height:18px;width:100px\">\r\n");
out.write(" \r\n");
out.write("认证码:\r\n");
out.write(" <input type=text name=rand maxlength=4 value=\"\" size=6>\r\n");
out.write(" \r\n");
out.write(" <img border=1 src=\"image.jsp\">\r\n");
out.write("<input type=\"submit\" name=\"submit\" value=\" 登陆\"><A href=\"zc1.jsp\">注册新用户</A><br>\r\n");
out.write("</form>\r\n");
out.write(" <div id=\"Sidebar\">\r\n");
out.write("新闻发布区\r\n");
out.write("<table height=100 border=2 cellpadding=2 cellspacing=8 >\r\n");
out.write("<TBODY>\r\n");
out.write("<TR>\r\n");
out.write("<TD>\r\n");
out.write("<marquee direction=\"left\" scrollamount=\"2\" scrolldelay=\"1\" width=\"100\" height=\"100\"> <font color=\"red\"> 没书了!别购了!</font></marquee>\r\n");
out.write("</TD></TR></TBODY></TABLE>\r\n");
out.write("<TABLE WIDTH=\"160\" BORDER=\"1\" HEIGHT=\"82\">\r\n");
out.write("<TR >\r\n");
out.write("<TD id=\"rt1\" HEIGHT=\"82\"></TD>\r\n");
out.write("</TR>\r\n");
out.write("</TABLE>\r\n");
out.write("<div id=\"templayer\" style=\"position:absolute;left:0;top:0;visibility:hidden\"></div>\r\n");
out.write(" </div>\r\n");
out.write(" <div id=\"MainBody\">\r\n");
out.write("教材更新发布区<BR>\r\n");
out.write("<TABLE WIDTH=\"500\" BORDER=\"0\" HEIGHT=\"120\">\r\n");
out.write("<TR >\r\n");
out.write(" <td align=center><font color=\"#309aff\">教材名</font></td>\r\n");
out.write(" <td align=center><font color=\"#309aff\">单价</font></td>\r\n");
out.write(" <td align=center><font color=\"#309aff\">出版社</font></td>\r\n");
out.write("<td align=center><font color=\"#309aff\">教材图片</font></td></tr>\r\n");
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("<tr><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) {}
out.write("\r\n");
out.write("\r\n");
out.write("</TABLE>\r\n");
out.write("<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\">\r\n");
out.write("</marquee>\r\n");
out.write(" </div>\r\n");
out.write(" </div>\r\n");
out.write(" <div id=\"Footer\">\r\n");
out.write("链接\r\n");
out.write(" </div>\r\n");
out.write("</div>\r\n");
out.write("<A href=\"jsp1.jsp?getname;\">申请教材</A>\r\n");
out.write("‖\r\n");
out.write("<A href=\"jsp2.jsp\">查看借阅历史</A>\r\n");
out.write("‖\r\n");
out.write("<A href=\"jsp3.jsp\">查看学生记录</A>\r\n");
out.write("‖\r\n");
out.write("<A href=\"jsp4.jsp\">离开教材购销管理系统</A>\r\n");
out.write("‖\r\n");
out.write("<A href=\"jsp1.jsp\"onclick=window.close();>离开</A>\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -