Forum:

Retrive a single data from database and display that in jsp text box.

Ranch Hand

Posts: 119

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

I tried to retrive the data from database its perfect but iam getting all the datas but my problem is i can't retrive a single data from database and i need to display that data in jsp page.

I tried but i am not getting any error, iam getting my jsp page but after iam giving a data and click the submit button its in blank only i can't retrive them please help me to solve my issue.

My database is MYSql. just two datas if i retrive from database and shown in jsp field mens then i will develop remaing information.

my database code is :

My jsp code is

I know that iam doing mistake but i can't find it in google also i tried iam getting fail only Please Guide me to solve my issue. no one is not there to guide me in my office iam developing alone so please solve my issue as soon as possible and give guide to me.Because by using this idea only iam going develop my project in frameworks is just foundation so please put my foundation strongly.

Thanks in advance.

Gopakumar Naryanan

Ranch Hand

Posts: 72

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Correct your Query. Are there many records with fname?
I guess you may want to pass the requestParameter 'fname' in your query. Please check it.

Thanks & Regards
Gopakumar

P Arunkumar

Ranch Hand

Posts: 119

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

I have changed my code but still its same only, if i give my fname it wants to show my first name and last name from database in database also i am having same fname and lname only.

String connectionURL = "jdbc:mysql://localhost:3306/pdfpro";   
       Connection connection = null;   
       Statement statement = null;   
       ResultSet doc = null;   
       Class.forName("com.mysql.jdbc.Driver").newInstance();   
       int updateQuery = 0;   
       String fname = request.getParameter("fname");
       String lname = request.getParameter("lname");
 try{   
                   connection = DriverManager.getConnection(connectionURL, "root", "root");   
                    String queryString = "select * from adduser where fname='fname'" ;   
                   doc=statement.executeQuery(queryString);   
                   while (doc.next()) {   
                       fname=doc.getString(1);   
                       lname=doc.getString(2);   
                        }   
}   
catch(Exception e)   
        {   
            out.println("Unable to connect to database");   
        }   
        finally{   
            statement.close();   
            connection.close();   
               }

Gopakumar Naryanan

Ranch Hand

Posts: 72

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

try this.

Thanks & Regards
Gopakumar

P Arunkumar

Ranch Hand

Posts: 119

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I have tried but still ame issue. now iam give my full sapmle code its for sample only later i will make it with servlet code, my code in jsp page in jsp page java code its not perfect i know but for time being iam using like this don't mistake me.

my jsp page.

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %> 
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Add Details</title>
</head>
<body bgcolor="#ffffcc">
<h1><b><center>Find Customer</center></b></h1>
<center>
<form action="text.jsp" method="get" >
	 <TABLE style="background-color: #ECE5B6;" WIDTH="80%" >
                    <tr>
                        <td> First Name : </td><td> <input name="fname" size=15 type='text' id='fname' /> </td><td> Last Name : </td><td> <input name="lname" size=15 type="text" id='lname' /> </td> 
                    </tr>
                    <tr>
                        <td> Phone Number (9-13) : </td><td> <input name="phone" size=15 type="text" id='phone'/> </td><td> Mobile Number : </td><td> <input name="mobile" id='mobile' size=15 type="text" /> </td> 
                    </tr>
                    <tr>
                        <td> Door Number : </td><td> <input name="doorno" id='doorno' size=15 type='text' /> </td><td> Address1 : </td><td> <input name="addr1" id='addr1' size=15 type="text" /> </td>
                    </tr>
                    <tr>
                        <td> Address2 : </td><td> <input name="addr2" id='addr2' size=15 type='text' /> </td><td> Address3 : </td><td> <input name="addr3" id='addr3' size=15 type="text" /> </td>
                    </tr>
                    <tr>
                        <td> City : </td><td> <input name="city" id='city' size=15 type="text" /> </td><td> Zip : </td><td> <input name="zip" id='zip' size=15 type="text" /> </td> 
                    </tr>
                    <tr>
                        <td> State : </td><td> <input name="state" id='state' size=15 type="text" /> </td><td> Country : </td><td> <input name="country" id='country' size=15 type="text" /> </td> 
                    </tr>
                    <tr>
                        <td> Email-id  : </td><td> <input name="email" id='email' size=15 type="text" /> </td> 
                    </tr>
                    <tr></tr> <tr></tr> 
                    <tr>
                    <center>
                         <td></td><td><input type='submit' value='Submit' onclick='return formValidator()' /></td>
                    </center>                  
                    </tr>
                    
      </table>
      <%
       String fname = request.getParameter("fname");
       String lname = request.getParameter("lname");
       String phone = request.getParameter("phone");
       String mobile = request.getParameter("mobile");
       String doorno = request.getParameter("doorno");
       String addr1 = request.getParameter("addr1");
       String addr2 = request.getParameter("addr2");
       String addr3 = request.getParameter("addr3");
       String city = request.getParameter("city");
       String zip = request.getParameter("zip");
       String state = request.getParameter("state");
       String country = request.getParameter("country");
       String email = request.getParameter("email");
       String username = request.getParameter("username");
       String password = request.getParameter("password");
       String connectionURL = "jdbc:mysql://localhost:3306/pdfpro";
       Connection connection = null;
       Statement statement = null;
       ResultSet doc = null;
       Class.forName("com.mysql.jdbc.Driver").newInstance();
       int updateQuery = 0;
       if(fname!=null && lname!=null && phone!=null && mobile!=null && doorno!=null && addr1!=null && addr2!=null && addr3!=null && city!=null && zip!=null && state!=null && country!=null && email!=null && username!=null && password!=null){
    	   if(fname!="" && lname!="" && phone!="" && mobile!="" && doorno!="" && addr1!="" && addr2!="" && addr3!="" &&  city!="" &&  zip!="" &&  state!="" &&  country!="" &&  email!="" &&  username!="" &&  password!=""){
    		   try{
    			   connection = DriverManager.getConnection(connectionURL, "root", "jeni");
    			    String queryString = "select * from adduser where fname="+fname ;
    			   doc=statement.executeQuery(queryString);
    			   while (doc.next()) {
    				   fname=doc.getString(1);
    				   lname=doc.getString(2);
    				   phone=doc.getString(3);
    				   mobile=doc.getString(4);
    				   doorno=doc.getString(5);
    				   addr1=doc.getString(6);
    				   addr2=doc.getString(7);
    				   addr3=doc.getString(8);
    				   city=doc.getString(9);
    				   zip=doc.getString(10);
    				   state=doc.getString(11);
    				  country=doc.getString(12);
    				  email=doc.getString(13);
    			   }
    	%>
    	<br>
                  <TABLE style="background-color: #E3E4FA;" 
                  WIDTH="30%" border="1">
                     <tr><th>Data is inserted successfully 
                   in database.</th></tr>
                  </table>
    	<%
    		 
    		}
    	catch(Exception e)
    	{
    		out.println("Unable to connect to database");
    	}
    	finally{
    		statement.close();
    		connection.close();
    	       }
    	   }
       }
    %>
</form>
</center>
</body>
</html>

Please solve me.

Gopakumar Naryanan

Ranch Hand

Posts: 72

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

:confused: Forget about all these things.. make it clear what are you trying to do?

As far as i understood, you are taking fname from the user and trying to retrieve data related to the 'fname'(of one perticular user). you are getting multiple records instead of one.

am i right?

please display the value of the 'fname' variable... use SQLException and ClassNotFoundException classes in catch block.

Please Write the servlet code in java file.. i'm not used of these scriptlets etc. :thumbdown:

Make it more clear.. it will be easy to solve the problem.

Thanks & Regards
Gopakumar

P Arunkumar

Ranch Hand

Posts: 119

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

I have tried But iam getting error Exception is : Java.SQL.SQLException: After end of result set.

My Jsp Page : find.jsp

WelcomeServlet

package jsptube.tutorials;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
public class WelcomeServlet extends HttpServlet {
 
@Override
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
 
 
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	PrintWriter out = response.getWriter();
	  String connectionURL = "jdbc:mysql://localhost:3306/messagepaging";
	  Connection connection=null;
	  ResultSet rs;
	  String userName=request.getParameter("user");
	  String passwrd=request.getParameter("pass");
	  response.setContentType("text/html");
	  int count=0;
	  try {
	 // Load the database driver
	  Class.forName("com.mysql.jdbc.Driver");
	  // Get a Connection to the database
	  connection = DriverManager.getConnection(connectionURL, "root", "root"); 
	  //Add the data into the database
	  	  Statement s = connection.createStatement();
	  s.executeQuery ("select * from user where user='"+userName+"'");
	  rs = s.getResultSet();
	  while (rs.next ()){
		  count++;
	  }
	  if(count>0){
		  userName = rs.getString(1);
		  passwrd = rs.getString(2);
          RequestDispatcher dispatcher=getServletContext().getRequestDispatcher( "/find.jsp" );
   	      dispatcher.forward( request, response );
          }
         else{
        	 out.println("Invalid user");
         }
	  rs.close ();
	  s.close ();
	  }
	  catch(SQLException e){
	  System.out.println("Exception is ;"+e);
	  } 
	  catch (ClassNotFoundException e) {
		  System.out.println("Exception is ;"+e);
	}
 
}
 public void destroy() { 
}
}

Web.xml:

I am having some username and password in my database if i gave username and click ok means it wants to show the password in the text box.
It is like find option. please help me to solve my issue.

Thanks in advance.

P Arunkumar

Ranch Hand

Posts: 119

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

I have tried by servlet but still iam getting error.

Exception is : java.SQL.SQLException:After end of result set.

find .jsp

servlet

package jsptube.tutorials;

Web.xml:

iam having some username and password in my database if i gave username and click ok means it wants to show the password in inputfield.
it is same as finding option.

Please help me to solve my issue.

Thanks in advance.

S Subbu

Ranch Hand

Posts: 87

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Arun,

I can't understand your problem.What i understood is

You have User Name and Password in your database and have a jsp page that contains username and passwords input text fileds when you type user name and then click submit button you get the
password related to that username .

For this you have to use ajax.This is the better way . Leave ajax now do what i say

In Servlet Page

String connectionURL = "jdbc:mysql://localhost:3306/pdfpro";   
       Connection connection = null;   
       Statement statement = null;   
       ResultSet doc = null;   
       Class.forName("com.mysql.jdbc.Driver").newInstance();   
       int updateQuery = 0;   
 try{   
                   connection = DriverManager.getConnection(connectionURL, "root", "root");   
                    String queryString = "select * from adduser where fname='"+request.getParameter("fname").trim()+"'" ;   //Trim() for any space in your username
                   doc=statement.executeQuery(queryString);   
                   if(doc.next()) {   //Use If rather than while . 
                       request.setAttribute("fname",doc.getString(1));   //set the getting values in request attribute.
                       request.setAttribute("lname",doc.getString(1));   //set the getting values in request attribute.
                   }   
}   
catch(Exception e)   
        {   
            out.println("Unable to connect to database");   
        }   
        finally{   
            statement.close();   
            connection.close();   
               }   
             
       //Back  to Find.jsp page
      RequestDispatcher rd = request.getRequestDispatcher("/find.jsp");
      rd.forward(request,response)

In Your JSP Page add value to input tags like

<td> First Name : </td><td> <input name="fname" size=15 type='text' id='fname' value='${request.fname}' /> </td><td> Last Name : </td><td> <input name="lname" size=15 type="text" id='lname' value='${request.lname}' /> </td>

EL Works if your jdk is greater than 5.0

P Arunkumar

Ranch Hand

Posts: 119

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

Thank you for your guide still iam facing problem.

Now iam not getting any error and iam getting my jsp page but still in my jsp page my username and password is not reflecting. please now iam giving my full code please check and guide me.

find.jsp page:

my servlet

package jsptube.tutorials;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
public class WelcomeServlet extends HttpServlet {
 
@Override
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
 
 
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	PrintWriter out = response.getWriter();
	  String connectionURL = "jdbc:mysql://localhost:3306/messagepaging";
	  Connection connection=null;
	  Statement s=null;
	  ResultSet rs=null;
	  String user=request.getParameter("user");
	  String password=request.getParameter("password");
	  response.setContentType("text/html");
	  int count=0;
	  try {
	 // Load the database driver
	  Class.forName("com.mysql.jdbc.Driver");
	  // Get a Connection to the database
	  connection = DriverManager.getConnection(connectionURL, "root", "root"); 
	  //Add the data into the database
	  	   s = connection.createStatement();
	  	 String QueryString = "select * from user where user='"+user.trim()+"'";
          rs = s.executeQuery(QueryString);
	  while (rs.next ()){
		request.setAttribute("user",rs.getString(1));
		request.setAttribute("password",rs.getString(2));
		  }
	  rs.close();
                    s.close();
	  RequestDispatcher dispatcher=getServletContext().getRequestDispatcher( "/find.jsp" );
	  dispatcher.forward( request, response );
	  }
	  catch(SQLException e){
	  System.out.println("Exception is ;"+e);
	  } 
	  catch (ClassNotFoundException e) {
		  System.out.println("Exception is ;"+e);
	}
	}
 public void destroy() { 
}
}

web.xml

Now if i gave my username and click ok button it is coming to jsp page but from database it is not taking my username and password from database and not reflecting in jsp page input field.

Please help me in which place iam doing mistake.

Thanks in advance.

S Subbu

Ranch Hand

Posts: 87

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am Placing System.out.println() and observer the outputs

Please execute query in sql browser.(I placed query string in System.out.println()) execute That .

package jsptube.tutorials;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
public class WelcomeServlet extends HttpServlet {
 
@Override
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
 
 
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	PrintWriter out = response.getWriter();
	  String connectionURL = "jdbc:mysql://localhost:3306/messagepaging";
	  Connection connection=null;
	  Statement s=null;
	  ResultSet rs=null;
	  String user=request.getParameter("user");
	  String password=request.getParameter("password");
	  response.setContentType("text/html");
	  int count=0;
	  try {
	 // Load the database driver
	  Class.forName("com.mysql.jdbc.Driver");
	  // Get a Connection to the database
	  connection = DriverManager.getConnection(connectionURL, "root", "root"); 
	  //Add the data into the database
	  	   s = connection.createStatement();
	  	 String QueryString = "select * from user where user='"+user.trim()+"'";
         System.out.println(QueryString)
          rs = s.executeQuery(QueryString);
	  if(rs.next ()){//Use If Here not While
		request.setAttribute("user",rs.getString(1));
		request.setAttribute("password",rs.getString(2));
		  }
                   System.out.println(request.getAttribute("user"));
                  System.out.println(request.getAttribute("password")) 
	  rs.close();
                    s.close();
	  RequestDispatcher dispatcher=getServletContext().getRequestDispatcher( "/find.jsp" );
	  dispatcher.forward( request, response );
	  }
	  catch(SQLException e){
	  System.out.println("Exception is ;"+e);
	  } 
	  catch (ClassNotFoundException e) {
		  System.out.println("Exception is ;"+e);
	}
	}
 public void destroy() { 
}
}

Check Web.xml after close <web-app> tag again pasted some mapping there.

P Arunkumar

Ranch Hand

Posts: 119

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

Thanks you for your reply.

From database it is taking username and password but that username and password is not showing in jsp input field.

Please understand my question, iam haveing one jsp page its having 2 fields one is username and password in database iam having some username and password. if i gave username and click ok means in username field it wants to show username and in password field it wants to take the password from database and that password wants to reflect in jsp page.

It is same as find option, data is taken from database but that data is not fetching in jsp page. iam running in eclipse in console tab it is showing the information but in jsp page in particular place it is not reflecting. i don't know that i want to keep one jsp page or 2jsp page.

Please guide me to solve my issue. please help me. to ask this doute also iam not having any member to help me in my office,iam developing alone please guide me.

Thanks in advance.

P Arunkumar

Ranch Hand

Posts: 119

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

i have finished the task but now iam facing one more problem.

While iam running my jsp page its showing null in input field,i know why its showing but i don't know how to solve my issue please help me. Iam passing my values in the jsp page for that resone its showing null but if i pass the values only from database its showing values in input filed . please help me.

My find.jsp page is

If you note in my jsp page i have given value="<%=request.getAttribute("user") %>" for that resone only its showing null values, then by using this line code only iam getting values from database in input field. please help me to avoid my issue.

My servlet code is:

package jsptube.tutorials;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
public class WelcomeServlet extends HttpServlet {
 
@Override
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
 
 
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	PrintWriter out = response.getWriter();
	  String connectionURL = "jdbc:mysql://localhost:3306/messagepaging";
	  Connection connection=null;
	  Statement s=null;
	  ResultSet rs=null;
	  String user=request.getParameter("user");
	  String password=request.getParameter("password");
	  response.setContentType("text/html");
	  int count=0;
	  try {
	 // Load the database driver
	  Class.forName("com.mysql.jdbc.Driver");
	  // Get a Connection to the database
	  connection = DriverManager.getConnection(connectionURL, "root", "root"); 
	  //Add the data into the database
	  	   s = connection.createStatement();
	  	 String QueryString = "select * from user where user='"+user.trim()+"'";
         rs = s.executeQuery(QueryString);
	  if(rs.next ()){//Use If Here not While
		request.setAttribute("user",rs.getString(1));
		request.setAttribute("password",rs.getString(2));
		  }
                  
	  rs.close();
                    s.close();
	  RequestDispatcher dispatcher=getServletContext().getRequestDispatcher( "/find.jsp" );
	  dispatcher.forward( request, response );
	  }
	  catch(SQLException e){
	  System.out.println("Exception is ;"+e);
	  } 
	  catch (ClassNotFoundException e) {
		  System.out.println("Exception is ;"+e);
	}
	}
 public void destroy() { 
}
}

i wants to use same jsp page to find the values it will be possible or not because for everythig we keep 2pages means its not a right way to develop, so iwants to use same jsp page.

please solve my issue, please guide me.

Thanks in advance.

S Subbu

Ranch Hand

Posts: 87

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Arun Good Job, For removing null you have to do

<input type="text" value="<%=(request.getAttribute("user")==null)?"":(String)request.getAttribute("user")%>">

but insteadof using scriptlet go for EL as

<input type="text" value="${user}">

My Suggestion is use EL is recommendded than scriptlet in your jsp page.

Go ahead keep it up.

P Arunkumar

Ranch Hand

Posts: 119

posted 12 years ago