ManagerDaoImpl.java
2.96 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
package com.bjivt.dao.showtime.impl;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import com.bjivt.dao.showtime.ManagerDao;
import com.bjivt.entity.showtime.Manager;
@Component
public class ManagerDaoImpl implements ManagerDao{
@Autowired(required = true)
protected SqlSession sqlSessionTemplate;
@Override
public Manager loginCheckManager(String loginName, String password) {
Map<String,Object> arg = new HashMap<String,Object>();
arg.put("loginName", loginName);
arg.put("password", password);
return sqlSessionTemplate.selectOne("com.bjivt.entity.showtime.Manager.loginCheck", arg);
}
@Override
public List<Manager> findManager(Manager manager) {
return sqlSessionTemplate.selectList("com.bjivt.entity.showtime.Manager.findManager",manager);
}
@Override
public List<Integer> findRoleForManager(Integer managerId) {
return sqlSessionTemplate.selectList("com.bjivt.entity.showtime.Manager.findRoleForManager",managerId);
}
@Override
public int saveManager(Manager manager) {
return sqlSessionTemplate.insert("com.bjivt.entity.showtime.Manager.addManager", manager);
}
@Override
public int saveRoleForManager(Integer roleId, Integer managerId) {
Map<String,Integer> args = new HashMap<String,Integer>();
args.put("roleId", roleId);
args.put("managerId", managerId);
return sqlSessionTemplate.insert("com.bjivt.entity.showtime.Manager.addRoleForManager", args);
}
@Override
public Manager getManager(Integer managerId) {
return sqlSessionTemplate.selectOne("com.bjivt.entity.showtime.Manager.getManager",managerId );
}
@Override
public int updateManager(Manager manager) {
return sqlSessionTemplate.update("com.bjivt.entity.showtime.Manager.updateManager",manager);
}
@Override
public int updateManagerCompetence(Manager manager){
return sqlSessionTemplate.update("com.bjivt.entity.showtime.Manager.updateManagerCompetence",manager);
}
@Override
public int deleteRoleForManager(Integer managerId) {
return sqlSessionTemplate.delete("com.bjivt.entity.showtime.Manager.deleteRoleForManager",managerId);
}
@Override
public int updatePassword(String loginPass, Integer managerId) {
Map<String,Object> args = new HashMap<String,Object>();
args.put("loginPass", loginPass);
args.put("managerId", managerId);
return sqlSessionTemplate.update("com.bjivt.entity.showtime.Manager.updatePassword", args);
}
@Override
public int deleteManager(Integer managerId) {
return sqlSessionTemplate.delete("com.bjivt.entity.showtime.Manager.deleteManager", managerId);
}
@Override
public Integer getManagerCount(Manager manager) {
return sqlSessionTemplate.selectOne("com.bjivt.entity.showtime.Manager.getManagerCount",manager);
}
public List<String> findRoleElement(String id) {
return sqlSessionTemplate.selectList("com.bjivt.entity.showtime.Manager.findRoleElement",id);
}
}