| | |
how to pass the parameters of jsp from one servlet to another
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Nov 2008
Posts: 28
Reputation:
Solved Threads: 0
Hi i created one jsp form with 2 fields..now in the first servlet i want check whether those 2 fields values are presented in the Database or not..if not then i want move those values to another servlet .. how can i do this?how to get the values (parameter values of jsp in second servlet... here is my code plz check it once.. and send me update ASAP very urgent...
1st Servlet..
1st Servlet..
java Syntax (Toggle Plain Text)
____________ package com; import java.io.*; import java.util.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class SearchServlet extends HttpServlet { private ServletConfig config; public void init(ServletConfig config) throws ServletException{ this.config=config; } public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException{ HttpSession ses=request.getSession(); PrintWriter out = response.getWriter(); String connectionURL = "jdbc:mysql://localhost/test"; Connection connection=null; ResultSet rs; String mobileno=request.getParameter("mobileno"); String password=request.getParameter("password"); response.setContentType("text/html"); try { // Load the database driver Class.forName("com.mysql.jdbc.Driver"); // Get a Connection to the database connection = DriverManager.getConnection(connectionURL, "root", "DBpassword"); //Add the data into the database String sql = "select mobileno,password from newuser"; Statement s = connection.createStatement(); s.executeQuery (sql); rs = s.getResultSet(); while (rs.next ()){ mobileno=rs.getString("mobileno"); password=rs.getString("password"); } rs.close (); s.close (); }catch(Exception e) { System.out.println("Exception is ;"+e); } if(mobileno.equals(request.getParameter("mobileno")) && password.equals(request.getParameter("password"))){ request.setAttribute("MOBILENO",mobileno); request.setAttribute("PASSWORD",password); mobileno = (String)ses.getAttribute("MOBILENO"); out.print("<h1>You are Already Registerd </h1>"); } else { // out.println("<h1>You are not a Valid User Please Register</h1>"); // response.sendRedirect("/ServletProject/ValidUser"); request.setAttribute("MOBILENO",mobileno); request.setAttribute("PASSWORD",password); response.sendRedirect("LoginServlet"); //out.println("<a href='newregister.jsp'><br>Register Here!!</a>"); } } } 2nd servlet... ___________ package com; import java.io.*; import java.util.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class LoginServlet extends HttpServlet{ private ServletConfig config; public void init(ServletConfig config) throws ServletException{ this.config=config; } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException{ PrintWriter out = response.getWriter(); String connectionURL = "jdbc:mysql://localhost/test"; Connection connection=null; HttpSession ses=request.getSession(); String mobileno = (string)ses.getAttribute(mobileno); String password = ses.getAttribute(password); response.setContentType("text/html"); try { // Load the database driver Class.forName("com.mysql.jdbc.Driver"); // Get a Connection to the database connection = DriverManager.getConnection(connectionURL, "root", "DBpassword"); //Add the data into the database String sql = "insert into newuser values(" + mobileno + ",'" + password + "')"; Statement s = connection.createStatement(); int x = s.executeUpdate(sql); if(x==1) { out.println("<h1> Thanks For the Registration</h1>"); out.println("<br><h1> Welcome to 4s Technologies</h1></br>"); } else{ out.println("<h1>+Your Registration is failed..Plase try again+</h1>"); out.println("<a href='newregister.jsp'><br>Register Here!!</a>"); } s.close(); } catch(Exception e) { System.out.println("Exception is ;"+e); } } }
Last edited by ~s.o.s~; Nov 22nd, 2008 at 2:14 am. Reason: Added code tags, learn to use them.
•
•
•
•
here is my code plz check it once.. and send me update ASAP very urgent...
- Once again you posted in wrong section. In Web Development we have JSP section to which most of your posts been already moved and this one will be hopefully moved soon
- Your imperious demand for immediate results is shameful
- If you actually bother tried to search around you would find a solution, like this one
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
![]() |
Similar Threads
- Passing parameters back to calling document (JSP)
- Difference between <%@include%> and <jsp:include> (JSP)
- generating dynamic/runtime query (JSP)
Other Threads in the JSP Forum
- Previous Thread: Separate JSP-Page and Content
- Next Thread: Reading the mail ids from other websites.
| Thread Tools | Search this Thread |
apache array backbutton combobox comma connection csv database development directorystructure dropdownlist dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 mysql netbeans network parameters passing ping printinserverinsteadofclient read redirect request.getparameter response seperated servlet servletdopost()readxml sessions software sql ssl state_saving_method stocks sun tomcat tutorial update values video web write






