jsp

이전 글에 믿에 selectMember()를 매번 만드는게 아니라 MemberController라는 클래스를 만들어 호출해서 사용하도록 하였다.

package sample.web;

import java.io.IOException;

import java.io.Reader;

import java.sql.SQLException;

import java.util.List;

import com.ibatis.common.resources.Resources;

import com.ibatis.sqlmap.client.SqlMapClient;

import com.ibatis.sqlmap.client.SqlMapClientBuilder;

import sample.dao.MemberDAO;

public class MemberController {

public List selecMember() throws IOException, SQLException {

SqlMapClient sqlMapClient = null;

Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");

sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);

reader.close();

MemberDAO dao = new MemberDAO();

List list = (List) dao.getListMember(sqlMapClient);

return list;

}

public List datailMember(String id) throws IOException, SQLException {

SqlMapClient sqlMapClient = null;

Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");

sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);

reader.close();

MemberDAO dao = new MemberDAO();

List list = (List) dao.getDetailMember(sqlMapClient, id);

return list;

}

}