Hibernate?????????????
???????????? ???????[ 2015/10/12 13:39:43 ] ??????????????????
??????hibernate?????????????????????Щ??????????????????в???????????????????????????????????????model??????????????????key??value?У??磺
?????????CREATE TABLE `SKILL_GROUP` (
????`ID` int(11) NOT NULL AUTO_INCREMENT??
????`SKILL_GROUP` varchar(36) NOT NULL??
????`TYPE` int(11) NOT NULL??
????`WORK_END_TIME` varchar(10) DEFAULT NULL??
????`WORK_START_TIME` varchar(10) DEFAULT NULL??
????`SP_ID` varchar(36) DEFAULT NULL??
????`USER_ID` int(11) DEFAULT NULL??
????PRIMARY KEY (`ID`)??
????UNIQUE KEY `SP_ID` (`SP_ID`)??
????KEY `FK508C0AD1AA67812B` (`SP_ID`)??
????KEY `FK508C0AD11DD0822B` (`USER_ID`)
????) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
?????????? CREATE TABLE `SKILL_CONFIGURATION` (
????`CONFIG_KEY` varchar(36) NOT NULL??
????`CONFIG_VALUE` varchar(36) NOT NULL??
????`SKILL_GROUP_ID` int(11) NOT NULL
????) ENGINE=InnoDB DEFAULT CHARSET=utf8;
???????????model????????(TskillGroup)??
????private Map<String?? String> configMap = new HashMap<String?? String>(); //?????????????????map?洢
????@ElementCollection(fetch=FetchType.EAGER)
????@MapKeyColumn(name = "CONFIG_KEY") //?????????key?
????@Column(name = "CONFIG_VALUE"?? length = 290) //??????????
????@CollectionTable(name = "SKILL_CONFIGURATION"?? //????????
????joinColumns = @JoinColumn(name = "SKILL_GROUP_ID")) //????????????
????public Map<String?? String> getConfigMap() {
????return configMap;
????}
????public void setConfigMap(Map<String?? String> configMap) {
????this.configMap = configMap;
????}
??????????TskillGroup??????????????????·????????????????
????TskillGroup tsg = new TskillGroup();
????......?????????set???
??????????skillGroupDao.save(tsg);
?????????????????????tsg.getConfigMap().put(?????????key??????????? );
??????????TskillGroup tsg = skillGroupDao.get(TskillGroup.class?? skillGroup.getId());
????.....?????????set????????
?????????????????????tsg.getConfigMap().put(?????????key????????????μ?? );
???????????TskillGroup tsg = skillGroupDao.get(TskillGroup.class?? sgId);
?????????????????????????????tsg.getConfigMap().clear();
???????????List<TskillGroup> l = skillGroupDao.find(hql?? params);
???????list???TskillGroup????tsg
???????tsg?????????????????tsg.getConfigMap().get(?????????key)
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11