How to display the data column on jsp

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









Related Tutorials/Questions & Answers:
How to display the data column on jsp
How to display the data column on jsp  My requirements: Display total...; It display the data of last database server and it show in first column... 99 How i deal with this situtaion. should i set the data
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...+")"); out.println("Data is successfully inserted!"); //System.out.println...+"')"); out.println("Data is successfully inserted into database."); con.close
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 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
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   Hi, (adsbygoogle...; Check complete tutorial at How to Create JSP Page? (adsbygoogle
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
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
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 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
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 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... List:input Text Box and button. 3.In the same viewTR.jsp file, i have to display
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 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 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 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... in TableA and then we can copy the data, bt is there any way to copy both column name
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
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
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 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 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...({}); please help me out of this   Here is a jsp code that reads the excel
jsp code for display of data from database and snap shot of the output
jsp code for display of data from database and snap shot of the output  i am using JSP.i want to insert data into database and also want to display... the following link: http://www.roseindia.net/jsp/displaydatafrom_database1.shtml
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 display jsp frame - Java Beginners
how display jsp frame  Hi all, I am creating two jsp in frame... 1)In the code, you have provided,we have created another jsp 'new.jsp' in order to open the link on this jsp frame.It is having no code. Jsp Frameset
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 each arraylist value on new page in jsp
how to display each arraylist value on new page in jsp  hi!!!! i want to display each arraylist value on new page in jsp????? and also want to access.../servlet-jsp-data-list.shtml
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 data from database in a TableView
How to display data from database in a TableView  I need to populate...: This is the Class that creates the database data object: import java.io.Serializable...; public ObservableList<NewBeautifulKiwi> data; private List<
Dynamic retrieval od data from database and display it in the table at jsp
; Here is a jsp code that retrieves the data from the database and display...Dynamic retrieval od data from database and display it in the table at jsp  Hi friends.... Am creating software for chit fund.. I want to display
How to display images in jsp ffrom sqlserver2000 - JSP-Servlet
How to display images in jsp ffrom sqlserver2000   These code u sent is till not displaying the image in jsp from sqlserver2000. what table... for more information. http://www.roseindia.net/jsp/ Thanks
how to display or retrive an image in jsp whose path is stored in oracle database
how to display or retrive an image in jsp whose path is stored in oracle database  how to display or retrive an image in jsp whose path is stored in oracle database and the image is stored in my pictures folder
how to display action errors in jsp which is in a form list
how to display action errors in jsp which is in a form list  My jsp contains list of forms iterating using display:table, each FORM forms a row. I want to display action errors for individual form in the same row
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 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
Display data
Display data  after successful login how i can fetch my account information from sql database
how to display image and text in single jsp page from the mysql database
how to display image and text in single jsp page from the mysql database  hello please help me to display the image and text in single jsp page from mysql database if have any reference code please send me Thanks in advance
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
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 Jfreechart from servlet in jsp web page at specified location
How to display Jfreechart from servlet in jsp web page at specified... to display the chart in web page. I generated the chart using Jfreechart in Servlet which is in image format.plz sir give me the code to display this chart
How to display image in jsp from database using Servlet?
How to display image in jsp from database using Servlet?  Hi, How to display image in jsp from database using Servlet? Thanks (adsbygoogle = window.adsbygoogle || []).push({});   Hi, You will find code
Display Data from Database in JSP
Display Data from Database in JSP   ... and execute query to display data from the specified table.  Before.... This is first jsp page that has a link 'show data from table', user can show

Ads