public void _jspService( javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws java.io.IOException, javax.servlet.ServletException { javax.servlet.http.HttpSession session = request.getSession(true); com.caucho.server.webapp.Application _jsp_application = _caucho_getApplication(); javax.servlet.ServletContext application = _jsp_application; com.caucho.jsp.PageContextImpl pageContext = com.caucho.jsp.QJspFactory.allocatePageContext( this, _jsp_application, request, response, "/error.jsp", session, 8192, true); javax.servlet.jsp.JspWriter out = pageContext.getOut(); javax.servlet.ServletConfig config = getServletConfig(); javax.servlet.Servlet page = this; response.setContentType("text/html"); try { out.write(_jsp_string0, 0, _jsp_string0.length); out.print(((String) session.getAttribute("user"))); out.write(_jsp_string1, 0, _jsp_string1.length); out.print(((String) session.getAttribute("db"))); out.write(_jsp_string2, 0, _jsp_string2.length); // get all tables in the database ConDB dbcon = (ConDB) session.getAttribute("dbcon"); Connection conn = dbcon.get(); int total_rec = 0; int total_table = 0; String sql = "show tables"; PreparedStatement pstm = null; ResultSet rs = null; try { pstm = conn.prepareStatement(sql); rs = pstm.executeQuery(); } catch (SQLException e) { out.println(e); } // count the records of each table while (rs.next()) { String curr_tb = rs.getString(1); int curr_rec = 0; PreparedStatement pstm_rec = null; ResultSet rs_rec = null; sql = "select count(*) from " + curr_tb; try { pstm_rec = conn.prepareStatement(sql); rs_rec = pstm_rec.executeQuery(); } catch (SQLException e) { out.println(e); } try { if (rs_rec.next()) { curr_rec = rs_rec.getInt(1); total_rec += curr_rec; } } catch (SQLException e) { out.println(e.getErrorCode() + "---" + e.getSQLState()); } total_table++; out.write(_jsp_string3, 0, _jsp_string3.length); out.print((total_table & 1)); out.write(_jsp_string4, 0, _jsp_string4.length); out.print((curr_tb)); out.write(_jsp_string5, 0, _jsp_string5.length); out.print((curr_tb)); out.write(_jsp_string6, 0, _jsp_string6.length); out.print((curr_tb)); out.write(_jsp_string7, 0, _jsp_string7.length); out.print((curr_tb)); out.write(_jsp_string8, 0, _jsp_string8.length); out.print((curr_tb)); out.write(_jsp_string9, 0, _jsp_string9.length); out.print((curr_rec)); out.write(_jsp_string10, 0, _jsp_string10.length); } out.write(_jsp_string11, 0, _jsp_string11.length); out.print((total_table)); out.write(_jsp_string12, 0, _jsp_string12.length); out.print((total_rec)); out.write(_jsp_string13, 0, _jsp_string13.length); out.print((session.getAttribute("db"))); out.write(_jsp_string14, 0, _jsp_string14.length); } catch (java.lang.Throwable _jsp_e) { pageContext.handlePageException(_jsp_e); } finally { com.caucho.jsp.QJspFactory.freePageContext(pageContext); } }
public void _jspService(HttpServletRequest request, HttpServletResponse response) throws java.io.IOException, ServletException { 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 { response.setContentType("text/html"); 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("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("<!--%@ page errorPage=\"/error.jsp\" %-->\n"); response.setHeader("Pragma", "no-cache"); // HTTP 1.0 response.setDateHeader("Expires", 0); response.setHeader("Cache-Control", "no-cache"); // HTTP 1.1 String _adminid = ""; String _adminname = ""; String _admintype = ""; String _admingroup = ""; String _approval = ""; String _adminclass = ""; String _adminmail = ""; try { _adminid = (String) session.getAttribute("adminid"); if (_adminid == null || _adminid.length() == 0 || _adminid.equals("null")) { response.sendRedirect("/admin/login_first.html"); return; } _adminname = (String) session.getAttribute("adminname"); _admintype = (String) session.getAttribute("admintype"); _admingroup = (String) session.getAttribute("admingroup"); _approval = (String) session.getAttribute("approval"); _adminclass = (String) session.getAttribute("adminclass"); _adminmail = (String) session.getAttribute("admin_email"); // session.setMaxInactiveInterval(60*60); } catch (Exception e) { response.sendRedirect("/admin/login_first.html"); return; } out.write('\n'); out.write('\n'); out.write('\n'); String password = request.getParameter("password"); String fromURL = request.getParameter("fromURL"); String oldPassword = ""; String sql = ""; int iCnt = 0; boolean isSucceeded = false; String strMsg = ""; Connection conn = null; MatrixDataSet matrix = null; DataProcess dataProcess = null; PreparedStatement pstmt = null; String targetUrl = ""; try { if (password.equals("1111")) { throw new UserDefinedException( "The new password is not acceptable. Change your password."); } Context ic = new InitialContext(); DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/scm"); conn = ds.getConnection(); matrix = new dbconn.MatrixDataSet(); dataProcess = new DataProcess(); sql = " select password " + " from admin_01t " + " where adminid = '" + _adminid + "' "; iCnt = dataProcess.RetrieveData(sql, matrix, conn); if (iCnt > 0) { oldPassword = matrix.getRowData(0).getData(0); } else { throw new UserDefinedException("Can't find User Information."); } if (password.equals(oldPassword)) { throw new UserDefinedException( "The new password is not acceptable. Change your password."); } // update ó¸®... int idx = 0; conn.setAutoCommit(false); sql = " update admin_01t " + " set password = ?, pw_date = sysdate() " + " where adminid = ? "; pstmt = conn.prepareStatement(sql); pstmt.setString(++idx, password); pstmt.setString(++idx, _adminid); iCnt = pstmt.executeUpdate(); if (iCnt != 1) { throw new UserDefinedException("Password update failed."); } conn.commit(); isSucceeded = true; } catch (UserDefinedException ue) { try { conn.rollback(); } catch (Exception ex) { } strMsg = ue.getMessage(); } catch (Exception e) { try { conn.rollback(); } catch (Exception ex) { } System.out.println("Exception /admin/resetAdminPasswd : " + e.getMessage()); throw e; } finally { if (pstmt != null) { try { pstmt.close(); } catch (Exception e) { } } if (conn != null) { try { conn.setAutoCommit(true); } catch (Exception e) { } conn.close(); } } // °á°ú ¸Þ½ÃÁö ó¸® if (isSucceeded) { // where to go? if (fromURL.equals("menu")) { targetUrl = ""; } else { targetUrl = "/admin/index2.jsp"; } strMsg = "The data are successfully processed."; } else { strMsg = "The operation failed.\\n" + strMsg; targetUrl = "/admin/resetAdminPasswdForm.jsp"; } out.write("\n"); out.write("<html>\n"); out.write("<head>\n"); out.write("<title></title>\n"); out.write("<link href=\"/common/css/style.css\" rel=\"stylesheet\" type=\"text/css\">\n"); out.write("</head>\n"); out.write("<body leftmargin='0' topmargin='0' marginwidth='0' marginheight='0'>\n"); out.write("<form name=\"form1\" method=\"post\" action=\""); out.print(targetUrl); out.write("\">\n"); out.write("<input type='hidden' name='fromURL' value='"); out.print(fromURL); out.write("'>\n"); out.write("</form>\n"); out.write("<script language=\"javascript\">\n"); if (targetUrl.length() > 0) { out.write("\n"); out.write(" alert('"); out.print(strMsg); out.write("');\n"); out.write(" document.form1.submit();\n"); } out.write("\n"); out.write("</script>\n"); out.write("<table width='840' border='0' cellspacing='0' cellpadding='0'><tr><td>\n"); out.write("\n"); out.write("<table width='99%' border='0' cellspacing='0' cellpadding='0'>\n"); out.write("<tr>\n"); out.write(" <td height='15' colspan='2'></td>\n"); out.write("</tr>\n"); out.write("<tr>\n"); out.write(" <td width='3%'><img src='/img/title_icon.gif'></td>\n"); out.write(" <td width='*' class='left_title'>Password Change</td>\n"); out.write("</tr>\n"); out.write("<tr>\n"); out.write(" <td width='100%' height='2' colspan='2'><hr width='100%'></td>\n"); out.write("</tr>\n"); out.write("<tr>\n"); out.write(" <td height='10' colspan='2'></td>\n"); out.write("</tr>\n"); out.write("</table>\n"); out.write("\n"); out.write("<table width='90%' border='0' cellspacing='0' cellpadding='0' align='center'>\n"); out.write("<tr>\n"); out.write(" <td width='100%' align='center'><img border=\"0\" src=\"/img/pass.jpg\">\n"); out.write(" <br><br>\n"); out.write(" <b>The Password has been changed successfully.</b></td>\n"); out.write("</tr>\n"); out.write("</table>\n"); out.println(CopyRightLogo()); out.write("\n"); out.write("</tr></td></table>\n"); out.write("</body>\n"); out.write("</html>"); } catch (Throwable t) { if (!(t instanceof SkipPageException)) { out = _jspx_out; if (out != null && out.getBufferSize() != 0) try { out.clearBuffer(); } catch (java.io.IOException e) { } if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); } } finally { _jspxFactory.releasePageContext(_jspx_page_context); } }
public void _jspService( final javax.servlet.http.HttpServletRequest request, final javax.servlet.http.HttpServletResponse response) throws java.io.IOException, javax.servlet.ServletException { final java.lang.String _jspx_method = request.getMethod(); if (!"GET".equals(_jspx_method) && !"POST".equals(_jspx_method) && !"HEAD".equals(_jspx_method) && !javax.servlet.DispatcherType.ERROR.equals(request.getDispatcherType())) { response.sendError( HttpServletResponse.SC_METHOD_NOT_ALLOWED, "JSPs only permit GET POST or HEAD"); return; } final javax.servlet.jsp.PageContext pageContext; javax.servlet.http.HttpSession session = null; final javax.servlet.ServletContext application; final javax.servlet.ServletConfig config; javax.servlet.jsp.JspWriter out = null; final java.lang.Object page = this; javax.servlet.jsp.JspWriter _jspx_out = null; javax.servlet.jsp.PageContext _jspx_page_context = null; try { response.setContentType("text/html"); 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'); String username = ""; if (session.getAttribute("login") != null) { username = session.getAttribute("login").toString(); } else { out.println("Invalid session! You must log back into the system."); return; } String outputMsg = "TODO"; ResultSet employeeRevRes = null; String JDBC_DRIVER = "com.mysql.jdbc.Driver"; String DB_URL = "jdbc:mysql://localhost:3306/SilkRoad 5.0"; String USER = "******"; String PASS = "******"; Statement stmt = null; String sql = null; Connection conn = null; CallableStatement cs = null; try { // Register JDBC driver Class.forName(JDBC_DRIVER).newInstance(); // Open a connection conn = java.sql.DriverManager.getConnection(DB_URL, USER, PASS); System.out.println("HERE"); cs = conn.prepareCall("call GetEmployeeRevenues()"); cs.execute(); employeeRevRes = cs.getResultSet(); // TODO. Error handling out.write("\r\n"); out.write(" <html lang=\"en\">\r\n"); out.write(" <head>\r\n"); out.write(" <meta charset=\"utf-8\">\r\n"); out.write(" <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n"); out.write( " <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\r\n"); out.write( " <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->\r\n"); out.write(" <title>Silk Road 5.0</title>\r\n"); out.write(" <!-- Bootstrap -->\r\n"); out.write(" <link href=\"css/bootstrap.min.css\" rel=\"stylesheet\">\r\n"); out.write(" "); out.write("\r\n"); out.write( " <link href=\"css/responsive.bootstrap.min.css\" rel=\"stylesheet\" type=\"text/css\">\r\n"); out.write( " <link href=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/css/bootstrap-dialog.min.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n"); out.write(" <!-- Our own custom css -->\r\n"); out.write( " <link href=\"css/stylesheet.css\" rel=\"stylesheet\" type=\"text/css\">\r\n"); out.write( " <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->\r\n"); out.write( " <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->\r\n"); out.write(" <!--[if lt IE 9]>\r\n"); out.write( " <script src=\"https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js\"></script>\r\n"); out.write( " <script src=\"https://oss.maxcdn.com/respond/1.4.2/respond.min.js\"></script>\r\n"); out.write(" <![endif]-->\r\n"); out.write(" <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->\r\n"); out.write(" <script src=\"js/jquery-1.11.3.min.js\"></script>\r\n"); out.write(" <script src=\"js/jquery.validate.js\"></script>\r\n"); out.write(" "); out.write("\r\n"); out.write( " <!-- Include all compiled plugins (below), or include individual files as needed -->\r\n"); out.write(" <script src=\"js/bootstrap.min.js\"></script>\r\n"); out.write( " <script src=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/js/bootstrap-dialog.min.js\"></script>\r\n"); out.write(" <script src=\"js/pattern.js\"></script>\r\n"); out.write(" <script src=\"js/script.js\"></script>\r\n"); out.write(" <script src=\"js/editCustomer.js\"></script>\r\n"); out.write(" </head>\r\n"); out.write(" <nav class=\"navbar\">\r\n"); out.write(" <div class=\"container-fluid\">\r\n"); out.write(" <!-- Brand and toggle get grouped for better mobile display -->\r\n"); out.write(" <div class=\"navbar-header\">\r\n"); out.write( " <button type=\"button\" class=\"navbar-toggle collapsed\" data-toggle=\"collapse\" data-target=\"#bs-example-navbar-collapse-1\" aria-expanded=\"false\">\r\n"); out.write(" <span class=\"sr-only\">Toggle navigation</span>\r\n"); out.write(" <span class=\"icon-bar\"></span>\r\n"); out.write(" <span class=\"icon-bar\"></span>\r\n"); out.write(" <span class=\"icon-bar\"></span>\r\n"); out.write(" </button>\r\n"); out.write(" </div>\r\n"); out.write(" <!-- navbar-header -->\r\n"); out.write( " <!-- Collect the nav links, forms, and other content for toggling -->\r\n"); out.write(" <div class=\"myNavbar\">\r\n"); out.write(" <ul class=\"nav\">\r\n"); out.write( " <li class=\"floatLeft\"><a href=\"ManagerInformation.jsp\">Home</a></li>\r\n"); out.write( " <li class=\"dropdown navbar-right\" style=\"padding-left:125px;\">\r\n"); out.write( " <a data-target=\"#collapseHelp\" data-toggle=\"collapse\">Help<span class=\"caret\"></span></a>\r\n"); out.write(" <ul>\r\n"); out.write(" <div id=\"collapseHelp\" class=\"dropdown-menu\">\r\n"); out.write( " <li><a href=\"javascript:showEmployeeScreenHelp()\">Screens</a></li>\r\n"); out.write(" <br>\r\n"); out.write( " <li><a href=\"javascript:showAuctionHelp()\">Auctions</a></li>\r\n"); out.write(" <br>\r\n"); out.write(" </div>\r\n"); out.write(" </ul>\r\n"); out.write(" </li>\r\n"); out.write( " <li class=\"dropdown navbar-right\" style=\"padding-left:200px;\">\r\n"); out.write( " <a data-target=\"#collapseMenu\" data-toggle=\"collapse\" >Menu<span class=\"caret\"></span></a>\r\n"); out.write(" <ul>\r\n"); out.write(" <div id=\"collapseMenu\" class=\"dropdown-menu\">\r\n"); out.write(" </div>\r\n"); out.write(" </ul>\r\n"); out.write(" </li>\r\n"); out.write(" </ul>\r\n"); out.write(" <!-- .nav -->\r\n"); out.write(" </div>\r\n"); out.write(" <!-- .myNavbar -->\r\n"); out.write(" </div>\r\n"); out.write(" <!-- .container-fluid -->\r\n"); out.write(" </nav>\r\n"); out.write(" <body class=\"auctionHouseBody\">\r\n"); out.write( " <h4 class=\"auctionTableHeader\">Highest Grossing Employee</h4>\r\n"); out.write( " <table id =\"bestSellersTable\" class=\"table table-striped table-bordered dt-responsive nowrap auctionHouseTable\">\r\n"); out.write(" <thead>\r\n"); out.write(" <tr>\r\n"); out.write(" <th>Employee ID</th>\r\n"); out.write(" <th>Username</th>\r\n"); out.write(" <th>Revenue</th>\r\n"); out.write(" </tr>\r\n"); out.write(" </thead>\r\n"); out.write(" <tbody>\r\n"); out.write(" "); while (employeeRevRes.next()) { out.write("\r\n"); out.write(" <tr>\r\n"); out.write(" <td>\r\n"); out.write(" "); out.print(employeeRevRes.getString("EmployeeID")); out.write("\r\n"); out.write(" </td>\r\n"); out.write(" <td>\r\n"); out.write(" "); out.print(employeeRevRes.getString("Username")); out.write("\r\n"); out.write(" </td>\r\n"); out.write(" <td>\r\n"); out.write(" "); out.print(employeeRevRes.getDouble("Revenue")); out.write("\r\n"); out.write(" </td>\r\n"); out.write(" </tr>\r\n"); out.write(" "); } out.write("\r\n"); out.write(" </tbody>\r\n"); out.write(" </table>\r\n"); out.write(" </body>\r\n"); out.write(" </html>\r\n"); out.write("\r\n"); out.write(" "); } catch (Exception e) { e.printStackTrace(); } finally { try { conn.close(); } catch (Exception ee) { } ; } out.write('\r'); out.write('\n'); } catch (java.lang.Throwable t) { if (!(t instanceof javax.servlet.jsp.SkipPageException)) { out = _jspx_out; if (out != null && out.getBufferSize() != 0) try { if (response.isCommitted()) { out.flush(); } else { out.clearBuffer(); } } catch (java.io.IOException e) { } if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); else throw new ServletException(t); } } finally { _jspxFactory.releasePageContext(_jspx_page_context); } }
public void _jspService( final javax.servlet.http.HttpServletRequest request, final javax.servlet.http.HttpServletResponse response) throws java.io.IOException, javax.servlet.ServletException { final javax.servlet.jsp.PageContext pageContext; javax.servlet.http.HttpSession session = null; final javax.servlet.ServletContext application; final javax.servlet.ServletConfig config; javax.servlet.jsp.JspWriter out = null; final java.lang.Object page = this; javax.servlet.jsp.JspWriter _jspx_out = null; javax.servlet.jsp.PageContext _jspx_page_context = null; try { response.setContentType("text/html"); pageContext = _jspxFactory.getPageContext( this, request, response, "ReportErrorPage.jsp?page=EditTargetReportForm.jsp", true, 8192, true); _jspx_page_context = pageContext; application = pageContext.getServletContext(); config = pageContext.getServletConfig(); session = pageContext.getSession(); out = pageContext.getOut(); _jspx_out = out; out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); org.apache.jasper.runtime.JspRuntimeLibrary.include( request, response, "header.jsp", out, false); out.write(' '); out.write('\n'); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\t<!-- files for JqxWidget grid -->\n"); out.write( " <link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.base.css\" type=\"text/css\" />\n"); out.write( " <link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.darkblue.css\" type=\"text/css\" />\n"); out.write( "\t<link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.ui-redmond.css\" type=\"text/css\" />\n"); out.write("\t\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/gettheme.js\"></script>\n"); out.write("\t<script type=\"text/javascript\" src=\"js/jquery-1.10.2.min.js\"></script>\n"); out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxcore.js\"></script>\n"); out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdata.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxbuttons.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxscrollbar.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxlistbox.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxcalendar.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdatetimeinput.js\"></script>\n"); out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.filter.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.selection.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.sort.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.pager.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxmenu.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxlistbox.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdropdownlist.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdata.export.js\"></script> \n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.export.js\"></script> \n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.aggregates.js\"></script> \n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.grouping.js\"></script> \n"); out.write("\n"); out.write("\n"); out.write("\t\n"); out.write("\t"); session.getAttribute("UserName").toString(); // System.out.println("session bachka maapping : "+session +" \n user // "+session.getAttribute("UserName").toString()); out.write("\n"); out.write("\n"); out.write("\n"); out.write("<script src=\"js/editCustomer_details.js\"> </script> \n"); out.write("\n"); out.write("<script type=\"text/javascript\" src=\"js/popup.js\"></script>\n"); out.write("<style>\n"); out.write("hr {\n"); out.write("color: #f00;\n"); out.write("background-color: #f00;\n"); out.write("height: 3px;\n"); out.write("}\n"); out.write("#selected_order{\n"); out.write("width: 40%;\n"); out.write("max-height: 300px;\n"); out.write("border: 1px solid black; \n"); out.write("background-color: #ECFB99;\n"); out.write("float: right;\n"); out.write("margin-top: 30px;\n"); out.write("overflow: auto;\n"); out.write("margin-right: 2%;\n"); out.write("padding: 5px;\n"); out.write("}\n"); out.write("</style>\n"); out.write("<script>\n"); out.write("\t\n"); out.write("\tfunction checkField(){\n"); out.write("\t\tif(document.myform.chckall.checked==true){\n"); out.write("\t\t\tshowHint();\n"); out.write("\t\t}\n"); out.write("\t\telse{\t\tvar c_date1,c_date2,u_date2,u_date1;\n"); out.write("\t\t\t\tif(!($(\"#createDate2\").jqxDateTimeInput('disabled'))){\n"); out.write("\t\t\t\tc_date1 = $('#createDate1').jqxDateTimeInput('getText');\n"); out.write("\t\t\t\tc_date2 = $('#createDate2').jqxDateTimeInput('getText');\n"); out.write("\t\t\t}\n"); out.write("\t\t\t\n"); out.write("\t\t\tif(!($(\"#updateDate2\").jqxDateTimeInput('disabled'))){\n"); out.write("\t\t\t\tu_date1 = $('#updateDate1').jqxDateTimeInput('getText');\n"); out.write("\t\t\t\tu_date2 = $('#updateDate2').jqxDateTimeInput('getText');\n"); out.write("\t\t\t}\t \n"); out.write("\t\t showHint();\t\t \n"); out.write("\t }\n"); out.write("\t}\n"); out.write("\tfunction showMsg(){\n"); out.write("\t \t document.myform.action=\"HomeForm.jsp\";\n"); out.write("\t \t document.myform.submit();\n"); out.write("\t}\n"); out.write("\tfunction Clear(){\n"); out.write("\t\t\n"); out.write("\t\ttry{\n"); out.write("\t\t\tdocument.getElementById(\"order_number\").focus();\n"); out.write("\t\t} catch (exp){}\n"); out.write("\t\t\n"); out.write("\t\t\n"); out.write("\t\t\n"); out.write("\t\tdocument.myform.custCode.value=\"\";\n"); out.write("\t\tdocument.myform.phonenumber.value=\"\";\n"); out.write("\t\tdocument.myform.custName.value=\"\";\n"); out.write("\t\tdocument.myform.nameString.value=\"\";\t\t\n"); out.write("\t\tdocument.myform.Building.value=\"\";\n"); out.write("\t\tdocument.myform.Building_no.value=\"\";\n"); out.write("\t\tdocument.myform.wing.value=\"\";\n"); out.write("\t\tdocument.myform.block.value=\"\";\n"); out.write("\t\tdocument.myform.add1.value=\"\";\n"); out.write("\t\tdocument.myform.add2.value=\"\";\n"); out.write("\t\tdocument.myform.area.value=\"\";\n"); out.write("\t\tdocument.myform.station.value=\"\";\n"); out.write("\t\t\n"); out.write("\t\tdocument.myform.selmonth.value=\"\";\n"); out.write("\t\t\n"); out.write( "\t\t$(\"#createDate1\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',max:new Date(),formatString: \"yyyy-MM-dd\"});\n"); out.write( "\t\t$(\"#createDate2\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',min:new Date(),max:new Date(),formatString: \"yyyy-MM-dd\",value:new Date()});\n"); out.write("\t\t$(\"#createDate2\").jqxDateTimeInput({disabled: true});\n"); out.write("\t\t\n"); out.write("\t\t\n"); out.write( "\t\t$(\"#updateDate1\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',max:new Date(),formatString: \"yyyy-MM-dd\"});\n"); out.write( "\t\t$(\"#updateDate2\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',min:new Date(),max:new Date(),formatString: \"yyyy-MM-dd\",value:new Date()});\n"); out.write("\t\t$(\"#updateDate2\").jqxDateTimeInput({disabled: true});\n"); out.write("\t\t\n"); out.write("\t\t$('#createDate1').on('close', function (event) {\n"); out.write("\t\t // Some code here. \n"); out.write("\t\t \t$(\"#createDate2\").jqxDateTimeInput({disabled: false});\n"); out.write( "\t\t \t$(\"#createDate2\").jqxDateTimeInput({min: $('#createDate1').jqxDateTimeInput('getDate')});\n"); out.write(" \t\t}); \t\n"); out.write(" \t\t\n"); out.write(" \t\t$('#updateDate1').on('close', function (event) {\n"); out.write("\t\t // Some code here. \n"); out.write("\t\t \t$(\"#updateDate2\").jqxDateTimeInput({disabled: false});\n"); out.write( "\t\t \t$(\"#updateDate2\").jqxDateTimeInput({min: $('#updateDate1').jqxDateTimeInput('getDate')});\n"); out.write(" \t\t}); \t\n"); out.write("\t\t\n"); out.write("\t\tfunEnabled();\n"); out.write("\t}\n"); out.write("\t\n"); out.write("function ckeckEmpty(){\n"); out.write("\tif(document.getElementById(\"order_number\").value == \"\"){\n"); out.write("\t\talert(\"Please Enter Order Number\");\n"); out.write("\t\tdocument.getElementById(\"order_number\").focus();\n"); out.write("\t\treturn false;\n"); out.write("\t} else {\n"); out.write("\t\treturn true;\n"); out.write("\t}\n"); out.write("}\n"); out.write("\n"); out.write("\n"); out.write("</script>\n"); String call_type = request.getParameter("call_type"); if (call_type == null) { call_type = ""; } if (call_type.equals("search_payment")) { String m = "<< Show List"; out.write("\n"); out.write("\t\t\t<div id=\"selected_order\">\n"); out.write("\t\t\t\t<b>Selected orders</b>\n"); out.write( "\t\t\t\t<form action=\"PrintSelectedCustPayment.jsp\" method=\"get\" id=\"submit_form\">\n"); out.write( "\t\t\t\t<table style=\"width: 100%;border-collapse: collapse;\" border=1 id=\"selected_order_table\">\n"); out.write("\t\t\t\t<tr>\n"); out.write("\t\t\t\t\t<th style=\"width: 20%;\">Order Number</th>\n"); out.write("\t\t\t\t\t<th style=\"width: 35%;\">Cust Name</th>\n"); out.write("\t\t\t\t\t<th style=\"width: 20%;\">Balance</th>\n"); out.write("\t\t\t\t\t<th style=\"width: 25%;\"> </th>\n"); out.write("\t\t\t\t</tr>\n"); out.write("\t\t\t\t</table>\n"); out.write("\t\t\t\t<table style=\"width: 100%;\" border=1 id=\"insert_table\">\n"); out.write("\t\t\t\t</table>\n"); out.write( "\t\t\t\t <input type=\"text\" readonly=\"readonly\" name=\"order_count\" id=\"order_count_id\" size=\"3\" value=\"0\" style=\"background-color :#ECFB99 ;\"/> orders selected to print.\n"); out.write( "\t\t\t\t<input type=\"submit\" onclick=\" return printSelectedInformation()\" value=\"Print\" style=\"float: right;\"/>\n"); out.write("\t\t\t\t</form>\n"); out.write("\t\t\t</div>\n"); out.write("\t\t"); } if (!call_type.equals("search_payment") || !call_type.equals("communication")) { out.write("\n"); out.write("<center>\n"); } out.write("\n"); out.write("<fieldset style=\"width: 55%;\"><legend>\n"); String msg = request.getParameter("msg"); if (call_type.equals("receive_payment")) { out.print("<h3>Search Customer To Receive Payment</h3>"); } else if (call_type.equals("search_payment")) { out.print("<h3>Search Customer To See Pending</h3>"); } else if (call_type.equals("communication")) { out.print("<h3>Search Customer To Communicate</h3>"); } else { out.print("<h3>Search Customer</h3>"); } out.write("\n"); out.write("</legend>\n"); if (call_type.equals("receive_payment")) { out.write("\n"); out.write( "\t\t<input type = \"radio\" name = \"radio\" onclick=\"ChangeCriteria('order')\" checked=\"checked\"/>Search By Order Number\n"); out.write( "\t\t<input type = \"radio\" name = \"radio\" onclick=\"ChangeCriteria('cust')\"/>Search By Customer Detail\n"); out.write("\t"); } if (call_type.equals("receive_payment")) { out.write("\n"); out.write("\t<br/><br/>\n"); out.write("<form id=\"myform1\" action=\"SearchCustUsingOrderNo.jsp\" method=\"get\">\n"); out.write("\t"); if (msg != null) { out.print("<i><font color=red>No Matching Record Found</font></i><br/><br/>"); } out.write("\n"); out.write( "\tEnter Order Number : <input type = \"text\" name = \"order_number\" value=\"\" id =\"order_number\" onkeypress=\"return isNumberKey(event)\"/>\n"); out.write( "\t<input type = \"submit\" value=\"Search\" onclick=\"return ckeckEmpty();\"/>\n"); out.write("\n"); out.write("<br/>\n"); out.write("</form>\n"); out.write("<form name=\"myform\" method=\"post\" id=\"myform\" style=\"display: none\">\n"); } else { out.write("\n"); out.write("<form name=\"myform\" method=\"post\" id=\"myform\" >\n"); } out.write("\n"); out.write("\t<table style=\"width: 100%;\">\n"); out.write("\t\t<tr style=\"width: 100%;\">\n"); out.write( "\t\t\t<td align=\"center\" colspan=3><b><font color=\"blue\"> A</font>ll Customers List       \n"); out.write( "\t\t\t<input type=\"CheckBox\" name=\"chckall\" accesskey=\"a\" onClick=\"funEnabled();\"></td>\n"); out.write("\t\t</tr>\t\t\n"); out.write("\t\t<tr style=\"width: 100%;\">\n"); out.write("\t\t\t<td colspan=3>\n"); out.write("\t\t\t<div id=\"div4\" style=\"width: 100%;\" >\n"); out.write("\t\t\t\t<table>\t\t\t\t\n"); out.write("\t\t\t\t\t<tr>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\">\n"); out.write("\t\t\t\t\t\t\t<b><font color=\"blue\">C</font>ustomer Code</b>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"custCode\" accesskey=\"c\"></td>\n"); out.write("\t\t\t\t\t\t"); if (call_type.equals("search_payment") || call_type.equals("communication")) { out.write("\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\">\n"); out.write("\t\t\t\t\t\t\t<b>O<font color=\"blue\">r</font>der Number</b>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"ordernumber\" accesskey=\"c\"></td>\n"); out.write("\t\t\t\t\t\t"); } out.write("\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Customer <font color=\"blue\">N</font>ame</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"custName\" align=\"right\" accesskey=\"n\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">P</font>hone Number</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"phonenumber\" size=\"22\" align=\"right\" colspan=\"2\" accesskey=\"p\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>M<font color=\"blue\">o</font>bile Number</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"mobilenumber\" size=\"22\" align=\"right\" colspan=\"2\" accesskey=\"o\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Na<font color=\"blue\">m</font>e String</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" style=\"width: 100%;\" type=\"text\" name=\"nameString\" size=\"22\" align=\"right\" accesskey=\"m\" colspan=\"2\"></td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">B</font>uilding</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"Building\" accesskey=\"b\" align=\"right\"></b></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Building <font color=\"blue\">N</font>o.</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"Building_no\" size=\"22\" accesskey=\"o\"></b></td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t <td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">W</font>ing</b></td>\n"); out.write("\t\t\t\t\t <td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t <td><input style=\"width: 97%;\" type =\"text\" name=\"wing\" accesskey=\"w\" ></td>\n"); out.write("\t\t\t\t\t \n"); out.write("\t\t\t\t\t <td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t \n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">F</font>lat No.</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" name=\"block\" size=\"22\" accesskey=\"f\" align=\"right\">\n"); out.write("\t\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Addr<font color=\"blue\">e</font>ss1</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" accesskey=\"e\" name=\"add1\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>A<font color=\"blue\">d</font>dress2</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" accesskey=\"d\" name=\"add2\" size=\"22\"></td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr >\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>A<font color=\"blue\">r</font>ea</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td>\n"); out.write("\t\t\t\t\t\t"); String name; try { Context initContext = new InitialContext(); Context envContext = (Context) initContext.lookup("java:/comp/env"); // DataSource ds = (DataSource)envContext.lookup("jdbc/js"); DataSource ds = (DataSource) envContext.lookup("jdbc/re"); Connection conn = ds.getConnection(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery( "select value from code_table where category='AREA' order by value asc"); out.write("\n"); out.write("\t\t\t\t\t\t\t<SELECT style=\"width: 97%;\" name=\"area\">\n"); out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"\"> Select Area </OPTION>\n"); out.write("\t\t\t\t\t\t"); while (rs.next()) { name = rs.getString(1); out.write("\n"); out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\""); out.print(name); out.write('"'); out.write('>'); out.write(' '); out.print(name); out.write(" </OPTION>\n"); out.write("\t\t\t\t\t\t"); } out.write("\n"); out.write("\t\t\t\t\t\t\t</SELECT>\n"); out.write("\t\t\t\t\t\t</td>\t\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Payment Type</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td>\n"); out.write("\t\t\t\t\t\t\t<SELECT style=\"width: 97%;\" name=\"payment\" align=\"left\">\n"); out.write("\t\t\t\t\t\t\t\t<OPTION selected VALUE=\"\"> Select Type </OPTION>\n"); out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"NoType\"> No Type </OPTION>\n"); out.write("\t\t\t\t\t\t"); ResultSet rs2 = stmt.executeQuery("SELECT payment_type_code, payment_type_desc FROM payment_type"); while (rs2.next()) { out.write("\t\n"); out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\""); out.print(rs2.getString(1)); out.write('"'); out.write('>'); out.write(' '); out.print(rs2.getString(2)); out.write(" </OPTION>\n"); out.write("\t\t\t\t\t\t"); } rs2.close(); stmt.close(); conn.close(); } catch (Exception e) { e.getMessage(); e.printStackTrace(); } out.write("\n"); out.write("\t\t\t\t\t\t\t</SELECT>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Create<font color=\"blue\">D</font>ate</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td>\n"); out.write( "\t\t\t\t\t\t\t<!-- <input type =\"text\" accesskey=\"d\" name=\"c_date1\" size=\"15\" style=\"width: 79%;\">\n"); out.write( "\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('c_date1');\" value=\"...\" style=\"width: 15%;\"/> -->\n"); out.write("\t\t\t\t\t\t\t<div id='createDate1'></div>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>And</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td> \n"); out.write( "\t\t\t\t\t\t\t<!-- <input type =\"text\" name=\"c_date2\" size=\"15\" style=\"width: 79%;\">\n"); out.write( "\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('c_date2');\" value=\"...\" style=\"width: 15%;\"/> -->\n"); out.write("\t\t\t\t\t\t\t<div id='createDate2'></div>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">U</font>pdate Date</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td>\n"); out.write( "\t\t\t\t\t\t\t<!-- <input type =\"text\" accesskey=\"u\" name=\"u_date1\" size=\"15\" style=\"width: 79%;\"/>\n"); out.write( "\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('u_date1');\" value=\"...\" style=\"width: 15%;\"/> -->\n"); out.write("\t\t\t\t\t\t\t<div id=\"updateDate1\"></div>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>And</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td> \n"); out.write( "\t\t\t\t\t\t\t<!-- <input type =\"text\" name=\"u_date2\" size=\"15\" style=\"width: 79%;\"/>\n"); out.write( "\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('u_date2');\" value=\"...\" style=\"width: 15%;\"/> -->\n"); out.write("\t\t\t\t\t\t\t<div id='updateDate2'></div>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">S</font>tation</b></td>\n"); out.write("\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" size=\"22\" accesskey=\"d\" name=\"station\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Last Order Days</b></td>\n"); out.write("\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"selmonth\"/></td></tr>\n"); out.write("\t\t\t\t</table></div>\n"); out.write("\t\t\t</td>\n"); out.write("\t\t</tr>\n"); out.write("\t\t\t\n"); out.write("\t\t<tr>\n"); out.write("\t\t\t<td align=\"center\" colspan=4>\n"); out.write( "\t\t\t\t<input type=\"submit\" name=\"search\" title=\"Press <Enter>\" value=\"Search <Enter>\" accesskey=\"s\" onclick=\"checkField();return false;\"/>\n"); out.write( "\t\t\t\t<input type=\"reset\" name=\"clear\" title=\"Press <Alt+c>\" tabindex=\"1\" value=\"Clear <Alt+c>\" accesskey=\"c\" onclick=\"document.getElementById('txtHint').innerHTML='';\"/>\n"); out.write( "\t\t\t\t<INPUT type=BUTTON value=\"Cancel <Alt+c>\" accesskey=\"c\" onClick=\"showMsg();\"/></center>\n"); out.write("\t\t\t</td>\n"); out.write("\t\t</tr>\n"); out.write("\t</table>\n"); out.write("\t</fieldset>\n"); out.write("\t<input type=\"hidden\" name=\"hchckall\" value=\"1\">\n"); out.write("\t<input type=\"hidden\" name=\"call_type\" value=\""); out.print(call_type); out.write("\"/>\n"); out.write("<script>\n"); out.write("function funEnabled(){\n"); out.write("\t if (document.myform.chckall.checked==true){\n"); out.write("\t\t\tdocument.getElementById('div4').style.visibility=\"hidden\";\n"); out.write("\t\t\tdocument.myform.hchckall.value=1;\t\t\n"); out.write("\t\t\t$(\"#createDate2\").jqxDateTimeInput({disabled: true});\n"); out.write("\t\t\t$(\"#updateDate2\").jqxDateTimeInput({disabled: true});\n"); out.write("\t\t\t\n"); out.write("\t\t}\n"); out.write("\t\telse{\n"); out.write("\t\t\tdocument.getElementById('div4').style.visibility=\"visible\";\n"); out.write("\t\t\tdocument.myform.hchckall.value=0;\t\t\t\n"); out.write("\t\t}\n"); out.write("\t}\n"); out.write("window.onload =Clear;\n"); out.write("\n"); out.write("function ChangeCriteria(str){\n"); out.write("\tif(str == \"cust\"){\n"); out.write("\t\tdocument.getElementById(\"myform\").style.display='block';\n"); out.write("\t\tdocument.getElementById(\"myform1\").style.display='none';\n"); out.write("\t}else if(str == \"order\"){\n"); out.write("\t\tdocument.getElementById(\"myform\").style.display='none';\n"); out.write("\t\tdocument.getElementById(\"myform1\").style.display='block';\n"); out.write("\t\tdocument.getElementById(\"txtHint\").innerHTML=\"\";\n"); out.write("\t\tdocument.getElementById(\"order_number\").focus();\n"); out.write("\t\tdocument.getElementById(\"order_number\").value=\"\";\n"); out.write("\t}\n"); out.write("}\n"); out.write("function isNumberKey(evt) {\n"); out.write("\tvar charCode = (evt.which) ? evt.which : event.keyCode;\n"); out.write("\tif (charCode != 46 && charCode > 31 && (charCode < 48 || charCode > 57))\n"); out.write("\t\treturn false;\n"); out.write("\telse\n"); out.write("\t\treturn true;\n"); out.write("}\n"); out.write("</script>\n"); out.write( "\t<hr><center><div id=\"txtHint\" class=\"ddm1\" style=\"background-color: white;width: 100%;max-height: 400px;overflow: auto;\"></div></center>\n"); out.write("\t<br><br>\n"); out.write( "\t<p><h1><center><div id=\"waitMessage\" style=\"cursor: sw-resize;\"></center></div></h1></p>\n"); String fromFromName = ""; if (request.getParameter("fromForm") != null) fromFromName = request.getParameter("fromForm"); // CustPmtHstry out.write("\n"); out.write("\t<input type=\"hidden\" name=\"fromForm\" value=\""); out.print(fromFromName); out.write("\">\n"); out.write("</form>\n"); out.write("\n"); out.write( "<div id=\"dispdiv\" align=\"center\" style=\"border:1px solid black; padding:25px; text-align:center; display:none; background-color:#FFF; overflow:auto; height:300px; width=200px;\"> </div>\n"); out.write("</body>\n"); out.write("</html>\n"); } catch (java.lang.Throwable t) { if (!(t instanceof javax.servlet.jsp.SkipPageException)) { out = _jspx_out; if (out != null && out.getBufferSize() != 0) try { out.clearBuffer(); } catch (java.io.IOException e) { } if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); else throw new ServletException(t); } } finally { _jspxFactory.releasePageContext(_jspx_page_context); } }
public void _jspService(HttpServletRequest request, HttpServletResponse response) throws java.io.IOException, ServletException { 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 { response.setContentType("text/html;charset=UTF-8"); 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; _jspx_resourceInjector = (org.glassfish.jsp.api.ResourceInjector) application.getAttribute("com.sun.appserv.jsp.resource.injector"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("<!DOCTYPE html>\n"); out.write("<html>\n"); out.write(" <head>\n"); out.write( " <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n"); out.write(" <title>Fine</title>\n"); out.write(" <link rel=\"stylesheet\" type=\"text/css\" href=\"style.css\"> \n"); out.write("\n"); out.write(" </head>\n"); out.write(" <body style = \"background-image: url(lib2.jpg)\"> \n"); out.write(" <center>\n"); out.write(" <h1>Update Fines information</h1>\n"); out.write(" <form name=\"Update\" action=\"Fines_upd.jsp\">\n"); out.write(" <table border=\"0\" width=\"3\" cellspacing=\"2\">\n"); out.write(" <thead>\n"); out.write(" <tr>\n"); out.write(" <th>Update Fines</th>\n"); out.write(" <th></th>\n"); out.write(" </tr>\n"); out.write(" </thead>\n"); out.write(" <tbody>\n"); out.write(" <tr>\n"); out.write(" <td>Update Fine table with todays Data</td>\n"); out.write( " <td><input type=\"submit\" value=\"Update / View Fines\" name=\"SUBMIT\"/></td>\n"); out.write(" </tr>\n"); out.write(" </tbody>\n"); out.write(" </table> \n"); out.write(" </form>\n"); out.write(" <h1>Check your Fines Here</h1>\n"); out.write(" <form name=\"Fines\" action=\"Fines.jsp\">\n"); out.write(" <table border=\"0\" width=\"3\" cellspacing=\"2\">\n"); out.write(" <thead>\n"); out.write(" <tr>\n"); out.write(" <th>Get Fine Details</th>\n"); out.write(" <th></th>\n"); out.write(" </tr>\n"); out.write(" </thead>\n"); out.write(" <tbody>\n"); out.write(" <tr>\n"); out.write(" <td>Card No</td>\n"); out.write( " <td><input type=\"text\" name=\"Card_no\" value=\"\"/></td>\n"); out.write(" </tr>\n"); out.write(" <tr>\n"); out.write(" <td></td>\n"); out.write( " <td><input type=\"submit\" value=\"Get Fines\" name=\"SUBMIT\" /></td>\n"); out.write(" </tr>\n"); out.write(" </tbody>\n"); out.write(" </table> \n"); out.write(" "); Connection con = null; String[] selected_Checkboxes = request.getParameterValues("chk"); PreparedStatement pst = null; ResultSet result = null; ResultSet resUpd = null; con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/lbms_db?zeroDateTimeBehavior=convertToNull", "root", "admin12"); String Card_no = request.getParameter("Card_no"); String button = null; Date dt = new Date(); SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd"); String current_date = sdf.format(dt); if (Card_no != null && selected_Checkboxes == null) { String selSql = "SELECT l.card_no, SUM(f.fine_amt) AS total_fine, f.paid " + "FROM book_loans l, fines f " + "WHERE l.loan_id = f.loan_id AND " + "l.card_no = " + Card_no + " " + "GROUP BY l.card_no"; pst = con.prepareStatement(selSql); result = pst.executeQuery(); String box = null; String paid; String pay; Boolean chk = false; out.println("<table>"); pay = "<form action='Fines.jsp'>"; out.println(pay); out.println("<tr>"); out.println("<th>Card No</th>"); out.println("<th>Fine_Amt</th>"); out.println("<th>Paid OR Not</th>"); out.println("</tr>"); while (result.next()) { chk = true; paid = "No"; if (result.getBoolean("f.paid")) { paid = "Yes"; } out.println("<tr>"); out.println( "<td>" + result.getInt("l.card_no") + "</td><td>" + result.getString("total_fine") + "</td><td>" + paid + "</td>"); out.print("<td>"); box = "<input name='chk' value=" + result.getInt("l.card_no") + " type='checkbox'>"; out.print(box); out.print("</td>"); out.print("</tr>"); } if (chk == true) { out.println("<tr>"); out.print("<td>"); button = "<input type='submit' value='Pay Fine' name='Pay'>"; out.print(button); out.print("</td>"); out.println("</tr>"); } else { out.write( "<dialog open> <font color = 'green'>No Fine information. You owe nothing! Thank You</font> </dialog>"); } out.println("</form>"); out.println("</table>"); } else if (selected_Checkboxes != null) { String sqlLoan = null; ResultSet resultLoan = null; String sqlUpdFine = null; PreparedStatement pstUpd = null; String sqlBook = null; ResultSet rsltBook = null; char chkouts = 'N'; int length_chk = selected_Checkboxes.length; for (int i = 0; i < length_chk; i++) { // Check whether the Book is returned before paying the fine. sqlBook = "SELECT COUNT(loan_id) AS no_chkouts FROM book_loans WHERE card_no = " + selected_Checkboxes[i] + " AND date_in = '0000-00-00' AND due_date < " + current_date + ""; pst = con.prepareStatement(sqlBook); rsltBook = pst.executeQuery(); while (rsltBook.next()) { if (rsltBook.getInt("no_chkouts") > 0) { chkouts = 'Y'; } } if (chkouts == 'Y') { out.write( "<dialog open> <font color = 'red'>You have outstanding due checkouts!. Please return the books and then Pay the fine</font> </dialog>"); } // Get the corresponding loan_Ids for each customer from Fines table sqlLoan = "SELECT loan_id FROM book_loans WHERE card_no = " + selected_Checkboxes[i] + " AND date_in IS NOT NULL AND due_date < date_in"; pst = con.prepareStatement(sqlLoan); resultLoan = pst.executeQuery(); while (resultLoan.next()) { sqlUpdFine = "UPDATE fines SET paid = true WHERE loan_id = " + resultLoan.getInt("loan_id") + ""; pstUpd = con.prepareStatement(sqlUpdFine); pstUpd.executeUpdate(); out.println("Payment Updated Successfully"); } } } out.write("\n"); out.write(" </form> \n"); out.write(" </center>\n"); out.write("</body>\n"); out.write("</html>\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); else throw new ServletException(t); } } finally { _jspxFactory.releasePageContext(_jspx_page_context); } }
public void _jspService(HttpServletRequest request, HttpServletResponse response) throws java.io.IOException, ServletException { 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 { response.setContentType("text/html;charset=UTF-8"); 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; _jspx_resourceInjector = (org.apache.jasper.runtime.ResourceInjector) application.getAttribute("com.sun.appserv.jsp.resource.injector"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write(" "); DataSource ds = null; Connection con = null; PreparedStatement ps = null; InitialContext ic; try { ic = new InitialContext(); ds = (DataSource) ic.lookup("java:/jdbc/AVMS"); // ds = (DataSource)ic.lookup( "java:/jboss" ); con = ds.getConnection(); ps = con.prepareStatement("SELECT * FROM dbo.ROLE"); // pr = con.prepareStatement("SELECT * FROM dbo.JMS_USERS"); ResultSet rs = ps.executeQuery(); while (rs.next()) { out.println("<br> " + rs.getString("role_name") + " | " + rs.getString("role_desc")); // out.println("<br> " +rs.getString("USERID") + " | " +rs.getString("PASSWD")); } rs.close(); ps.close(); } catch (Exception e) { out.println("Exception thrown :: " + e); } finally { if (con != null) { con.close(); } } out.write('\n'); out.write('\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 { _jspxFactory.releasePageContext(_jspx_page_context); } }
public void _jspService(HttpServletRequest request, HttpServletResponse response) throws java.io.IOException, ServletException { 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 { response.setContentType("text/html"); pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true); _jspx_page_context = pageContext; application = pageContext.getServletContext(); config = pageContext.getServletConfig(); session = pageContext.getSession(); out = pageContext.getOut(); _jspx_out = out; out.write('\n'); out.write('\n'); Connection conn = null; Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_shas", "root", "password"); ResultSet rsdoLogin = null; PreparedStatement psdoLogin = null; String sUserID = request.getParameter("username"); String sPassword = request.getParameter("password"); String message = "User login successfully "; try { String sqlOption = "select * FROM Users where username='******' and Password='******'"; psdoLogin = conn.prepareStatement(sqlOption); // psdoLogin.setString(1,sUserID); // psdoLogin.setString(2,sPassword); rsdoLogin = psdoLogin.executeQuery(); if (rsdoLogin.next()) { String sUserName = rsdoLogin.getString("firstname") + " " + rsdoLogin.getString("lastname"); session.setAttribute("sUserID", sUserName); // session.setAttribute("sUserID",rsdoLogin.getString("firstname")); // session.setAttribute("iUserType",rsdoLogin.getString("iUserType")); // session.setAttribute("iUserLevel",rsdoLogin.getString("iUserLevel")); // session.setAttribute("sUserName",sUserName); response.sendRedirect("success.jsp?statusmsg=" + message); } else { message = "Invalid credentials"; response.sendRedirect("Invalid.jsp?error=" + message); } } catch (Exception e) { e.printStackTrace(); } /// close object and connection try { if (psdoLogin != null) { psdoLogin.close(); } if (rsdoLogin != null) { rsdoLogin.close(); } if (conn != null) { conn.close(); } } catch (Exception e) { e.printStackTrace(); } } catch (Throwable t) { if (!(t instanceof SkipPageException)) { out = _jspx_out; if (out != null && out.getBufferSize() != 0) try { out.clearBuffer(); } catch (java.io.IOException e) { } if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); } } finally { _jspxFactory.releasePageContext(_jspx_page_context); } }