?? buy_0002ejsp_jsp.java
字號:
import jxc.ConnectionManager;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
public class buy_0002ejsp_jsp extends HttpJspBase {
static {
}
public buy_0002ejsp_jsp( ) {
}
private static boolean _jspx_inited = false;
public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
}
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;
String _value = null;
try {
if (_jspx_inited == false) {
synchronized (this) {
if (_jspx_inited == false) {
_jspx_init();
_jspx_inited = true;
}
}
}
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
"", true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
// HTML // begin [file="/buy.jsp";from=(0,122);to=(3,0)]
out.write("\r\n<html><title>進貨</title>\r\n<body>\r\n");
// end
// HTML // begin [file="/header.jsp";from=(0,0);to=(16,0)]
out.write("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n <td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr align=\"center\"> \r\n <td height=\"100\" colspan=\"5\"><font size=\"+3\">小型超市進銷存系統</font></td>\r\n </tr>\r\n <tr align=\"center\"> \r\n <td width=\"25%\"><a href=\"buy.jsp\">進貨登記</a></td>\r\n <td width=\"25%\"><a href=\"sale.jsp\">銷售登記</a></td>\r\n <td width=\"25%\"><a href=\"resQuery.jsp\">庫存查詢</a></td>\r\n <td width=\"25%\"><a href=\"logout.jsp\">退出</a></td>\r\n <td width=\"25%\"> </td>\r\n </tr>\r\n </table></td>\r\n </tr>\r\n</table>\r\n");
// end
// HTML // begin [file="/buy.jsp";from=(3,32);to=(14,16)]
out.write("\r\n<table width=\"800\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr>\r\n <td><form action=\"/jxc/buyservlet.do\" method=\"post\">\r\n <table width=\"80%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"2\">\r\n <tr align=\"center\">\r\n <td colspan=\"2\">進貨</td>\r\n </tr>\r\n <tr>\r\n <td width=\"246\" align=\"right\">供貨商名稱</td>\r\n <td width=\"388\"><select name=\"supplierID\" id=\"supplierID\">\r\n ");
// end
// begin [file="/buy.jsp";from=(14,18);to=(24,0)]
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
conn = ConnectionManager.getConnection();
stmt = conn.prepareStatement("select * from Supplier");
rs = stmt.executeQuery();
while (rs.next()) {
// end
// HTML // begin [file="/buy.jsp";from=(24,2);to=(25,31)]
out.write("\r\n <option value=\"");
// end
// begin [file="/buy.jsp";from=(25,34);to=(25,60)]
out.print(rs.getString("supplierID"));
// end
// HTML // begin [file="/buy.jsp";from=(25,62);to=(25,64)]
out.write("\">");
// end
// begin [file="/buy.jsp";from=(25,67);to=(25,95)]
out.print(rs.getString("supplierName"));
// end
// HTML // begin [file="/buy.jsp";from=(25,97);to=(26,16)]
out.write("</option>\r\n ");
// end
// begin [file="/buy.jsp";from=(26,18);to=(28,0)]
}
// end
// HTML // begin [file="/buy.jsp";from=(28,2);to=(35,16)]
out.write("\r\n \r\n </select></td>\r\n </tr>\r\n <tr>\r\n <td align=\"right\">商品名稱</td>\r\n <td><select name=\"wareID\" id=\"wareID\">\r\n ");
// end
// begin [file="/buy.jsp";from=(35,18);to=(42,0)]
rs.close();
stmt.close();
stmt = conn.prepareStatement("select * from Ware");
rs = stmt.executeQuery();
while (rs.next()) {
// end
// HTML // begin [file="/buy.jsp";from=(42,2);to=(43,31)]
out.write("\r\n <option value=\"");
// end
// begin [file="/buy.jsp";from=(43,34);to=(43,56)]
out.print(rs.getString("wareID"));
// end
// HTML // begin [file="/buy.jsp";from=(43,58);to=(43,60)]
out.write("\">");
// end
// begin [file="/buy.jsp";from=(43,63);to=(43,87)]
out.print(rs.getString("wareName"));
// end
// HTML // begin [file="/buy.jsp";from=(43,89);to=(44,16)]
out.write("</option>\r\n ");
// end
// begin [file="/buy.jsp";from=(44,18);to=(49,0)]
}
rs.close();
stmt.close();
conn.close();
// end
// HTML // begin [file="/buy.jsp";from=(49,2);to=(78,7)]
out.write("\r\n \r\n </select></td>\r\n </tr>\r\n <tr>\r\n <td align=\"right\">商品價格</td>\r\n <td><input name=\"buyPrice\" type=\"text\" id=\"buyPrice\"></td>\r\n </tr>\r\n <tr>\r\n <td height=\"24\" align=\"right\">購買數量</td>\r\n <td><input name=\"buyQty\" type=\"text\" id=\"buyQty\"></td>\r\n </tr>\r\n <tr>\r\n <td align=\"right\">購買時間(格式如2003-5-20)</td>\r\n <td><input name=\"buyDate\" type=\"text\" id=\"buyDate\"></td>\r\n </tr>\r\n <tr>\r\n <td align=\"right\">購買人</td>\r\n <td><input name=\"buyPerson\" type=\"text\" id=\"buyPerson\"></td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td><input type=\"submit\" name=\"Submit\" value=\"確定\"> <input type=\"reset\" name=\"Submit2\" value=\"清空\"></td>\r\n </tr>\r\n </table>\r\n </form></td>\r\n </tr>\r\n</table>\r\n</body>\r\n</html>");
// end
} catch (Throwable t) {
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -