/** * 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; Connection con = null; try { Class.forName("com.mysql.jdbc.Driver"); String connectionUrl = "jdbc:mysql://localhost/myflickr?" + "user=root&password=123456"; con = DriverManager.getConnection(connectionUrl); if (con != null) { System.out.println("connected to 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(); System.out.println("SELECT * FROM flickrusers WHERE name='" + username + "'"); rs = stmt.executeQuery("SELECT * FROM flickrusers WHERE name='" + username + "'"); while (rs.next()) { if (rs.getObject(1).toString().equals(username)) { out.println("<h1>To username pou epileksate uparxei hdh</h1>"); out.println("<a href=\"project3.html\">parakalw dokimaste kapoio allo.</a>"); stmt.close(); rs.close(); return; } } stmt.close(); rs.close(); stmt = con.createStatement(); if (!stmt.execute("INSERT INTO flickrusers VALUES('" + username + "', '" + password + "')")) { out.println("<h1>Your registration is completed " + username + "</h1>"); out.println("<a href=\"index.jsp\">go to the login menu</a>"); registerListener.Register(username); } else { out.println("<h1>To username pou epileksate uparxei hdh</h1>"); out.println("<a href=\"project3.html\">Register</a>"); } } catch (SQLException e) { throw new ServletException("Servlet Could not display records.", e); } }
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(); } }
protected collegeTable getCollege(String id, Connection con) throws SQLException { try { ResultSet rs = null; Statement statement = con.createStatement(); rs = statement.executeQuery( "SELECT * FROM " + TABLECOLLEGES + " WHERE " + collegeTable.ID + " = " + id + " LIMIT 1"); // if found if (rs.next()) { collegeTable table = new collegeTable(); table.setID(id); table.setShort(rs.getString(collegeTable.SHORTNAME)); table.setFull(rs.getString(collegeTable.FULLNAME)); return table; } else { return null; // not found } } catch (Exception e) { log.writeException(e.getMessage()); throw new SQLException(e.getMessage()); } } // end getCollege
public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { res.setContentType("text/html"); PrintWriter toClient = res.getWriter(); toClient.println("<!DOCTYPE HTML>"); toClient.println("<html>"); toClient.println("<head><title>Books</title></head>"); toClient.println("<body>"); toClient.println("<a href=\"index.html\">Home</A>"); toClient.println("<h2>List of books</h2>"); HttpSession session = req.getSession(false); if (session != null) { String name = (String) session.getAttribute("name"); if (name != null) { toClient.println("<h2>name: " + name + "</h2>"); } } toClient.print("<form action=\"bookOpinion\" method=GET>"); toClient.println("<table border='1'>"); String sql = "Select code, title, author FROM books"; System.out.println(sql); try { Statement statement = connection.createStatement(); ResultSet result = statement.executeQuery(sql); while (result.next()) { toClient.println("<tr>"); String codeStr = result.getString("code"); toClient.println( "<td><input type=\"radio\" name=\"book" + "\" value=\"" + codeStr + "\"></td>"); toClient.println("<td>" + codeStr + "</td>"); toClient.println("<td>" + result.getString("title") + "</td>"); toClient.println("<td>" + result.getString("author") + "</td>"); toClient.println("</tr>"); } } catch (SQLException e) { e.printStackTrace(); System.out.println("Resulset: " + sql + " Exception: " + e); } toClient.println("</table>"); toClient.println("<textarea rows=\"8\" cols=\"60\" name=\"comment\"></textarea><BR>"); toClient.println("<input type=submit>"); toClient.println("</form>"); toClient.println("</body>"); toClient.println("</html>"); toClient.close(); }
@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 { try { res.setContentType("text/html"); pw = res.getWriter(); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:com", "o7it58", "yajiv32737"); st = con.createStatement(); pw.println("<html>"); pw.println("<head><title>Welcome</title></head>"); pw.println("<body>"); s = req.getParameter("login"); if (s.equals("Submit")) { uname = req.getParameter("firstname"); pass = req.getParameter("pwd"); PrintWriter out = new PrintWriter(new FileWriter("log.txt"), true); out.println(uname); rs = st.executeQuery( "select type from login where username='******' and password='******'"); if (rs.next()) { type = rs.getString("type"); } else { pw.println("<center>"); pw.println("User does not exists"); pw.println("</center>"); } if (type.equals("admin")) { pw.println( "<a href=\"http://localhost:8080/servlet/AdminLogin\">Hello Admin.Please Click Here</a>"); } else if (type.equals("staff")) { pw.println( "<a href=\"http://localhost:8080/servlet/StaffLogin\">Hello Staff.Please Click Here</a>"); } else { pw.println( "<a href=\"http://localhost:8080/servlet/StudentLogin\">Hello Student.Please Click Here</a>"); } } pw.println("</body></html>"); } catch (Exception e) { } }
public void init(ServletConfig sc) throws ServletException { super.init(sc); try { Class.forName("com.mysql.jdbc.Driver"); System.out.println("driver is loaded"); con = DriverManager.getConnection(url, un, password); System.out.println("connected"); stmt = con.createStatement(); System.out.println("wrapper created"); } catch (ClassNotFoundException cnfe) { System.out.println("driver Not Loaded" + cnfe.getMessage()); return; } catch (SQLException sqle) { System.out.println("connection problem" + sqle.getMessage()); return; } }
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 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 doPost (HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { Connection con=null; pw=res.getWriter(); Statement stmt=null; ResultSet rr=null; ResultSetMetaData rsmd; res.setContentType("text/html"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger"); stmt=con.createStatement(); String inm="'"+req.getParameter("txtinm")+"'"; String q="'"+req.getParameter("txtq")+"'"; String t=req.getParameter("txtr"); char type=t.charAt(0); System.out.println((char)type); pw.println("Item name "+inm); pw.println("Quantity "+q); pw.println("Item Type "+t); pw.println((char)type); String qry1=null; switch(type) { case 'H': case 'h': qry1="select rate,iname from hware where iname="+inm; pw.println(qry1); // rr=stmt.executeQuery("select rate from hware where iname="+inm); rr=stmt.executeQuery(qry1); pw.println("Query is Executed..."); break; case 'S': case 's': qry1="select rate,iname from sware where iname="+inm; pw.println(qry1); break; case 'M': case 'm': rr=stmt.executeQuery("select rate,title from music where title="+inm); break; case 'B': case 'b': rr=stmt.executeQuery("select rate,title from books where title="+inm); break; default: { pw.println("Invalid choice"); myflag='n'; } } pw.println("Concerned Statement Prepared and Executed..."); pw.println((char)type+" Valid item type "+myflag); /*rsmd=rr.getMetaData(); int col=rsmd.getColumnCount(); pw.println("The Above Query has fetched "+col+ " Columns");*/ String name=""; while(rr.next()) { String rate=rr.getString(1); int amount=Integer.parseInt(rate); name=rr.getString(2); System.out.println(" "+rate+" "+name); pw.println(" "+amount+" "+name); pw.println("\n"+myflag); System.out.println("Valid item name "+rr.getString(2)+" "+myflag); } pw.println(" "+myflag); if(myflag=='y') { pw.println("\nOK"); pw.println("Valid item name "+name+" "+myflag); if(rr==null) { pw.println("Not a valid item"); myflag='n'; } pw.println("Valid item name "+name+" "+myflag); if(myflag=='y') { pw.println(" "+inm+" "+q); rr=stmt.executeQuery("select * from reges where flag='y'"); if(rr==null) { pw.println("\nSign in first"); //System.exit(0); myflag='n'; } pw.println("Signed in "+rr.getString(1)+" "+myflag); if(myflag=='y') { String data="'"+rr.getString(1)+"'"; String qry="insert into cart values("+inm+","+q+","+data+")"; pw.println("Query is "+qry); int rs=stmt.executeUpdate(qry); pw.println("1 row inserted"); } } } } catch(ClassNotFoundException e){} catch(SQLException e){} }
/** Business logic to execute. */ public final Response executeCommand( Object inputPar, UserSessionParameters userSessionPars, HttpServletRequest request, HttpServletResponse response, HttpSession userSession, ServletContext context) { String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId(); String username = ((JAIOUserSessionParameters) userSessionPars).getUsername(); Connection conn = null; Statement stmt = null; try { conn = ConnectionManager.getConnection(context); // fires the GenericEvent.CONNECTION_CREATED event... EventsManager.getInstance() .processEvent( new GenericEvent( this, getRequestName(), GenericEvent.CONNECTION_CREATED, (JAIOUserSessionParameters) userSessionPars, request, response, userSession, context, conn, inputPar, null)); stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery( "select SYS04_ROLES.PROGRESSIVE,SYS04_ROLES.PROGRESSIVE_SYS10,SYS10_TRANSLATIONS.DESCRIPTION from " + "SYS14_USER_ROLES,SYS04_ROLES,SYS10_TRANSLATIONS where " + "SYS14_USER_ROLES.PROGRESSIVE_SYS04=SYS04_ROLES.PROGRESSIVE and " + "SYS04_ROLES.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and " + "SYS10_TRANSLATIONS.LANGUAGE_CODE='" + serverLanguageId + "' and " + "SYS14_USER_ROLES.USERNAME_SYS03='" + username + "' and " + "SYS04_ROLES.ENABLED='Y'"); RoleVO vo = null; ArrayList list = new ArrayList(); while (rset.next()) { vo = new RoleVO(); vo.setDescriptionSYS10(rset.getString(3)); vo.setEnabledSYS04("Y"); vo.setProgressiveSYS04(rset.getBigDecimal(1)); vo.setProgressiveSys10SYS04(rset.getBigDecimal(2)); list.add(vo); } rset.close(); Response answer = new VOListResponse(list, false, list.size()); // fires the GenericEvent.BEFORE_COMMIT event... EventsManager.getInstance() .processEvent( new GenericEvent( this, getRequestName(), GenericEvent.BEFORE_COMMIT, (JAIOUserSessionParameters) userSessionPars, request, response, userSession, context, conn, inputPar, answer)); return answer; } catch (Throwable ex) { Logger.error( userSessionPars.getUsername(), this.getClass().getName(), "executeCommand", "Error while fetching user roles list", ex); return new ErrorResponse(ex.getMessage()); } finally { try { stmt.close(); } catch (Exception ex2) { } try { ConnectionManager.releaseConnection(conn, context); } catch (Exception ex1) { } } }
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; } }
@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 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 }
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(); }
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()); } } }
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(); }
/** Business logic to execute. */ public final Response executeCommand( Object inputPar, UserSessionParameters userSessionPars, HttpServletRequest request, HttpServletResponse response, HttpSession userSession, ServletContext context) { String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId(); Connection conn = null; Statement stmt = null; try { conn = ConnectionManager.getConnection(context); // fires the GenericEvent.CONNECTION_CREATED event... EventsManager.getInstance() .processEvent( new GenericEvent( this, getRequestName(), GenericEvent.CONNECTION_CREATED, (JAIOUserSessionParameters) userSessionPars, request, response, userSession, context, conn, inputPar, null)); java.util.List list = (ArrayList) inputPar; HierarItemDiscountVO vo = null; ResultSet rset = null; stmt = conn.createStatement(); for (int i = 0; i < list.size(); i++) { vo = (HierarItemDiscountVO) list.get(i); vo.setDiscountTypeSAL03(ApplicationConsts.DISCOUNT_CUSTOMER); // retrieve COMPANY_CODE from progressiveHIE01... rset = stmt.executeQuery( "select COMPANY_CODE_SYS01 from ITM02_ITEM_TYPES where PROGRESSIVE_HIE02 in " + "(select PROGRESSIVE_HIE02 from HIE01_LEVELS where PROGRESSIVE=" + vo.getProgressiveHie01SAL05() + ")"); if (rset.next()) vo.setCompanyCodeSys01SAL03(rset.getString(1)); else { rset.close(); conn.rollback(); return new ErrorResponse("Item hierarchy not found."); } rset.close(); DiscountBean.insertDiscount(conn, vo); stmt.execute( "insert into SAL05_ITEM_HIERAR_DISCOUNTS(COMPANY_CODE_SYS01,PROGRESSIVE_HIE01,DISCOUNT_CODE_SAL03) " + "values('" + vo.getCompanyCodeSys01SAL03() + "'," + vo.getProgressiveHie01SAL05() + ",'" + vo.getDiscountCodeSAL03() + "')"); } Response answer = new VOListResponse(list, false, list.size()); // fires the GenericEvent.BEFORE_COMMIT event... EventsManager.getInstance() .processEvent( new GenericEvent( this, getRequestName(), GenericEvent.BEFORE_COMMIT, (JAIOUserSessionParameters) userSessionPars, request, response, userSession, context, conn, inputPar, answer)); conn.commit(); // fires the GenericEvent.AFTER_COMMIT event... EventsManager.getInstance() .processEvent( new GenericEvent( this, getRequestName(), GenericEvent.AFTER_COMMIT, (JAIOUserSessionParameters) userSessionPars, request, response, userSession, context, conn, inputPar, answer)); return answer; } catch (Throwable ex) { Logger.error( userSessionPars.getUsername(), this.getClass().getName(), "executeCommand", "Error while inserting hierarchy item discounts", ex); try { conn.rollback(); } catch (Exception ex3) { } return new ErrorResponse(ex.getMessage()); } finally { try { stmt.close(); } catch (Exception ex2) { } try { ConnectionManager.releaseConnection(conn, context); } catch (Exception ex1) { } } }
public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); PreparedStatement pstmt = null; Statement stmt = null; ResultSet rs = null; HttpSession session = SystemUtils.verifyMem(req, out); // check for intruder if (session == null) return; Connection con = Connect.getCon(req); // get DB connection if (con == null) { resp.setContentType("text/html"); out.println(SystemUtils.HeadTitle("DB Connection Error")); out.println("<BODY><CENTER><BR>"); out.println("<BR><BR><H3>Database Connection Error</H3>"); out.println("<BR><BR>Unable to connect to the Database."); out.println("<BR>Please try again later."); out.println("<BR><BR>If problem persists, contact customer support."); out.println("<BR><BR>"); out.println("<a href=\"javascript:history.back(1)\">Return</a>"); out.println("</CENTER></BODY></HTML>"); out.close(); return; } // // Get needed vars out of session obj // String club = (String) session.getAttribute("club"); String user = (String) session.getAttribute("user"); String caller = (String) session.getAttribute("caller"); int activity_id = (Integer) session.getAttribute("activity_id"); int foretees_mode = 0; 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 + " -->"); // // START PAGE OUTPUT // out.println(SystemUtils.HeadTitle("Member Acivities")); out.println("<style>"); out.println(".actLink { color: black }"); out.println(".actLink:hover { color: #336633 }"); // out.println(".playerTD {width:125px}"); out.println("</style>"); out.println( "<body bgcolor=\"#CCCCAA\" text=\"#000000\" link=\"#336633\" vlink=\"#8B8970\" alink=\"#8B8970\">"); SystemUtils.getMemberSubMenu(req, out, caller); // required to allow submenus on this page // // DISPLAY A LIST OF AVAILABLE ACTIVITIES // out.println( "<p align=center><b><font size=5 color=#336633><BR><BR>Available Activities</font></b></p>"); out.println( "<p align=center><b><font size=3 color=#000000>Select your desired activity from the list below.<br>NOTE: You can set your default activity under <a href=\"Member_services\" class=actLink>Settings</a>.</font></b></p>"); out.println("<table align=center>"); try { stmt = con.createStatement(); rs = stmt.executeQuery("SELECT foretees_mode FROM club5 WHERE clubName <> '';"); if (rs.next()) { foretees_mode = rs.getInt(1); } // if they have foretees then give a link in to the golf system if (foretees_mode != 0) { out.println( "<tr><td align=center><b><a href=\"Member_jump?switch&activity_id=0\" class=linkA style=\"color:#336633\" target=_top>Golf</a></b></td></tr>"); // ForeTees } // build a link to any activities they have access to rs = stmt.executeQuery( "SELECT * FROM activities " + "WHERE parent_id = 0 " + "ORDER BY activity_name"); while (rs.next()) { out.println( "<tr><td align=center><b><a href=\"Member_jump?switch&activity_id=" + rs.getInt("activity_id") + "\" class=linkA style=\"color:#336633\" target=_top>" + rs.getString("activity_name") + "</a></b></td></tr>"); } stmt.close(); } catch (Exception exc) { out.println("<p>ERROR:" + exc.toString() + "</p>"); } finally { try { rs.close(); } catch (Exception ignore) { } try { stmt.close(); } catch (Exception ignore) { } } out.println("</table>"); out.println("</body></html>"); /* 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("function load_times(id) {"); out.println(" top.bot.location.href='Member_gensheets?id=' + id;"); 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 activities WHERE parent_id = 0"); while (rs.next()) { Common_Config.buildOption(rs.getInt("activity_id"), rs.getString("activity_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 activity_id, activity_name FROM activities WHERE parent_id = " + type_id); rs.last(); if (rs.getRow() == 1) { group_id = rs.getInt("activity_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("activity_id"), rs.getString("activity_name"), group_id, out); } stmt.close(); } catch (Exception exc) { out.println("<p>ERROR:" + exc.toString() + "</p>"); } } out.println(""); out.println("</select>"); boolean do_load = false; if (group_id > 0 ) { //|| sitem_id != null // LOAD ACTIVITIES BY ITEM TYPE try { stmt = con.createStatement(); rs = stmt.executeQuery("SELECT activity_id, activity_name FROM activities WHERE parent_id = " + group_id); rs.last(); if (rs.getRow() == 0) { // no sub groups found do_load = true; item_id = group_id; } else if (rs.getRow() == 1) { // single sub group found (pre select it) item_id = rs.getInt("activity_id"); out.println("<!-- ONLY FOUND 1 ITEM -->"); } else { out.println("<select name=item_id onchange=\"load_times(this.options[this.selectedIndex].value)\">"); out.println("<option value=\"0\">CHOOSE...</option>"); } if (!do_load) { rs.beforeFirst(); while (rs.next()) { Common_Config.buildOption(rs.getInt("activity_id"), rs.getString("activity_name"), item_id, out); } } stmt.close(); out.println(""); out.println("</select>"); } catch (Exception exc) { out.println("<p>ERROR:" + exc.toString() + "</p>"); } } out.println("</form>"); out.println("<p><a href=\"Member_genrez\">Reset</a></p>"); try { con.close(); } catch (Exception ignore) {} if (do_load) out.println("<script>load_times(" + item_id + ")</script>"); //out.println("<iframe name=ifSheet src=\"\" style=\"width:640px height:480px\"></iframe>"); */ out.close(); }
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; }
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 doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String userAgent = request.getHeader("user-agent"); if (userAgent.matches(".*Android.*")) { int flag = 0; try { Connection con = DBConnectionAdmin.getConnection(); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT email,password FROM admin"); String emailmember = request.getParameter("mail"); String passwordmember = request.getParameter("pass"); while (rs.next()) { String email = rs.getString("email"); String password = rs.getString("password"); if (email.equals(emailmember) && password.equals(passwordmember)) { flag = 1; // success in login break; } } /*if(request.getParameter("remember")!=null ){ if( request.getParameter("remember").equals("yes") ){ Cookie c1 = new Cookie("email", emailmember); c1.setMaxAge(60*60*24*365); response.addCookie(c1); Cookie c2 = new Cookie("password", passwordmember); c2.setMaxAge(60*60*24*365); response.addCookie(c2); } } else{ Cookie[] cookies = request.getCookies(); if (cookies != null) { for(Cookie cookie: cookies) { if(cookie.getName().equals("email")){ cookie.setMaxAge(0); response.addCookie(cookie); } else if(cookie.getName().equals("password")){ cookie.setMaxAge(0); response.addCookie(cookie); } } } }*/ } catch (SQLException | ClassNotFoundException e1) { e1.printStackTrace(); } if (flag == 1) { response.setContentType("text/html"); PrintWriter out = response.getWriter(); String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\">\n"; String title = "You Signed In Successfully"; out.println( docType + "<HTML>\n" + "<HEAD>" + "<script type='text/javascript'>" + "function changeweb() {" + " AndroidFunction.Second();" + "}" + "</script>" + "<TITLE>" + title + "</TITLE></HEAD>\n" + "<BODY BGCOLOR=\"#FDF5E6\" ><H1 ALIGN=CENTER>" + title + "</H1>\n" + "<button type='button' onclick=\"changeweb()\">Click Me!</button>" + "</BODY></HTML>"); HttpSession session = request.getSession(true); String email = request.getParameter("mail"); session.setAttribute("email", email); } else { response.setContentType("text/html"); PrintWriter out = response.getWriter(); String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\">\n"; String title = "Wrong password or E-mail.Please try again."; out.println( docType + "<HTML>\n" + "<HEAD><TITLE>" + title + "</TITLE></HEAD>\n" + "<BODY BGCOLOR=\"#FDF5E6\" ><H1 ALIGN=CENTER>" + title + "</H1>\n</BODY></HTML>"); } } else { response.setContentType("text/html"); PrintWriter out = response.getWriter(); String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\">\n"; String title = "Main"; out.println( docType + "<HTML>\n" + "<HEAD><TITLE>" + title + "</TITLE>" + "<style>" + "ul" + "{" + "list-style-type:none;" + "margin:0;" + "padding:0;" + "overflow:hidden;" + "}" + "li" + "{" + "float:left;" + "}" + "a:link,a:visited" + "{" + "display:block;" + "font-weight:bold;" + "font-size:200%;" + "color:#FFFFFF;" + "background-color:#98bf21;" + "text-align:center;" + "padding:4px;" + "text-decoration:none;" + "text-transform:uppercase;" + "border: 1px solid black;" + "padding:25px" + "}" + "a:hover,a:active" + "{" + "background-color:#7A991A;" + "}" + "</style>" + "</HEAD>\n" + "<body style='background-color:black' >\n"); out.println("<ul>"); out.println("<li><a href='http://localhost:8083/TestProject/main.html'>New Event!!</a></li>"); out.println("<li><a href='post.Eventlist'>Events</a></li>"); out.println("<li><a href='post.Myeventlist'>My Events</a></li>"); out.println("<li><a href='post.Memberslist'>Members</a></li>"); out.println("<li><a href='post.Profile'>Profile</a></li>"); out.println("<li><a href='post.Help'>Help</a></li>"); out.println("</ul>"); out.println("</BODY></HTML>"); } }
/** * 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); } }
/** @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(); } }
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); } }
@Override public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { out = response.getWriter(); HttpSession session; String connectionURL = USERS_INFO; Connection connection = null; ResultSet rs; String email = ""; String userName = ""; String passwrd = ""; String remoteAddr = ""; response.setContentType("text/html"); int error = 0; try { // Load the database driver Class.forName("com.mysql.jdbc.Driver"); // Get a Connection to the database connection = DriverManager.getConnection(connectionURL, USERNAME, PASSWORD); // Add the data into the database String sql = "SELECT username, email FROM users"; Statement s = connection.createStatement(); s.executeQuery(sql); rs = s.getResultSet(); while (rs.next()) { email = rs.getString("email"); userName = rs.getString("username"); if (email.equals(request.getParameter("email"))) { String message = "Email" + email + "already exists"; request.setAttribute("RegisterMessage", message); RequestDispatcher view = request.getRequestDispatcher("signup.jsp"); view.forward(request, response); error = 1; } if (userName.equals(request.getParameter("user"))) { String message = "Username '" + userName + "' already exists"; request.setAttribute("RegisterMessage", message); RequestDispatcher view = request.getRequestDispatcher("signup.jsp"); view.forward(request, response); error = 1; } if (error == 1) { break; } } passwrd = request.getParameter("pass"); if (!passwrd.equalsIgnoreCase(request.getParameter("pass2"))) { String message = "Passwords don't match"; request.setAttribute("RegisterMessage", message); RequestDispatcher view = request.getRequestDispatcher("signup.jsp"); view.forward(request, response); error = 1; } remoteAddr = request.getRemoteAddr(); // ReCaptchaImpl reCaptcha = new ReCaptchaImpl(); // reCaptcha.setPrivateKey("6LezstoSAAAAAEE9lfB6TR2kEX81_peDt4n03K4l"); // String challenge = request.getParameter("recaptcha_challenge_field"); // String uresponse = request.getParameter("recaptcha_response_field"); // ReCaptchaResponse reCaptchaResponse = reCaptcha.checkAnswer(remoteAddr, challenge, // uresponse); /*if (!reCaptchaResponse.isValid()) { print_wrong_once(error); out.print("<h2 align=\"center\">Validation code is wrong.</h2>"); error = 1; }*/ if (error == 1) { rs.close(); s.close(); return; } else { sql = "INSERT INTO users_info.users (`username`, `password`, `email`) VALUES ('" + request.getParameter("user") + "', '" + request.getParameter("pass") + "', '" + request.getParameter("email") + "')"; s.executeUpdate(sql); File dir = new File(mainPath + "/" + request.getParameter("user")); dir.mkdir(); session = request.getSession(true); session.setAttribute("username", request.getParameter("user")); response.sendRedirect(response.encodeRedirectURL("XmlParser")); } rs.close(); s.close(); connection.close(); } catch (Exception e) { System.out.println("Unexpected error: " + e); } }
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); } }