java - Creating a bar chart using JSP -

-

how create bar chart through data database using jsp.i created 2 tables in database (1)cust_entry,(2)cust_response.so plz give me correct code , place put code in coding.

thanks in advance.

thanks

            <html> <head>     <meta http-equiv="content-type" content="text/html; charset=utf-8">     <title>customer response</title> </head> <body>     <%@page import="java.sql.*" %>     <%! string name,date,desg,org,add,q1,q2,q3,q4,q5,q6,q7,q8,q9,q10,q11,q12,q13,q14,q15,q16;     connection con=null;     statement stmt=null;    // statement stmt1=null; //    resultset rs=null;     string drivername="com.mysql.jdbc.driver";     string url="jdbc:mysql://106.197.161.194/wiprofeedback.jsp/wipro";     string user="root";     string password ="root";     %>              <%                 name= request.getparameter("person");              date= request.getparameter("date");                 desg=request.getparameter("designation");              org=request.getparameter("organisation");              add=request.getparameter("address");                  q1=request.getparameter("group1");                q2=request.getparameter("group2");                    q3=request.getparameter("group3");                    q4=request.getparameter("group4");                   q5=request.getparameter("group5");                      q6=request.getparameter("group6");                   q7=request.getparameter("group7");                      q8=request.getparameter("group8");                     q9=request.getparameter("group9");                       q10=request.getparameter("group10");                    q11=request.getparameter("group11");                      q12=request.getparameter("group12");                       q13=request.getparameter("group13");                  q14=request.getparameter("group14");                   q15=request.getparameter("group15");                    q16=request.getparameter("group16");                   %>     <%     try{         class.forname(drivername);        connection con=drivermanager.getconnection(url,user,password);          statement stmt = con.createstatement();          stmt.executeupdate("insert cust_entry(name,date,desg,org,address)  values('"+name+"','"+date+"','"+desg+"','"+org+"','"+add+"')");           stmt.executeupdate("insert  cust_response(q1,q2,q3,q4,q5,q6,q7,q8,q9,q10,q11,q12,q13,q14,q15,q16) values('"+q1+"','"+q2+"','"+q3+"','"+q4+"','"+q5+"','"+q6+"','"+q7+"','"+q8+"','"+q9+"','"+q10+"','"+q11+"','"+q12+"','"+q13+"','"+q14+"','"+q15+"','"+q16+"')");     }catch(sqlexception  e)     {         system.out.println(e);     }      %>             name :<%=name%>           <br>            date:<%=date%>                  <br>              desg:<%=desg%>                 <br>              org:<%=org%>                    <br>                add:<%=add%>                   <br>                group1:<%=q1%>                     <br>               group2:<%=q2%>                    <br>                 group3:<%=q3%>                    <br>                   group4:<%=q4%>                   <br>                   group5:<%=q5%>                        <br>                group6:<%=q6%>                   <br>                   group7:<%=q7%>                     <br>                 group8:<%=q8%>                      <br>                  group9:<%=q9%>                     <br>                   group10:<%=q10%>                       <br>                     group11:<%=q11%>                        <br>                        group12:<%=q12%>                           <br>                         group13:<%=q13%>                            <br>                       group14:<%=q14%>                             <br>                        group15:<%=q15%>                            <br>                            group16:<%=q16%>               </body>                  </html>

use highcharts library... put dynamic jsp value in.

$(function () { var chart = new highcharts.chart({     chart: {         renderto: 'container',         type: 'column'     },     xaxis: {         categories: ['q_1', 'q_2', 'q_3', 'q_4']     },      plotoptions: {         series: {             cursor: 'pointer',             point: {                 events: {                     click: function() {                         (var = 0; < this.series.data.length; i++) {                             this.series.data[i].update({ color: '#ecb631' }, true, false);                         }                         this.update({ color: '#f00' }, true, false)                     }                 }             }         }     },      series: [{         data: [<%=q_1%>,<%=q_2%>,<%=q_3%>,<%=q_4%>]             }] }); });

Comments

Post a Comment

Popular posts from this blog

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

-
any ideas when firefox implement lengthadjust andtextlength?..... working svg application. lengthadjust , textlength working fine in chrome not working in fire fox . <svg viewbox = "0 0 500 300" version = "1.1"> <defs> <path id="s3" d="m 10,90 q 100,15 200,70" /> </defs> <g> <text font-size = "20"> <textpath xlink:href="#s3" textlength="205"> short text</textpath> </text> <use xlink:href="#s3" fill="none" stroke="black" stroke-width="1"/> </g> </svg> this implemented in firefox text elements (not textpath or tspan) in case that's ok though can move attribute text element. <svg viewbox = "0 0 500 300" version = "1.1"> <defs>
Read more

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11
Read more