1 |
/** |
---|
2 |
* |
---|
3 |
*/ |
---|
4 |
package org.springframework.samples.kyuriboard.dao.ibatis; |
---|
5 |
|
---|
6 |
import java.util.List; |
---|
7 |
|
---|
8 |
import org.springframework.dao.DataAccessException; |
---|
9 |
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; |
---|
10 |
import org.springframework.samples.kyuriboard.dao.UserDao; |
---|
11 |
import org.springframework.samples.kyuriboard.domain.User; |
---|
12 |
|
---|
13 |
/** |
---|
14 |
* @author DAMI(archy712@naver.com) |
---|
15 |
* |
---|
16 |
*/ |
---|
17 |
public class SqlMapUserDao extends SqlMapClientDaoSupport implements UserDao { |
---|
18 |
|
---|
19 |
/* (non-Javadoc) |
---|
20 |
* @see org.springframework.samples.kyuriboard.dao.UserDao#getUserByUserId(java.lang.String) |
---|
21 |
*/ |
---|
22 |
public User getUserByUserId(String userId) throws DataAccessException { |
---|
23 |
// TODO Auto-generated method stub |
---|
24 |
return (User) getSqlMapClientTemplate().queryForObject("getUserByUserId", userId); |
---|
25 |
} |
---|
26 |
|
---|
27 |
/* (non-Javadoc) |
---|
28 |
* @see org.springframework.samples.kyuriboard.dao.UserDao#getUserByUserIdAndPasswd(java.lang.String, java.lang.String) |
---|
29 |
*/ |
---|
30 |
public User getUserByUserIdAndPasswd(String userId, String passwd) |
---|
31 |
throws DataAccessException { |
---|
32 |
// TODO Auto-generated method stub |
---|
33 |
User user = new User(); |
---|
34 |
user.setUserId(userId); |
---|
35 |
user.setPasswd(passwd); |
---|
36 |
return (User) getSqlMapClientTemplate().queryForObject("getUserByUserIdAndPasswd", user); |
---|
37 |
} |
---|
38 |
|
---|
39 |
/* (non-Javadoc) |
---|
40 |
* @see org.springframework.samples.kyuriboard.dao.UserDao#getUserList() |
---|
41 |
*/ |
---|
42 |
public List getUserList() throws DataAccessException { |
---|
43 |
// TODO Auto-generated method stub |
---|
44 |
return getSqlMapClientTemplate().queryForList("getUserList", null); |
---|
45 |
} |
---|
46 |
|
---|
47 |
/* (non-Javadoc) |
---|
48 |
* @see org.springframework.samples.kyuriboard.dao.UserDao#insertUser(org.springframework.samples.kyuriboard.domain.User) |
---|
49 |
*/ |
---|
50 |
public void insertUser(User user) throws DataAccessException { |
---|
51 |
// TODO Auto-generated method stub |
---|
52 |
getSqlMapClientTemplate().insert("insertUser", user); |
---|
53 |
} |
---|
54 |
|
---|
55 |
/* (non-Javadoc) |
---|
56 |
* @see org.springframework.samples.kyuriboard.dao.UserDao#updateUser(org.springframework.samples.kyuriboard.domain.User) |
---|
57 |
*/ |
---|
58 |
public void updateUser(User user) throws DataAccessException { |
---|
59 |
// TODO Auto-generated method stub |
---|
60 |
getSqlMapClientTemplate().update("updateUser", user); |
---|
61 |
} |
---|
62 |
|
---|
63 |
} |
---|