数据库表
CREATE TABLE `sys_menus` (
`menu_id` int(11) NOT NULL AUTO_INCREMENT,
`menu_name` varchar(255) NOT NULL,
`menu_url` varchar(255) DEFAULT NULL,
`menu_pid` int(11) DEFAULT NULL,
`sys_ico` varchar(255) DEFAULT NULL,
PRIMARY KEY (`menu_id`),
KEY `FK_bjl014ucbcba3uglobyj6slb5` (`menu_id`),
CONSTRAINT `FK_bjl014ucbcba3uglobyj6slb5` FOREIGN KEY (`menu_id`) REFERENCES `sys_menus` (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
实体类
@Table(name = "sys_menus")
@Data
@Entity
public class Menu {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name="menu_id")
private Long menuId;
@Column(name="menu_name")
private String menuName;
@Column(name="menu_url")
private String menuUrl;
@Column(name="sys_ico")
private String sysIco;
@Column(name="menu_pid")
private Long menuPid;
@OneToMany(cascade=CascadeType.ALL, fetch = FetchType.EAGER,targetEntity = Menu.class)
@JoinColumn(name="menu_pid")
private List<Menu> menus;
}
结果
[Menu(menuId=1, menuName=项目管理, menuUrl=, sysIco=fa fa-bullhorn, menuPid=0, menus=[Menu(menuId=2, menuName=人员管理, menuUrl=/admin/user/toUserpage, sysIco=, menuPid=1, menus=[])])]