123456789101112131415161718192021222324252627282930 |
- package com.yihu.hos.standard.dao;
- import com.yihu.hos.standard.model.standard.StdDataSetModel;
- import com.yihu.hos.web.framework.dao.SQLGeneralDAO;
- import com.yihu.hos.web.framework.util.sql.BeanTransformer;
- import org.hibernate.Query;
- import org.springframework.stereotype.Repository;
- /**
- * Created by Administrator on 2016/5/4.
- */
- @Repository("stdeDatasetDao")
- public class StdDataSetModelDao extends SQLGeneralDAO implements IStdDataSetModelDao {
- @Override
- public StdDataSetModel getDatasetName(String version ,Integer id){
- StringBuffer sql = new StringBuffer();
- sql.append("SELECT d.*").append(" FROM std_dataset_").append(version).append(" d where d.id ="+id);
- try {
- Query query = getCurrentSession().createSQLQuery(sql.toString());
- query.setResultTransformer(new BeanTransformer(StdDataSetModel.class));
- StdDataSetModel stdDataSetModel =(StdDataSetModel) query.uniqueResult();
- return stdDataSetModel;
- }catch (Exception e){
- System.out.println("错误SQL:"+sql.toString());
- e.printStackTrace();
- return null;
- }
- }
- }
|