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();
}
