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

SampleDAO.java

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import util.DBConnection;
import vo.MemberVO;

public class SampleDAO {
	static Connection con;
	static {
		con = DBConnection.getConnection();
	}

	public static ArrayList select(String id) {
		PreparedStatement pstmt = null;
		StringBuffer sql = new StringBuffer();
		ArrayList list = new ArrayList();
		sql.append("select * from loveinblind where id=?");
		ResultSet rs = null;
		try {
			pstmt = con.prepareStatement(sql.toString());
			pstmt.setString(1, id);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				MemberVO vo = new MemberVO();
				vo.setNo(rs.getInt("no"));
				vo.setId(rs.getString("id"));
				vo.setPw(rs.getString("pw"));
				vo.setName(rs.getString("name"));
				list.add(vo);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (pstmt != null) {
				try {
					pstmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if (con != null) {
				try {
					con.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}

		return list;
	}
}

package util;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {
	static Connection con;

	static {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}

	public static Connection getConnection() {

		try {
			con = DriverManager.getConnection(
					"jdbc:oracle:thin:@211.63.89.52:1521:orcl", 
					"scott",
					"tiger");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return con;
	}
}

<%@page import="java.util.List"%>
<%@page import="dao.SampleDAO"%>
<%@page import="vo.MemberVO"%	List list = SampleDAO.select("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());
	}
%>

jdbc.war

Struts 다운로드

 struts-1.3.10 압축해제


 struts-1.3.10\apps\struts-blank-1.3.10\WEB-INF\lib => 프로젝트 WEB-INF\lib로 이동

 struts-1.3.10\apps\struts-blank-1.3.10\WEB-INF => 프로젝트 WEB-INF로 이동