Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class MenuDTO implements Serializable{
- @Id
- @Column(name = "Id", nullable = false)
- private String idMenu;
- @Column(name = "Caption", nullable = false)
- private String nombre;
- @Column(name = "NumMenu", nullable = false)
- private String numero;
- //get y sets
- }
- public class PermisoDTO implements Serializable {
- @Id
- @Column(name="IdPermiso",nullable=false)
- private String idPermiso;
- }
- public class GrupoDTO implements Serializable{
- @Id
- @Column(name="CodGrupo",nullable=false)
- private String idCodGrupo;
- }
- public class UsuarioDTO implements Serializable{
- @Id
- @Column(name="CodGrupo",nullable=false)
- private String idCodGUs;
- }
- select DISTINCT caption AS MENUS
- from permisomenu P1 Join permiso P ON IdPermiso=P.Id Join usuario e
- ON e.CodGrupo=P.CodGrupo Join grupo g ON g.codgrupo=e.codgrupo
- where g.codgrupo like '%admin%'
Add Comment
Please, Sign In to add comment