Databases
StackOverflow2013
Postsdbo
POFetching unique Value and no. of times of the Value
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFetching unique Value and no. of times of the Value
    primarykey
    data
    text
    <p>In a (using mysql)table one of my column(i.e. colour) is like :</p> <pre><code>|Color| ====== |Red | |Blue | |Green| |Red | |Green| |Green| |Red | |Red | </code></pre> <p>After establishing,jdbc connection in my current jsp page: I'm trying to show the value in a pie chart(it's wriien in jscript,where I'll putting the value from mysql) like : </p> <pre><code>|Color|no. of Times| ==================== |Red | 4 | |Blue | 1 | |Green| 3 | </code></pre> <p>Buy I am not able to put values into the graph(I guess there is problem in by code):</p> <pre><code>&lt;% Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost/apps","root","root"); Statement stmt = con.createStatement(); String sql2="select distinct(color) as COLOR from user_management order by device;"; ResultSet rs2 = stmt.executeQuery(sql2); String s = rs2.getString("color"); while(rs2.next()){ String device = rs2.getString("color"); List&lt;String&gt; list=new ArrayList&lt;String&gt;(); list.add(device); } // I guess here will be some code for device value in String, say "s" String sql1 = "select count(case when color='"+s+"' then 1 end) as COLOR from user_management"; ResultSet rs1 = stmt.executeQuery(sql1); System.out.println(sql1); %&gt; </code></pre> <p>then putting the resultset in piechart table </p> <pre><code>&lt;table id="chartData"&gt; &lt;% while(rs2.next()){ %&gt; &lt;% while(rs1.next()){ %&gt; &lt;tr&gt; &lt;th&gt;DEVICE&lt;/th&gt;&lt;th&gt;NUMBER&lt;/th&gt; &lt;/tr&gt; &lt;tr style="color: #0DA068"&gt; &lt;td&gt;&lt;%= rs2.getString("device")%&gt;&lt;/td&gt;&lt;td&gt;&lt;%= rs1.getString(1)%&gt;&lt;/td&gt; &lt;/tr&gt; &lt;% } %&gt; &lt;% } %&gt; &lt;/table&gt; </code></pre> <p>Any inputs that how to fetch the column value in a chart where color-name as well as no. of color happens at a same time.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USbig zero
    1. USbig zero
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POFetching unique Value and no. of times of the Value
      1. USbig zero
      1. VTFavorite
    2. VO
      singulars
      1. POFetching unique Value and no. of times of the Value
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POFetching unique Value and no. of times of the Value
      1. USTirtha
      1. VTFavorite
    1. COPlease learn to separate the concerns. This is not a Java/JSP/Servlet problem at all. This is just a simple JDBC/SQL problem. You would have exactly the same problem when executing/testing the JDBC/SQL code independently in a normal Java application class with a `main()` method instead of straight in a JSP file.
      singulars
      1. POFetching unique Value and no. of times of the Value
      1. USBalusC
    2. COThanks for your comment,Am I able to make you understand of issue ? Can it be achieve in this way... or where I'm going wrong..any inputs
      singulars
      1. POFetching unique Value and no. of times of the Value
      1. USbig zero
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload