public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); Connection conn = null; PreparedStatement pstmt = null; try { System.out.println("Enrollno: 130050131049"); // STEP 2: Register JDBC driver Class.forName(JDBC_DRIVER); // STEP 3: Open a connection System.out.println("Connecting to a selected database..."); conn = DriverManager.getConnection(DB_URL, USER, PASS); System.out.println("Connected database successfully..."); // STEP 2: Executing query String sql = "SELECT * FROM logindetails WHERE name = ?"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, "Krut"); ResultSet rs = pstmt.executeQuery(); out.print("| <b>Name</b>| "); out.print("<b>Password</b>| "); out.println("</br>\n-------------------------------</br>"); while (rs.next()) { out.println(); out.print("| " + rs.getString(1)); out.print("| " + rs.getString(2) + "|"); out.println("</br>"); } } catch (SQLException se) { // Handle errors for JDBC se.printStackTrace(); } catch (Exception e) { // Handle errors for Class.forName e.printStackTrace(); } finally { // finally block used to close resources try { if (pstmt != null) conn.close(); } catch (SQLException se) { } // do nothing try { if (conn != null) conn.close(); } catch (SQLException se) { se.printStackTrace(); } // end finally try } // end try }
public String checkValidLogin(String myUserName, String myPW) { try { Class.forName(javaSQLDriverPath); Connection conn = (Connection) DriverManager.getConnection(ConnectionPath, ConnectionUser, ConnectionPW); Statement st = conn.createStatement(); String query = "Select * from User"; ResultSet rs = st.executeQuery(query); while (rs.next()) { // return rs.getString("Username"); if (myUserName.equals(rs.getString("Username"))) { if (myPW.equals(rs.getString("Password"))) { setUserVariables(myUserName); return "success"; } else { return "wrongPassword"; } } } rs.close(); st.close(); conn.close(); return "userNotFound"; } catch (Exception e) { return e.getMessage(); } }
public void destroy() { super.destroy(); try { link.close(); } catch (Exception e) { System.err.println(e.getMessage()); } }
public void destroy() { try { // session.close(); ps.close(); con.close(); } catch (Exception e) { e.printStackTrace(); } }
@Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // get a connection ConnectionPool pool = ConnectionPool.getInstance(); Connection connection = pool.getConnection(); String sqlStatement = request.getParameter("sqlStatement"); String sqlResult = ""; try { // create a statement Statement statement = connection.createStatement(); // parse the SQL string sqlStatement = sqlStatement.trim(); if (sqlStatement.length() >= 6) { String sqlType = sqlStatement.substring(0, 6); if (sqlType.equalsIgnoreCase("select")) { // create the HTML for the result set ResultSet resultSet = statement.executeQuery(sqlStatement); sqlResult = SQLUtil.getHtmlTable(resultSet); resultSet.close(); } else { int i = statement.executeUpdate(sqlStatement); if (i == 0) { sqlResult = "<p>The statement executed successfully.</p>"; } else { // an INSERT, UPDATE, or DELETE statement sqlResult = "<p>The statement executed successfully.<br>" + i + " row(s) affected.</p>"; } } } statement.close(); connection.close(); } catch (SQLException e) { sqlResult = "<p>Error executing the SQL statement: <br>" + e.getMessage() + "</p>"; } finally { pool.freeConnection(connection); } HttpSession session = request.getSession(); session.setAttribute("sqlResult", sqlResult); session.setAttribute("sqlStatement", sqlStatement); String url = "/index.jsp"; getServletContext().getRequestDispatcher(url).forward(request, response); }
public void doPost(HttpServletRequest req, HttpServletResponse res) throws IOException, ServletException { res.setContentType("text/html"); PrintWriter out = res.getWriter(); /* Get Session */ HttpSession s = req.getSession(true); /* Make sure user is logged in */ if (s.getAttribute("login") == null || (String) s.getAttribute("login") != "go") { req.getRequestDispatcher("login.jsp").forward(req, res); } try { String dbuser = this.getServletContext().getInitParameter("dbuser"); String dbpassword = this.getServletContext().getInitParameter("dbpassword"); Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/project", dbuser, dbpassword); Statement stmt = conn.createStatement(); stmt.execute( "INSERT INTO songs VALUES(null, '" + req.getParameter("song_name") + "', '" + req.getParameter("artist") + "', '" + req.getParameter("album") + "', '" + req.getParameter("genre") + "', 0)"); stmt.close(); conn.close(); // delete memcache since new song is now added MemcachedClient c = new MemcachedClient(new InetSocketAddress("127.0.0.1", 11211)); c.delete("master"); req.getRequestDispatcher("add_song_success.jsp").forward(req, res); } catch (Exception e) { out.println(e.getMessage()); } }
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Statement question; String query; ResultSet answer; connect(); try { query = "SELECT * FROM PILOT WHERE Address ='" + request.getParameter("city") + "'"; question = link.createStatement(); answer = question.executeQuery(query); PrintWriter pen; response.setContentType("text/html"); pen = response.getWriter(); pen.println("<HTML>"); pen.println("<HEAD> <TITLE> Answer </TITLE> </HEAD>"); pen.println("<BODY>"); while (answer.next()) { String pN = answer.getString("PilotNumber"); String lN = answer.getString("LastName"); String fN = answer.getString("FirstName"); String ad = answer.getString("Address"); float sa = answer.getFloat("Salary"); float pr = answer.getFloat("Premium"); Date hD = answer.getDate("HiringDate"); if (answer.wasNull() == false) { pen.println("<P><B> Pilot : </B>" + lN + " " + fN); pen.println("<P><B> ---Reference : </B>" + pN); pen.println("<P><B> ---Address : </B>" + ad); pen.println("<P><B> ---Salary : </B>" + sa); pen.println("<P><B> ---since : </B>" + hD); if (pr > 0) pen.println("<P><B> ---Premium : </B>" + pr); else pen.println("<P><B> ---No premium </B>"); } } pen.println("</BODY>"); pen.println("</HTML>"); answer.close(); question.close(); link.close(); } catch (SQLException e) { System.out.println("Connection error: " + e.getMessage()); } }
public void service(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { try { Driver driver = new com.mysql.jdbc.Driver(); DriverManager.registerDriver(driver); Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1/school", "root", "password"); PreparedStatement preparedStatement = connection.prepareStatement("update student set name=?, per=? where roll=?"); preparedStatement.setString(1, request.getParameter("name")); preparedStatement.setFloat(2, Float.parseFloat(request.getParameter("per"))); preparedStatement.setInt(3, Integer.parseInt(request.getParameter("roll"))); preparedStatement.execute(); preparedStatement.close(); connection.close(); } catch (SQLException e) { e.printStackTrace(); } RequestDispatcher requestDispatcher = request.getRequestDispatcher("/Display"); requestDispatcher.forward(request, response); }
public void doGet(HttpServletRequest request, HttpServletResponse response) { try { String comment = request.getParameter("comment"); int answerId = Integer.parseInt(request.getParameter("answer_id")); Connection connection = GlobalResources.getConnection(); Statement s; s = connection.createStatement(); PreparedStatement preparedStatement; PreparedStatement preparedStatement1; preparedStatement = connection.prepareStatement("insert into comment(comment,answer_id) values(?,?)"); preparedStatement.setString(1, comment); preparedStatement.setInt(2, answerId); preparedStatement.executeUpdate(); preparedStatement.close(); connection.close(); RequestDispatcher requestDispatcher; requestDispatcher = request.getRequestDispatcher("/studenthome.jsp"); requestDispatcher.forward(request, response); } catch (Exception e) { } }
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); String dbUser = "******"; // enter your username here String dbPassword = "******"; // enter your password here try { OracleDataSource ods = new oracle.jdbc.pool.OracleDataSource(); ods.setURL("jdbc:oracle:thin:@//w4111b.cs.columbia.edu:1521/ADB"); ods.setUser(dbUser); ods.setPassword(dbPassword); Connection conn = ods.getConnection(); String query = new String(); Statement s = conn.createStatement(); query = "select * from events"; ResultSet r = s.executeQuery(query); while (r.next()) { out.println("Today's Date: " + r.getString(1) + " "); } r.close(); s.close(); conn.close(); } catch (Exception e) { out.println("The database could not be accessed.<br>"); out.println("More information is available as follows:<br>"); e.printStackTrace(out); } } // end doGet method
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); } }
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); } }
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // Variable initializations. HttpSession session = request.getSession(); FileItem image_file = null; int record_id = 0; int image_id; // Check if a record ID has been entered. if (request.getParameter("recordID") == null || request.getParameter("recordID").equals("")) { // If no ID has been entered, send message to jsp. response_message = "<p><font color=FF0000>No Record ID Detected, Please Enter One.</font></p>"; session.setAttribute("msg", response_message); response.sendRedirect("UploadImage.jsp"); } try { // Parse the HTTP request to get the image stream. DiskFileUpload fu = new DiskFileUpload(); // Will get multiple image files if that happens and can be accessed through FileItems. List<FileItem> FileItems = fu.parseRequest(request); // Connect to the database and create a statement. conn = getConnected(drivername, dbstring, username, password); stmt = conn.createStatement(); // Process the uploaded items, assuming only 1 image file uploaded. Iterator<FileItem> i = FileItems.iterator(); while (i.hasNext()) { FileItem item = (FileItem) i.next(); // Test if item is a form field and matches recordID. if (item.isFormField()) { if (item.getFieldName().equals("recordID")) { // Covert record id from string to integer. record_id = Integer.parseInt(item.getString()); String sql = "select count(*) from radiology_record where record_id = " + record_id; int count = 0; try { rset = stmt.executeQuery(sql); while (rset != null && rset.next()) { count = (rset.getInt(1)); } } catch (SQLException e) { response_message = e.getMessage(); } // Check if recordID is in the database. if (count == 0) { // Invalid recordID, send message to jsp. response_message = "<p><font color=FF0000>Record ID Does Not Exist In Database.</font></p>"; session.setAttribute("msg", response_message); // Close connection. conn.close(); response.sendRedirect("UploadImage.jsp"); } } } else { image_file = item; if (image_file.getName().equals("")) { // No file, send message to jsp. response_message = "<p><font color=FF0000>No File Selected For Record ID.</font></p>"; session.setAttribute("msg", response_message); // Close connection. conn.close(); response.sendRedirect("UploadImage.jsp"); } } } // Get the image stream. InputStream instream = image_file.getInputStream(); BufferedImage full_image = ImageIO.read(instream); BufferedImage thumbnail = shrink(full_image, 10); BufferedImage regular_image = shrink(full_image, 5); // First, to generate a unique img_id using an SQL sequence. rset1 = stmt.executeQuery("SELECT image_id_sequence.nextval from dual"); rset1.next(); image_id = rset1.getInt(1); // Insert an empty blob into the table first. Note that you have to // use the Oracle specific function empty_blob() to create an empty blob. stmt.execute( "INSERT INTO pacs_images VALUES(" + record_id + "," + image_id + ", empty_blob(), empty_blob(), empty_blob())"); // to retrieve the lob_locator // Note that you must use "FOR UPDATE" in the select statement String cmd = "SELECT * FROM pacs_images WHERE image_id = " + image_id + " FOR UPDATE"; rset = stmt.executeQuery(cmd); rset.next(); BLOB myblobFull = ((OracleResultSet) rset).getBLOB(5); BLOB myblobThumb = ((OracleResultSet) rset).getBLOB(3); BLOB myblobRegular = ((OracleResultSet) rset).getBLOB(4); // Write the full size image to the blob object. OutputStream fullOutstream = myblobFull.getBinaryOutputStream(); ImageIO.write(full_image, "jpg", fullOutstream); // Write the thumbnail size image to the blob object. OutputStream thumbOutstream = myblobThumb.getBinaryOutputStream(); ImageIO.write(thumbnail, "jpg", thumbOutstream); // Write the regular size image to the blob object. OutputStream regularOutstream = myblobRegular.getBinaryOutputStream(); ImageIO.write(regular_image, "jpg", regularOutstream); // Commit the changes to database. stmt.executeUpdate("commit"); response_message = "<p><font color=00CC00>Upload Successful.</font></p>"; session.setAttribute("msg", response_message); instream.close(); fullOutstream.close(); thumbOutstream.close(); regularOutstream.close(); // Close connection. conn.close(); response.sendRedirect("UploadImage.jsp"); instream.close(); fullOutstream.close(); thumbOutstream.close(); regularOutstream.close(); // Close connection. conn.close(); } catch (Exception ex) { response_message = ex.getMessage(); } }
public void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); Connection con = null; // init DB objects PreparedStatement pstmt = null; Statement stmt = null; ResultSet rs = null; try { con = dbConn.Connect("demopaul"); } catch (Exception ignore) { } String stype_id = req.getParameter("type_id"); int type_id = 0; String sgroup_id = req.getParameter("group_id"); int group_id = 0; String sitem_id = req.getParameter("item_id"); int item_id = 0; try { type_id = Integer.parseInt(stype_id); } catch (NumberFormatException ignore) { } try { group_id = Integer.parseInt(sgroup_id); } catch (NumberFormatException ignore) { } try { item_id = Integer.parseInt(sitem_id); } catch (NumberFormatException ignore) { } out.println( "<!-- type_id=" + type_id + ", group_id=" + group_id + ", item_id=" + item_id + " -->"); out.println("<script>"); out.println("function load_types() {"); out.println(" try {document.forms['frmSelect'].item_id.selectedIndex = -1; } catch (err) {}"); out.println(" document.forms['frmSelect'].group_id.selectedIndex = -1;"); out.println(" document.forms['frmSelect'].submit();"); out.println("}"); out.println("function load_groups() {"); out.println(" document.forms['frmSelect'].submit();"); out.println("}"); out.println("</script>"); out.println("<form name=frmSelect>"); // LOAD ACTIVITY TYPES out.println("<select name=type_id onchange=\"load_types()\">"); if (type_id == 0) { out.println("<option>CHOOSE TYPE</option>"); } try { stmt = con.createStatement(); rs = stmt.executeQuery("SELECT * FROM activity_types"); while (rs.next()) { Common_Config.buildOption(rs.getInt("type_id"), rs.getString("type_name"), type_id, out); } stmt.close(); } catch (Exception exc) { out.println("<p>ERROR:" + exc.toString() + "</p>"); } out.println(""); out.println("</select>"); // LOAD ACTIVITIES BY GROUP TYPE out.println("<select name=group_id onchange=\"load_groups()\">"); if (type_id == 0) { out.println("<option>CHOOSE TYPE</option>"); } else { try { stmt = con.createStatement(); rs = stmt.executeQuery( "SELECT group_id, group_name FROM activity_groups WHERE type_id = " + type_id); rs.last(); if (rs.getRow() == 1) { group_id = rs.getInt("group_id"); out.println("<!-- ONLY FOUND 1 GROUP -->"); } else { out.println("<option value=\"0\">CHOOSE...</option>"); } rs.beforeFirst(); while (rs.next()) { Common_Config.buildOption( rs.getInt("group_id"), rs.getString("group_name"), group_id, out); } stmt.close(); } catch (Exception exc) { out.println("<p>ERROR:" + exc.toString() + "</p>"); } } out.println(""); out.println("</select>"); if (group_id > 0) { // || sitem_id != null // LOAD ACTIVITIES BY ITEM TYPE out.println("<select name=item_id onchange=\"load_times()\">"); if (group_id == 0) { out.println("<option value=\"0\">CHOOSE GROUP</option>"); } else { try { stmt = con.createStatement(); rs = stmt.executeQuery( "SELECT item_id, item_name FROM activity_items WHERE group_id = " + group_id); rs.last(); if (rs.getRow() == 1) { item_id = rs.getInt("item_id"); out.println("<!-- ONLY FOUND 1 ITEM -->"); } else { out.println("<option value=\"0\">CHOOSE...</option>"); } rs.beforeFirst(); while (rs.next()) { Common_Config.buildOption( rs.getInt("item_id"), rs.getString("item_name"), item_id, out); } stmt.close(); } catch (Exception exc) { out.println("<p>ERROR:" + exc.toString() + "</p>"); } } out.println(""); out.println("</select>"); } out.println("</form>"); out.println("<p><a href=\"Member_genrez\">Reset</a></p>"); try { con.close(); } catch (Exception ignore) { } out.close(); }
// ***************************************************** // Process the initial request from Proshop_main // ***************************************************** // public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // // Prevent caching so sessions are not mangled // resp.setHeader("Pragma", "no-cache"); // for HTTP 1.0 resp.setHeader("Cache-Control", "no-store, no-cache, must-revalidate"); // for HTTP 1.1 resp.setDateHeader("Expires", 0); // prevents caching at the proxy server resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); HttpSession session = SystemUtils.verifyHotel(req, out); // check for intruder if (session == null) { return; } String club = (String) session.getAttribute("club"); // get club name String user = (String) session.getAttribute("user"); if (req.getParameter("clubswitch") != null && req.getParameter("clubswitch").equals("1") && req.getParameter("club") != null) { // // Request is to switch clubs - switch the db (TPC or Demo sites) // String newClub = req.getParameter("club"); Connection con = null; // // release the old connection // ConnHolder holder = (ConnHolder) session.getAttribute("connect"); if (holder != null) { con = holder.getConn(); // get the connection for previous club } if (con != null) { /* // abandon any unfinished transactions try { con.rollback(); } catch (Exception ignore) {} */ // close/release the connection try { con.close(); } catch (Exception ignore) { } } // // Connect to the new club // try { con = dbConn.Connect(newClub); // get connection to this club's db } catch (Exception ignore) { } holder = new ConnHolder(con); session.setAttribute("club", newClub); session.setAttribute("connect", holder); out.println("<HTML><HEAD><Title>Switching Sites</Title>"); out.println("<meta http-equiv=\"Refresh\" content=\"0; url=/" + rev + "/hotel_home.htm\">"); out.println("</HEAD>"); out.println("<BODY><CENTER><BR>"); out.println("<BR><H2>Switching Sites</H2><BR>"); out.println("<a href=\"/" + rev + "/hotel_home.htm\" target=_top>Continue</a><br>"); out.println("</CENTER></BODY></HTML>"); out.close(); return; } // // Call is to display the Home page. // out.println("<html><head>"); out.println("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">"); out.println("<meta http-equiv=\"Content-Language\" content=\"en-us\">"); out.println("<title> \"ForeTees Hotel Home Page\"</title>"); out.println( "<script language=\"JavaScript\" src=\"/" + rev + "/web utilities/foretees.js\"></script>"); out.println( "<style type=\"text/css\"> body {text-align: center} </style>"); // so body will align on // center out.println("</head>"); out.println("<body bgcolor=\"#CCCCAA\" text=\"#000000\">"); out.println("<div style=\"align:center; margin:0px auto;\">"); if (club.startsWith("tpc") && user.startsWith("passport")) { // if TPC Passport user out.println("<br><H3>Welcome to ForeTees</H3><br>"); String clubname = ""; String fullname = ""; Connection con = null; try { con = dbConn.Connect(rev); // get connection to the Vx db // // Get the club names for each TPC club // PreparedStatement pstmt = con.prepareStatement("SELECT fullname FROM clubs WHERE clubname=?"); pstmt.clearParameters(); pstmt.setString(1, club); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { fullname = rs.getString("fullname"); // get the club's full name } out.println("<p>You are currently connected to: <b>" + fullname + "</b><br><br>"); out.println("To continue with this site, simply use the navigation menus above.<br><br>"); out.println("To switch sites, click on the desired club name below.</p><br>"); // // Get the club names for each TPC club // pstmt = con.prepareStatement( "SELECT clubname, fullname FROM clubs WHERE inactive=0 AND clubname LIKE 'tpc%' ORDER BY fullname"); pstmt.clearParameters(); rs = pstmt.executeQuery(); while (rs.next()) { clubname = rs.getString("clubname"); // get a club name if (clubname.startsWith("tpc")) { fullname = rs.getString("fullname"); // get the club's full name out.println( "<a href=\"Hotel_home?clubswitch=1&club=" + clubname + "\" target=_top>" + fullname + "</a><br>"); } } pstmt.close(); } catch (Exception e) { // Error connecting to db.... out.println( "<BR><BR>Sorry, we encountered an error while trying to connect to the database."); // out.println("<br><br>Error: " + e.toString() + "<br>"); out.println("<BR><BR> <A HREF=\"Hotel_home\">Return</A>."); out.println("</BODY></HTML>"); return; } } else { out.println( "<BR><BR> You have entered here by mistake. Please contact ForeTees Support at 651-765-6006."); out.println("</BODY></HTML>"); } out.println("</div></BODY></HTML>"); } // end of doGet
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); } }
@Override public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { // create the workbook, its worksheet, and its title row Workbook workbook = new HSSFWorkbook(); Sheet sheet = workbook.createSheet("User table"); Row row = sheet.createRow(0); row.createCell(0).setCellValue("The User table"); // create the header row row = sheet.createRow(2); row.createCell(0).setCellValue("UserID"); row.createCell(1).setCellValue("LastName"); row.createCell(2).setCellValue("FirstName"); row.createCell(3).setCellValue("Email"); try { // read database rows ConnectionPool pool = ConnectionPool.getInstance(); Connection connection = pool.getConnection(); Statement statement = connection.createStatement(); String query = "SELECT * FROM User ORDER BY UserID"; ResultSet results = statement.executeQuery(query); // create spreadsheet rows int i = 3; while (results.next()) { row = sheet.createRow(i); row.createCell(0).setCellValue(results.getInt("UserID")); row.createCell(1).setCellValue(results.getString("LastName")); row.createCell(2).setCellValue(results.getString("FirstName")); row.createCell(3).setCellValue(results.getString("Email")); i++; } results.close(); statement.close(); connection.close(); } catch (SQLException e) { this.log(e.toString()); } // set response object headers response.setHeader("content-disposition", "attachment; filename=users.xls"); response.setHeader("cache-control", "no-cache"); // get the output stream String encodingString = request.getHeader("accept-encoding"); OutputStream out; if (encodingString != null && encodingString.contains("gzip")) { out = new GZIPOutputStream(response.getOutputStream()); response.setHeader("content-encoding", "gzip"); // System.out.println("User table encoded with gzip"); } else { out = response.getOutputStream(); // System.out.println("User table not encoded with gzip"); } // send the workbook to the browser workbook.write(out); out.close(); }
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 doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); HttpSession session = request.getSession(true); try { Object accountObject = session.getValue(ACCOUNT); // If no account object was put in the session, or // if one exists but it is not a hashtable, then // redirect the user to the original login page if (accountObject == null) throw new RuntimeException("You need to log in to use this service!"); if (!(accountObject instanceof Hashtable)) throw new RuntimeException("You need to log in to use this service!"); Hashtable account = (Hashtable) accountObject; String userName = (String) account.get("name"); ////////////////////////////////////////////// // Display Messages for the user who logged in ////////////////////////////////////////////// Connection con = null; Statement stmt = null; ResultSet rs = null; String lookupID = request.getParameter("LookupMemberID"); out.println("<HTML>"); out.println("<HEAD>"); out.println("<TITLE>Searching for member: lookupID</TITLE>"); out.println("</HEAD>"); out.println("<BODY BGCOLOR='#EFEFEF'>"); out.println("<H3><u>Searching for Member ID: " + lookupID + "</u></H3>"); out.println("<CENTER>"); try { Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection( "jdbc:mysql://localhost/contacts?user=kareena&password=kapoor"); stmt = con.createStatement(); rs = stmt.executeQuery( "SELECT * FROM userstable WHERE UserID=" + Integer.parseInt(lookupID)); out.println("<TABLE BGCOLOR='#EFEFFF' CELLPADDING='2' CELLSPACING='4' BORDER='1'>"); out.println("<TR BGCOLOR='#D6DFFF'>"); out.println("<TD ALIGN='center'><B>Picture</B></TD>"); out.println("<TD ALIGN='center'><B>User Name</B></TD>"); out.println("<TD ALIGN='center'><B>Gender</B></TD>"); out.println("<TD ALIGN='center'><B>City / State</B></TD>"); out.println("<TD ALIGN='center'><B>Country</B></TD>"); out.println("<TD ALIGN='center'><B>About User</B></TD>"); out.println("<TD ALIGN='center'><B>User Profile</B></TD>"); out.println("<TD ALIGN='center'><B>Add to Contact List</B></TD>"); out.println("</TR>"); int i = 0; String formName = "form"; String buttonName = "button"; while (rs.next()) { String picture = rs.getString("FileLocation"); String user = rs.getString("UserName"); String city = rs.getString("City"); String state = rs.getString("State"); String country = rs.getString("Country"); String aboutUser = rs.getString("AboutMe1"); String gender = rs.getString("Gender"); formName += i; buttonName += i; out.println("<form name='" + formName + "' method='post' action='addContact'>"); out.println("<TR>"); out.println("<TD><img src='" + picture + "'</TD>"); out.println("<TD>" + user + "</TD>"); out.println("<TD>" + gender + "</TD>"); out.println("<TD>" + city + " / " + state + "</TD>"); out.println("<TD>" + country + "</TD>"); out.println("<TD>" + aboutUser + "</TD>"); out.println( "<TD><A href='details.jsp?type=1&data=" + lookupID + "'><IMG SRC='images/detail.jpg'></A></TD>"); out.println( "<TD><input type='submit' value='Add to Contact List' name='" + buttonName + "'></TD>"); out.println("<input type='hidden' value='" + user + "' name='hiddenUser'>"); out.println("</TR>"); out.println("</form>"); i++; } out.println("</TABLE>"); } catch (Exception e) { out.println("Could not connect to the users database.<P>"); out.println("The error message was"); out.println("<PRE>"); out.println(e.getMessage()); out.println("</PRE>"); } finally { if (rs != null) { try { rs.close(); } catch (SQLException ignore) { } } if (stmt != null) { try { stmt.close(); } catch (SQLException ignore) { } } if (con != null) { try { con.close(); } catch (SQLException ignore) { } } } out.println("</CENTER>"); out.println("</BODY>"); out.println("</HTML>"); } catch (RuntimeException e) { out.println("<script language=\"javascript\">"); out.println("alert(\"You need to log in to use this service!\");"); out.println("</script>"); out.println("<a href='index.html'>Click Here</a> to go to the main page.<br><br>"); out.println( "Or Click on the button to exit<FORM><INPUT onClick=\"javascipt:window.close()\" TYPE=\"BUTTON\" VALUE=\"Close Browser\" TITLE=\"Click here to close window\" NAME=\"CloseWindow\" STYLE=\"font-family:Verdana, Arial, Helvetica; font-size:smaller; font-weight:bold\"></FORM>"); log(e.getMessage()); return; } }
private List<LicenseData> getSearchByFieldResults( String reseller, String parameter, String type) { List<LicenseData> list = new ArrayList<LicenseData>(); Connection con = null; try { Statement pst = null; con = getConnectiontoDB(); StringBuffer sql = new StringBuffer(); if (type.equalsIgnoreCase("sno")) { sql.append( " select distinct ib.item,o.orderkey,'1',so_header.so_number,so_header.end_user,TO_CHAR(TO_TIMESTAMP(so_header.ship_date/1000), 'YYYY-MM-DD'), "); } else { sql.append( " select distinct so_item.item,so_item.entitlementkey,so_item.quantity,so_header.so_number,so_header.end_user,TO_CHAR(TO_TIMESTAMP(so_header.ship_date/1000), 'YYYY-MM-DD'), "); } sql.append( "o.hmid, CASE TO_CHAR(TO_TIMESTAMP(o.substartdate/1000), 'YYYY-MM-DD') WHEN '1969-12-31' THEN '' WHEN TO_CHAR(TO_TIMESTAMP(o.subenddate/1000), 'YYYY-MM-DD') THEN '' ELSE TO_CHAR(TO_TIMESTAMP(o.substartdate/1000), 'YYYY-MM-DD') END, "); sql.append( "CASE TO_CHAR(TO_TIMESTAMP(o.subenddate/1000), 'YYYY-MM-DD') WHEN '1969-12-31' THEN '' WHEN TO_CHAR(TO_TIMESTAMP(o.substartdate/1000), 'YYYY-MM-DD') THEN '' ELSE TO_CHAR(TO_TIMESTAMP(o.subenddate/1000), 'YYYY-MM-DD') END, so_header.po_check_number,so_header.reseller, "); sql.append( " CASE WHEN so_item.producttype='Support' THEN TO_CHAR(TO_TIMESTAMP(o.startdate/1000), 'YYYY-MM-DD') ELSE '' END, "); sql.append( " CASE WHEN so_item.producttype='Support' THEN TO_CHAR(TO_TIMESTAMP(o.enddate/1000), 'YYYY-MM-DD') ELSE '' END "); if (type.equalsIgnoreCase("sno")) { sql.append(" ,ib.serialnumber"); sql.append( " from ns.so_header so_header inner join ns.ib ib on ib.salesordernumber =so_header.so_number "); sql.append(" inner join orderkey_information o on so_header.entitlement_key=o.orderkey"); sql.append( " inner join ns.temp_so_item so_item on so_header.entitlement_key=so_item.entitlementkey"); } else { sql.append( " from ns.so_header so_header inner join ns.temp_so_item so_item on so_header.entitlement_key=so_item.entitlementkey "); sql.append(" inner join orderkey_information o on so_header.entitlement_key=o.orderkey "); } if (type.equalsIgnoreCase("sno")) sql.append(" where ib.serialnumber ILIKE '%" + parameter.trim() + "%' "); if (type.equalsIgnoreCase("so")) sql.append("where so_header.so_number='" + parameter.trim() + "' "); if (type.equalsIgnoreCase("enduser")) sql.append( "where so_header.end_user ILIKE '%" + parameter.trim().replace("'", "''") + "%'"); if (type.equalsIgnoreCase("ek")) sql.append("where so_header.entitlement_key ILIKE '%" + parameter.trim() + "%'"); if (type.equalsIgnoreCase("po")) sql.append("where so_header.po_check_number ILIKE '%" + parameter.trim() + "%'"); if (type.equalsIgnoreCase("hm")) sql.append("where o.hmid ILIKE '%" + parameter.trim() + "%'"); if (reseller != null && !reseller.isEmpty() && !reseller.equalsIgnoreCase("%admin%")) sql.append(" and so_header.reseller ILIKE '" + reseller.trim() + "'"); if (type.equalsIgnoreCase("sno")) sql.append(" order by so_header.so_number desc "); pst = con.createStatement(); ResultSet rs = pst.executeQuery(sql.toString()); log.info("Search Fields : SQL Query " + sql); while (rs.next()) { LicenseData data = new LicenseData(); data.setEntitlementKey(rs.getString(2)); data.setSku(rs.getString(1)); data.setQuantity(rs.getString(3)); data.setSoNumbber(rs.getString(4)); ; data.setEndUser(rs.getString(5)); data.setShipDate(rs.getString(6)); data.setHmId(rs.getString(7)); data.setLicenseStartDate(rs.getString(8)); data.setLicenseEndDate(rs.getString(9)); data.setPoNumber(rs.getString(10)); data.setNumber(rs.getString(4)); data.setBillingCustomer(rs.getString(11)); data.setSupportStartDate(rs.getString(12)); data.setSupportEndDate(rs.getString(13)); if (type.equalsIgnoreCase("sno")) data.setSerialNumber(rs.getString(14)); list.add(data); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return list; }
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); ResultSet rs = null; try { // SET UP Context environment, to look for Data Pooling Resource Context initCtx = new InitialContext(); Context envCtx = (Context) initCtx.lookup("java:comp/env"); DataSource ds = (DataSource) envCtx.lookup("jdbc/TestDB"); Connection dbcon = ds.getConnection(); // ########### SEARCH INPUT PARAMETERS, EXECUTE search // ##################################################### Vector<String> params = new Vector<String>(); params.add(request.getParameter("fname")); params.add(request.getParameter("lname")); params.add(request.getParameter("title")); params.add(request.getParameter("year")); params.add(request.getParameter("director")); List<Movie> movies = new ArrayList<Movie>(); movies = SQLServices.getMovies(params.toArray(new String[params.size()]), dbcon); // ########## SET DEFAULT SESSION() PARAMETERS #################################### request.getSession().removeAttribute("movies"); request.getSession().removeAttribute("linkedListMovies"); request.getSession().removeAttribute("hasPaged"); request.getSession().setAttribute("hasPaged", "no"); request.getSession().setAttribute("movies", movies); request.getSession().setAttribute("currentIndex", "0"); request.getSession().setAttribute("defaultN", "5"); // ########## IF MOVIES FROM SEARCH NON-EMPTY ########################################### List<String> fields = Movie.fieldNames(); int count = 1; if (!movies.isEmpty()) { request.setAttribute("movies", movies); for (String field : fields) { request.setAttribute("f" + count++, field); } request.getRequestDispatcher("../movieList.jsp").forward(request, response); } else { out.println("<html><head><title>error</title></head>"); out.println("<body><h1>could not find any movies, try your search again.</h1>"); out.println("<p> we are terribly sorry, please go back. </p>"); out.println("<table border>"); out.println("</table>"); } dbcon.close(); } catch (SQLException ex) { while (ex != null) { System.out.println("SQL Exception: " + ex.getMessage()); ex = ex.getNextException(); } } catch (java.lang.Exception ex) { out.println( "<html>" + "<head><title>" + "moviedb: error" + "</title></head>\n<body>" + "<p>SQL error in doGet: " + ex.getMessage() + "</p></body></html>"); return; } out.close(); }
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { res.setContentType("text/xml"); PrintWriter out = res.getWriter(); Connection con = null; Statement stmt = null; ResultSet rs = null; HttpSession session = req.getSession(true); String url = ""; String nom = ""; String mdp = ""; try { // Enregistrement du Driver Class.forName("org.postgresql.Driver"); // Chargement du fichier Props Properties prop = new Properties(); try { prop.load(new FileInputStream(getServletContext().getRealPath("/Props.txt"))); url = prop.getProperty("url"); nom = prop.getProperty("nom"); mdp = prop.getProperty("mdp"); } catch (Exception e) { out.println(e.getMessage()); } // Connexion a la base con = DriverManager.getConnection(url, nom, mdp); stmt = con.createStatement(); rs = stmt.executeQuery( "SELECT prix,libelle,pno From produits WHERE prix=(select MAX(prix) FROM produits) limit 1;"); int prix = 0; String libelle = ""; int pno = 0; if (rs.next()) { prix = Integer.parseInt(rs.getString("prix")); libelle = rs.getString("libelle"); pno = Integer.parseInt(rs.getString("pno")); } out.println("<data>"); out.println("<prix>" + prix + "</prix>"); out.println("<libelle>" + libelle + "</libelle>"); out.println("<pno>" + pno + "</pno>"); out.println("</data>"); } catch (Exception e) { out.println(e.getMessage()); } finally { try { stmt.close(); con.close(); } catch (Exception e) { out.println(e.getMessage()); } } }
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); HttpSession session = request.getSession(false); if (session == null) { session = request.getSession(); } PrintWriter out = response.getWriter(); Connection conn = null; Statement stmt = null; try { System.out.println("Enrollno: 130050131067"); // STEP 2: Register JDBC driver Class.forName(JDBC_DRIVER); // STEP 3: Open a connection System.out.println("Connecting to a selected database..."); conn = DriverManager.getConnection(DB_URL, USER, PASS); System.out.println("Connected database successfully..."); stmt = conn.createStatement(); // STEP 2: Executing query String name = "asdf"; String rollno = "34"; String branch = "CSE"; String sql = "INSERT INTO student(rollno, name, branch) VALUES ('" + rollno + "', '" + name + "', '" + branch + "')"; if (stmt.executeUpdate(sql) != 0) { out.println("Record has been inserted</br>"); } else { out.println("Sorry! Failure</br>"); } } catch (SQLException se) { // Handle errors for JDBC se.printStackTrace(); } catch (Exception e) { // Handle errors for Class.forName e.printStackTrace(); } finally { // finally block used to close resources try { if (stmt != null) conn.close(); } catch (SQLException se) { } // do nothing try { if (conn != null) conn.close(); } catch (SQLException se) { se.printStackTrace(); } // end finally try } // end try }
/** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub response.setContentType("text/html"); Connection conn = null; System.out.println("Reached here 1"); String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; String user = ""; String userpass = ""; String strQuery = ""; Statement st = null; ResultSet rs = null; HttpSession session = request.getSession(true); try { Class.forName(driver); conn = DriverManager.getConnection("jdbc:odbc:test", "", ""); if (request.getParameter("user") != null && request.getParameter("user") != "" && request.getParameter("userpass") != null && request.getParameter("userpass") != "") { user = request.getParameter("user").toString(); userpass = request.getParameter("userpass").toString(); strQuery = "select * from register "; st = conn.createStatement(); System.out.println("Reached here 2"); rs = st.executeQuery(strQuery); System.out.println("Reached here 3"); String cpass = null; String name = null; while (rs.next()) { if (rs.getString(3).equals(user)) { name = rs.getString(1); cpass = rs.getString("pass"); break; } } session.setAttribute("sname", name); System.out.println("Reached Here 4"); StringBuffer q = pack.calc(userpass); String q1 = q.toString(); System.out.println("Reached Here 5"); if (cpass.equals(q1)) { RequestDispatcher rd = this.getServletConfig().getServletContext().getRequestDispatcher("/home.jsp"); rd.forward(request, response); } else { RequestDispatcher rd = this.getServletConfig().getServletContext().getRequestDispatcher("/login5.jsp"); rd.forward(request, response); } } conn.close(); } catch (Exception e) { e.printStackTrace(); } }
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); String username = request.getParameter("username"); String password = request.getParameter("password"); Statement stmt; ResultSet rs; if (username == null || password == null) { out.println("<h1>Invalid Register Request</h1>"); out.println("<a href=\"register.html\">Register</a>"); return; } Connection con = null; try { Class.forName("com.mysql.jdbc.Driver"); String connectionUrl = "jdbc:mysql://localhost/project3?" + "user=root&password=marouli"; con = DriverManager.getConnection(connectionUrl); if (con != null) { System.out.println("Ola ok me mysql"); } } catch (SQLException e) { System.out.println("SQL Exception: " + e.toString()); } catch (ClassNotFoundException cE) { System.out.println("Class Not Found Exception: " + cE.toString()); } try { stmt = con.createStatement(); rs = stmt.executeQuery("SELECT * FROM users WHERE username='******'"); if (rs.next()) { out.println("<h1>Username exists</h1>"); out.println("<a href=\"register.html\">Register</a>"); stmt.close(); rs.close(); con.close(); return; } stmt.close(); rs.close(); stmt = con.createStatement(); if (!stmt.execute("INSERT INTO users VALUES('" + username + "', '" + password + "')")) { out.println("<h1>You are now registered " + username + "</h1>"); out.println("<a href=\"index.jsp\">Login</a>"); int i; for (i = 0; i < listeners.size(); i++) listeners.get(i).UserRegistered(username); } else { out.println("<h1>Could not add your username to the db</h1>"); out.println("<a href=\"register.html\">Register</a>"); } stmt.close(); con.close(); } catch (SQLException e) { throw new ServletException("Servlet Could not display records.", e); } }
/** Business logic to execute. */ public VOListResponse loadItemVariants(GridParams pars, String serverLanguageId, String username) throws Throwable { PreparedStatement pstmt = null; Connection conn = null; try { if (this.conn == null) conn = getConn(); else conn = this.conn; String tableName = (String) pars.getOtherGridParams().get(ApplicationConsts.TABLE_NAME); ItemPK pk = (ItemPK) pars.getOtherGridParams().get(ApplicationConsts.ITEM_PK); String productVariant = (String) productVariants.get(tableName); String variantType = (String) variantTypes.get(tableName); String variantTypeJoin = (String) variantTypeJoins.get(tableName); String variantCodeJoin = (String) variantCodeJoins.get(tableName); String sql = "select " + tableName + "." + variantTypeJoin + "," + tableName + ".VARIANT_CODE,A.DESCRIPTION,B.DESCRIPTION, " + tableName + ".PROGRESSIVE_SYS10," + variantType + ".PROGRESSIVE_SYS10 " + "from " + tableName + "," + variantType + ",SYS10_COMPANY_TRANSLATIONS A,SYS10_COMPANY_TRANSLATIONS B " + "where " + tableName + ".COMPANY_CODE_SYS01=? and " + tableName + ".COMPANY_CODE_SYS01=" + variantType + ".COMPANY_CODE_SYS01 and " + tableName + "." + variantTypeJoin + "=" + variantType + ".VARIANT_TYPE and " + tableName + ".COMPANY_CODE_SYS01=A.COMPANY_CODE_SYS01 and " + tableName + ".PROGRESSIVE_SYS10=A.PROGRESSIVE and A.LANGUAGE_CODE=? and " + variantType + ".COMPANY_CODE_SYS01=B.COMPANY_CODE_SYS01 and " + variantType + ".PROGRESSIVE_SYS10=B.PROGRESSIVE and B.LANGUAGE_CODE=? and " + tableName + ".ENABLED='Y' and " + variantType + ".ENABLED='Y' and " + // and not "+tableName+"."+variantTypeJoin+"=? and "+ "not " + tableName + ".VARIANT_CODE=? " + "order by " + tableName + "." + variantTypeJoin + "," + tableName + ".CODE_ORDER"; Map attribute2dbField = new HashMap(); attribute2dbField.put("variantType", tableName + "." + variantTypeJoin); attribute2dbField.put("variantCode", tableName + ".VARIANT_CODE"); attribute2dbField.put("variantDesc", "A.DESCRIPTION"); attribute2dbField.put("variantTypeDesc", "B.DESCRIPTION"); attribute2dbField.put("variantProgressiveSys10", tableName + ".PROGRESSIVE_SYS10"); attribute2dbField.put("variantTypeProgressiveSys10", variantType + ".PROGRESSIVE_SYS10"); ArrayList values = new ArrayList(); values.add(pk.getCompanyCodeSys01ITM01()); values.add(serverLanguageId); values.add(serverLanguageId); // values.add(ApplicationConsts.JOLLY); values.add(ApplicationConsts.JOLLY); // read from ITMxxx table... Response answer = QueryUtil.getQuery( conn, new UserSessionParameters(username), sql, values, attribute2dbField, ItemVariantVO.class, "Y", "N", null, pars, 50, true); if (!answer.isError()) { java.util.List vos = ((VOListResponse) answer).getRows(); HashMap map = new HashMap(); ItemVariantVO vo = null; for (int i = 0; i < vos.size(); i++) { vo = (ItemVariantVO) vos.get(i); vo.setCompanyCodeSys01(pk.getCompanyCodeSys01ITM01()); vo.setItemCodeItm01(pk.getItemCodeITM01()); vo.setTableName(tableName); map.put(vo.getVariantType() + "." + vo.getVariantCode(), vo); } pstmt = conn.prepareStatement( "select " + productVariant + "." + variantTypeJoin + "," + productVariant + "." + variantCodeJoin + " " + "from " + productVariant + " " + "where " + productVariant + ".COMPANY_CODE_SYS01=? and " + productVariant + ".ITEM_CODE_ITM01=? and " + productVariant + ".ENABLED='Y' "); pstmt.setString(1, pk.getCompanyCodeSys01ITM01()); pstmt.setString(2, pk.getItemCodeITM01()); ResultSet rset = pstmt.executeQuery(); while (rset.next()) { vo = (ItemVariantVO) map.get(rset.getString(1) + "." + rset.getString(2)); if (vo != null) vo.setSelected(Boolean.TRUE); } rset.close(); pstmt.close(); } if (answer.isError()) throw new Exception(answer.getErrorMessage()); else return (VOListResponse) answer; } catch (Throwable ex) { Logger.error( username, this.getClass().getName(), "getItemVariants", "Error while fetching item variants list", ex); throw new Exception(ex.getMessage()); } finally { try { pstmt.close(); } catch (Exception ex2) { } try { if (this.conn == null && conn != null) { // close only local connection conn.commit(); conn.close(); } } catch (Exception exx) { } } }
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { server svr = new server(); response.setContentType("text/html"); HttpSession session = request.getSession(true); PrintWriter out = response.getWriter(); String email = request.getParameter("email"); String pw1 = request.getParameter("pw1"); String pw2 = request.getParameter("pw2"); String error = null; String username = session.getAttribute("username").toString(); if (pw1.compareTo(pw2) != 0) { error = "Passwords do not match"; session.setAttribute("ErrorMessage", error); response.sendRedirect("home.jsp"); } try { Statement st = null; String strQuery = null; if ((pw1.length() == 0) && (email.length() == 0)) { session.setAttribute("ErrorMessage", "Nothing to change!"); response.sendRedirect("home.jsp"); } else if ((pw1.length() != 0) && (email.length() != 0)) { strQuery = "UPDATE `twitter2012`.`users` SET `password`='" + pw1 + "', `email_address`='" + email + "' WHERE `username`='" + username + "'"; session.setAttribute("email", email); } else if ((pw1.length() == 0) && (email.length() != 0)) { strQuery = "UPDATE `twitter2012`.`users` SET `email_address`='" + email + "' WHERE `username`='" + username + "'"; session.setAttribute("email", email); } else if ((pw1.length() != 0) && (email.length() == 0)) { strQuery = "UPDATE `twitter2012`.`users` SET `password`='" + pw1 + "' WHERE `username`='" + username + "'"; } Connection dbcon = null; Class.forName("com.mysql.jdbc.Driver").newInstance(); dbcon = DriverManager.getConnection(svr.getURL(), svr.getUN(), svr.getPW()); st = dbcon.createStatement(); st.executeUpdate(strQuery); session.setAttribute("ErrorMessage", "Details Changed"); dbcon.close(); session.setAttribute("ErrorMessage", "Details Changed"); response.sendRedirect("home.jsp"); } catch (Exception ex) { out.println(ex); } }
private void doUpdate(PrintWriter out) { Connection con1 = null; // init DB objects Connection con2 = null; PreparedStatement pstmt = null; Statement stmt1 = null; Statement stmt1a = null; Statement stmt2 = null; Statement stmt3 = null; ResultSet rs1 = null; ResultSet rs2 = null; ResultSet rs3 = null; out.println("<HTML><HEAD><TITLE>Database Query</TITLE></HEAD>"); out.println("<BODY><H3>Starting Job to Check for Clubster Users</H3>"); out.flush(); String club = ""; String name = ""; try { con1 = dbConn.Connect(rev); } catch (Exception exc) { // Error connecting to db.... out.println("<BR><BR>Unable to connect to the DB."); out.println("<BR>Exception: " + exc.getMessage()); out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>."); out.println("</BODY></HTML>"); return; } // // Get the club names from the 'clubs' table // // Process each club in the table // int x1 = 0; int x2 = 0; int i = 0; boolean skip = true; try { stmt1 = con1.createStatement(); rs1 = stmt1.executeQuery("SELECT clubname, fullname FROM clubs ORDER BY clubname"); while (rs1.next()) { x1++; club = rs1.getString(1); // get a club name name = rs1.getString(2); // get full club name con2 = dbConn.Connect(club); // get a connection to this club's db stmt2 = con2.createStatement(); rs2 = stmt2.executeQuery("SELECT date FROM sessionlog WHERE msg LIKE '%clubster'"); if (rs2.next()) { out.println("<br><br>"); out.print("Club found: " + club + ", " + name); } stmt2.close(); con2.close(); } stmt1.close(); con1.close(); } catch (Exception e) { // Error connecting to db.... out.println("<BR><BR><H3>Fatal Error!</H3>"); out.println("Error performing update to club '" + club + "'."); out.println("<BR>Exception: " + e.getMessage()); out.println("<BR>Message: " + e.toString()); out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>."); out.println("</BODY></HTML>"); out.close(); Connect.close(stmt2, con2); Connect.close(stmt1, con1); return; } Connect.close(stmt2, con2); Connect.close(stmt1, con1); out.print("<BR><BR>Done, " + x1 + "clubs checked."); out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>"); out.println("</CENTER></BODY></HTML>"); // out.flush(); // out.close(); }
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); HttpSession session = request.getSession(true); try { Object accountObject = session.getValue(ACCOUNT); // If no account object was put in the session, or // if one exists but it is not a hashtable, then // redirect the user to the original login page if (accountObject == null) throw new RuntimeException("You need to log in to use this service!"); if (!(accountObject instanceof Hashtable)) throw new RuntimeException("You need to log in to use this service!"); Hashtable account = (Hashtable) accountObject; String userName = (String) account.get("name"); ////////////////////////////////////////////// // Display Messages for the user who logged in ////////////////////////////////////////////// out.println("<HTML>"); out.println("<HEAD>"); out.println("<TITLE>Contacts for " + userName + "</TITLE>"); out.println("</HEAD>"); out.println("<BODY BGCOLOR='#EFEFEF'>"); out.println("<H3>Welcome " + userName + "</H3>"); out.println("<CENTER>"); Connection con = null; Statement stmt = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection( "jdbc:mysql://localhost/contacts?user=kareena&password=kapoor"); stmt = con.createStatement(); rs = stmt.executeQuery( "SELECT * FROM contacts WHERE userName='******' ORDER BY contactID"); out.println("<form name='deleteContactsForm' method='post' action='deleteContact'>"); out.println("<TABLE BGCOLOR='#EFEFFF' CELLPADDING='2' CELLSPACING='4' BORDER='1'>"); out.println("<TR BGCOLOR='#D6DFFF'>"); out.println("<TD ALIGN='center'><B>Contact ID</B></TD>"); out.println("<TD ALIGN='center'><B>Contact Name</B></TD>"); out.println("<TD ALIGN='center'><B>Comment</B></TD>"); out.println("<TD ALIGN='center'><B>Date</B></TD>"); out.println("<TD ALIGN='center'><B>Delete Contacts</B></TD>"); out.println("</TR>"); int nRows = 0; while (rs.next()) { nRows++; String messageID = rs.getString("contactID"); String fromUser = rs.getString("contactName"); String message = rs.getString("comments"); String messageDate = rs.getString("dateAdded"); out.println("<TR>"); out.println("<TD>" + messageID + "</TD>"); out.println("<TD>" + fromUser + "</TD>"); out.println("<TD>" + message + "</TD>"); out.println("<TD>" + messageDate + "</TD>"); out.println( "<TD><input type='checkbox' name='msgList' value='" + messageID + "'> Delete</TD>"); out.println("</TR>"); } out.println("<TR>"); out.println( "<TD COLSPAN='6' ALIGN='center'><input type='submit' value='Delete Selected Contacts'></TD>"); out.println("</TR>"); out.println("</TABLE>"); out.println("</FORM>"); } catch (Exception e) { out.println("Could not connect to the users database.<P>"); out.println("The error message was"); out.println("<PRE>"); out.println(e.getMessage()); out.println("</PRE>"); } finally { if (rs != null) { try { rs.close(); } catch (SQLException ignore) { } } if (stmt != null) { try { stmt.close(); } catch (SQLException ignore) { } } if (con != null) { try { con.close(); } catch (SQLException ignore) { } } } out.println("</CENTER>"); out.println("</BODY>"); out.println("</HTML>"); } catch (RuntimeException e) { out.println("<script language=\"javascript\">"); out.println("alert(\"You need to log in to use this service!\");"); out.println("</script>"); out.println("<a href='index.html'>Click Here</a> to go to the main page.<br><br>"); out.println( "Or Click on the button to exit<FORM><INPUT onClick=\"javascipt:window.close()\" TYPE=\"BUTTON\" VALUE=\"Close Browser\" TITLE=\"Click here to close window\" NAME=\"CloseWindow\" STYLE=\"font-family:Verdana, Arial, Helvetica; font-size:smaller; font-weight:bold\"></FORM>"); log(e.getMessage()); return; } }
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); } }