Sign up Form
member_join.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>Sign up</title>
<link rel="stylesheet" type="text/css" href="./css/admin.css" />
<link rel="stylesheet" type="text/css" href="./css/member.css" />
<script src="./js/jquery.js"></script>
<script src="./js/member.js"></script>
</head>
<body>
<div id="join_wrap">
<h2 class="join_title">Sign up</h2>
<form name="f" method="post" action="member_join_ok.nhn"
onsubmit="return check()" enctype="multipart/form-data">
<table id="join_t">
<tr>
<th>ID</th>
<td>
<input name="join_id" id="join_id" size="14" class="input_box" />
<input type="button" value="Check your ID" class="input_button"
onclick="id_check()" />
<div id="idcheck"></div>
</td>
</tr>
<tr>
<th>Password</th>
<td>
<input type="password" name="join_pwd1" id="join_pwd1" size="14"
class="input_box" />
</td>
</tr>
<tr>
<th>Password</th>
<td>
<input type="password" name="join_pwd2" id="join_pwd2" size="14"
class="input_box" />
</td>
</tr>
<tr>
<th>Name</th>
<td>
<input name="join_name" id="join_name" size="14" class="input_box" />
</td>
</tr>
<tr>
<th>Post code</th>
<td>
<input name="join_zip1" id="join_zip1" size="3" class="input_box"
readonly onclick="post_search()" />-<input name="join_zip2"
id="join_zip2" size="3" class="input_box" readonly
onclick="post_search()"/>
<input type="button" value="Search" class="input_button"
onclick="post_check()" />
</td>
</tr>
<tr>
<th>Address1</th>
<td>
<input name="join_addr1" id="join_addr1" size="50" class="input_box"
readonly onclick="post_search()" />
</td>
</tr>
<tr>
<th>Address2</th>
<td>
<input name="join_addr2" id="join_addr2" size="37" class="input_box" />
</td>
</tr>
<tr>
<th>Telephone</th>
<td>
<%@ include file="../../jsp/include/tel_number.jsp"%>
<select name="join_tel1" >
<c:forEach var="t" items="${tel}" begin="0" end="16">
<option value="${t}">${t}</option>
</c:forEach>
</select>-<input name="join_tel2" id="join_tel2" size="4"
maxlength="4" class="input_box" />-<input name="join_tel3"
id="join_tel3" size="4" maxlength="4" class="input_box" />
</td>
</tr>
<tr>
<th>Mobile</th>
<td>
<%@ include file="../../jsp/include/phone_number.jsp" %>
<select name="join_phone1">
<c:forEach var="p" items="${phone}" begin="0" end="5">
<option value="${p}">${p}</option>
</c:forEach>
</select>-<input name="join_phone2" id="join_phone2" size="4"
maxlength="4" class="input_box" />-<input name="join_phone3"
id="join_phone3" size="4" maxlength="4" class="input_box" />
</td>
</tr>
<tr>
<th>Email</th>
<td>
<input name="join_mailid" id="join_mailid" size="10"
class="input_box" />@<input name="join_maildomain"
id="join_maildomain" size="20" class="input_box" readonly />
<select name="mail_list" onchange="domain_list()">
<option value="">=Select=</option>
<option value="daum.net">daum.net</option>
<option value="nate.com">nate.com</option>
<option value="naver.com">naver.com</option>
<option value="hotmail.com">hotmail.com</option>
<option value="gmail.com">gmail.com</option>
<option value="0">Other</option>
</select>
</td>
</tr>
<tr>
<th>Profile picture</th>
<td>
<input type="file" name="join_profile" />
</td>
</tr>
</table>
<div id="join_menu">
<input type="submit" value="Join" class="input_button" />
<input type="reset" value="Cancel" class="input_button"
onclick="$('#join_id').focus();" />
</div>
</form>
</div>
</body>
</html>
DAO
// DAO(Data Access Object)
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class MemberDAOImpl {
Connection con=null;
PreparedStatement pstmt=null;
Statement stmt=null;
ResultSet rs=null;
DataSource ds=null;
String sql=null;
public int checkMemberId(String id){
int re=-1; // Available ID
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:xe";
try{
//
// con=ds.getConnection();
Class.forName(driver);//JDBC Driver Loading
con = DriverManager.getConnection(url, "scott", "tiger");
sql="select join_code from join_member where join_id=?";
pstmt=con.prepareStatement(sql);
pstmt.setString(1,id);
rs=pstmt.executeQuery();
if(rs.next()){
re=1; // Occupied ID
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(rs != null) rs.close();
if(pstmt != null) pstmt.close();
if(con != null) con.close();
}catch(Exception e){
e.printStackTrace();
}
}
return re;
}
member.js
function check(){
if($.trim($("#join_id").val())==""){
alert("Insert your ID");
$("#join_id").val("").focus();
return false;
}
if($.trim($("#join_pwd1").val())==""){
alert("Insert your password");
$("#join_pwd1").val("").focus();
return false;
}
if($.trim($("#join_pwd2").val())==""){
alert("Insert your password(again)");
$("#join_pwd2").val("").focus();
return false;
}
if($.trim($("#join_pwd1").val()) != $.trim($("#join_pwd2").val())){
alert("Please double-check your password");
$("#join_pwd1").val("");
$("#join_pwd2").val("");
$("#join_pwd1").focus();
return false;
}
if($.trim($("#join_name").val())==""){
alert("Insert your name");
$("#join_name").val("").focus();
return false;
}
if($.trim($("#join_zip1").val())==""){
alert("Insert your post code1");
$("#join_zip1").val("").focus();
return false;
}
if($.trim($("#join_zip2").val())==""){
alert("Insert your post code2");
$("#join_zip2").val("").focus();
return false;
}
if($.trim($("#join_addr1").val())==""){
alert("Insert your address1");
$("#join_addr1").val("").focus();
return false;
}
if($.trim($("#join_addr2").val())==""){
alert("Insert your address2");
$("#join_addr2").val("").focus();
return false;
}
if($.trim($("#join_tel2").val())==""){
alert("Insert your telephone number");
$("#join_tel2").val("").focus();
return false;
}
if($.trim($("#join_tel3").val())==""){
alert("Insert your mobile number1");
$("#join_tel3").val("").focus();
return false;
}
if($.trim($("#join_phone2").val())==""){
alert("Insert your mobile number2");
$("#join_phone2").val("").focus();
return false;
}
if($.trim($("#join_phone3").val())==""){
alert("Insert your mobile number3");
$("#join_phone3").val("").focus();
return false;
}
if($.trim($("#join_mailid").val())==""){
alert("Insert your email ID");
$("#join_mailid").val("").focus();
return false;
}
if($.trim($("#join_maildomain").val())==""){
alert("Insert the domain of your email");
$("#join_maildomain").val("").focus();
return false;
}
}
function post_search(){
alert("Click the search button");
}
function post_check(){
window.open("zipcode_find.nhn","Search",
"width=420,height=200,scrollbars=yes");
}
function id_check(){
$("#idcheck").hide();
var memid=$("#join_id").val();
if($.trim($("#join_id").val()).length < 4){
var newtext='<font color="red">Your ID must be at least 4 characters.</font>';
$("#idcheck").text('');
$("#idcheck").show();
$("#idcheck").append(newtext);
$("#join_id").val("").focus();
return false;
};
if($.trim($("#join_id").val()).length >12){
var newtext='<font color="red">Your ID must be less than 12 characters </font>';
$("#idcheck").text('');
$("#idcheck").show();
$("#idcheck").append(newtext);
$("#join_id").val("").focus();
return false;
};
if(!(validate_userid(memid))){
var newtext='<font color="red">Your ID must include lower case English and numbers</font>';
$("#idcheck").text('');
$("#idcheck").show();
$("#idcheck").append(newtext);
$("#join_id").val("").focus();
return false;
};
$.ajax({
type:"POST",
url:"member_idcheck.jsp",
data: {"memid":memid},
success: function (data) {
alert(data);
if(data==1){
var newtext='<font color="red">The ID already exists</font>';
$("#idcheck").text('');
$("#idcheck").show();
$("#idcheck").append(newtext);
$("#join_id").val('').focus();
return false;
}else{
var newtext='<font color="blue">Available ID</font>';
$("#idcheck").text('');
$("#idcheck").show();
$("#idcheck").append(newtext);
$("#join_pwd1").focus();
}
}
,
error:function(e){
alert("data error"+e);
}
}); //$.ajax() end
};
function validate_userid(memid){
var pattern= new RegExp(/^[a-z0-9_]+$/);
return pattern.test(memid);
};
function domain_list() {
var num=f.mail_list.selectedIndex;
if ( num == -1 ) {
return true;
}
if(f.mail_list.value=="0")
{
f.join_maildomain.value="";
f.join_maildomain.readOnly=false;
f.join_maildomain.focus();
}
else {
f.join_maildomain.value=f.mail_list.options[num].value;
f.join_maildomain.readOnly=true;
}
}
Output
'Codes & Projects' 카테고리의 다른 글
HTML / Javascript / JSP ) Sign up Form2 (0) | 2022.08.28 |
---|---|
HTML / Javascript /JSP ) Bulletin Board (0) | 2022.08.28 |
Javascript/ JSP/ HTML ) Log in form (0) | 2022.08.27 |
Java) Finding Maximum value (0) | 2022.08.25 |
Java) Math.random() (0) | 2022.08.25 |