基于Java web的网上问卷调查系统（源码+数据库）.zip

package com.hibernate.query; import java.text.DecimalFormat; import java.text.NumberFormat; import java.util.ArrayList; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.cfg.AnnotationConfiguration; import com.hibernate.model.*; public class DBquery { public SessionFactory sf=new AnnotationConfiguration().configure().buildSessionFactory(); // public List<Tinfo> querytinfo(){ // Session sn=sf.openSession(); // sn.beginTransaction(); // Query q=sn.createQuery("from Tinfo "); // List<Tinfo> tinfos=(List<Tinfo>)q.list(); // sn.getTransaction().commit(); // sn.close(); // return tinfos; // public List<Question> queryquestions(){ Session sn=sf.openSession(); sn.beginTransaction(); Query q=sn.createQuery("from Question"); List<Question> questions= (List<Question>) q.list(); sn.getTransaction().commit(); sn.close(); return questions; } public List<Answer> querytester_answer(int i){//取出某一测试者答案 Session sn=sf.openSession(); sn.beginTransaction(); Query q=sn.createQuery("from Answer answer where answer.tid="+i); List<Answer> as= (List<Answer>) q.list(); sn.getTransaction().commit(); sn.close(); return as; } public void saveanswer(Answer asw){//存储答案对象 Session sn=sf.openSession(); sn.beginTransaction(); sn.save(asw); sn.getTransaction().commit(); sn.close(); } public int savetester(Tester t){ //存储测试者对象 Session sn=sf.openSession(); sn.beginTransaction(); sn.save(t); sn.getTransaction().commit(); int i=t.getTid(); sn.close(); return i; } public int queryqnum(){//取出问题总数 List<Question> qs=new ArrayList<Question>(); qs=this.queryquestions(); int i=qs.size(); return i; } public int counttester(){//获取测试者人数 Session sn=sf.openSession(); sn.beginTransaction(); Query q=sn.createQuery("from Tester"); List<Tester> ts= (List<Tester>) q.list(); sn.getTransaction().commit(); sn.close(); return ts.size(); } public void caddone(int cid){//某一选项加一个支持加一 Session sn=sf.openSession(); sn.beginTransaction(); Choice c=new Choice(); c=(Choice)sn.get(Choice.class, cid); int i=c.getTimes(); i=i+1; c.setTimes(i); sn.save(c); sn.getTransaction().commit(); sn.close(); } public void updatepercent(){//更新全部选项的百分比 Session sn=sf.openSession(); sn.beginTransaction(); List<Choice> cs=new ArrayList<Choice>(); cs=( List<Choice> )sn.createQuery("from Choice").list(); double alltester=(double)this.counttester(); for(Choice c:cs){ double times=(double)c.getTimes(); String percent=this.decimal(times, alltester); c.setPercentage(percent); sn.save(c); } sn.getTransaction().commit(); sn.close(); } public String decimal(double x,double y) { double z = x/y; DecimalFormat myformat = null; myformat= (DecimalFormat)NumberFormat.getPercentInstance(); myformat.applyPattern("00.00%");//设置百分率的输出形式，形如00.*,根据需要设定。 String percentage=myformat.format(z); return percentage; } public Tester querytinfo(int tid){ Session sn=sf.openSession(); sn.beginTransaction(); Tester tinfo=(Tester)sn.createQuery("from Tester t where t.tid="+tid).uniqueResult(); sn.getTransaction().commit(); sn.close(); return tinfo; } public List<Tester> queryts(){ Session sn=sf.openSession(); sn.beginTransaction(); List<Tester> testers=(List<Tester>)sn.createQuery("from Tester ").list(); sn.getTransaction().commit(); sn.close(); return testers; } }