Loveinblind Story

	
	
	 SELECT * from loveinblind where id = #value#

package dao;

import java.io.IOException;
import java.io.Reader;
import java.util.List;
import vo.MemberVO;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class SampleDAO {

	private static SqlMapClient sqlMapper;
	static {
		try {
			Reader reader = Resources
					.getResourceAsReader("dao/MemberConfig.xml");
			sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
			reader.close();
		} catch (IOException e) {
			throw new RuntimeException(
					"Something bad happened while building the SqlMapClient instance."
							+ e, e);
		}
	}
	
	public static List searchAll(String id) throws Exception{
		List list = sqlMapper.queryForList("selectAll",id);
		return list;
	}
	

}

<%@page import="java.util.List"%>
<%@page import="dao.SampleDAO"%>
<%@page import="vo.MemberVO"%>



<%
	List list = SampleDAO.searchAll("a");
	out.println(list.size());
	for (int i = 0; i < list.size(); i++) {
		MemberVO vo = (MemberVO) list.get(i);
		out.println("id");
		out.println(vo.getId());
		out.println(vo.getPw());
		out.println(vo.getName());
		out.println(vo.getNo());
	}
%>

ibatis.war