/******************************************************************************
|
* Copyright (C) 2015 Shenzhen Penguin Network Technology Co., Ltd
|
* All Rights Reserved.
|
* 本软件为深圳市企鹅网络科技有限公司开发研制。未经本公司正式书面同意，其他任何个人、团体
|
* 不得使用、复制、修改或发布本软件.
|
*****************************************************************************/
|
|
package com.qxueyou.scc.exercise.dao;
|
|
import java.text.ParseException;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import org.hibernate.SQLQuery;
|
import org.hibernate.Session;
|
import org.hibernate.transform.Transformers;
|
import org.springframework.orm.hibernate4.HibernateCallback;
|
import org.springframework.stereotype.Repository;
|
|
import com.qxueyou.scc.base.dao.BaseDAO;
|
import com.qxueyou.scc.base.model.Pager;
|
import com.qxueyou.scc.base.model.Result;
|
import com.qxueyou.scc.base.util.DateUtils;
|
import com.qxueyou.scc.exercise.model.ExerciseAnalisisResult;
|
import com.qxueyou.scc.exercise.model.ExerciseGroup;
|
import com.qxueyou.scc.exercise.model.ExerciseGroupItemRe;
|
import com.qxueyou.scc.exercise.model.ExerciseItem;
|
|
@Repository(value="exerciseDAO")
|
/**
|
* 自动注入sessionFactory
|
*
|
* @author 邓志永
|
* @since JDK1.6
|
* @history 2010-07-28 夏德虎 新建
|
*/
|
|
public class ExerciseDAO extends BaseDAO {
|
|
|
/**
|
* 组装查询练习题目 顺序、随机练习
|
* @return
|
*/
|
@SuppressWarnings("unchecked")
|
public List<ExerciseItem> queryExtendExerciseItem(String hql,
|
List<Object> args) {
|
List<ExerciseItem> lstitems = new ArrayList<ExerciseItem>();
|
ExerciseItem item;
|
List<Object[]> lst = (List<Object[]>) this.getHibernateTemplate().find(hql, args.toArray());
|
ExerciseAnalisisResult analisisResult=null;
|
for (Object[] obj : lst) {
|
item = (ExerciseItem) obj[0];
|
item.setExerciseExtendId(String.valueOf(obj[1]));
|
item.setExerciseRecordId(String.valueOf(obj[2]));
|
analisisResult= new ExerciseAnalisisResult();
|
analisisResult.setCurrTitleNumber(String.valueOf(obj[3] == null ? 0 :obj[3]));
|
analisisResult.setExerAccuracy(String.valueOf(obj[4] == null ? 0 :obj[4]));
|
analisisResult.setExerCorrectCount(String.valueOf(obj[5] == null ? 0 :obj[5]));
|
item.setAnalisisResult(analisisResult);
|
lstitems.add(item);
|
}
|
|
return lstitems;
|
}
|
|
/**
|
*查询错题 收藏对应的练习记录
|
* @return
|
* @throws ParseException
|
*/
|
@SuppressWarnings({ "unchecked"})
|
public List<ExerciseItem> queryExerciceItemList(String hql,
|
List<Object> args){
|
List<ExerciseItem> lstitems = new ArrayList<ExerciseItem>();
|
ExerciseItem item;
|
List<Object[]> lst = (List<Object[]>) this.getHibernateTemplate().find(hql, args.toArray());
|
try {
|
for (Object[] obj : lst) {
|
item = (ExerciseItem) obj[0];
|
item.setExerciseGroupId(String.valueOf(obj[1]));
|
item.setUpdateTime(DateUtils.convertStringToDate(String.valueOf(obj[2]), "yyyy-MM-dd HH:mm:ss"));
|
lstitems.add(item);
|
}
|
} catch (Exception e) {
|
|
}
|
|
return lstitems;
|
}
|
|
/**
|
* 根据hql查询,返回列表分页数据
|
*
|
* @param hql 查询语句
|
* @param args 参数
|
* @param cls 返回类型
|
* @return
|
*/
|
@SuppressWarnings("unchecked")
|
public List<Map<String,String>> queryRecentRecords(final String sql, final Pager page, final List<Object> args) {
|
// 查询得到结果
|
|
List<Object[]> resultLst = this.getHibernateTemplate().execute(
|
new HibernateCallback<List<Object[]>>() {
|
public List<Object[]> doInHibernate(Session session) {
|
SQLQuery query = session.createSQLQuery(sql);
|
|
int i = 0;
|
for (Object arg : args) {
|
query.setParameter(i++, arg);
|
}
|
query.setFirstResult(page.getPageSize()
|
* (page.getPageNum() - 1));
|
query.setMaxResults(page.getPageSize());
|
return query.list();
|
}
|
});
|
|
List<Map<String,String>> lst = new ArrayList<Map<String,String>>();
|
Map<String, String> map = null;
|
|
for (Object[] obj : resultLst) {
|
map = new HashMap<String, String>();
|
map.put("groupId", String.valueOf(obj[0]));
|
map.put("type", String.valueOf(obj[1]));
|
map.put("name", String.valueOf(obj[2]));
|
map.put("recordId", String.valueOf(obj[3]));
|
map.put("attribute2", String.valueOf(obj[4]));
|
map.put("attribute1", String.valueOf(obj[5]));
|
map.put("schedule", String.valueOf(obj[6]));
|
map.put("allCount", String.valueOf(obj[7]));
|
|
lst.add(map);
|
}
|
|
return lst;
|
}
|
|
/**
|
* 根据hql查询,返回列表分页数据
|
*
|
* @param hql 查询语句
|
* @param args 参数
|
* @param cls 返回类型
|
* @return
|
*/
|
@SuppressWarnings({"unchecked" })
|
public List<Map<String,String>> queryExerciseRecentRecords(final String sql, final List<Object> args) {
|
// 查询得到结果
|
List<Object[]> resultLst = this.getHibernateTemplate().execute(new HibernateCallback<List<Object[]>>() {
|
|
public List<Object[]> doInHibernate(Session session) {
|
SQLQuery query = session.createSQLQuery(sql);
|
|
int i = 0;
|
for (Object arg : args) {
|
query.setParameter(i++, arg);
|
}
|
return query.list();
|
}
|
});
|
|
List<Map<String,String>> lst = new ArrayList<Map<String,String>>();
|
Map<String, String> map = null;
|
|
for (Object[] obj : resultLst) {
|
map = new HashMap<String, String>();
|
map.put("groupId", String.valueOf(obj[0]));
|
map.put("titleMaxNumber", String.valueOf(obj[1]));
|
map.put("status", String.valueOf(obj[2]));
|
map.put("doCount", String.valueOf(obj[3]));
|
|
lst.add(map);
|
}
|
|
return lst;
|
}
|
|
/**
|
*查询练习列表，还需查询联系下面习题个数
|
* @return
|
*/
|
@SuppressWarnings("unchecked")
|
public List<ExerciseGroup> queryExerciceGroupList(String sql,List<Object> args) {
|
|
Session session = this.getSessionFactory().getCurrentSession();
|
SQLQuery query = session.createSQLQuery(sql);
|
query.setResultTransformer(Transformers.aliasToBean(ExerciseGroup.class));
|
for(int i = 0;args !=null && i < args.size() ; i++ ){
|
query.setParameter(i, args.get(i));
|
}
|
|
return query.list();
|
}
|
|
public Result deleteExerciseItemRe(ExerciseGroupItemRe objExerciseItemRe){
|
|
this.getHibernateTemplate().delete(objExerciseItemRe);
|
|
return new Result(true);
|
|
}
|
|
}
|
