<%@ 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 message"; 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("content") %>