DB접속
MemberConfig.xml
Member.xml
SampleDAO.java
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{ ListMemberList.jsplist = 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()); } %>
'Programing > JSP' 카테고리의 다른 글
JSP EL태그 안될때 (0) | 2010.01.20 |
---|---|
JDBC DB설정 (0) | 2010.01.14 |
Struts 설정 (0) | 2009.12.21 |
Java JSP 설정 (0) | 2009.11.28 |