CREATE TABLE `T_NAME` ( `ID` INT(11) NOT NULL COMMENT '编号', `NAME` VARCHAR(100) COMMENT '名称' )COMMENT='名称表' COLLATE='utf8mb4_bin' ENGINE=InnoDB; CREATE TABLE `T_TITLE` ( `SID` INT(11) NOT NULL COMMENT '编号', `TITLE` VARCHAR(100) COMMENT '标题' )COMMENT='标题' COLLATE='utf8mb4_bin' ENGINE=InnoDB;
初始化数据:
for(int i = 0; i < 5; i++){ Name name = new Name(); name.setId(i); name.setName("Name" + i); Title title = new Title(); title.setSid(name.getId()); title.setTitle("Title" + i); nameService.save(name); titleService.save(title); } for(int i = 5; i < 10; i++){ Name name = new Name(); name.setId(i); name.setName("Name" + i); Title title = new Title(); title.setSid(name.getId()); title.setTitle("Title" + i); if(i%2 == 0) { nameService.save(name); }else { titleService.save(title); } }
示例: