| Line 7... |
Line 7... |
| 7 |
import javax.persistence.Convert;
|
7 |
import javax.persistence.Convert;
|
| 8 |
import javax.persistence.Entity;
|
8 |
import javax.persistence.Entity;
|
| 9 |
import javax.persistence.GeneratedValue;
|
9 |
import javax.persistence.GeneratedValue;
|
| 10 |
import javax.persistence.GenerationType;
|
10 |
import javax.persistence.GenerationType;
|
| 11 |
import javax.persistence.Id;
|
11 |
import javax.persistence.Id;
|
| 12 |
import javax.persistence.NamedQueries;
|
- |
|
| 13 |
import javax.persistence.NamedQuery;
|
- |
|
| 14 |
import javax.persistence.Table;
|
12 |
import javax.persistence.Table;
|
| 15 |
import javax.persistence.UniqueConstraint;
|
13 |
import javax.persistence.UniqueConstraint;
|
| 16 |
|
14 |
|
| 17 |
import org.hibernate.annotations.UpdateTimestamp;
|
15 |
import org.hibernate.annotations.UpdateTimestamp;
|
| 18 |
|
16 |
|
| Line 24... |
Line 22... |
| 24 |
* @author ashikali
|
22 |
* @author ashikali
|
| 25 |
*
|
23 |
*
|
| 26 |
*/
|
24 |
*/
|
| 27 |
@Entity
|
25 |
@Entity
|
| 28 |
@Table(name="dtr.users", schema = "dtr",uniqueConstraints = {@UniqueConstraint(columnNames = {"email","mobile_number"})})
|
26 |
@Table(name="dtr.users", schema = "dtr",uniqueConstraints = {@UniqueConstraint(columnNames = {"email","mobile_number"})})
|
| 29 |
@NamedQueries({
|
- |
|
| 30 |
@NamedQuery(name = "User.selectCount", query = "select count(u) from User u"),
|
- |
|
| 31 |
@NamedQuery(name = "User.selectAll",query="select u from User u"),
|
- |
|
| 32 |
@NamedQuery(name = "User.selectById",query="select u from User u where u.id= :id"),
|
- |
|
| 33 |
@NamedQuery(name = "User.selectByEmailId", query = "select u from User u where u.emailId= :emailId"),
|
- |
|
| 34 |
@NamedQuery(name = "User.selectByMobileNumber", query = "select u from User u where u.mobileNumber= :mobileNumber"),
|
- |
|
| 35 |
@NamedQuery(name = "User.countByEmailId", query = "select count(u) from User u where u.emailId= :emailId"),
|
- |
|
| 36 |
@NamedQuery(name = "User.countByMobileNumber", query = "select count(u) from User u where u.mobileNumber= :mobileNumber"),
|
- |
|
| 37 |
@NamedQuery(name = "User.selectIdAndSololicUserId", query = "select u.id, ua.account_key, u.createTimestamp, u.updateTimestamp from User u join UserAccounts ua on u.id = ua.user_id where ua.account_type = 'saholic'")
|
- |
|
| 38 |
})
|
- |
|
| 39 |
public class User implements Serializable{
|
27 |
public class User implements Serializable{
|
| 40 |
|
28 |
|
| 41 |
|
29 |
|
| 42 |
private static final long serialVersionUID = 1L;
|
30 |
private static final long serialVersionUID = 1L;
|
| 43 |
|
31 |
|