How to display the data column on jsp

Ads

 
 

Share on Google+Share on Google+

V kumar
How to display the data column on jsp
1 Answer(s)      4 months and 16 days ago
Posted in : JSP-Servlet

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 .
Ads
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
how to display data from database in jsp
how to display data from database in jsp  how to display data from database in jsp
Advertisements
how to display data in List Or grid or in table in Jsp
how to display data in List Or grid or in table in Jsp   <%@page...(); } %> </body> </html> this is my jsp code i want to display String P Value in List GIrd or Table please help am able to Print display data
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
How to read and display data from a .properties file from a jsp page
How to read and display data from a .properties file from a jsp page ... the data from this .properties file and display it in table format. Ex:by using... = DEDCHGG_PWDP and goes on... I have to create a jsp page to show these data
how to display data from mysql table in text box using jsp??
how to display data from mysql table in text box using jsp??  <p>hi, i have a written a code to display data from a mysql table into txtboxes... at line: 113 in the jsp file: /Cat1.jsp The local variable v_RGPC may not have
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
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
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 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
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 output on jsp from while loop of action class....actually i am retreiving the post from posts column from my sql.plz help.thnkss
how to display output on jsp from while loop of action class....actually i am retreiving the post from posts column from my sql.plz help.thnkss  how to display output on jsp from while loop of action class....actually i am
How to display data fom MySQL DataBase-table in to JSP file by submitting a value in combobox.
How to display data fom MySQL DataBase-table in to JSP file by submitting a value in combobox.   I have the same problem.plz help me. I have MySQL... have to display the Nodename and packageno. i.e.,select nodename,packageno from
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
how to display the email message in jsp
how to display the email message in jsp  hi every one .. i am new from this industry please help me to display the email message in jsp page please send me sample code
data are not display in JSP from database - JSP-Servlet
data are not display in JSP from database   i want to finding some data through a SQL query from SQL server database to a JSP page based on some... of this jsp page. like.. School Result and three request parameters 'class', 'from
How to copy existing column along with data and column name into another existing table
How to copy existing column along with data and column name into another existing table  i want to copy the existing column along with data... hyd xyz 678 how to do this.... i know that firstly the column
How to Sort Column values of a jsp table - JSP-Servlet
How to Sort Column values of a jsp table  Hi Friend Please help me. I am displaying reultset values on multiple jsp page. I want to sort selected column values on every page onclick of an event its very urgent pleasehelp
how to change a column data in a every row in a text file in java
how to change a column data in a every row in a text file in java   i have text file like this 11,6,13/9/14,1287605778,89... column in every row ie. account number to some text in a text file in java could
how to display the data from excel to webpage
how to display the data from excel to webpage  Hi, I need help... search for the value 4024 in a excel file and to display the remaining values on the same row. please help me out of this   Here is a jsp code
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 jfreechart at specified place in jsp
How to display jfreechart at specified place in jsp  I have a jsp page where i need to display the chart at specified position... of the jsp page is not displaying.... Below is my code. DefaultPieDataset
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 data from database in a TableView
How to display data from database in a TableView  I need to populate... at this. The classes: This is the Class that creates the database data object: import...; data; private List<NewBeautifulKiwi> initializeTable() { data
How to add a column with checkboxes for each record in my table in JSP
How to add a column with checkboxes for each record in my table in JSP   Hi, Could you please explain it to me how I can add a column with check boxes for each record in my table in JSP? Also, I want to figure out a way
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 selected checkboxes dynamically using jsp
how to display selected checkboxes dynamically using jsp  Hi friends i have a requirement that : in my JSP page i have radio buttons followed by the DB fields..when i click SUBMIT button,if the field(or record
How to display data in form using aryylist in struts - Java Beginners
How to display data in form using aryylist in struts  Hi, I want to display data using arraylist in struts pls help me Its urgent
how to display data into textboxes which is retrieved from the database
how to display data into textboxes which is retrieved from the database  I would like to know how to display data into textboxes which is retrieved from database in jsf. could you please provide a small example of how to do
how to display data into textboxes which is retrieved from the database
how to display data into textboxes which is retrieved from the database  I would like to know how to display data into textboxes which is retrieved from database in jsf. could you please provide a small example of how to do

Ads

 
Advertisement null

Ads