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 ArrayListselect(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; } }
DBConnection.java
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; } }
MemberList.jsp
<%@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()); } %>파일 다운로드 ::
'Programing > JSP' 카테고리의 다른 글
JSP EL태그 안될때 (0) | 2010.01.20 |
---|---|
ibatis 설정 (0) | 2010.01.14 |
Struts 설정 (0) | 2009.12.21 |
Java JSP 설정 (0) | 2009.11.28 |