728x90
반응형
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%-- src/main/webapp/jdbc/jdbc1.jsp --%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
//드라이버 클래스 설정
Class.forName("oracle.jdbc.driver.OracleDriver");
//Connection 객체 생성.
//Connection 객체 : db와 연결된 객체.
//localhost : ip 주소값. 현재 컴퓨터의 ip주소값.
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","kic","1234");
out.println("오라클 접속 성공");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * From emp");
%>
<table>
<tr>
<td>사번</td>
<td>이름</td>
<td>직무</td>
</tr>
<% while(rs.next()) {%>
<tr>
<td><%=rs.getString("empno") %></td>
<td><%=rs.getString("ename") %></td>
<td><%=rs.getString("job") %></td>
</tr>
<% } %>
</table>
</body>
</html>/* src/main/webapp/main.css */
table { width : 100%; border-collapse: collapse; }
th,td {
border : 3px solid #bcbcbc;
text-align: center;
padding: 8px;
}
th { background-color: #B7F0B1; color : #353535; }
td { background-color: #F2F2F2;}
caption { color : #111111; font-size: 20px;
background-color: #FFFFFF; }
input[type=text],input[type=password],textarea {
width:100%;
}<%@page import="java.sql.ResultSetMetaData"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%-- src/main/webapp/jdbc/jdbc2.jsp --%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>emp 테이블 읽기</title>
<link rel="stylesheet" href="../css/main.css">
</head>
<body>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","kic","1234");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * From emp");
ResultSetMetaData rsmt = rs.getMetaData(); //ResultSetMetaData : 결과 정보 저장
%>
<table>
<tr>
<%
//rsmt.getColumncount() : 조회된 컬럼의 갯수
//getColumnName(i) : i번째 컬럼의 이름
for(int i=1; i<rsmt.getColumnCount(); i++) {
%>
<th> <%=rsmt.getColumnName(i) %> </th>
<% } %>
</tr>
<% while(rs.next()) { %>
<tr>
<%
for(int i=1; i<rsmt.getColumnCount(); i++) {
%>
<th> <%=rs.getString(i) %> </th>
<% } %>
<% } %>
</tr>
</table>
</body>
</html>728x90
반응형