시소당
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통