<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.io.*"%> <%@ page import="java.sql.*"%> Message list

Main Menu로 이동

테이블에 있는 전체 데이터 출력

<% try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:xe", "HR", "1234"); if (conn == null) {System.out.println("DB접속에 실패");} else {System.out.println("DB접속 성공");} String sql = "select * from phonebook"; PreparedStatement pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { %> <%}// while문 end rs.close(); pstmt.close(); conn.close(); } // try end catch(Exception e){} finally{} %>
번호이름전화번호메모
<%=rs.getInt("no") %> <%=rs.getNString("name") %> <%=rs.getNString("phonenum") %> <%=rs.getNString("memo") %>