public void listTingcheweiScalar( ){
Session session = factory.openSession();
Transaction tx = null;
try{
//开启事务
tx = session.beginTransaction();
//进行查询
String sql = "SELECT sum(bb) FROM Tingchewei where aa = :tingchewei_aa";
SQLQuery query = session.createSQLQuery(sql);
String sql2 = "SELECT name FROM TeamA";
SQLQuery query2 = session.createSQLQuery(sql2);
query2.setResultTransformer(Criteria.ROOT_ENTITY);
//结果存放到list
List results = query2.list();
System.out.println(results);
String[] str=new String[results.size()];
int i=0;
for(Object obj:results){
str[i++]=obj.toString();
}
List<Object> list = new ArrayList();
for(int j=0;j<str.length;j++){
query.setParameter("tingchewei_aa",str[j]);
Object count = query.uniqueResult();
System.out.println(str[j]);
list.add(count);
}
System.out.println(list);
tx.commit();
}catch (HibernateException e) {
if (tx!=null) tx.rollback();
e.printStackTrace();
}finally {
session.close();
}
}
页面是一个两列的form表单 名字 工时 要把list的值放到工时那一列中 需要怎么做呢
Session session = factory.openSession();
Transaction tx = null;
try{
//开启事务
tx = session.beginTransaction();
//进行查询
String sql = "SELECT sum(bb) FROM Tingchewei where aa = :tingchewei_aa";
SQLQuery query = session.createSQLQuery(sql);
String sql2 = "SELECT name FROM TeamA";
SQLQuery query2 = session.createSQLQuery(sql2);
query2.setResultTransformer(Criteria.ROOT_ENTITY);
//结果存放到list
List results = query2.list();
System.out.println(results);
String[] str=new String[results.size()];
int i=0;
for(Object obj:results){
str[i++]=obj.toString();
}
List<Object> list = new ArrayList();
for(int j=0;j<str.length;j++){
query.setParameter("tingchewei_aa",str[j]);
Object count = query.uniqueResult();
System.out.println(str[j]);
list.add(count);
}
System.out.println(list);
tx.commit();
}catch (HibernateException e) {
if (tx!=null) tx.rollback();
e.printStackTrace();
}finally {
session.close();
}
}
页面是一个两列的form表单 名字 工时 要把list的值放到工时那一列中 需要怎么做呢