오라클: ojdbc14.jar
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","아이디","패스워드");
String passwd=request.getParameter("passwd");
String name=request.getParameter("name");
Timestamp register=new Timestamp(System.currentTimeMillis());
Connection conn=null;
PreparedStatement pstmt=null;
try{
//오라클 연결정보
String jdbcUrl="jdbc:oracle:thin:@localhost:1521:ORCL";
String dbId="scott";
String dbPass="tiger";
//오라클 드라이버 로드
Class.forName("oracle.jdbc.driver.OracleDriver");
//오라클 연결
conn=DriverManager.getConnection(jdbcUrl,dbId,dbPass);
out.println("연결완료");
//쿼리문 실행
String sql="insert into member1 values(?,?,?,?)";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,id);
pstmt.setString(2,passwd);
pstmt.setString(3,name);
pstmt.setTimestamp(4,register);
pstmt.executeUpdate();
out.println("레코드 추가 완료");
}
//예외처리
catch(Exception e){
e.printStackTrace();
}
//객체닫기
finally{
if(pstmt != null) try{pstmt.close();}catch(SQLException sqle){}
if(conn != null) try{conn.close();}catch(SQLException sqle){}
}
%>
----------------------------------------------------------------------------
<%@ page contentType="text/html;charset=euc-kr" %>
<%@ page import="java.sql.*" %>
<% request.setCharacterEncoding("euc-kr"); %>
<html>
<head>
<title>select 예제</title>
</head>
<body>
<h2>member1의 테이블의 레코드 표시</h2>
<table width="550" border="1">
<tr>
<td width="100">아이디</td>
<td width="100">패스워드</td>
<td width="100">이름</td>
<td width="250">가입일자</td>
</tr>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
//오라클 연결정보
String jdbcUrl="jdbc:oracle:thin:@localhost:1521:ORCL";
String dbId="scott";
String dbPass="tiger";
//오라클 드라이버 로드
Class.forName("oracle.jdbc.driver.OracleDriver");
//오라클 연결
conn=DriverManager.getConnection(jdbcUrl,dbId,dbPass);
out.println("연결완료");
//쿼리문 실행
String sql="select * from member1";
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
String id=rs.getString("id");
String passwd=rs.getString("passwd");
String name=rs.getString("name");
Timestamp register=rs.getTimestamp("reg_date");
%>
<tr>
<td width="100"><%=id%></td>
<td width="100"><%=passwd%></td>
<td width="100"><%=name%></td>
<td width="250"><%=register.toString()%></td>
</tr>
<% }
}
//예외처리
catch(Exception e){
e.printStackTrace();
}
//객체닫기
finally{
if(rs != null) try{rs.close();}catch(SQLException sqle){}
if(stmt != null) try{stmt.close();}catch(SQLException sqle){}
if(conn != null) try{conn.close();}catch(SQLException sqle){}
}
%>
</table>
</body>
</html>
'C Jsp' 카테고리의 다른 글
| JSP 스크립트 요소 (0) | 2017.07.02 |
|---|---|
| 톰캣 설정 (0) | 2017.07.02 |
| 자바스크립트 - 숫자체크하는 스크립트 (0) | 2017.07.02 |
| 팝업 window.open 사용하기 (0) | 2017.07.02 |
| javascript 에서 replaceAll 구현하는 방법 (0) | 2017.07.02 |
