?? resquery_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 resQuery_0002ejsp_jsp extends HttpJspBase {
static {
}
public resQuery_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="/resQuery.jsp";from=(0,122);to=(6,0)]
out.write("\r\n<html>\r\n<head>\r\n<title>庫存查詢</title>\r\n</head>\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="/resQuery.jsp";from=(6,32);to=(17,0)]
out.write("\r\n<table width=\"800\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr>\r\n <td><form action=\"/jxc/resquery.do\" method=\"post\">\r\n <table width=\"80%\" border=\"0\" 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=\"256\" align=\"right\">商品名稱</td>\r\n <td width=\"384\"><select name=\"wareID\">\r\n");
// end
// begin [file="/resQuery.jsp";from=(17,2);to=(27,0)]
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
conn = ConnectionManager.getConnection();
stmt = conn.prepareStatement("select * from Ware");
rs = stmt.executeQuery();
while (rs.next()) {
// end
// HTML // begin [file="/resQuery.jsp";from=(27,2);to=(28,31)]
out.write("\r\n <option value=\"");
// end
// begin [file="/resQuery.jsp";from=(28,34);to=(28,56)]
out.print(rs.getString("wareID"));
// end
// HTML // begin [file="/resQuery.jsp";from=(28,58);to=(28,60)]
out.write("\">");
// end
// begin [file="/resQuery.jsp";from=(28,63);to=(28,87)]
out.print(rs.getString("wareName"));
// end
// HTML // begin [file="/resQuery.jsp";from=(28,89);to=(29,0)]
out.write("</option>\r\n");
// end
// begin [file="/resQuery.jsp";from=(29,2);to=(34,0)]
}
rs.close();
stmt.close();
conn.close();
// end
// HTML // begin [file="/resQuery.jsp";from=(34,2);to=(46,7)]
out.write("\r\n </select></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 + -