Subversion Repositories SmartDukaan

Rev

Rev 21720 | Rev 22009 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
21720 ashik.ali 1 
package com.spice.profitmandi.dao.entity.dtr;
21545 ashik.ali 2 
 
3 
import java.io.Serializable;
4 
 
5 
import javax.persistence.Column;
6 
import javax.persistence.Entity;
7 
import javax.persistence.GeneratedValue;
8 
import javax.persistence.GenerationType;
9 
import javax.persistence.Id;
10 
import javax.persistence.NamedQueries;
11 
import javax.persistence.NamedQuery;
12 
import javax.persistence.Table;
13 
import javax.persistence.UniqueConstraint;
14 
 
15 
/**
16 
 * This class basically contains api details
17 
 *
18 
 * @author ashikali
19 
 *
20 
 */
21 
@Entity
21720 ashik.ali 22 
@Table(name="dtr.user_role", schema = "dtr", uniqueConstraints = {@UniqueConstraint(columnNames = {"user_id", "role_id"})})
21545 ashik.ali 23 
@NamedQueries({
24 
	@NamedQuery(name="UserRole.selectByUserId", query="select ur from UserRole ur where ur.userId= :userId"),
25 
	@NamedQuery(name="UserRole.deleteByUserAndRoleId", query="delete from UserRole ur where ur.userId= :userId and ur.roleId = :roleId"),
26 
	@NamedQuery(name = "UserRole.selectRolesByUserId", query = "select r.id, r.name, r.type, r.status, r.createTimestamp, r.updateTimestamp, p.type from UserRole ur join Role r on r.id = ur.roleId join Permission p on p.roleId = ur.roleId where ur.userId = :userId")
27 
})
28 
public class UserRole implements Serializable{
29 
 
30 
	private static final long serialVersionUID = 1L;
31 
 
32 
	@Id
33 
	@Column(name="id", unique=true, updatable=false)
34 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
35 
	private int id;
36 
 
37 
	public UserRole() {
38 
	}
39 
 
40 
	public int getId() {
41 
		return id;
42 
	}
43 
	public void setId(int id) {
44 
		this.id = id;
45 
	}
46 
	@Column(name="user_id", unique=false, updatable=false)
47 
	private int userId;
48 
 
49 
	@Column(name="role_id", unique = false)
50 
	private int roleId;
51 
 
52 
	public int getUserId() {
53 
		return userId;
54 
	}
55 
 
56 
	public void setUserId(int userId) {
57 
		this.userId = userId;
58 
	}
59 
	public int getRoleId() {
60 
		return roleId;
61 
	}
62 
	public void setRoleId(int roleId) {
63 
		this.roleId = roleId;
64 
	}
21602 ashik.ali 65 
 
66 
	@Override
21924 ashik.ali 67 
	public int hashCode() {
68 
		final int prime = 31;
69 
		int result = 1;
70 
		result = prime * result + id;
71 
		result = prime * result + roleId;
72 
		result = prime * result + userId;
73 
		return result;
74 
	}
75 
 
76 
	@Override
77 
	public boolean equals(Object obj) {
78 
		if (this == obj)
79 
			return true;
80 
		if (obj == null)
81 
			return false;
82 
		if (getClass() != obj.getClass())
83 
			return false;
84 
		UserRole other = (UserRole) obj;
85 
		if (id != other.id)
86 
			return false;
87 
		if (roleId != other.roleId)
88 
			return false;
89 
		if (userId != other.userId)
90 
			return false;
91 
		return true;
92 
	}
93 
 
94 
	@Override
21602 ashik.ali 95 
	public String toString() {
96 
		return "UserRole [id=" + id + ", userId=" + userId + ", roleId=" + roleId + "]";
97 
	}
21545 ashik.ali 98 
 
21602 ashik.ali 99 
 
100 
 
21545 ashik.ali 101 
}