1. Oracle 설치
Oracle 환경 구축
1. ORACLE 11g XE Download oracle 11g XE 2. HR계정 활성화 시작 > Oracle Database 11g Express Edition > Run SQL Command Line 3. SQL Developer Download oracle SQL Developer 4. DB연결
negno.tistory.com
2. Eclipse Oracle DB연동
3. 연동 확인
3-1. JSP파일 생성
3-2. DB연결 코드 입력
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="oracle.jdbc.driver.OracleDriver"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>Hello World</h1>
<table border="1">
<tr>
<th>사번</th>
<th>first_name</th>
<th>last_name</th>
</tr>
<%
// 클래스 로드
Class.forName("oracle.jdbc.driver.OracleDriver");
// connection 취득
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/xe", "hr", "hr");
out.print(conn);
// 문장 생성
PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM EMPLOYEES ORDER BY EMPLOYEE_ID");
// 결과집합 생성
ResultSet rs = pstmt.executeQuery();
// 결과집합 순환 후 적절히 가공
while(rs.next()) {
%>
<tr>
<td><%=rs.getInt("EMPLOYEE_ID")%></td>
<td><%=rs.getString("FIRST_NAME")%></td>
<td><%=rs.getString("LAST_NAME")%></td>
</tr>
<%
}
%>
</table>
</body>
</html>3-3. 실행 결과
4. Maven Project OJDBC 연동
4-1.MVNREPOSITORY
Maven Repository: Search/Browse/Explore
H2O Persist HDFS Last Release on Jul 11, 2022
mvnrepository.com
CTRL + C
pom.xml <dependencies> 안에 CTRL + V
4-1. DB연결 코드 입력
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="oracle.jdbc.driver.OracleDriver"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>Hello World</h1>
<table border="1">
<tr>
<th>사번</th>
<th>first_name</th>
<th>last_name</th>
</tr>
<%
// 클래스 로드
Class.forName("oracle.jdbc.driver.OracleDriver");
// connection 취득
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/xe", "hr", "hr");
out.print(conn);
// 문장 생성
PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM EMPLOYEES ORDER BY EMPLOYEE_ID");
// 결과집합 생성
ResultSet rs = pstmt.executeQuery();
// 결과집합 순환 후 적절히 가공
while(rs.next()) {
%>
<tr>
<td><%=rs.getInt("EMPLOYEE_ID")%></td>
<td><%=rs.getString("FIRST_NAME")%></td>
<td><%=rs.getString("LAST_NAME")%></td>
</tr>
<%
}
%>
</table>
</body>
</html>
'BACK-END > JSP Servlet' 카테고리의 다른 글
| [MessageSystem] Main.jsp (0) | 2022.07.15 |
|---|---|
| Eclipse MyBatis 설정 (0) | 2022.07.13 |
| Eclipse Lombok 설정 (0) | 2022.07.13 |
| Eclipse MAVEN Setting (0) | 2022.07.12 |
| Eclipse Tomcat9 Setting (0) | 2022.07.12 |