📄 jsp1_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
public final class jsp1_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
int bjiage=1;
int balljiage=1;
int booknum=1;
int n1=1;
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=GBK");
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');
out.write('\n');
out.write("\r\n");
out.write("<link href=\"2.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n");
out.write("<script type=\"text/javascript\">\r\n");
out.write("function mycheck(){\r\n");
out.write("alert(\"恭喜，申请成功，请转入发票页！\");\r\n");
out.write("response.sendRedirect(\"jsp6.jsp\");\r\n");
out.write("}\r\n");
out.write("</script>\r\n");
out.write("\r\n");
out.write("<HTML><BODY><center>\r\n");
out.write("<div id=\"container\">\r\n");
out.write("\r\n");
out.write("<center><font SIZE=\"30\" color=\"red\">申请教材\r\n");
out.write("</font>\r\n");
out.write("<marquee direction=\"left\" scrollamount=\"2\" scrolldelay=\"1\" width=\"150\" height=\"80\"> <img border=1 src=\"images/1.png\"><img border=1 src=\"images/2.png\"><img border=1 src=\"images/3.png\"><img border=1 src=\"images/4.png\"><img border=1 src=\"images/5.png\"><img border=1 src=\"images/6.png\"><img border=1 src=\"images/7.png\">\r\n");
out.write("</marquee>\r\n");
out.write(" <div id=\"Header\"><div id=\"menu\">\r\n");
out.write("<ul>\r\n");
out.write(" <li><a href=\"jsp3.jsp\">查看可申请教材目录</a></li>\r\n");
out.write(" <li class=\"menuDiv\"></li>\r\n");
out.write(" <li><a href=\"jsp2.jsp\">返回主页</a><br></li>\r\n");
out.write(" <li class=\"menuDiv\"></li>\r\n");
out.write("</ul>\r\n");
out.write("</div></div> \r\n");
out.write("<html><body>\r\n");
String getsno = request.getParameter("sno");
String getbnum = request.getParameter("bnum");
String getbooknum= request.getParameter("booknum");
out.write("\r\n");
out.write("<A href=jsp6.jsp?sno=");
out.print(getsno);
out.write(">\r\n");
out.write("<center><font SIZE=\"30\" color=\"red\">领取发票</font></A>\r\n");
Statement stmt=null;
PreparedStatement pstmt=null;
String str = "select * from s where bnum='"+getbnum+"'";
//加载JDBC-ODBC桥驱动
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//定义JDBC URL
}catch (Exception e) {
out.println(e.getMessage());
}
try{ System.out.print("SQL:" + str);
String url = "jdbc:odbc:s";
//得到与数据库的连接
Connection con = DriverManager.getConnection(url);
stmt = con.createStatement();
ResultSet g = stmt.executeQuery(str);
while(g.next())
{
bjiage=g.getInt("bjiage");
balljiage=Integer.parseInt(getbooknum)*bjiage;
booknum=g.getInt("booknum");
n1 = booknum- Integer.parseInt(getbooknum);
if(n1>=0)
{
str= "update s set booknum='"+n1 +"' where bnum like'"+getbnum+"'";
ResultSet h = stmt.executeQuery(str);
}
else
{
out.print("<script>type='text/JavaScript'>alert('对不起 该教材已经没有库存！请等候通知');</script>");
String sstr= "insert into waitbuybook(sno,bnum,booknum) VALUES("+getsno+"," +getbnum + "," +n1+ ")";
ResultSet h= stmt.executeQuery(sstr);
}
}
} catch (Exception e) {}
String sql = "insert into fapiao(sno,bnum,bjiage,booknum,balljiage) VALUES(" +getsno+
"," +getbnum + "," +bjiage + "," +getbooknum + "," +balljiage + ")";
//加载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);
ResultSet p = stmt.executeQuery(sql);
} catch (Exception e) {}
out.write("\r\n");
out.write("<FORM Action=\"jsp1.jsp\" method=\"POST\" name=\"myform\">\r\n");
out.write("请输入学号<input type=\"text\" name=\"sno\" style=\"height:18px;width:100px\"> \r\n");
out.write("请输入要申请的教材号<input type=\"text\" name=\"bnum\" style=\"height:18px;width:100px\"> \r\n");
out.write("请输入要申请的教材数量<input type=\"text\" name=\"booknum\" style=\"height:18px;width:100px\"> \r\n");
out.write("<br><br><br><br><br><input type=submit name=\"submit\" value=\"申请教材\" onclick=\"mycheck()\">\r\n");
out.write("</FORM></center>\r\n");
out.write("<input type=\"button\" name = \"a\" value = \"返回\" onclick = \"javacscript:history.back()\">\r\n");
out.write("</HTML></BODY>\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 + -