테이블
member1
번호 seq number not null primary key
아이디 id varhcar2(10) not null
이름 writer varchar2(10) not null
비번 passwd varchar2(10) not null
전화번호 phone char(13)
phone1-phone2-phone3
우편번호 zipcode char(7)
zipcode-zipcode2
주소 address1 varchar2(100)
address2 varchar2(100)
가입일 regdate date default sysdate not null
테이블 생성
create table member1(
seq number not null primary key,
id varchar2(10) not null,
writer varchar2(10) not null,
passwd varchar2(10) not null,
phone char(13),
zipcode char(7),
address1 varchar2(100),
address2 varchar2(100),
regdate date default sysdate not null
)
시퀀스 생성
create sequence mem1_seq;
index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("utf-8");
%>
<html>
<head>
<title></title>
<meta http-equiv='Content-Type' content='text/html;charset=utf-8'>
<link rel='stylesheet' type='text/css' href='./images/common.css'>
<script language='javascript'>
<!--
String.prototype.trim = function() {
return this.replace(/(^\s*)|(\s*$)/gi, "");
}
//-->
</script>
</head>
<body bgcolor='#ffffff' topmargin='5' rightmargin='0' leftmargin='5' bottommargin='10'>
<table width='1030' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2' height='23' bgcolor='#f0f0f0'></td>
</tr>
<tr>
<td colspan='2' height='10' bgcolor='#ffffff'></td>
</tr>
<tr>
<td width='280' height='500' bgcolor='#ffffff' valign='top'>
<table width='270' cellpadding='0' cellspacing='0' border='0' align='center'>
<tr>
<td class='stab_bot' style='padding:5px 5px 5px 5px'>
<form action='member_login_ok1.jsp' method='post'>
<table width='100%' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td width='60'>아 이 디</td>
<td width='120'><input type='text' name='id' size='12' maxlength='10' class='form'></td>
<td rowspan='2'><input type='submit' value='로 그 인' class='form' style='height:35px'></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type='text' name='id' size='12' maxlength='10' class='form'></td>
</tr>
<tr>
<td colspan='3' height='5'> </td>
</tr>
<tr>
<td colspan='3'>
<input type='button' value='회 원 가 입' onclick="location.href='./member/member_write1.jsp'" class='form'>
<input type='button' value='아이디찾기' class='form'>
<input type='button' value='비 번 찾 기' class='form'>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
<td bgcolor='#ffffff' valign='top'>
<table width='100%' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td class='stab_bot' colspan='3'></td>
</tr>
<tr>
<td class='stab_left'></td>
<td class='stab_mid' style='padding:5px 5px 0px 5px'>
<!-- 검색 부분 -->
<form action='board_list1.jsp' method='post'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td></td>
<td height='25' align='right'>
<select name='searchkey' class='form' align='absmiddle'>
<option value='all'>전체</option>
<option value='subject'>제목</option>
<option value='writer'>이름</option>
<option value='content'>내용</option>
</select>
<input type='text' name='searchword' size='15' align='absmiddle' class='form'>
<input type='image' src='./images/btn_search.gif' border='0' align='absmiddle'>
</td>
</tr>
</table>
</form>
<!-- -->
</td>
<td class='stab_right'></td>
</tr>
<tr>
<td class='stab_bot' colspan='3'></td>
</tr>
<tr>
<td height='10' colspan='3'></td>
</tr>
</table>
<table width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td align='center' class='gline'></td>
</tr>
<tr>
<td align='center'>
<table width='100%' border='0' cellpadding='0' cellspacing='0' class='titlecell'>
<tr height='25' align='center'>
<td width='40'>No</td>
<td>제목</td>
<td width='100'>이름</td>
<td width='80'>등록일</td>
<td width='50'> 조회수</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align='center' class='gline'></td>
</tr>
<tr>
<td height='3'></td>
</tr>
</table>
<table width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='500' height='30'> </td>
<td align='right'></td>
</tr>
</table>
</td>
</tr>
</table>
<table width='1030' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td height='15' bgcolor='#f0f0f0' style='padding:5' align='center'></td>
</tr>
</table>
</body>
</html>
member/member_write1.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("utf-8");
%>
<html>
<head>
<title></title>
<meta http-equiv='Content-Type' content='text/html;charset=utf-8'>
<link rel='stylesheet' type='text/css' href='../images/common.css'>
<script language='javascript'>
<!--
String.prototype.trim = function() {
return this.replace(/(^\s*)|(\s*$)/gi, "");
}
//-->
</script>
</head>
<body bgcolor='#ffffff' topmargin='5' rightmargin='0' leftmargin='5' bottommargin='10'>
<table width='1030' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2' height='23' bgcolor='#f0f0f0'></td>
</tr>
<tr>
<td colspan='2' height='10' bgcolor='#ffffff'></td>
</tr>
<tr>
<td width='280' height='500' bgcolor='#ffffff' valign='top'>
<table width='270' cellpadding='0' cellspacing='0' border='0' align='center'>
<tr>
<td class='stab_bot' style='padding:5px 5px 5px 5px'>
<form action='member_login_ok1.jsp' method='post'>
<table width='100%' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td width='60'>아 이 디</td>
<td width='120'><input type='text' name='id' size='12' maxlength='10' class='form'></td>
<td rowspan='2'><input type='submit' value='로 그 인' class='form' style='height:35px'></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type='text' name='id' size='12' maxlength='10' class='form'></td>
</tr>
<tr>
<td colspan='3' height='5'> </td>
</tr>
<tr>
<td colspan='3'>
<input type='button' value='회 원 가 입' onclick="location.href='./member_write1.jsp'" class='form'>
<input type='button' value='아이디찾기' class='form'>
<input type='button' value='비 번 찾 기' class='form'>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
<td bgcolor='#ffffff' valign='top'>
<form action='member_write_ok1.jsp' method='post' name='wfrm' onSubmit='return ChkForm(this)'>
<table width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>아이디</font> :
</td>
<td>
<input type='text' name='id' size='40' maxlength='10' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>이름</font> :
</td>
<td>
<input type='text' name='writer' size='40' maxlength='10' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>비밀번호 1</font> :
</td>
<td>
<input type='password' name='passwd1' size='20' maxlength='10' class='form'> /
<font class='titdot'>• </font>
<font class='title'>비밀번호 2</font> :
<input type='password' name='passwd2' size='20' maxlength='10' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>전화번호</font> :
</td>
<td>
<select name='phone1' class='form'>
<option value='010'>010</option>
<option value='011'>011</option>
<option value='017'>017</option>
<option value='018'>018</option>
<option value='019'>019</option>
</select>
-
<input type='text' name='phone2' size='15' maxlength='4' class='form'> -
<input type='text' name='phone3' size='15' maxlength='4' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>주소</font> :
</td>
<td>
<input type='text' name='zipcode1' size='3' maxlength='3' class='form'> -
<input type='text' name='zipcode2' size='3' maxlength='3' class='form'>
<input type='button' value='우편번호 찾기' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40' valign='top' align='right'></td>
<td>
<input type='text' name='address1' size='50' maxlength='100' class='form'>
<br><br>
<input type='text' name='address2' size='50' maxlength='100' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td colspan='2' class='gline'></td>
</tr>
</table>
<table width='100%' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td width='400' height='60'> </td>
<td align='left'>
<input type='button' value='회 원 가 입' class='form'>
<input type='button' value='뒤 로 가 기' class='form' onclick='history.back()'>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<table width='1030px' border='0' cellpadding='0' cellspacing='0' align='center'>
<tr>
<td height='15' bgcolor='#f0f0f0' height='40' align='center'></td>
</tr>
</table>
</body>
</html>
member1
번호 seq number not null primary key
아이디 id varhcar2(10) not null
이름 writer varchar2(10) not null
비번 passwd varchar2(10) not null
전화번호 phone char(13)
phone1-phone2-phone3
우편번호 zipcode char(7)
zipcode-zipcode2
주소 address1 varchar2(100)
address2 varchar2(100)
가입일 regdate date default sysdate not null
테이블 생성
create table member1(
seq number not null primary key,
id varchar2(10) not null,
writer varchar2(10) not null,
passwd varchar2(10) not null,
phone char(13),
zipcode char(7),
address1 varchar2(100),
address2 varchar2(100),
regdate date default sysdate not null
)
시퀀스 생성
create sequence mem1_seq;
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("utf-8");
%>
<html>
<head>
<title></title>
<meta http-equiv='Content-Type' content='text/html;charset=utf-8'>
<link rel='stylesheet' type='text/css' href='./images/common.css'>
<script language='javascript'>
<!--
String.prototype.trim = function() {
return this.replace(/(^\s*)|(\s*$)/gi, "");
}
//-->
</script>
</head>
<body bgcolor='#ffffff' topmargin='5' rightmargin='0' leftmargin='5' bottommargin='10'>
<table width='1030' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2' height='23' bgcolor='#f0f0f0'></td>
</tr>
<tr>
<td colspan='2' height='10' bgcolor='#ffffff'></td>
</tr>
<tr>
<td width='280' height='500' bgcolor='#ffffff' valign='top'>
<table width='270' cellpadding='0' cellspacing='0' border='0' align='center'>
<tr>
<td class='stab_bot' style='padding:5px 5px 5px 5px'>
<form action='member_login_ok1.jsp' method='post'>
<table width='100%' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td width='60'>아 이 디</td>
<td width='120'><input type='text' name='id' size='12' maxlength='10' class='form'></td>
<td rowspan='2'><input type='submit' value='로 그 인' class='form' style='height:35px'></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type='text' name='id' size='12' maxlength='10' class='form'></td>
</tr>
<tr>
<td colspan='3' height='5'> </td>
</tr>
<tr>
<td colspan='3'>
<input type='button' value='회 원 가 입' onclick="location.href='./member/member_write1.jsp'" class='form'>
<input type='button' value='아이디찾기' class='form'>
<input type='button' value='비 번 찾 기' class='form'>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
<td bgcolor='#ffffff' valign='top'>
<table width='100%' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td class='stab_bot' colspan='3'></td>
</tr>
<tr>
<td class='stab_left'></td>
<td class='stab_mid' style='padding:5px 5px 0px 5px'>
<!-- 검색 부분 -->
<form action='board_list1.jsp' method='post'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td></td>
<td height='25' align='right'>
<select name='searchkey' class='form' align='absmiddle'>
<option value='all'>전체</option>
<option value='subject'>제목</option>
<option value='writer'>이름</option>
<option value='content'>내용</option>
</select>
<input type='text' name='searchword' size='15' align='absmiddle' class='form'>
<input type='image' src='./images/btn_search.gif' border='0' align='absmiddle'>
</td>
</tr>
</table>
</form>
<!-- -->
</td>
<td class='stab_right'></td>
</tr>
<tr>
<td class='stab_bot' colspan='3'></td>
</tr>
<tr>
<td height='10' colspan='3'></td>
</tr>
</table>
<table width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td align='center' class='gline'></td>
</tr>
<tr>
<td align='center'>
<table width='100%' border='0' cellpadding='0' cellspacing='0' class='titlecell'>
<tr height='25' align='center'>
<td width='40'>No</td>
<td>제목</td>
<td width='100'>이름</td>
<td width='80'>등록일</td>
<td width='50'> 조회수</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align='center' class='gline'></td>
</tr>
<tr>
<td height='3'></td>
</tr>
</table>
<table width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='500' height='30'> </td>
<td align='right'></td>
</tr>
</table>
</td>
</tr>
</table>
<table width='1030' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td height='15' bgcolor='#f0f0f0' style='padding:5' align='center'></td>
</tr>
</table>
</body>
</html>
member/member_write1.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("utf-8");
%>
<html>
<head>
<title></title>
<meta http-equiv='Content-Type' content='text/html;charset=utf-8'>
<link rel='stylesheet' type='text/css' href='../images/common.css'>
<script language='javascript'>
<!--
String.prototype.trim = function() {
return this.replace(/(^\s*)|(\s*$)/gi, "");
}
//-->
</script>
</head>
<body bgcolor='#ffffff' topmargin='5' rightmargin='0' leftmargin='5' bottommargin='10'>
<table width='1030' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2' height='23' bgcolor='#f0f0f0'></td>
</tr>
<tr>
<td colspan='2' height='10' bgcolor='#ffffff'></td>
</tr>
<tr>
<td width='280' height='500' bgcolor='#ffffff' valign='top'>
<table width='270' cellpadding='0' cellspacing='0' border='0' align='center'>
<tr>
<td class='stab_bot' style='padding:5px 5px 5px 5px'>
<form action='member_login_ok1.jsp' method='post'>
<table width='100%' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td width='60'>아 이 디</td>
<td width='120'><input type='text' name='id' size='12' maxlength='10' class='form'></td>
<td rowspan='2'><input type='submit' value='로 그 인' class='form' style='height:35px'></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type='text' name='id' size='12' maxlength='10' class='form'></td>
</tr>
<tr>
<td colspan='3' height='5'> </td>
</tr>
<tr>
<td colspan='3'>
<input type='button' value='회 원 가 입' onclick="location.href='./member_write1.jsp'" class='form'>
<input type='button' value='아이디찾기' class='form'>
<input type='button' value='비 번 찾 기' class='form'>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
<td bgcolor='#ffffff' valign='top'>
<form action='member_write_ok1.jsp' method='post' name='wfrm' onSubmit='return ChkForm(this)'>
<table width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>아이디</font> :
</td>
<td>
<input type='text' name='id' size='40' maxlength='10' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>이름</font> :
</td>
<td>
<input type='text' name='writer' size='40' maxlength='10' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>비밀번호 1</font> :
</td>
<td>
<input type='password' name='passwd1' size='20' maxlength='10' class='form'> /
<font class='titdot'>• </font>
<font class='title'>비밀번호 2</font> :
<input type='password' name='passwd2' size='20' maxlength='10' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>전화번호</font> :
</td>
<td>
<select name='phone1' class='form'>
<option value='010'>010</option>
<option value='011'>011</option>
<option value='017'>017</option>
<option value='018'>018</option>
<option value='019'>019</option>
</select>
-
<input type='text' name='phone2' size='15' maxlength='4' class='form'> -
<input type='text' name='phone3' size='15' maxlength='4' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40'>
<font class='titdot'>• </font>
<font class='title'>주소</font> :
</td>
<td>
<input type='text' name='zipcode1' size='3' maxlength='3' class='form'> -
<input type='text' name='zipcode2' size='3' maxlength='3' class='form'>
<input type='button' value='우편번호 찾기' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td width='100' height='40' valign='top' align='right'></td>
<td>
<input type='text' name='address1' size='50' maxlength='100' class='form'>
<br><br>
<input type='text' name='address2' size='50' maxlength='100' class='form'>
</td>
</tr>
<tr>
<td colspan='2' class='imgline'></td>
</tr>
<tr>
<td colspan='2' class='gline'></td>
</tr>
</table>
<table width='100%' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td width='400' height='60'> </td>
<td align='left'>
<input type='button' value='회 원 가 입' class='form'>
<input type='button' value='뒤 로 가 기' class='form' onclick='history.back()'>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<table width='1030px' border='0' cellpadding='0' cellspacing='0' align='center'>
<tr>
<td height='15' bgcolor='#f0f0f0' height='40' align='center'></td>
</tr>
</table>
</body>
</html>
'Study > Programming' 카테고리의 다른 글
servlet 기본 골격 (0) | 2009.06.15 |
---|---|
JSP webprj1 (0) | 2009.06.09 |
JSP 쿠키 (0) | 2009.06.04 |
JSP 파일 업로드 (0) | 2009.06.03 |
jsp에서 파일 업로드 처리 (0) | 2009.06.03 |