SSISO Community

시소당

iBatis 예제입니다. (2)실행파일작성

1. ///////////// SqlMapClientManager  ///////////////////

import java.io.Reader;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
/**
*
* @author Administrator
*
*/
public class SqlMapClientManager {
        
        private static final SqlMapClient sqlMap;

        static {
                try {
                        String resource = "src/SqlMapClientManager.xml";
                        Reader reader = Resources.getResourceAsReader(resource);
                        sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
                        
                } catch (Exception e) {
                        e.printStackTrace();
                        throw new RuntimeException(e);
                }
        }
        
        private SqlMapClientManager(){}
        
        public static SqlMapClient getSqlMapClient() {
                return sqlMap;  //자신을 리턴하지 않고 sqlMap을 리턴, 변형된 싱글턴 패턴
        }

}

2. /////////////  BlogUser  //////////////////

import java.io.Serializable;

public class BlogUser implements Serializable {

          private String userID;
          private String userName;
          private String role;
          private String password;
          
        public String getPassword() {
                return password;
        }
        public void setPassword(String password) {
                this.password = password;
        }
        public String getRole() {
                return role;
        }
        public void setRole(String role) {
                this.role = role;
        }
        public String getUserID() {
                return userID;
        }
        public void setUserID(String userID) {
                this.userID = userID;
        }
        public String getUserName() {
                return userName;
        }
        public void setUserName(String userName) {
                this.userName = userName;
        }                  
          
          
}

3. //////////// 실행파일 ////////////////////////////

import java.util.Iterator;
import java.util.List;

import com.ibatis.sqlmap.client.SqlMapClient;

public class IBatisTest {
        
        private static SqlMapClient sqlMap = SqlMapClientManager.getSqlMapClient();
        
        public static void main(String args[]){
                
                try{
                        
                        System.out.println("------------------------------");
                        System.out.println("initial");
                        System.out.println("------------------------------");
                        
                        BlogUser paramBlogUser = new BlogUser();
                        BlogUser returnBlogUser = new BlogUser();
                        
                        List list = sqlMap.queryForList("BlogUser.getBlogUserAll", paramBlogUser);
                        Iterator it = list.iterator();
                        
                        while(it.hasNext()){
                                
                                returnBlogUser = (BlogUser)it.next();
                                
                                System.out.println("UserID = " + returnBlogUser.getUserID());
                                System.out.println("UserName = " + returnBlogUser.getUserName());
                                System.out.println("Role = " + returnBlogUser.getRole());
                                
                                System.out.println("===============\n");
                        }
                        
                        // 새로운 사용자 입력
                        paramBlogUser = new BlogUser();
                        
                        paramBlogUser.setUserID("kkjae");
                        paramBlogUser.setUserName("김길재");
                        paramBlogUser.setRole("user");
                        paramBlogUser.setPassword("kkjae");
                        
                        sqlMap.insert("BlogUser.regUser",paramBlogUser);
                        
                        System.out.println("------------------------------");
                        System.out.println("after insert");
                        System.out.println("------------------------------");
                        
                        list = sqlMap.queryForList("BlogUser.getBlogUserAll", paramBlogUser);
                        it = list.iterator();
                        
                        while(it.hasNext()){
                                
                                returnBlogUser = (BlogUser)it.next();
                                
                                System.out.println("UserID = " + returnBlogUser.getUserID());
                                System.out.println("UserName = " + returnBlogUser.getUserName());
                                System.out.println("Role = " + returnBlogUser.getRole());
                                
                                System.out.println("===============\n");
                                
                        }
                        
                        // 사용자 수정
                        paramBlogUser.setUserID("kkjae");
                        paramBlogUser.setUserName("김정수");
                        paramBlogUser.setRole("user");
                        paramBlogUser.setPassword("kkjae");
                        
                        sqlMap.update("BlogUser.updUser",paramBlogUser);
                        
                        System.out.println("------------------------------");
                        System.out.println("after update");
                        System.out.println("------------------------------");
                        
                        list = sqlMap.queryForList("BlogUser.getBlogUserAll", paramBlogUser);
                        it = list.iterator();
                        
                        while(it.hasNext()){
                                
                                returnBlogUser = (BlogUser)it.next();
                                
                                System.out.println("UserID = " + returnBlogUser.getUserID());
                                System.out.println("UserName = " + returnBlogUser.getUserName());
                                System.out.println("Role = " + returnBlogUser.getRole());
                                
                                System.out.println("===============\n");
                                
                        }
                        
                        // 사용자 삭제
                        sqlMap.update("BlogUser.delUser",paramBlogUser);
                        
                        System.out.println("------------------------------");
                        System.out.println("after delete");
                        System.out.println("------------------------------");
                        
                        list = sqlMap.queryForList("BlogUser.getBlogUserAll", paramBlogUser);
                        it = list.iterator();
                        
                        while(it.hasNext()){
                                
                                returnBlogUser = (BlogUser)it.next();
                                
                                System.out.println("UserID = " + returnBlogUser.getUserID());
                                System.out.println("UserName = " + returnBlogUser.getUserName());
                                System.out.println("Role = " + returnBlogUser.getRole());
                                
                                System.out.println("===============\n");
                                
                        }
                        
                }catch(Exception e){
                        e.printStackTrace();
                }
                
                
                
        }

}

출처 : Tong - 반이오타님의 JAVA Framework통

1303 view

4.0 stars