Repository navigation
Expand file tree
/
Copy pathUserDaoImpl.java
More file actions
129 lines (84 loc) · 2.49 KB
/
Copy pathUserDaoImpl.java
File metadata and controls
129 lines (84 loc) · 2.49 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
/**
*
*/
package com.fas.dao;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.exception.ConstraintViolationException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;
import com.fas.modal.Users;
/**
* @author swaybhase
*
*/
@Repository("UserDao")
public class UserDaoImpl implements UserDao {
@Autowired
private SessionFactory sessionFactory;
@Transactional
public void saveUser(Users user) {
try {
sessionFactory.getCurrentSession().saveOrUpdate(user);
} catch (ConstraintViolationException conVioex) {
if (conVioex.getErrorCode() == 1062) {
} else if (conVioex.getErrorCode() == 1064) {
}
}catch(Exception ex){
// TODO Auto-generated catch block
ex.printStackTrace();
}
}
@Transactional
public List<Users> getUser() {
@SuppressWarnings("unchecked")
List<Users> user=sessionFactory.getCurrentSession().createCriteria(Users.class).list();
return user;
}
@Transactional
public void deleteUser(int id) {
Users userModel=getUser(id);
if(userModel!=null)
sessionFactory.getCurrentSession().delete(userModel);
}
@Transactional
public Users getUser(int id) {
Users userModel=(Users)sessionFactory.getCurrentSession().get(Users.class,id);
return userModel;
}
@Transactional
public void updateUser(Users user) {
Users userModel=new Users();
userModel.setId(user.getId());
userModel.setFirstname(user.getFirstname());
userModel.setLastname(user.getLastname());
userModel.setEmail(user.getEmail());
sessionFactory.getCurrentSession().update(userModel);
}
@Transactional
public Users authenticateUser(Users user) {
boolean validUser;
Query query=sessionFactory.getCurrentSession().createQuery("from Users where username=? and password=?");
/*
* is interpreted as a named parameter! So here we actually have to write it as
.setParameter("1", 9L)
*
*/
query.setParameter(0, user.getUsername());
query.setParameter(1, user.getPassword());
if(query.uniqueResult()!=null){
validUser=true;
List<?> userList=query.list();
if(!userList.isEmpty()){
user=(Users) userList.get(0);
System.out.println("get user data "+user.getFirstname());
}
}else
validUser=false;
user.setValidUser(validUser);
return user;
}
}