Loveinblind Story

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