Databases
StackOverflow2013
Postsdbo
POCompletion Bar for Form Registration in Struts2 Jquery Plugin
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCompletion Bar for Form Registration in Struts2 Jquery Plugin
    primarykey
    data
    text
    <p>I am trying to implement a web application using Struts 2, Hibernate 3, and the Struts 2 jQuery plugin progress bar and other widgets.</p> <p>(<a href="http://struts.jgeppert.com/struts2-jquery-showcase/index.action" rel="nofollow">http://struts.jgeppert.com/struts2-jquery-showcase/index.action</a>)</p> <p>I have a Registration form where I need to show the "% of Form Completion".</p> <pre><code>&lt;sj:progressbar id="progressbarchange" value="21" onChangeTopics="progressbarchangetopic" cssClass="progressbar"/&gt; </code></pre> <p>I've put above code to instantiate the progress bar in the JSP.</p> <p>In the "value" field I have hard coded "21", but I want to put the value which I want to extract from a session variable in the action class. i.e., <code>"#session.progressvarible"</code></p> <p><code>"#session.progressvarible"</code> is the value I get by calculating the number of columns for a particular record for <b> NOT NULL COLUMNS </b> and depending upon the value I will set the progress completion in the bar.</p> <p>I also need to store this Completion Percentage because there are some fields in the form which can be skipped for that moment, so this completion rate has to be displayed whenever user logs in to his home page.</p> <p>My question is how do I write the query or criteria or whatever, in Hibernate so I can get the count of the NOT NULL columns, for example:</p> <pre><code>select no of columns from table1 which are NOT NULL for the student id=101. </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDave Newton
    1. USKenny Weeler
    plurals
    1. PL
      singulars
      1. LTLinked
    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. This table or related slice is empty.
    1. COI'm not sure what the question is--are you having a problem with Hibernate, or the progress bar?
      singulars
      1. POCompletion Bar for Form Registration in Struts2 Jquery Plugin
      1. USDave Newton
    2. COProbably need a native query. If you're going to do that then creating a view in the db would probably be best, for sql solutions see: http://stackoverflow.com/questions/173745/how-do-i-get-the-count-of-null-value-columns-per-row-in-a-return-set It sounds like you just want it for a known table, so a Java solution could go a couple ways. Probably not needing this service for everything you could just make a method in your entity which checks for null and produces a sum. If you do have many entities you would wish to do this for, then apply the same solution using reflection.
      singulars
      1. POCompletion Bar for Form Registration in Struts2 Jquery Plugin
      1. USQuaternion
    3. COI justt want to know if there is way to get the number of columns for particular record . say-"studentID-501", which are not null. ? and put that ina session variable to use it how ever i can...if there is any such query please lemme know...and how can i use it using "criteria" ?
      singulars
      1. POCompletion Bar for Form Registration in Struts2 Jquery Plugin
      1. USKenny Weeler
 

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