Untitled

yc                      yc              y           c           2017-08-07  ais                                                 555         NULL
22                      22              22          22          2017-08-09  55                                                  22          NULL
aa                      aa              a           a           2017-08-07  aa                                                  5151        NULL

import java.sql.ResultSet;
import java.sql.SQLException;


public class ViewUserBean {

    private String username;
    private String firstname;
    private String lastname;

    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getFirstname() {
        return firstname;
    }
    public void setFirstname(String firstname) {
        this.firstname = firstname;
    }
    public String getLastname() {
        return lastname;
    }
    public void setLastname(String lastname) {
        this.lastname = lastname;
    }


    public ViewUserBean(ResultSet rs)throws SQLException {
        this.username = rs.getString("username");
        this.lastname = rs.getString("lastname");
        this.firstname = rs.getString("firstname");

    }

}

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class ViewUser extends HttpServlet {
    private static final long serialVersionUID = 1L;


     static Connection currentCon = null;
     static ResultSet rs = null;
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        response.setContentType("text/html");
        PrintWriter out = response.getWriter();


        Statement stmt = null;

       //String username = bean.getUsername();
       //String password = bean.getPassword();

        String searchQuery =
              "select username,firstname,lastname from yc_user_login ";


        try
        {
           //connect to DB
           currentCon = ConnectionManager.getConnection();
           stmt=currentCon.createStatement();
           rs = stmt.executeQuery(searchQuery);
           List dataList = new ArrayList();
          //
           while (rs.next()) {

           System.out.println("aa22bb");


           ViewUserBean viewuserbean = new ViewUserBean (rs);
          // viewuserbean.setUsername(rs.getString("username"));
          // viewuserbean.setLastname(rs.getString("lastname"));
           //viewuserbean.setFirstname(rs.getString("firstname"));
           dataList.add(rs.getString("username"));
           dataList.add(rs.getString("lastname"));
           dataList.add(rs.getString("firstname"));

         request.setAttribute("viewuserbean", viewuserbean);

          RequestDispatcher  rd=  request.getRequestDispatcher("viewuser.jsp");

           rd.forward(request, response);
           return;
          }


        }
        catch(SQLException e) {
            out.println("SQLException caught: " + e.getMessage());
        }


}
}

<%@ 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>View User Info System</title>
<style type="text/css">
body {
    background-color:white;
    margin: 0px;
    padding: 0px;
}

#left, #right {
    width: 10%;
    height: 800px;
    margin: 0px;
    padding: 10px;
    background-color: silver;
}

#left, #center, #right {
    float: left;
}

#center {
    width: 100%;
}

#top {
    height: 150px;
    background-color: purple;
}

#main {
    height: 800px;
    background-color: white;
}
</style>
</head>
<body>
    <div id="top"><jsp:include page="top1.jsp"></jsp:include></div>
    <div id="left"><jsp:include page="left1.jsp"></jsp:include></div>


    <table>
        <TR>
            <TD>User Name:</TD>
            <TD>${viewuserbean.username}</TD>
        </TR>

        <TR>
            <TD>Last

     name:</TD>
                <TD>${viewuserbean.lastname}</TD>

        </TR>
        <TR>
            <TD>First name:</TD>
            <TD>${viewuserbean.firstname}</TD>
        </TR>
    </table>
    ${viewuserbean}

    <%
      String str = (String)request.getAttribute("viewuserbean");
%>

</body>
</html>