public Leave detail(int id) { Session session = HibernateSessionFactory.getSession(); session.beginTransaction(); Leave leave = (Leave) session.get(Leave.class, id); session.getTransaction().commit(); HibernateSessionFactory.closeSession(); return leave; }
public void delete(int id) { Session session = HibernateSessionFactory.getSession(); session.beginTransaction(); Leave leave = (Leave) session.get(Leave.class, id); session.delete(leave); session.getTransaction().commit(); HibernateSessionFactory.closeSession(); }
/** Hibernate Test class */ public static void main(String[] args) { // TODO Auto-generated method stub // Session session = HibernateUtil.currentSession(); Session session = HibernateSessionFactory.getSession(); session.beginTransaction(); // create query object Query query = session.createQuery("from Customer"); // create customer list List<Customer> list = query.list(); Customer cus = null; if (list != null && list.size() > 0) { /*for(int i = 0;i<list.size();i++){ cus = (Customer)list.get(i); System.out.println("" + "+i= " + i + "ID = "+ cus.getId()+ "name = "+ cus.getName()+"Age = " +cus.getAge()); }*/ for (Customer customer : list) { cus = customer; System.out.println( "ID = " + cus.getId() + " name = " + cus.getName() + " Age = " + cus.getAge()); } } session.beginTransaction().commit(); // submit }
public static String getParsedUrl(String url) { LogDAO logDAO = new LogDAO(); Session session = HibernateSessionFactory.openCurrentSession(); Transaction tran = session.beginTransaction(); List<Log> list = logDAO.findByProperty("url", url.trim()); tran.commit(); if (null == list || list.size() == 0) return null; return list.get(0).getOther(); }
public static boolean checkTitle(String title, String host) { logger.info("checkTitle : " + title + " , " + host); LogDAO logDAO = new LogDAO(); Session session = HibernateSessionFactory.openCurrentSession(); Transaction tran = session.beginTransaction(); List list = logDAO.findByProperty("name", title + ";" + host); tran.commit(); if (null == list || list.size() == 0) return false; return true; }
/** * @param link * @return 有该link返回true,没有的话返回false */ public static boolean checkUrl(String link) { LogDAO logDAO = new LogDAO(); Session session = HibernateSessionFactory.openCurrentSession(); Transaction tran = session.beginTransaction(); List list = logDAO.findByProperty("url", link.trim()); tran.commit(); logger.info("checkUrl : " + link + " , result : " + list); if (null == list || list.size() == 0) return false; return true; }
public boolean islike(Integer userid, Integer goodsid) { Session session = null; Like like = null; try { session = HibernateSessionFactory.getSession(); like = new Like(userid, goodsid, null); like = (Like) session.get(Like.class, like); } catch (Exception e) { // TODO: handle exception System.err.println(e); System.out.println("likeDao.islike()"); return false; } finally { session.flush(); session.clear(); HibernateSessionFactory.closeSession(); } if (like == null) { return false; } return true; }
/** * 取消喜爱作品 * * @param userid * @param goodsid * @return */ public boolean unlikeGoods(Integer userid, Integer goodsid) { Transaction tx = null; Session session = null; try { session = HibernateSessionFactory.getSession(); tx = session.beginTransaction(); Like like = new Like(userid, goodsid, null); like = (Like) session.get(Like.class, like); session.delete(like); tx.commit(); } catch (Exception e) { // TODO: handle exception System.err.println(e); System.out.println("likeDao.unlikeGoods()"); tx.rollback(); return false; } finally { session.flush(); session.clear(); HibernateSessionFactory.closeSession(); } return true; }
/** * 喜爱作品 * * @param userid * @param goodsid * @return */ public boolean likeGoods(Integer userid, Integer goodsid) { Transaction tx = null; Session session = null; try { session = HibernateSessionFactory.getSession(); tx = session.beginTransaction(); System.out.println(userid + "," + goodsid); Like like = new Like(userid, goodsid, GLobalMethod.getNowTime()); session.save(like); tx.commit(); } catch (Exception e) { // TODO: handle exception System.err.println(e); System.out.println("likeDao.likeGoods()"); tx.rollback(); return false; } finally { session.flush(); session.clear(); HibernateSessionFactory.closeSession(); } return true; }
/** * 根据作品id获取销售记录 * * @param goods * @return */ public List<SaleHistory> getSaleListByGoods(Integer goodsid) { Session session = HibernateSessionFactory.getSession(); List<SaleHistory> historyList = null; try { historyList = session .createQuery("from SaleHistory as sh where sh.goods.goodsid=?") .setInteger(0, goodsid) .list(); } catch (Exception e) { // TODO: handle exception System.out.println(e); } return historyList; }
/** * 根据用户id获取已购列表 * * @param userid * @return */ public List<SaleHistory> getSaleListByUser(Integer userid) { Session session = HibernateSessionFactory.getSession(); List<SaleHistory> historyList = null; try { historyList = session .createQuery("from SaleHistory as sh where sh.user.userid=? order by sh.buytime desc") .setInteger(0, userid) .list(); } catch (Exception e) { // TODO: handle exception System.out.println(e); } return historyList; }
private static void configureFromExistingSessionFactory( SessionFactory sessionFactory, boolean hibernate4Used) { HibernateSessionFactory.setExistingSessionFactory( sessionFactory, hibernate4Used ? new SessionControlHibernate4() : new SessionControlHibernate5()); }
/** Close a Hibernate session factory. */ public void close() { HibernateSessionFactory.closeSessionFactory(); }
public static void main(String[] args) { Session s = HibernateSessionFactory.getSession(); s.beginTransaction(); // form type s.save(new FormType("健康教育活动记录表")); // 1 s.save(new FormType("新生儿家庭访视记录表", "child/child_0_edit.jsp")); // 2 s.save(new FormType("健康体检表", "base/exam", 5)); // 3 s.save(new FormType("接诊记录表", "base/other/jiuzhen_edit.jsp")); // 4 s.save(new FormType("会诊记录表", "base/other/huizhen_edit.jsp")); // 5 s.save(new FormType("双向转诊单(转出)", "base/other/zhuanzhen1_edit.jsp")); // 6 s.save(new FormType("居民健康档案信息卡", "base/other/infoka_edit.jsp")); // 7 s.save(new FormType("1岁以内儿童健康检查记录表", "child/child_1_edit.jsp")); // 8 s.save(new FormType("1~2岁儿童健康检查记录表", "child/child_2_edit.jsp")); // 9 s.save(new FormType("3~6岁儿童健康检查记录表", "child/child_3_edit.jsp")); // 10 s.save(new FormType("双向转诊单(回转)", "base/other/zhuanzhen2_edit.jsp")); // 11 s.save(new FormType("第1次产前随访服务记录表", "mother/mother_1_edit.jsp")); // 12 s.save(new FormType("第2~5次产前随访服务记录表", "mother/mother_2_5_edit.jsp")); // 13 s.save(new FormType("产后访视记录表", "mother/mother_after_edit.jsp")); // 14 s.save(new FormType("产后42天健康检查记录表", "mother/mother_42_edit.jsp")); // 15 s.save(new FormType("预防接种卡", "yufang/yufang_edit.jsp")); // 16 s.save(new FormType("重性精神疾病患者评估表", "mental/mental_info_edit.jsp")); // 17 s.save(new FormType("重性精神疾病患者随访表", "mental/mental_access_edit.jsp")); // 18 s.save(new FormType("高血压患者随访服务记录表", "serious/high", 2)); // 19 s.save(new FormType("2型糖尿病患者随访服务记录表", "serious/tangniao", 2)); // 20 // 表格分类 FormCatalog[] fcs = new FormCatalog[12]; // System.out.println(fcs.length); for (int i = 0; i < fcs.length; i++) { fcs[i] = new FormCatalog(); } fcs[0].setName("居民健康档案封面"); // 21 fcs[1].setName("个人基本信息表"); // 22 fcs[2].setName("健康体检表"); // 23 fcs[3].setName("重点人群健康管理记录表(图、卡)"); // 24 fcs[4].setName("0~36个月儿童健康管理记录表"); // 25 fcs[4].setParentCatalog(fcs[3]); fcs[5].setName("孕产妇健康管理记录表"); // 26 fcs[5].setParentCatalog(fcs[3]); fcs[6].setName("0~6岁儿童预防接种卡"); // 27 fcs[6].setParentCatalog(fcs[3]); fcs[7].setName("慢性病记录表"); // 28 fcs[7].setParentCatalog(fcs[3]); fcs[8].setName("重性精神疾病记录表"); // 29 fcs[8].setParentCatalog(fcs[3]); fcs[9].setName("其他医疗卫生服务记录表"); // 30 fcs[10].setName("居民健康档案信息卡"); // 31 fcs[11].setName("填表基本要求"); // 32 FormType ft = (FormType) s.get(FormType.class, (long) 2); ft.setCatalog(fcs[4]); ft = (FormType) s.get(FormType.class, (long) 8); ft.setCatalog(fcs[4]); ft = (FormType) s.get(FormType.class, (long) 9); ft.setCatalog(fcs[4]); ft = (FormType) s.get(FormType.class, (long) 10); ft.setCatalog(fcs[4]); // ft = (FormType) s.get(FormType.class, (long)11); // ft.setCatalog(fcs[4]); ft = (FormType) s.get(FormType.class, (long) 12); ft.setCatalog(fcs[5]); ft = (FormType) s.get(FormType.class, (long) 13); ft.setCatalog(fcs[5]); ft = (FormType) s.get(FormType.class, (long) 14); ft.setCatalog(fcs[5]); ft = (FormType) s.get(FormType.class, (long) 15); ft.setCatalog(fcs[5]); ft = (FormType) s.get(FormType.class, (long) 16); ft.setCatalog(fcs[6]); ft = (FormType) s.get(FormType.class, (long) 17); ft.setCatalog(fcs[8]); ft = (FormType) s.get(FormType.class, (long) 18); ft.setCatalog(fcs[8]); ft = (FormType) s.get(FormType.class, (long) 19); ft.setCatalog(fcs[7]); ft = (FormType) s.get(FormType.class, (long) 20); ft.setCatalog(fcs[7]); for (FormCatalog fc : fcs) { if (fc == null) continue; s.save(fc); } // 权限、页面、按钮 Permission home = new Permission(); home.setName("首页"); home.setUrl("doc_base_baseInfoList.action"); home.setIsOnlySa(false); s.save(home); // 33 Permission[] pers = new Permission[37]; for (int i = 0; i < pers.length; i++) { pers[i] = new Permission(); pers[i].setOrderNum(i + 1); s.save(pers[i]); } pers[0].setName("基础档案管理"); // 34 pers[0].setUrl("doc_base_index.action"); pers[0].setIsOnlySa(false); pers[1].setName("个人基本信息"); // 35 pers[1].setUrl("doc_base_index.action"); pers[1].setIsOnlySa(false); pers[1].setParent(pers[0]); pers[2].setName("家庭档案"); // 36 pers[2].setUrl("doc_base_familyList.action"); pers[2].setIsOnlySa(false); pers[2].setParent(pers[0]); pers[3].setName("健康体检表"); // 37 pers[3].setUrl("doc_common_formList.action?formType.id=3"); pers[3].setIsOnlySa(false); // pers[3].setParent(pers[0]); pers[4].setName("就诊记录"); // 38 pers[4].setUrl("doc_common_formList.action?formType.id=4"); pers[4].setIsOnlySa(false); pers[4].setParent(pers[0]); pers[5].setName("档案管理信息"); // 39 pers[5].setUrl("doc_base_docTransferManage.action"); pers[5].setIsOnlySa(false); pers[5].setParent(pers[0]); pers[6].setName("健康教育"); // 40 pers[6].setUrl("doc_edu_index.action"); pers[6].setIsOnlySa(false); pers[7].setName("档案管理信息"); // 41 pers[7].setUrl("welcome.action"); pers[7].setIsOnlySa(false); pers[7].setParent(pers[6]); pers[8].setName("儿童健康"); // 42 pers[8].setUrl("doc_common_formList.action?formType.id=2"); pers[8].setIsOnlySa(false); pers[9].setName("新生儿家庭访视"); // 43 pers[9].setUrl("doc_common_formList.action?formType.id=2"); pers[9].setIsOnlySa(false); pers[9].setParent(pers[8]); pers[10].setName("1岁以内儿童随访"); // 44 pers[10].setUrl("doc_common_formList.action?formType.id=8"); pers[10].setIsOnlySa(false); pers[10].setParent(pers[8]); pers[11].setName("1~2岁儿童随访"); // 45 pers[11].setUrl("doc_common_formList.action?formType.id=9"); pers[11].setIsOnlySa(false); pers[11].setParent(pers[8]); pers[12].setName("3~6岁儿童随访"); // 46 pers[12].setUrl("doc_common_formList.action?formType.id=10"); pers[12].setIsOnlySa(true); pers[12].setParent(pers[8]); pers[13].setName("孕产妇保健"); // 47 pers[13].setUrl("doc_common_formList.action?formType.id=12"); pers[13].setIsOnlySa(false); pers[14].setName("第一次产前随访"); // 48 pers[14].setUrl("doc_common_formList.action?formType.id=12"); pers[14].setIsOnlySa(false); pers[14].setParent(pers[13]); pers[15].setName("第2~5次产前随访"); // 49 pers[15].setUrl("doc_common_formList.action?formType.id=13"); pers[15].setIsOnlySa(false); pers[15].setParent(pers[13]); pers[16].setName("产后访视"); // 50 pers[16].setUrl("doc_common_formList.action?formType.id=14"); pers[16].setIsOnlySa(false); pers[16].setParent(pers[13]); pers[17].setName("产后42天健康检查"); // 51 pers[17].setUrl("doc_common_formList.action?formType.id=15"); pers[17].setIsOnlySa(true); pers[17].setParent(pers[13]); pers[18].setName("儿童预防接种"); // 52 pers[18].setUrl("doc_common_formList.action?formType.id=16"); pers[18].setIsOnlySa(false); pers[19].setName("0~6岁儿童预防接种卡"); // 53 pers[19].setUrl("doc_common_formList.action?formType.id=16"); pers[19].setIsOnlySa(false); pers[19].setParent(pers[18]); pers[20].setName("慢性病管理"); // 54 pers[20].setUrl("doc_common_formList.action?formType.id=19"); pers[20].setIsOnlySa(false); pers[21].setName("高血压患者"); // 55 pers[21].setUrl("doc_common_formList.action?formType.id=19"); pers[21].setIsOnlySa(false); pers[21].setParent(pers[20]); pers[22].setName("糖尿病患者"); // 56 pers[22].setUrl("doc_common_formList.action?formType.id=20"); pers[22].setIsOnlySa(false); pers[22].setParent(pers[20]); pers[23].setName("重性精神疾病患者"); // 57 pers[23].setUrl("doc_common_formList.action?formType.id=17"); pers[23].setIsOnlySa(false); pers[24].setName("评估表"); // 58 pers[24].setUrl("doc_common_formList.action?formType.id=17"); pers[24].setIsOnlySa(false); pers[24].setParent(pers[23]); pers[25].setName("随访表"); // 59 pers[25].setUrl("doc_common_formList.action?formType.id=18"); pers[25].setIsOnlySa(false); pers[25].setParent(pers[23]); pers[26].setName("填表要求"); // 60 pers[26].setUrl("spec_index.action"); pers[26].setIsOnlySa(false); pers[27].setName("机构人员"); // 61 pers[27].setUrl("org_index.action"); pers[27].setIsOnlySa(true); pers[28].setName("机构管理"); // 62 pers[28].setUrl("org_orgList.action"); pers[28].setIsOnlySa(true); pers[28].setParent(pers[27]); pers[29].setName("人员管理"); // 63 pers[29].setUrl("org_employeeList.action"); pers[29].setIsOnlySa(true); pers[29].setParent(pers[27]); pers[30].setName("系统管理"); // 64 pers[30].setUrl("dic_index.action"); pers[30].setIsOnlySa(true); pers[31].setOrderNum(2); pers[31].setName("诊疗记录"); // 65 pers[31].setUrl("doc_common_formList.action?formType.id=4"); pers[31].setIsOnlySa(false); pers[32].setName("接诊记录表"); // 66 pers[32].setUrl("doc_common_formList.action?formType.id=4"); pers[32].setIsOnlySa(false); pers[32].setParent(pers[31]); pers[33].setName("会诊记录表"); // 67 pers[33].setUrl("doc_common_formList.action?formType.id=5"); pers[33].setIsOnlySa(false); pers[33].setParent(pers[31]); pers[34].setName("双向转诊单(转出)"); // 68 pers[34].setUrl("doc_common_formList.action?formType.id=6"); pers[34].setIsOnlySa(false); pers[34].setParent(pers[31]); pers[35].setName("双向转诊单(回转)"); // 69 pers[35].setUrl("doc_common_formList.action?formType.id=11"); pers[35].setIsOnlySa(true); pers[35].setParent(pers[31]); pers[36].setName("居民健康档案信息卡"); // 70 pers[36].setUrl("doc_common_formList.action?formType.id=7"); pers[36].setIsOnlySa(true); pers[36].setParent(pers[31]); FormCatalog fcs71 = new FormCatalog(); fcs71.setName("填表基本要求"); // 71 ft = (FormType) s.get(FormType.class, (long) 4); ft.setCatalog(fcs71); ft = (FormType) s.get(FormType.class, (long) 5); ft.setCatalog(fcs71); ft = (FormType) s.get(FormType.class, (long) 6); ft.setCatalog(fcs71); ft = (FormType) s.get(FormType.class, (long) 7); ft.setCatalog(fcs71); ft = (FormType) s.get(FormType.class, (long) 11); ft.setCatalog(fcs71); s.save(fcs71); s.save(new FormType("老年人生活自理能力评估表", "old/pinggu.jsp")); // 72 Permission oldManPer = new Permission(); oldManPer.setName("65岁以上人群"); oldManPer.setUrl("doc_common_formList.action?formType.id=72"); oldManPer.setIsOnlySa(false); oldManPer.setOrderNum(27); s.save(oldManPer); // 73 Permission oldManPingPer = new Permission(); oldManPingPer.setName("老年人生活自理能力评估表"); oldManPingPer.setUrl("doc_common_formList.action?formType.id=72"); oldManPingPer.setParent(oldManPer); oldManPingPer.setIsOnlySa(false); s.save(oldManPingPer); // 74 Permission jkPer = new Permission(); jkPer.setName("健康体检表"); // 37 jkPer.setUrl("doc_common_formList.action?formType.id=3"); jkPer.setIsOnlySa(false); jkPer.setParent(pers[3]); jkPer.setOrderNum(3); s.save(jkPer); // 用户和机构 SuperAdmin sa = new SuperAdmin(); sa.setName("超级管理员"); sa.setLoginName("sa"); sa.setPassword("123"); s.save(sa); // Employee e = new Employee(); // e.setName("张三"); // e.setCreatedDate(new Date()); // e.setIsActive(true); // e.setLastModifyDate(new Date()); // e.setLoginName("zs"); // e.setPassword("123"); // e.setFullName("张三"); // // Employee e2 = new Employee(); // e2.setName("李四"); // e2.setCreatedDate(new Date()); // e2.setIsActive(true); // e2.setLastModifyDate(new Date()); // e2.setLoginName("ls"); // e2.setPassword("123"); // e2.setFullName("李四"); // // Employee e3 = new Employee(); // e3.setName("王五"); // e3.setCreatedDate(new Date()); // e3.setIsActive(true); // e3.setLastModifyDate(new Date()); // e3.setLoginName("ww"); // e3.setPassword("123"); // e3.setFullName("王五"); // Organization org = new Organization(); // org.setName("广州市卫生厅"); // org.setParentOrg(null); // org.getEmployees().add(e); // e.setOrganization(org); // // Organization org2 = new Organization(); // org2.setName("广州市白云区卫生服务中心"); // org2.setParentOrg(org); // org2.getEmployees().add(e2); // e2.setOrganization(org); // // Organization org3 = new Organization(); // org3.setName("广州市白云区沙河镇卫生院"); // org3.setParentOrg(org2); // s.save(org3); // org3.getEmployees().add(e3); // e3.setOrganization(org3); // // s.save(org); // s.save(org2); // s.save(org3); // s.save(e); // s.save(e2); // s.save(e3); // Organization[] orgArr = new Organization[1]; // int num = 1; // for (Organization o : orgArr) { // o = new Organization(); // o.setName("测试机构" + (num++)); // s.save(o); // } // // Employee[] empArr = new Employee[1]; // num = 1; // for (Employee o : empArr) { // o = new Employee(); // o.setName("测试用户" + (num++)); // o.setLoginName("test" + num); // o.setPassword("123"); // o.setOrganization(org2); // s.save(o); // } // //医生 // Doctor doctor = new Doctor(); // doctor.setName("张医生"); // s.save(doctor); // 各种选项 SelectGender[] genders = new SelectGender[4]; genders[0] = new SelectGender("未知的性别", 0); genders[1] = new SelectGender("男", 1); genders[2] = new SelectGender("女", 2); genders[3] = new SelectGender("未说明的性别", 9); saveEntities(s, genders); String[] nationArr = { "汉族", "壮族", "满族", "回族", "苗族", "维吾尔族", "土家族", "彝族", "蒙古族", "藏族", "布依族", "侗族", "瑶族", "朝鲜族", "白族", "哈尼族", "哈萨克族", "傣族", "畲族僳族", "仡佬族", "东乡族", "拉祜族", "水族佤族", "纳西族", "羌族", "土族", "仫佬族", "锡伯族", "柯尔克孜族", "达斡尔族", "撒拉族", "布朗族", "塔吉克族", "阿昌族普米族", "鄂温克族怒族", "京族", "基诺族", "德昂族", "保安族", "俄罗斯族", "裕固族", "乌孜别克族", "门巴族", "鄂伦春族", "独龙族", "塔塔尔族", "赫哲族", "高山族", "珞巴族", "未识别民族" }; SelectNation[] nations = new SelectNation[nationArr.length]; for (int i = 0; i < nationArr.length; i++) { nations[i] = new SelectNation(nationArr[i], i + 1); } saveEntities(s, nations); saveSelect(s, new String[] {"户籍", "非户籍"}, SelectHuJiType.class); SelectBlood[] bloods = new SelectBlood[5]; bloods[0] = new SelectBlood(); bloods[0].setCode(1); bloods[0].setName("A型"); bloods[1] = new SelectBlood(); bloods[1].setCode(2); bloods[1].setName("B型"); bloods[2] = new SelectBlood(); bloods[2].setCode(3); bloods[2].setName("O型"); bloods[3] = new SelectBlood(); bloods[3].setCode(4); bloods[3].setName("AB型"); bloods[4] = new SelectBlood(); bloods[4].setCode(5); bloods[4].setName("不详"); saveEntities(s, bloods); saveSelect(s, new String[] {"否", "是", "不详"}, SelectRH.class); String[] xueliArr = {"文盲及半文盲", "小学", "初中", "高中/技校/中专", "大学专科及以上", "不详"}; SelectXueli[] xueli = new SelectXueli[xueliArr.length]; for (int i = 0; i < xueliArr.length; i++) { xueli[i] = new SelectXueli(); xueli[i].setCode(i + 1); xueli[i].setName(xueliArr[i]); } saveEntities(s, xueli); String[] zhiyeArr = { "国家机关", "党群组织", "企业", "事业单位负责人", "专业技术人员", "办事人员和有关人", "商业", "服务业人员", "农、林、牧、渔、水利业生产人员", "生产", "运输设备操作人员及有关人员", "军人", "不便分类的其他从业人员" }; saveSelect(s, zhiyeArr, SelectPosition.class); String[] marriedArr = {"未婚", "已婚", "丧偶", "离婚", "未说明的婚姻状况"}; saveSelect(s, marriedArr, SelectMarried.class); String[] payArr = { "城镇职工基本医疗保险", "城镇居民基本医疗保险", "新型农村合作医疗", "贫困救助", "商业医疗保险", "全公费", "全自费", "其他" }; saveSelect(s, payArr, SelectPayment.class); String[] guominArr = {"无", "有", "青霉素", "磺胺", "链霉素", "其他"}; saveSelect(s, guominArr, SelectGuoMin.class); String[] deseaseArr = { "无", "高血压", "糖尿病", "冠心病", "慢性阻塞性肺疾病", "恶性肿瘤", "脑卒中", "重性精神疾病", "结核病", "肝炎", "其他法定传染病", "职业病" }; saveSelect(s, deseaseArr, CheckboxDisease.class); String[] familyDeseaseArr = { "无", "高血压", "糖尿病", "冠心病", "慢性阻塞性肺疾病", "恶性肿瘤", "脑卒中", "重性精神疾病", "结核病", "肝炎", "先天畸形" }; saveSelect(s, familyDeseaseArr, CheckboxFamilyDisease.class); String[] brokenArr = {"无残疾", "视力残疾", "听力残疾", "言语残疾", "肢体残疾", "智力残疾", "精神残疾"}; saveSelect(s, brokenArr, CheckboxBroken.class); String[] materialArr = {"书面材料", "图片材料", "印刷材料", "影音材料", "居民签到表", "其他材料"}; saveSelect(s, materialArr, CheckboxMaterial.class); String[] pregnantDiseaseArr = {"糖尿病", "妊娠期高血压疾病"}; saveSelect(s, pregnantDiseaseArr, SelectPregnantDisease.class); String[] pregnantStyleArr = {"顺产", "头吸", "产钳", "剖宫", "双多胎", "臀位"}; saveSelect(s, pregnantStyleArr, SelectPregnantStyle.class); String[] newChildBreathAtrr = {"无", "有(轻)", "有(中)", "有(重)"}; saveSelect(s, newChildBreathAtrr, SelectNewChildBreath.class); String[] feedAttr = {"纯母乳", "混合", "人工"}; saveSelect(s, feedAttr, SelectNewChildFeedStyle.class); String[] faceColorAttr = {"红润", "黄染"}; saveSelect(s, faceColorAttr, SelectNewChildFaceColor.class); String[] frontAttr = {"正常", "膨隆", "凹陷"}; saveSelect(s, frontAttr, SelectNewChildFrontStyle.class); String[] skinAttr = {"未见异常", "湿疹", "糜烂"}; saveSelect(s, skinAttr, SelectNewChildSkin.class); String[] jidaAttr = {"未脱", "脱落", "脐部有渗出"}; saveSelect(s, jidaAttr, SelectNewChildJidai.class); String[] guideAttr = {"喂养指导", "发育指导", "防病指导", "预防伤害指导", "口腔保健指导"}; saveSelect(s, guideAttr, CheckboxGuide.class); String[] fmAttr = {"户主", "爷爷", "奶奶", "父亲", "母亲", "兄弟", "姐妹", "儿子", "女儿"}; saveSelect(s, fmAttr, SelectFamilyRelation.class); String[] symptomAttr = { "无症状", "头痛", "头晕", "心悸", "胸闷", "胸痛", "慢性咳嗽", "咳痰", "呼吸困难", "多饮", "多尿", "体重下降", "乏力", "关节肿痛", "视力模糊", "手脚麻木", "尿急", "尿痛", "便秘", "腹泻", "恶心呕吐", "眼花", "耳鸣", "乳房胀痛" }; saveSelect(s, symptomAttr, CheckboxSymptom.class); String[] oldManAttr = {"粗筛阴性", "粗筛阳性"}; saveSelect(s, oldManAttr, SelectOldManState.class); String[] sportAttr = {"每天", "每周一次以上", "偶尔", "不锻炼"}; saveSelect(s, sportAttr, SelectSportOften.class); String[] foodAttr = {"荤素均衡", "荤食为主", "素食为主", "嗜盐", "嗜油", "嗜糖"}; saveSelect(s, foodAttr, CheckboxFoodStyle.class); String[] xiyanAttr = {"从不吸烟", "已戒烟", "吸烟"}; saveSelect(s, xiyanAttr, SelectXiyan.class); String[] yinjiuAttr = {"从不", "偶尔", "经常", "每天"}; saveSelect(s, yinjiuAttr, SelectYinjiu.class); String[] wineAttr = {"白酒", "啤酒", "红酒", "黄酒"}; saveSelect(s, wineAttr, CheckboxWine.class); String[] kouchunAttr = {"红润", "苍白", "发干", "皲裂", "疱疹"}; saveSelect(s, kouchunAttr, SelectKouChun.class); String[] toothAttr = {"正常", "缺齿", "龋齿", "义齿(假牙)"}; saveSelect(s, toothAttr, SelectTooth.class); String[] yanbuAttr = {"无充血", "充血", "淋巴滤泡增生"}; saveSelect(s, yanbuAttr, SelectYanhou.class); String[] skinAttr2 = {"正常", "潮红", "苍白", "发绀", "黄染", "色素沉着"}; saveSelect(s, skinAttr2, SelectSkin.class); String[] gongmoAttr = {"正常", "黄染", "充血"}; saveSelect(s, gongmoAttr, SelectGongmo.class); String[] linbaAttr = {"未触及", "锁骨上", "腋窝"}; saveSelect(s, linbaAttr, SelectLinba.class); String[] xiazhiAttr = {"无", "单侧", "双侧不对称", "双侧对称"}; saveSelect(s, xiazhiAttr, SelectXiazhiShuizhong.class); String[] gmAttr = {"未及异常", "触痛", "包块", "前列腺异常"}; saveSelect(s, gmAttr, SelectGangmen.class); String[] rxAttr = {"未见异常", "乳房切除", "异常泌乳", "乳腺包块", "其他"}; saveSelect(s, rxAttr, CheckboxRuXian.class); String[] naoxueAttr = {"未发现", "缺血性卒中", "脑出血", "蛛网膜下腔出血", "短暂性脑缺血发作"}; saveSelect(s, naoxueAttr, CheckboxNaoxueDisease.class); String[] shenzangAttr = {"未发现", "糖尿病肾病", "肾功能衰竭", "急性肾炎", "慢性肾炎"}; saveSelect(s, shenzangAttr, CheckboxShenzangDisease.class); String[] heartAttr = {"未发现", "心肌梗死", "心绞痛", "冠状动脉血运重建", "充血性心力衰竭", "心前区疼痛"}; saveSelect(s, heartAttr, CheckboxHeartDisease.class); String[] booldAttr = {"未发现", "夹层动脉瘤", "动脉闭塞性疾病"}; saveSelect(s, booldAttr, CheckboxBloodDisease.class); String[] eyeAttr = {"未发现", "视网膜出血或渗出", "视乳头水肿", "白内障"}; saveSelect(s, eyeAttr, CheckboxEyeDisease.class); String[] yaoAttr = {"规律", "间断", "不服药"}; saveSelect(s, yaoAttr, SelectYaoOften.class); String[] baoluAttr = {"无", "化学品", "毒物", "射线"}; saveSelect(s, baoluAttr, SelectBaolu.class); String[] chufangAttr = {"无", "油烟机", "换气扇", "烟囱"}; saveSelect(s, chufangAttr, SelectChufang.class); String[] ranliaoAttr = {"液化气", "煤", "天然气", "沼气", "柴火", "其他"}; saveSelect(s, ranliaoAttr, SelectRanliao.class); String[] waterAttr = {"自来水", "经净化过滤的水", "井水", "河湖水", "塘水", "其他"}; saveSelect(s, waterAttr, SelectWater.class); String[] wcAttr = {"卫生厕所", "一格或二格粪池式", "马桶", "露天粪坑 ", "简易棚厕"}; saveSelect(s, wcAttr, SelectWC.class); String[] animalAttr = {"单设", "室内", "室外"}; saveSelect(s, animalAttr, SelectAnimal.class); String[] zubeiMaidongAttr = {"未触及", "触及双侧对称", "触及左侧弱或消失", "触及右侧弱或消失"}; saveSelect(s, zubeiMaidongAttr, SelectZubeiMaidong.class); s.getTransaction().commit(); s.close(); // add a patient // SpringTest.main(null); }
private synchronized SessionFactory getSessionFactory(PageContext pc, boolean init) throws PageException { ApplicationContextPro appContext = ((ApplicationContextPro) pc.getApplicationContext()); if (!appContext.isORMEnabled()) throw new ORMException(this, "ORM is not enabled in application.cfc/cfapplication"); this.hash = hash(appContext); // datasource String dsn = appContext.getORMDatasource(); if (StringUtil.isEmpty(dsn)) throw new ORMException(this, "missing datasource defintion in application.cfc/cfapplication"); if (!dsn.equalsIgnoreCase(datasource)) { configuration = null; if (_factory != null) _factory.close(); _factory = null; datasource = dsn.toLowerCase(); } // config ormConf = appContext.getORMConfiguration(); // List<Component> arr = null; arr = null; if (init) { if (ormConf.autogenmap()) { arr = HibernateSessionFactory.loadComponents(pc, this, ormConf); cfcs.clear(); } else throw new HibernateException(this, "orm setting autogenmap=false is not supported yet"); } // load entities if (!ArrayUtil.isEmpty(arr)) { loadNamingStrategy(ormConf); DatasourceConnectionPool pool = ((ConfigWebImpl) pc.getConfig()).getDatasourceConnectionPool(); DatasourceConnection dc = pool.getDatasourceConnection(pc, pc.getConfig().getDataSource(dsn), null, null); // DataSourceManager manager = pc.getDataSourceManager(); // DatasourceConnection dc=manager.getConnection(pc,dsn, null, null); this.ds = dc.getDatasource(); try { Iterator<ComponentPro> it = arr.iterator(); while (it.hasNext()) { createMapping(pc, it.next(), dc, ormConf); } } finally { pool.releaseDatasourceConnection(dc); // manager.releaseConnection(pc,dc); } if (arr.size() != cfcs.size()) { ComponentPro cfc; String name, lcName; Map<String, String> names = new HashMap<String, String>(); Iterator<ComponentPro> it = arr.iterator(); while (it.hasNext()) { cfc = it.next(); name = HibernateCaster.getEntityName(cfc); lcName = name.toLowerCase(); if (names.containsKey(lcName)) throw new ORMException( this, "Entity Name [" + name + "] is ambigous, [" + names.get(lcName) + "] and [" + cfc.getPageSource().getDisplayPath() + "] use the same entity name."); names.put(lcName, cfc.getPageSource().getDisplayPath()); } } } arr = null; if (configuration != null) return _factory; // MUST // cacheconfig // cacheprovider // ... String mappings = HibernateSessionFactory.createMappings(this, cfcs); DatasourceConnectionPool pool = ((ConfigWebImpl) pc.getConfig()).getDatasourceConnectionPool(); DatasourceConnection dc = pool.getDatasourceConnection(pc, pc.getConfig().getDataSource(dsn), null, null); try { configuration = HibernateSessionFactory.createConfiguration(this, mappings, dc, ormConf); } catch (Exception e) { throw Caster.toPageException(e); } finally { pool.releaseDatasourceConnection(dc); } addEventListeners(pc, configuration, ormConf, cfcs); EntityTuplizerFactory tuplizerFactory = configuration.getEntityTuplizerFactory(); // tuplizerFactory.registerDefaultTuplizerClass(EntityMode.MAP, CFCEntityTuplizer.class); // tuplizerFactory.registerDefaultTuplizerClass(EntityMode.MAP, MapEntityTuplizer.class); tuplizerFactory.registerDefaultTuplizerClass(EntityMode.MAP, AbstractEntityTuplizerImpl.class); tuplizerFactory.registerDefaultTuplizerClass(EntityMode.POJO, AbstractEntityTuplizerImpl.class); // tuplizerFactory.registerDefaultTuplizerClass(EntityMode.POJO, // AbstractEntityTuplizerImpl.class); // configuration.setEntityResolver(new CFCEntityResolver()); // configuration.setEntityNotFoundDelegate(new EntityNotFoundDelegate()); return _factory = configuration.buildSessionFactory(); }