passing value to a jsp page from a java class using DAO

I wanted to pass the value retrieved on a java class to a page.I am using DAO classes. I have retrieved the values from the database and stored them on String variables.Now I want to set them to the text boxes in my view.jsp page.I am new to this area,can anyone help me out??

View.jsp is as

<%@ 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">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
    <title>Insert title here</title>
    </head>
    <body>

    <form action="process.jsp">
    Enter Name    <br/> <br> <input type="text" name="uname"  onclick="this.value=''"/><br/><br/>

    <input type="submit" value="view details"/><br/><br/>
    Email id:   <br/> <input type="text"  name="email"  id="email" > <br/><br/>
    password:   <br/> <input type="text"  name="passw"  id="passw"><br/><br/>

    </form>        
    </body>
    </html>

JavaScript
​x
 
<%@ 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">    <html>    <head>    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">    <title>Insert title here</title>    </head>    <body>​    <form action="process.jsp">    Enter Name    <br/> <br> <input type="text" name="uname"  onclick="this.value=''"/><br/><br/>​    <input type="submit" value="view details"/><br/><br/>    Email id:   <br/> <input type="text"  name="email"  id="email" > <br/><br/>    password:   <br/> <input type="text"  name="passw"  id="passw"><br/><br/>​    </form>            </body>    </html>​

and My Activity ViewDAO.java is as

 public static void  view(user u) {
    Connection con=ConnectionProvider.getCon(); 
    String uname=u.getUname();
    try {
        PreparedStatement ps=con.prepareStatement("select email,pass from  S1.USER432 where name='"+uname+"'");
        ResultSet rs = ps.executeQuery();       

        while (rs.next()) {

            String email = rs.getString("EMAIL");
            String pass = rs.getString("PASS");

            }

    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }       

    }
}

JavaScript
 
 public static void  view(user u) {    Connection con=ConnectionProvider.getCon();     String uname=u.getUname();    try {        PreparedStatement ps=con.prepareStatement("select email,pass from  S1.USER432 where name='"+uname+"'");        ResultSet rs = ps.executeQuery();       ​        while (rs.next()) {​            String email = rs.getString("EMAIL");            String pass = rs.getString("PASS");​            }​    } catch (SQLException e) {        // TODO Auto-generated catch block        e.printStackTrace();    }       ​    }}​

Thanks…

Answer

You need to call the DAO method from your servlet like below:

    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

      // call DAO method to get the email and password
    HashMap<String,String> map=ViewDAO.getDetails();

    //from the map you will get the  email and password.then you need to set them in the attributes and get them in your jsp

     request.setAttribute("email", map.get("email"));
      request.setAttribute("password", map.get("password"));

}

JavaScript
 
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {​      // call DAO method to get the email and password    HashMap<String,String> map=ViewDAO.getDetails();​    //from the map you will get the  email and password.then you need to set them in the attributes and get them in your jsp​     request.setAttribute("email", map.get("email"));      request.setAttribute("password", map.get("password"));​}​

your DAO method should be like the below:

public static HashMap<String,String>  getDetails(user u) {
    Connection con=ConnectionProvider.getCon(); 
    String uname=u.getUname();
    Map<String,String> map=new HashMap<>();
    try {
        PreparedStatement ps=con.prepareStatement("select email,pass from  S1.USER432 where name='"+uname+"'");
        ResultSet rs = ps.executeQuery();       

        while (rs.next()) {

            String email = rs.getString("EMAIL");
            String pass = rs.getString("PASS");

            }
       map.put("email",email);
       map.put("password",pass);


    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }       
    return map;
    }
}

JavaScript
 
public static HashMap<String,String>  getDetails(user u) {    Connection con=ConnectionProvider.getCon();     String uname=u.getUname();    Map<String,String> map=new HashMap<>();    try {        PreparedStatement ps=con.prepareStatement("select email,pass from  S1.USER432 where name='"+uname+"'");        ResultSet rs = ps.executeQuery();       ​        while (rs.next()) {​            String email = rs.getString("EMAIL");            String pass = rs.getString("PASS");​            }       map.put("email",email);       map.put("password",pass);​​    } catch (SQLException e) {        // TODO Auto-generated catch block        e.printStackTrace();    }           return map;    }}​

Hope this will help you.

Advertisement

Answer