Model2 login,join
2020. 9. 25. 16:52ㆍJSP
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<style>
li{
list-style: none;
}
font {
font-weight: 900;
}
</style>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="../Memberlogin.me" method="post" >
<h1 style="text-align:center">로그인 ver.1</h1>
<div style="text-align: center">
<hr/>
<ul>
<li><font>아이디:</font><input type="text" name="userid"></li>
<li><font>비밀번호:</font><input type="password" name="userpw"></li>
<li><input type="submit" value="로그인">
<input type="button" value="회원가입" onclick="location='joinForm.jsp'">
</li>
</ul>
</div>
</form>
</body>
</html>loginform
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<style>
th {
background-color: #A9BCF5;
}
table,
th,
tr,
td {
border: 1px solid;
}
</style>
<!-- <script type="text/javascript">
//비밀번호 확인.
function checkpass(){
var objuserPw = document.getElementById("userPw");
var objusePwConfirm = document.getElementById("userPwConfirm");
if(objuserPw.value != objusePwConfirm.value || objuserPw.value == ""){
alert("패스워드가 다릅니다. 다시입력해주세요")
objuserPw.value = "";
objusePwConfirm.value = "";
objuserPw.focus();
return false;
}else {
alert("패스워드가 일치합니다.");
return true;
}
}
</script>
<script type="text/javascript">
function joininsert() {
//정규식
var re = /^[a-zA-Z0-9]{4,12}$/ // 아이디와 패스워드가 적합한지 검사할 정규식
var re2 = /^[0-9a-zA-Z]([-_.]?[0-9a-zA-Z])*@[0-9a-zA-Z]([-_.]?[0-9a-zA-Z])*.[a-zA-Z]{2,3}$/i;
var objuserId = document.getElementById("userId");
var objuserPw = document.getElementById("userPw");
var objusePwConfirm = document.getElementById("userPwConfirm");
var objMail = document.getElementById("userMail");
var objuserName = document.getElementById("userName");
var objhobby = document.getElementsByName("hobby");
var intro = document.getElementById("intro");
//address
var address1 = document.getElementById("sample6_postcode");
var address2 = document.getElementById("sample6_address");
var address3 = document.getElementById("sample6_address2");
//주민 번호
var objjubun1 = document.getElementById("jubun1"); //주민번호 앞자리
var objjubun2 = document.getElementById("jubun2"); // 주민번호 뒷자리
var objArr1 = new Array(); //주민번호 6개
var objArr2 = new Array(); //주민번호 뒤 7개
if(objuserId.value == ""){ //아이디 공백일때.
alert("id를 입력해주세요.");
objuserId.focus();
return false;
}
else if(re.test(objuserId.value) != true){
alert("id 조건이 맞지않소.");
objuserId.value = ""; //초기화
objuserId.focus();
return false;
}
else if(objuserPw.value == ""){ //패스워드 공백일때.
alert("password를 입력해주세요.")
objuserPw.focus();
return false;
}
else if(objusePwConfirm.value == ""){ // 패스워드 공백일때.
alert("password를 입력해주세요.")
objusePwConfirm.focus();
return false;
}
else if(objMail.value == ""){ //이메일 공백
alert("email를 입력해주세요.")
objMail.focus();
return false;
}
else if(re2.test(objMail.value) != true){
alert("이메일이 올바르지 않습니다.")
objmail.value == "";
objMail.focus();
return false;
}
else if(objuserName.value == ""){ //이름 공백
alert("name를 입력해주세요.")
objuserName.focus();
return false;
}
//주소 4종 세트
else if(address1.value == ""){
alert("우편번호를 입력해주세요.")
address1.focus();
return false;
}
else if(address2.value == ""){
alert("도로명 주소");
address2.focus();
return false;
}
/* else if(objbranchaddress.value == ""){
alert("지번 주소");
objbranchaddress.focus();
return false;
} */
else if(address3.value == ""){
alert("상세 주소");
address3.focus();
return false;
}
/* //주민번호.
else if(objjubun1.value == true){
for(var i = 0; i < objjubun1.length; i++){ //앞자리 배열에 담기
objArr1 = objjubun1.value.charAt(i);
}
for(var i = 0; i< objjubun2.length; i++){ //뒷자리 배열에 담기/
objArr2 = objjubun2.value.charAt(i);
}
}
else if(objjubun1.objjubun1 == "" && objjubun2.value == ""){
alert("주민등록번호를 다시 입력해주세요.");
objjubun1.focus();
return false;
}
else if(objArr1[0] == 1 || objArr1[0] == 2){ //남자는 1 여자는 2
var y = "19"+ parseInt(objArr1.value.substring(0,2));
var m = parseInt(objArr1.value.substring(2,4));
var d = parseInt(objArr1.value.substring(4,6));
join.year.value = y;
join.month.value = m;
join.date.value = d;
}
else if(objArr1[0] == 3 || objArr1[0] == 4){ //남자는 1 여자는 2
var y = "20"+ parseInt(objArr1.value.substring(0,2));
var m = parseInt(objArr1.value.substring(2,4));
var d = parseInt(objArr1.value.substring(4,6));
join.year.value = y;
join.month.value = m;
join.date.value = d;
} */
//게시판
else if(intro.value == ""){
alert("자기소개를 입력해주세요");
intro.focus();
return false;
}
//관심분야
var hobby = new Array();
for(var i=0; i<objhobby.length; i++){
{
if(objhobby[i].checked)
{
hobby+=objhobby[i].value; //관심분야 저장
}
}
}
if(hobby.length < 1) //입력이 안될때 1
{
alert("관심분야를 선택해주세요.");
return false;
}
alert("회원가입이 완료되었습니다.");
document.join.submit();
}
</script>
<script src="https://t1.daumcdn.net/mapjsapi/bundle/postcode/prod/postcode.v2.js"></script>
<script src="http://dmaps.daum.net/map_js_init/postcode.v2.js"></script>
<script>
function sample6_execDaumPostcode() {
new daum.Postcode({
oncomplete: function(data) {
// 팝업에서 검색결과 항목을 클릭했을때 실행할 코드를 작성하는 부분.
// 각 주소의 노출 규칙에 따라 주소를 조합한다.
// 내려오는 변수가 값이 없는 경우엔 공백('')값을 가지므로, 이를 참고하여 분기 한다.
var fullAddr = ''; // 최종 주소 변수
var extraAddr = ''; // 조합형 주소 변수
// 사용자가 선택한 주소 타입에 따라 해당 주소 값을 가져온다.
if (data.userSelectedType === 'R') { // 사용자가 도로명 주소를 선택했을 경우
fullAddr = data.roadAddress;
} else { // 사용자가 지번 주소를 선택했을 경우(J)
fullAddr = data.jibunAddress;
}
// 사용자가 선택한 주소가 도로명 타입일때 조합한다.
if(data.userSelectedType === 'R'){
//법정동명이 있을 경우 추가한다.
if(data.bname !== ''){
extraAddr += data.bname;
}
// 건물명이 있을 경우 추가한다.
if(data.buildingName !== ''){
extraAddr += (extraAddr !== '' ? ', ' + data.buildingName : data.buildingName);
}
// 조합형주소의 유무에 따라 양쪽에 괄호를 추가하여 최종 주소를 만든다.
fullAddr += (extraAddr !== '' ? ' ('+ extraAddr +')' : '');
}
// 우편번호와 주소 정보를 해당 필드에 넣는다.
document.getElementById('sample6_postcode').value = data.zonecode; //5자리 새우편번호 사용
document.getElementById('sample6_address').value = fullAddr;
// 커서를 상세주소 필드로 이동한다.
document.getElementById('sample6_address2').focus();
}
}).open();
}
</script>
-->
<body>
<form action="../Memberjoin.me" method="post">
<div align="center">
<table>
<tr>
<th colspan="2">회원 기본 정보</th>
</tr>
<tr>
<td align="center">아이디 : </td>
<td>
<input type="text" id="userId" name="userId">4~12자의 영문 대소문자와 숫자로만 입력
</td>
</tr>
<tr>
<td align="center">비밀번호 : </td>
<td>
<input type="password" id="userPw" name="userPw">4~12자의 영문 대소문자와 숫자로만 입력
</td>
</tr>
<tr>
<td align="center">비밀번호 확인 : </td>
<td>
<input type="password" id="userPwConfirm" name="userPwConfirm">
<input type="button" id="userPwConfirm" name="userPwConfirm" value="확인" onclick="checkpass()">
</td>
</tr>
<tr>
<td align="center">메일주소 : </td>
<td>
<input type="text" id="userMail" name="userMail">예) id@domain.com
</td>
</tr>
<tr>
<td align="center">이름 : </td>
<td>
<input type="text" id="userName" name="userName">
</td>
</tr>
<tr>
<th colspan="2">개인 신상 정보</th>
</tr>
<tr>
<td align="center">우편번호 : </td>
<td>
<input type="text" id="sample6_postcode" name="sample6_postcode" placeholder="우편번호">
<input type="button" onclick="sample6_execDaumPostcode()" value="우편번호 찾기"><br>
<input type="text" id="sample6_address" name="sample6_address" placeholder="주소">
<input type="text" id="sample6_address2" name="sample6_address2" placeholder="상세주소">
</td>
</tr>
<tr>
<td align="center">주민등록번호 : </td>
<td>
<input type="text" id="jubun1" name="jubun1" style="width: 72px;"> -
<input type="text" id="jubun2" name="jubun2" style="width: 72px;"> 예) 123456-1234567
</td>
</tr>
<tr>
<td align="center">생일 : </td>
<td>
<input type="text" id="year" name="year" style="width: 70px;" >년
<input type="text" id="month" name="month" style="width: 20px;" >월
<input type="text" id="date" name="day" style="width: 20px;" >일
</td>
</tr>
<tr>
<td align="center">관심분야 : </td>
<td>
<input type="checkbox" name="hobby" value="computer">컴퓨터
<input type="checkbox" name="hobby" value="internet">인터넷
<input type="checkbox" name="hobby" value="travle">여행
<input type="checkbox" name="hobby" value="movie">영화감상
<input type="checkbox" name="hobby" value="music">음악감상
</td>
</tr>
<tr>
<td align="center">자기소개 : </td>
<td>
<textarea id="intro" name="intro" style="width: 450px; height: 200px; resize: none;"></textarea>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="회원 가입">
<input type="reset" value="다시 입력">
</td>
</tr>
</table>
</form>
</body>
</html>joinform
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
String myid =(String)session.getAttribute("userid");
if(myid.equals("admin")){
// out.write("<form action='Memberlist.me'>");
out.write("<a href='Memberlist.me'>회원 조회");
out.write("</a>");
// out.write("</form>");
}
%>
<!DOCTYPE html>
<html>
<head>
<style>
font.id{
font-size: 30px;
font-weight: 900;
}
a{
text-align: center;
font-size: 30px;
display: block;
background-color: black;
color: white;
}
</style>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<font class="id"><%=myid%>님이 로그인하셨습니다.</font>
</body>
</html>main
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.util.*" %>
<%
out.print("<h1>회원조회</h1>");
List memberList =(List)session.getAttribute("userid");
for(int i = 0; i < memberList.size(); i++){
String me = (String) memberList.get(i);
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<a href='./Memberview.me?values=<%=me%>'><%=me%></a>
<% } %>
</body>
</html>member_list
<%@page import="net.member.db.MemberBean"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
MemberBean memberbean=(MemberBean)request.getAttribute("as"); //주소
//->(request.getAttribute("as") memberBean 주소를
//MemberBean 래퍼런스에 담아줌
String userid=memberbean.getUserId();
String userpw=memberbean.getUserPw();
String usermail=memberbean.getUserMail();
String username=memberbean.getUserName();
String sam=memberbean.getSample6_postcode();
String sam1=memberbean.getSample6_address();
String sam2=memberbean.getSample6_address2();
int jumin1=memberbean.getJubun1();
int jumin2=memberbean.getJubun2();
int year=memberbean.getYear();
int month=memberbean.getMonth();
int day=memberbean.getDay();
String hobby=memberbean.getHobby();
String intro=memberbean.getIntro();
%>
<!DOCTYPE html>
<html>
<head>
<style>
table
{border: 1px black solid;
}
a{
display:block;
width: 100px;
height: 30px;
background-color: black;
text-align : center;
color:white;
}
</style>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<table>
<tr>
<td>아이디:</td><td><%=userid%></td>
</tr>
<tr>
<td>비밀번호:</td><td><%=userpw%></td>
</tr>
<tr>
<td>메일:</td><td><%=usermail%></td>
</tr>
<tr>
<td>이름:</td><td><%=username%></td>
</tr>
<tr>
<td>주소:</td><td><%=sam%>-<%=sam1%>-<%=sam2%></td>
</tr>
<tr>
<td>주민번호:</td><td><%=jumin1%>-<%=jumin2%></td>
</tr>
<tr>
<td>생년월일:</td><td><%=year%>-<%=month%>-<%=day%></td>
</tr>
<tr>
<td>취미:</td><td><%=hobby%></td>
</tr>
<tr>
<td>자기소개:</td><td><%=intro%></td>
</tr>
</table>
<a href='./Memberdelete.me?values=<%=userid%>'>회원삭제</a>
</body>
</html>member_view
package net.member.action;
import javax.servlet.http.*;
public interface Action {
public ActionForward execute(HttpServletRequest request,HttpServletResponse response)
throws Exception;
}
action
package net.member.action;
public class ActionForward {
private boolean isRedirect=false;
private String path=null;
public boolean isRedirect(){
return isRedirect;
}
public String getPath(){
return path;
}
public void setRedirect(boolean b){
isRedirect=b;
}
public void setPath(String string){
path=string;
}
}actionforward
package net.member.action;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class MemberFrontController
extends javax.servlet.http.HttpServlet
implements javax.servlet.Servlet {
protected void doProcess(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String RequestURI=request.getRequestURI();
String contextPath=request.getContextPath();
String command=RequestURI.substring(contextPath.length());
System.out.println("command"+command);
ActionForward forward = null;
Action action = null;
// 메인 controller
if(command.equals("/MemberMain.me")) {
forward = new ActionForward();
forward.setRedirect(false);
forward.setPath("member/main.jsp");
}
//로그인 controller
else if(command.equals("/Memberlogin.me")){
action = new MemberLoginAction();
System.out.println("Logincontroller");
try{
forward=action.execute(request, response);
}catch(Exception e){
e.printStackTrace();
}}
//조인 controller
else if(command.equals("/Memberjoin.me")){
action = new MemberJoinAction();
System.out.println("Joincontroller");
try{
forward=action.execute(request, response);
}catch(Exception e){
e.printStackTrace();
}
}
// 회원정보 조회
else if(command.equals("/Memberlist.me")){
action = new MemberListAction();
try{
forward=action.execute(request, response);
System.out.println("Listcontroller");
}catch(Exception e){
e.printStackTrace();
}
} // 개인정보 조회
else if(command.equals("/Memberview.me")){
action = new MemberViewAction();
try{
forward=action.execute(request, response);
System.out.println("viewcontroller");
}catch(Exception e){
e.printStackTrace();
}
}//삭제
else if(command.equals("/Memberdelete.me")){
action = new MemberDeleteAction();
try{
forward=action.execute(request, response);
System.out.println("delcontroller");
}catch(Exception e){
e.printStackTrace();
}
}
if(forward.isRedirect()){
response.sendRedirect(forward.getPath());
}else{
RequestDispatcher dispatcher=
request.getRequestDispatcher(forward.getPath());
dispatcher.forward(request, response);
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doProcess(request,response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doProcess(request,response);
}
}controller
package net.member.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import net.member.db.*;
public class MemberLoginAction implements Action {
public ActionForward execute(HttpServletRequest request,HttpServletResponse response)
throws Exception{
request.setCharacterEncoding("utf-8");
ActionForward forward =new ActionForward();
MemberDAO mdao = new MemberDAO();
String id = request.getParameter("userid");
String pass =request.getParameter("userpw");
mdao.selectMember(id,pass);
HttpSession session=request.getSession();
session.setAttribute("userid",id);
System.out.println("로그인까지옴?");
forward.setRedirect(false);
forward.setPath("MemberMain.me");
System.out.println("넘어갔나?");
return forward;
}
}loginaction
package net.member.action;
import java.io.PrintWriter;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.member.db.MemberBean;
import net.member.db.MemberDAO;
public class MemberJoinAction implements Action {
public ActionForward execute(HttpServletRequest request,HttpServletResponse response)
throws Exception{
MemberDAO mdao = new MemberDAO();
MemberBean memberbean =new MemberBean();
ActionForward forward= new ActionForward();
System.out.println("단계1");
memberbean.setUserId(request.getParameter("userId"));
memberbean.setUserPw(request.getParameter("userPw"));
memberbean.setUserMail(request.getParameter("userMail"));
memberbean.setUserName(request.getParameter("userName"));
memberbean.setSample6_postcode(request.getParameter("sample6_postcode"));
memberbean.setSample6_address(request.getParameter("sample6_address"));
memberbean.setSample6_address2(request.getParameter("sample6_address2"));
memberbean.setJubun1(Integer.parseInt(request.getParameter("jubun1")));
memberbean.setJubun2(Integer.parseInt(request.getParameter("jubun2")));
memberbean.setYear(Integer.parseInt(request.getParameter("year")));
memberbean.setMonth(Integer.parseInt(request.getParameter("month")));
memberbean.setDay(Integer.parseInt(request.getParameter("day")));
memberbean.setHobby(request.getParameter("hobby"));
memberbean.setIntro(request.getParameter("intro"));
System.out.println("단계2");
//dao에 있는 joinMember메소드 pstmt.set의 값을 불러오기위해
mdao.joinMember(memberbean);
response.setContentType("text/html;charset=euc-kr"); PrintWriter
out=response.getWriter(); out.println("<script>");
out.println("alert('회원가입이 완료되었습니다.');"); out.println("</script>");
out.close();
forward.setRedirect(false);
forward.setPath("/member/LoginForm.jsp");
System.out.println(forward.getPath());
return forward;
}
}joinaction
package net.member.action;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import net.member.db.MemberDAO;
public class MemberListAction implements Action {
public ActionForward execute(HttpServletRequest request,HttpServletResponse response) throws Exception{
MemberDAO mdao=new MemberDAO();
List id = mdao.allselectMember();
System.out.println(mdao.allselectMember());
HttpSession session=request.getSession();
session.setAttribute("userid",id);
ActionForward forward = new ActionForward();
forward.setRedirect(false);
forward.setPath("member/member_list.jsp");
return forward;
}
}listaction
package net.member.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.member.db.MemberBean;
import net.member.db.MemberDAO;
public class MemberViewAction implements Action {
public ActionForward execute(HttpServletRequest request,HttpServletResponse response)
throws Exception{
MemberDAO mdao = new MemberDAO();
String idvalues = request.getParameter("values");
System.out.println("조계현병신1");
// bean의 주소값
MemberBean as = mdao.SelectInfo(idvalues);
System.out.println("조계현병신2");
request.setAttribute("as",as);
System.out.println(as);
ActionForward forward= new ActionForward();
forward.setRedirect(false);
System.out.println("넘어갔나?");
forward.setPath("/member/member_view.jsp");
System.out.println(forward.getPath());
return forward;
}
}viewaction
package net.member.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.member.db.MemberDAO;
public class MemberDeleteAction implements Action {
public ActionForward execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
MemberDAO memberdao =new MemberDAO();
String delinfo = request.getParameter("values");
memberdao.Deleteinfo(delinfo);
ActionForward forward = new ActionForward();
forward.setRedirect(true);
forward.setPath("./Memberlist.me");
return forward;
}
}
deleteaciton
package net.member.db;
public class MemberBean{
String userId; //아이디
String userPw; //비밀번호
String userMail; //메일
String userName ;//이름
String sample6_postcode; //주소1
String sample6_address ;//주소2
String sample6_address2 ;//주소3
int jubun1 ;//주민 앞자리
int jubun2 ;//주민 뒷자리
int year ;//년
int month ;//월
int day ;//일
String hobby ;// 취미
String intro; // 자기소개
public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
public String getUserPw() {
return userPw;
}
public void setUserPw(String userPw) {
this.userPw = userPw;
}
public String getUserMail() {
return userMail;
}
public void setUserMail(String userMail) {
this.userMail = userMail;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getSample6_postcode() {
return sample6_postcode;
}
public void setSample6_postcode(String sample6_postcode) {
this.sample6_postcode = sample6_postcode;
}
public String getSample6_address() {
return sample6_address;
}
public void setSample6_address(String sample6_address) {
this.sample6_address = sample6_address;
}
public String getSample6_address2() {
return sample6_address2;
}
public void setSample6_address2(String sample6_address2) {
this.sample6_address2 = sample6_address2;
}
public int getJubun1() {
return jubun1;
}
public void setJubun1(int jubun1) {
this.jubun1 = jubun1;
}
public int getJubun2() {
return jubun2;
}
public void setJubun2(int jubun2) {
this.jubun2 = jubun2;
}
public int getYear() {
return year;
}
public void setYear(int year) {
this.year = year;
}
public int getMonth() {
return month;
}
public void setMonth(int month) {
this.month = month;
}
public int getDay() {
return day;
}
public void setDay(int day) {
this.day = day;
}
public String getHobby() {
return hobby;
}
public void setHobby(String hobby) {
this.hobby = hobby;
}
public String getIntro() {
return intro;
}
public void setIntro(String intro) {
this.intro = intro;
}
}bean
package net.member.db;
import java.sql.*;
import java.util.*;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.RequestDispatcher;
import javax.sql.DataSource;
import org.apache.catalina.connector.Request;
import oracle.net.aso.p;
public class MemberDAO {
Connection con;
PreparedStatement pstmt;
ResultSet rs;
public MemberDAO() {
try{
Context init = new InitialContext();
DataSource ds = (DataSource) init.lookup("java:comp/env/jdbc/OracleDB");
System.out.println("DB접속");
con = ds.getConnection();
}catch(Exception ex){
System.out.println("DB: " + ex);
return;
}
}
public String selectMember (String userid ,String userpass){
String login_sql ="SELECT userid FROM testlogin WHERE userid = ? and userpw = ? ";
try {
pstmt=con.prepareStatement(login_sql);
pstmt.setString(1,userid);
pstmt.setString(2,userpass);
rs =pstmt.executeQuery();
}catch (Exception e) {
e.printStackTrace();
}
return userid;
}
// -> memberbean을 action에 넘기기 위해 매게변수를 선언함
public boolean joinMember(MemberBean memberbean) {
String join_sql ="insert into testlogin values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
try {
System.out.println("단계3");
pstmt=con.prepareStatement(join_sql);
pstmt.setString(1,memberbean.getUserId());
pstmt.setString(2,memberbean.getUserPw());
pstmt.setString(3,memberbean.getUserMail());
pstmt.setString(4,memberbean.getUserName());
pstmt.setString(5,memberbean.getSample6_postcode());
pstmt.setString(6,memberbean.getSample6_address());
pstmt.setString(7,memberbean.getSample6_address2());
pstmt.setInt(8,memberbean.getJubun1());
pstmt.setInt(9,memberbean.getJubun2());
pstmt.setInt(10,memberbean.getYear());
pstmt.setInt(11,memberbean.getMonth());
pstmt.setInt(12,memberbean.getDay());
pstmt.setString(13,memberbean.getHobby());
pstmt.setString(14,memberbean.getIntro());
pstmt.executeQuery();
System.out.println("여기까지 왔나??");
}
catch (Exception e) {
e.printStackTrace();
}
return true;
}
public List allselectMember(){
List memberList = new ArrayList();
MemberBean memberbean = new MemberBean();
// String id ="";
String alllogin_sql ="SELECT userid FROM testlogin";
try {
pstmt=con.prepareStatement(alllogin_sql);
rs =pstmt.executeQuery();
while (rs.next()) {
memberbean.setUserId(rs.getString("userid"));
memberList.add(rs.getString("userid"));
}
}catch (Exception e) {
e.printStackTrace();
}
return memberList;
}
public MemberBean SelectInfo(String uservalues) {
MemberBean memberbean = null;
String Info_sql ="select * from testlogin WHERE userid = ? ";
try {
System.out.println("try로 들어오니??");
pstmt=con.prepareStatement(Info_sql);
pstmt.setString(1,uservalues);
rs =pstmt.executeQuery();
if (rs.next()) {
System.out.println("if문이 null??");
memberbean =new MemberBean();
memberbean.setUserId(rs.getString("userId"));
memberbean.setUserPw(rs.getString("userPw"));
memberbean.setUserMail(rs.getString("userMail"));
memberbean.setUserName(rs.getString("userName"));
memberbean.setSample6_postcode(rs.getString("sample6_postcode"));
memberbean.setSample6_address(rs.getString("sample6_address"));
memberbean.setSample6_address(rs.getString("sample6_address2"));
memberbean.setJubun1(rs.getInt("jubun1"));
memberbean.setJubun2(rs.getInt("jubun2"));
memberbean.setYear(rs.getInt("year"));
memberbean.setMonth(rs.getInt("month"));
memberbean.setDay(rs.getInt("day"));
memberbean.setHobby(rs.getString("hobby"));
memberbean.setIntro(rs.getString("intro"));
}
// memberbean 이 null 일시 false를 return;
if(memberbean==null){
System.out.println("null이 들어 왔나???");
return null;
}
System.out.println("정상적으로 bean을 리턴하나?");
return memberbean;
} catch (Exception e) {
e.printStackTrace();
}
System.out.println("아예 null을 리턴하나?");
return null;
}
public boolean Deleteinfo(String delinfo) {
String del_sql="DELETE testlogin WHERE userid= ? ";
try {
int check ;
pstmt = con.prepareStatement(del_sql);
pstmt.setString(1,delinfo);
// int 타입 반환가능 return
check = pstmt.executeUpdate();
if(check!=0) {
System.out.println("정상적으로 삭제되었습니다.");
return true;
}
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println("삭제되지않았습니다.");
return false;
}
}
dao
'JSP' 카테고리의 다른 글
| (JSP)파일업로드 (0) | 2020.09.22 |
|---|---|
| (jsp)JDBC (0) | 2020.09.21 |
| (JSP) 자바빈즈를 이용하여 회원가입 폼의 데이터를 출력하기 (0) | 2020.08.28 |
| (JSP)자바 빈즈 (0) | 2020.08.28 |
| (JSP) Scope & Attribute개념정리 action태그- include 예제 (0) | 2020.08.28 |