join.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>회원가입</title>
</head>
<body>
<center>
<hr width = 500 size=2 color="blue">
<h2>회원 가입</h2>
<hr width = 500 size=2 color="blue">
<form action="JoinOK" method="post">
이름 : <input type="text" name="name" size="20"><br />
아이디 :<input type="text" name="id" size="20"><br />
비밀번호 :<input type="password" name="pw" size="20"><br/>
전화번호 :<select name = "hp">
<option value="010">010</option>
<option value="016">016</option>
<option value="017">017</option>
<option value="018">018</option>
<option value="019">019</option>
</select>
<input type="text" name="hp2" size="4">-<input type="text" name="hp3" size=4><br/>
성별 : <input type="radio" name="gender" value="man">남 <input type="radio" name="gender" value="woman">여<br/>
<input type="submit" value="회원가입"> <input type="reset" value="취소">
</form>
</center>
</body>
</html>
-----------------------------------------------------------------------------------------------------------
JoinOK.java
package com.test.ex;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class JoinOK
*/
@WebServlet("/JoinOK")
public class JoinOK extends HttpServlet {
private static final long serialVersionUID = 1L;
private Connection dbconn;
private PreparedStatement pstmt;
private String name, id, pw, hp, hp2, hp3, gender;
/**
* @see HttpServlet#HttpServlet()
*/
public JoinOK() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
System.out.println("doGet");
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
System.out.println("doPost");
registerMember(request, response);
}
private void registerMember(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
name=request.getParameter("name");
id=request.getParameter("id");
pw=request.getParameter("pw");
hp=request.getParameter("hp");
hp2=request.getParameter("hp2");
hp3=request.getParameter("hp3");
gender=request.getParameter("gender");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
dbconn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "scott", "1234");
String sql="insert into member values(?,?,?,?,?,?,?)";
pstmt=dbconn.prepareStatement(sql);
pstmt.setString(1,name);
pstmt.setString(2,id);
pstmt.setString(3,pw);
pstmt.setString(4, hp);
pstmt.setString(5, hp2);
pstmt.setString(6, hp3);
pstmt.setString(7, gender);
int n = pstmt.executeUpdate();
if( n > 0){
System.out.println("가입 성공");
response.sendRedirect("joinRes.jsp");
}else{
System.out.println("가입 실패!!");
response.sendRedirect("join.html");
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(pstmt !=null) pstmt.close();
if(dbconn !=null) dbconn.close();
}catch(Exception e){}
}
} //registerMember
}
-------------------------------------------------------------------------------------
joinRes.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
가입성공<br/>
<a href="login.jsp">로그인</a>
</body>
</html>
---------------------------------------------------------------------------
테이블 구조
CREATE TABLE MEMBER
(
NAME VARCHAR2(20 BYTE) NOT NULL
, ID VARCHAR2(20 BYTE) NOT NULL
, PW VARCHAR2(20 BYTE) NOT NULL
, HP VARCHAR2(3 BYTE) NOT NULL
, HP2 VARCHAR2(4 BYTE) NOT NULL
, HP3 VARCHAR2(4 BYTE) NOT NULL
, GENDER VARCHAR2(10 BYTE) NOT NULL
)
'기존카테고리 > JSP' 카테고리의 다른 글
| 회원정보 수정 및 로그아웃 (0) | 2017.06.07 |
|---|---|
| 로그인 입력, 처리페이지 (0) | 2017.06.07 |
| [회원가입1]join.html, joinOK.java (0) | 2017.06.06 |
| 웹어플리케이션을 감시하는 리스너 ServletContextListener(contextInitialized(), contextDestroy()) (0) | 2017.06.06 |
| ServletContext를 이용한 데이터 공유 (0) | 2017.06.06 |