<03_addMemberForm.jsp>
<%@ 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>
<form method="post" action="03_addMember_jsp.jsp">
<table>
<tr>
<td>이름</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>아이디</td>
<td><input type="text" name="userid"></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type="password" name="pwd"></td>
</tr>
<tr>
<td>이메일</td>
<td><input type="text" name="email"></td>
</tr>
<tr>
<td>전화번호</td>
<td><input type="text" name="phone"></td>
</tr>
<tr colspan="2">
<td><input type="radio" name="admin" value="1">관리자<input type="radio" name="admin" value="0">일반회원</td>
</tr>
<tr colspan="2">
<td><input type="submit" value="전송"><input type="reset" value="취소"></td>
</tr>
</table>
</form>
</body>
</html>
03_addMember_jsp.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%!
Connection conn = null;
PreparedStatement pstmt = null;
String url = "jdbc:oracle:thin:@localhost:1521:XE";
String uid = "ora_user";
String pass = "ora123";
String sql = "insert into member values(?, ?, ?, ?, ?, ?)";
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%request.setCharacterEncoding("UTF-8");
String name = request.getParameter("name");
String userid = request.getParameter("userid");
String pwd = request.getParameter("pwd");
String email = request.getParameter("email");
String phone = request.getParameter("phone");
int admin = Integer.parseInt(request.getParameter("admin"));
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url, uid, pass);
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, userid);
pstmt.setString(3, pwd);
pstmt.setString(4, email);
pstmt.setString(5, phone);
pstmt.setInt(6, admin);
pstmt.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(pstmt != null){pstmt.close();}
if(conn != null){conn.close();}
}catch(Exception e){
e.printStackTrace();
}
}
%>
<h3>회원 가입 성공</h3>
<a href="03_allMember.jsp">회원 목록 보기</a>
</body>
</html>
<03_allMember.jsp>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.Statement"%>
<%@ page import="java.sql.ResultSet"%>
<%!// 변수 선언
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String uid = "ora_user";
String pwd = "ora123";
String url = "jdbc:oracle:thin:@localhost:1521:XE";
String sql = "select * from member";%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
try {
// 데이터베이스를 접속하기 위한 드라이버 SW 로드
Class.forName("oracle.jdbc.driver.OracleDriver");
// 데이터베이스에 연결하는 작업 수행
conn = DriverManager.getConnection(url, uid, pwd);
// 쿼리를 생성gkf 객체 생성
stmt = conn.createStatement();
// 쿼리 생성
rs = stmt.executeQuery(sql);
%>
<table border="1">
<tr>
<td>이름</td>
<td>아이디</td>
<td>암호</td>
<td>이메일</td>
<td>전화번호</td>
<td>권한(1 : 관리자, 0 : 일반회원)</td>
</tr>
<%
while (rs.next()) {
%>
<tr>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("userid")%></td>
<td><%=rs.getString("pwd")%></td>
<td><%=rs.getString("email")%></td>
<td><%=rs.getString("phone")%></td>
<td><%=rs.getInt("admin")%></td>
</tr>
<%
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
%>
</table>
</body>
</html>
728x90
반응형
'JSP, Servlet > JSP, Oracle 기초' 카테고리의 다른 글
| [JSP] DBCP 소개 (0) | 2020.08.18 |
|---|---|
| [JSP] 상품정보 입력 후 출력(fmt태그 사용) (0) | 2020.08.18 |
| [JSP] 사원정보 입력 후 테이블 형태로 출력 (0) | 2020.08.18 |
| [JSP] 오라클 DB에 데이터 저장하기 (0) | 2020.08.14 |
| [JSP] 오라클 DB에 저장되어있는 데이터 불러오기 (0) | 2020.08.14 |
