How to display the data column on jsp
My requirements:
Display total error count of error description of each database server (column wise).
like this:
Description DBServer1 DBServer2
Error1 10 22
Error2 20 30
Error3 66 32
..
in table of each database having two columns: description, error. but data is dynamic. one database having 2 rows and another database could have 10 rows. so database should be mapped.(error with descrption)
program read a properties file where database server ip is defined and fill a array list with database server ip's. and using a loop over this database server ips to create db connection and all the tasks.
HashMap hm=null;
public HashMap getHm() {
return hm;
}
public void setHm(HashMap hm) {
this.hm = hm;
}
public String countErrorData(){
//String[][] tempArray = null;
// ReadDBFile();
hm=new HashMap();
for (int j=0; j<dbSizeList.size();j++){
//mdList= new ArrayList();
//ArrayList errorCountList1= new ArrayList();
serverurl=String.valueOf(dbSizeList.get(j));
try {
String connectionUrl=null;
Class.forName("com.mysql.jdbc.Driver");
connectionUrl = "jdbc:mysql://"+serverurl+":"+Global.myport+"/"+Global.database+"?" +
"user="+Global.myuser2+"&password="+Global.mypasswod+"&autoReconnect=true&useUnicode=true&characterEncoding=utf8";
conn = DriverManager.getConnection(connectionUrl);
stmt=conn.createStatement();
query="select distinct err as Description,count(error) as TotalErrors from tablename where err!='NA' GROUP by ERR ORDER BY TotalErrors desc";
System.out.println("error query:"+query);
try {
ArrayList errorList= new ArrayList();
rs=stmt.executeQuery(query);
rs.last();
row_count=rs.getRow();
rs.beforeFirst();
column_count=dbSizeList.size();
//tempArray = new String[row_count][column_count];
while (rs.next())
{
hm.put(rs.getString(1), rs.getString(2));
//errorCountList1.add(rs.getString(2));
}
dbURLList.add(serverurl);
/*for(int row=0; row < row_count; row++){
for (int i = z; i <= z; i++) {
tempArray[row][i] =(String)errorCountList1.get(row);
System.out.println("tempArray["+row+"]["+i+"]: "+tempArray[row][i]);
mdList.add(tempArray[row][i]);
}
}*/
}
catch(Exception e){
e.printStackTrace();
}
}catch(Exception e)
{
e.printStackTrace();
}
}
request.setAttribute("row_count", String.valueOf(row_count));
request.setAttribute("column_count", String.valueOf(column_count));
request.setAttribute("dbURLList", dbURLList);
return "success";
}
jsp code:
<form id="myForm" method="post">
<%
String column_count= (String)request.getAttribute("column_count");
List dbURLList= (List)request.getAttribute("dbURLList");
%>
<H2 align="center">Error Details</H2>
<table border="1" align="center">
<tr><td>Description</td>
<% for (int i = 0; i < Integer.parseInt(column_count); i++) { %>
<td> <%=dbURLList.get(i)%> </td>
<% } %>
</tr>
<c:forEach items="${hm}" var="entry">
<tr><td> ${entry.key}</td><td> ${entry.value}</td></tr>
</c:forEach>
</table>
</form>
It display the data of last database server and it show in first column of database server column.
suppose i have 2 database. it is showing like this:
Description localhost localhost
Error1 138086
Error2 1500
Error3 99
How i deal with this situtaion. should i set the data in a pojo and display the data in row wise. but database server ip is not fix. there may be 2 database or may be 5 database.
Mapping (decription with error count of each database) on jsp is also a issue .
View Answers
June 9, 2017 at 10:12 PM
Hi,
In your code:
while (rs.next())
{
hm.put(rs.getString(1), rs.getString(2));
//errorCountList1.add(rs.getString(2));
}
After getting data rs.getString(1) you can dispaly with the code out.println(rs.getString(1)) on jsp page.
Please check tutorial: Display Data from Database in JSP.
Thanks
Ads
Related Tutorials/Questions & Answers:
How to display the data column on jsp
How to
display the
data column on jsp My requirements:
Display total...;
</form>
It
display the
data of last database server... with this situtaion. should i set the
data in a pojo and
display the
data in row wise
Advertisements
how to display data from jsp file into database
how to
display data from
jsp file into database this is a
jsp file...+","+ph2+")");
out.println("
Data is successfully inserted...+",'"+email+"')");
out.println("
Data is successfully inserted into database
How to display data in jsp from dao using java beans?
How to
display data in
jsp from dao using java beans? Hi
I need to
display data in
jsp pulling from dao using java beans, Please can anyone give me the sample application with above topics. Any help would be highly appreciated
Display Sum of Table Column Using In JSP
Display Sum of Table
Column Using In
JSP... an application to
Display the sum
data
of a Table
column for a specific Date. We... the total salary
between two specific date and result is
display using
Jsp
How to display date in JSP?
How to
display date in
JSP?
How to create a simple
JSP program which displays date on the page?
Thanks
Hi,
You should import...() %>
Check complete tutorial at
How to Create
JSP Page?
Thanks
Display Data from Database in JSP
;
<html>
<head>
<title>
display data from...;To
display all the
data from the table click here...</h2></TD>..., to show
data from the database
click on the link that calls another .
jsp file named
How to display multiple images in jsp
How to
display multiple images in jsp <%@ page import="java.io....());
System.out.println("st-7 "+brr);
//
display the image
response.setContentType("image... ");
}
} catch (Exception e) {
out.println("Unable To
Display image");
out.println
how to display data in excel sheet?
how to
display data in excel sheet? According to the user Id,some links will be generated from the database,and if we click a link,
data would... the button and to
display the
data in excel sheet
How to Display jrxml file on JSP page???
How to
Display jrxml file on
JSP page??? I made jrxml file using jasper report but
how to
display on
jsp page??
i tried lot but still i didnt find out solution.so pls help me as soon as possible
how to display one image on jsp through java
how to
display one image on
jsp through java Hi,
I wanted to
display one image on my
jsp file like social networking sites. But the scenario...://upload/image.jpg . what is the procedure to get that and
display on my
jsp page
How to Display Data in a tree structure on the GUI
How to
Display Data in a tree structure on the GUI
how to
display data in a tree structure on the GUI?
I need this sort of UI to
display data showing a set of rules showing various conditions and the actions related
image display - JSP-Servlet
image display
how to
display image that store in mysql database...
column have BLOB datatype.... Hi Friend,
Please visit the following link:
http://www.roseindia.net/
jsp/retrieve-image.shtml
Thanks
how to display the excel file content in the jsp
how to
display the excel file content in the jsp
How to present the content of the newly created excel file in the following
jsp to the web browser:
print("code sample");
<%@ page import="java.io.InputStream" %>
how to display values from database into table using jsp
how to
display values from database into table using jsp I want to
display values from database into table based on condition in query,
how... to
display books based on either bookname or authorname, for this i created one
jsp page