StdDataSetModelDao.java 1.1 KB

123456789101112131415161718192021222324252627282930
  1. package com.yihu.hos.standard.dao;
  2. import com.yihu.hos.standard.model.standard.StdDataSetModel;
  3. import com.yihu.hos.web.framework.dao.SQLGeneralDAO;
  4. import com.yihu.hos.web.framework.util.sql.BeanTransformer;
  5. import org.hibernate.Query;
  6. import org.springframework.stereotype.Repository;
  7. /**
  8. * Created by Administrator on 2016/5/4.
  9. */
  10. @Repository("stdeDatasetDao")
  11. public class StdDataSetModelDao extends SQLGeneralDAO implements IStdDataSetModelDao {
  12. @Override
  13. public StdDataSetModel getDatasetName(String version ,Integer id){
  14. StringBuffer sql = new StringBuffer();
  15. sql.append("SELECT d.*").append(" FROM std_dataset_").append(version).append(" d where d.id ="+id);
  16. try {
  17. Query query = getCurrentSession().createSQLQuery(sql.toString());
  18. query.setResultTransformer(new BeanTransformer(StdDataSetModel.class));
  19. StdDataSetModel stdDataSetModel =(StdDataSetModel) query.uniqueResult();
  20. return stdDataSetModel;
  21. }catch (Exception e){
  22. System.out.println("错误SQL:"+sql.toString());
  23. e.printStackTrace();
  24. return null;
  25. }
  26. }
  27. }