oracle data를 eclipse에서 작동시키기
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>oracle-eclipse</title>
</head>
<body>
<%!
Connection conn;
Statement stmt;
ResultSet rs;
%>
<%
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","orauser","1111");
stmt=conn.createStatement();
String query="select employee_id,emp_name,department_id,salary from employees where salary>=6000 order by employee_id";
//oracle에서 실행시킬 query문 적기
//대신 query문 안에서 ';'는 빼기
rs=stmt.executeQuery(query);
while(rs.next()){
//desc.table_name을 통해
//각 field의 type을 확인 후
//type에 맞게 변수를 만들어 줌
String id=rs.getString("employee_id");
String name=rs.getString("emp_name");
int departmentId=rs.getInt("department_id");
int salary=rs.getInt("salary");
out.println("아이디:"+id);
out.println("이름:"+name);
out.println("월급:"+salary);
out.println("부서번호:"+departmentId);
out.println("<br>");
}
}catch(Exception e){e.printStackTrace();
}finally{
try{ //선언해준 순서 반대로 닫아주기
if(rs!=null) rs.close();
if(stmt!=null)stmt.close();
if(conn!=null)conn.close();
}catch(Exception e2){
e2.printStackTrace();
}
}
%>
</body>
</html>
다양한 타입을 테이블에 넣어보기
<%@page import="java.sql.Date"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ 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>
<style>
table,td,th{border:1px solid black; border-collapse:collapse;}
</style>
</head>
<body>
<%!
Connection conn;
Statement stmt;
ResultSet rs;
%>
<table>
<tr>
<th>no</th>
<th>title</th>
<th>content</th>
<th>userid</th>
<th>date</th>
<th>hit</th>
<tr>
<%
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","orauser","1111");
stmt=conn.createStatement();
String query="select no,title,content,userid,bdate,hit from board";
rs=stmt.executeQuery(query);
while(rs.next()){
String title=rs.getString("title");
String content=rs.getString("content");
String userid=rs.getString("userid");
Date date=rs.getDate("bdate");
// date는 date타입으로 선언하고
// getDate로 가져온다.
int no=rs.getInt("no");
int hit=rs.getInt("hit");
%>
<tr>
<td><%=no %></td>
<td><%=title %></td>
<td><%=content %></td>
<td><%=userid %></td>
<td><%=date %></td>
<td><%=hit %></td>
</tr>
<% } %>
</table>
<%} catch(Exception e){e.printStackTrace();
}finally{
try{
if(rs!=null) rs.close();
if(stmt!=null)stmt.close();
if(conn!=null)conn.close();
}catch(Exception e2){
e2.printStackTrace();
}
}
%>
</body>
</html>
가끔져요