Forum:

displaying multiple columns in html table in jsp from mysql database

Greenhorn

Posts: 23

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi! I'm finding trouble on how to display more than one column from mysql database table into an html table in jsp. So far I can display rows of only one column using the code below. Someone help me on how I can display say table rows from more than one column.

This is the JSP:

<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<jsp:useBean id="fnm" scope="session" class="p1.fnmDao"/>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <style type="text/css">
            body {
                background-color:#AFC7C7;
                padding: 0;
                margin: 0;
            }
            div.wrapper {
                margin-left: 10%;
                margin-right: 10%;
                background-color:#6D7B8D;
                height: 607px;
                padding-top:0px;
                border: thin solid #000000;
            }

div#image{
                padding-top:1%;
                padding-bottom:1%;
            }
            div#adminlogin{
                width:auto;
                height:70%;
                background-color:#AFC7C7;
                border-width:thin;
                border-style:solid;
                border-color:#000000;
                margin: 0 auto;
                text-align:left;
                overflow: hidden;
                padding: 5px;
            }

hr {
                height:1px;
                color:#000000;
                background-color:#000000;
                width:99%;
                margin-left: 0 ;
                margin-right: auto ;
                border-style:solid;
            }

.inputtext {
                width: 200px;
                height: 30px;
                Font-Family:Arial;
                Font-Size:18px
            }
            table{
                padding: 3px;
                border-color: black;
                border-collapse: collapse;
                border-style: solid;
                border-width: 1px;
                height: auto;
                width: auto;
                font-size: 20px;

}

th{
                text-align: center;
                border-color: black;
                border-collapse: collapse;
                border-style: solid;
                border-width: 1px;
                font-size: 26px;
                background-color: graytext;
            }

td{
                padding-left: 4px;
                border-color: black;
                border-collapse: collapse;
                border-style: solid;
                border-width: 1px;

}
            table.center {
                margin-left:auto; 
                margin-right:auto;
            }

</style>

if (field.defaultValue == field.value) field.value = '';
                else if (field.value == '') field.value = field.defaultValue;

}

</script>
    </head>
    <body>
        <div class="wrapper">
            <div id="image">
                <p>
                    <img src="${pageContext.request.contextPath}/images/logo.gif"
                         alt="banner"
                         width=100%
                         height="100"
                         /></p>
            </div>
            <div id=adminlogin >
                <p style="text-align:center">Voters' List</p>
                <hr/>
                <p/>

<table class="center">
                    <tr>
                        <th>First Name</th>
                        <th>Last Name</th>
                    </tr>
                    <c:forEach items="${fnm.fnmList}" var="cam">
                        <%--<option value="1"><c:out value="${cam.campnm}"/></option>--%>

<p STYLE="color : #E41B17;">${message}</p>
                <c:remove var="message" scope="session" />

</div><%--end of admin login div--%>
            <p style="text-align: center"><a href=adminHome.jsp>Home</a> <a href=index.jsp>Logout</a></p>
        </div>
    </body>
</html>

And the DAO that accesses the database:

package p1;

/**
 *
 * @author kk
 */
import java.sql.*;
import java.util.*;

public class fnmDao {

private List<fnmDto> fnmList;
    private String dbUrl = "jdbc:mysql://localhost/mv_db";
    private String dbDriver = "com.mysql.jdbc.Driver";
    private String dbUser = "root";
    private String dbPwd = "";

public fnmDao() {
    }

public List<fnmDto> getFnmList() {
        fnmList = new ArrayList<fnmDto>();
        Connection con = null;
        Statement stmt = null;
        ResultSet rs = null;

try {//trying to load the database driver and establish a connection to the database
            Class.forName(dbDriver);//loading the database driver
            con = DriverManager.getConnection(dbUrl, dbUser, dbPwd);//establishing a connection to the database
            //pw.println("connection established");//output if connection is established
        } catch (Exception e) {
            e.printStackTrace();//printing the exception error trace
        }

try {

stmt = con.createStatement();
            rs = stmt.executeQuery("Select stud_fnm from student");

while (rs.next()) {
                String fnm = rs.getString("stud_fnm");
                fnmDto s = new fnmDto(fnm);
                fnmList.add(s);
            }

} catch (Exception e) {
            System.out.println(e);
        } finally {
            try {
                if (con != null) {
                    con.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

return fnmList;
    }
}

And the DTO:

Bear Bibeault

Sheriff

Posts: 67754

173

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please post an SSCCE of your issue. You've posted way too much unnecessary code to wade through.

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Kenneth Owino

Greenhorn

Posts: 23

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Ok. Thank you for the reply. Actually, I have a database table with 2 columns "firstname" and "lastname". All I need is to retrieve all the rows in these columns and display them in an html table in my JSP. I read that using JSTL is a good practice and I tried using forEach. In doing this I created 2 DTOs 1 that gets firstname and 1 that gets lastname and two respective DAOs to access the database and returns arrayLists for each of the columns. Now the problem is I'm only able to use one DAO and one DTO that displays the firstname column from the table. How can I make all the columns be displayed? This part of the JSP only displays a table with one column:

How do I add the column under header

Stefan Evans

Bartender

Posts: 1845

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Two DTOs? One for firstname, one for lastname?

That doesn't make sense to me. If you're going to get one, you're probably going to want the other.
Why make two trips?

What I would expect is that your DAO layer would return a list of Beans, with all the attributes that you need on them.
So rather than a firstnameDTO, and lastnameDTO, I would expect a StudentDTO which has firstname and lastname attributes (and email, and student id etc etc)

Suggestions on coding style/convention
- Classes should start with a capital letter. fnmDto should be FnmDto.
- fnmDto is a horrible name anyway. I presume it is "first name data transfer object"? Just for readability use "firstName" rather than "fnm"

You then iterate over that list of StudentDTOs, and display the attributes as you wish.

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?