public List<SysClass> getListByTechId(int techId){
String sql = "select * from t_sys_class where id in (select classid from t_tech_teaclass where teacherid = ?)";
SQLQuery query = this.getSession().createSQLQuery(sql).addEntity(SysClass.class);
query.setInteger(0, techId);
return query.list();
}
String sql = "select * from t_sys_class where id in (select classid from t_tech_teaclass where teacherid = ?)";
SQLQuery query = this.getSession().createSQLQuery(sql).addEntity(SysClass.class);
query.setInteger(0, techId);
return query.list();
}