day51 - JSP(model2, login)

KIC/JSP

day51 - JSP(model2, login)

바차 2021. 8. 26. 22:49

[memberInput]

<%@ 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>
<div class="w3-content " style="width:80%; align-self: center;">
	<form action="<%=request.getContextPath()%>/member/memberInputPro" 
	name="f" method="post">
		<input type="hidden" name="picture" value="">
		<table   >
			<caption>회원가입</caption>
			<tr>
				<td rowspan="4" valign="bottom"><img src="" width="100"
					height="120" id="pic"><br> <font size="1"><a
						href="javascript:win_upload()">사진등록</a></font></td>
				<td>아이디</td>
				<td><input type="text" name="id"></td>
			</tr>
			<tr>
				<td>비밀번호</td>
				<td><input type="password" name="pass"></td>
			</tr>
			<tr>
				<td>이름</td>
				<td><input type="text" name="name"></td>
			</tr>
			<tr>
				<td>성별</td>
				<td><input type="radio"  value="1" name="gender" checked>남
					<input type="radio"  value="2" name="gender" >여</td>
			</tr>
			<tr>
				<td>전화번호</td>
				<td colspan="2"><input type="text" name="tel"></td>
			</tr>
			<tr>
				<td>이메일</td>
				<td colspan="2"><input type="text" name="email"></td>
			</tr>
			<tr>
				<td colspan="3"  align="right"><input type="submit"   value="회원가입"></td>
			</tr>
		</table>
		
	</form></div>
</body>
</html>

[memberDao]

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import model.Member;
import util.DBConnection;

public class MemberDao {
	
	
	public int memberInsert(Member member) {
		Connection con = DBConnection.getConnection();
		
		PreparedStatement pstmt = null;
		String sql = "insert into member2  values (?, ?, ?, ?, ?, ?, ?)";
		
		try {
			pstmt = con.prepareStatement(sql);
			pstmt.setString(1, member.getId());
			pstmt.setString(2, member.getPass());
			pstmt.setString(3, member.getName());
			pstmt.setInt(4, member.getGender());
			pstmt.setString(5, member.getTel());
			pstmt.setString(6, member.getEmail());
			pstmt.setString(7, member.getPicture());
			return pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			DBConnection.close(con, pstmt, null);
		}
		
		return 0;
	}
	
	
    public List<Member> memberList() {
    	Connection con = DBConnection.getConnection();
 		PreparedStatement pstmt = null;
 		ResultSet rs = null;
 		String sql = "select  * from member2";
 		List<Member> li = new ArrayList<Member>();
 		try {
			pstmt = con.prepareStatement(sql);
			rs=pstmt.executeQuery();
			while(rs.next()) {
				Member member = new Member();
				member.setId(rs.getString("id"));
				member.setPass(rs.getString("pass"));
				member.setName(rs.getString("name")); 
				member.setGender(rs.getInt("gender"));
				member.setTel(rs.getString("tel"));
				member.setEmail(rs.getString("email"));
				member.setPicture(rs.getString("picture"));
				li.add(member);
				
			}		
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			DBConnection.close(con, pstmt, rs);
		}
 		
 		return li;
	}
    
    public Member selectOne(String id) {
    	Connection con = DBConnection.getConnection();
 		PreparedStatement pstmt = null;
 		ResultSet rs = null;
 		String sql = "select  * from member2 where id=?";
 		Member member = new Member();
 		try {
			pstmt = con.prepareStatement(sql);
			pstmt.setString(1, id);
			rs=pstmt.executeQuery();
			if(rs.next()) {
				member.setId(rs.getString("id"));
				member.setPass(rs.getString("pass"));
				member.setName(rs.getString("name"));
				member.setGender(rs.getInt("gender"));
				member.setTel(rs.getString("tel"));
				member.setEmail(rs.getString("email"));
				member.setPicture(rs.getString("picture"));
				
			}		
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			DBConnection.close(con, pstmt, rs);
		}
 		System.out.println(member);
 		return member;
	}
     

}

[loginForm.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>
<div class="w3-content" style="width:50%;">

<form action="<%=request.getContextPath() %>/member/loginPro" method="post">
<caption><h2>로그인</h2></caption>
<table>
<tr><th>아이디</th><td><input type="text" name="id"></td></tr>
<tr><th>비밀번호</th><td><input type="password" name="pass"></td></tr>
<tr><td colspan="2" ><input type="submit" value="로그인">
<input type="submit" value="회원가입"
onclick="location.href='<%=request.getContextPath() %>/member/memberInput'"></td>
</tr>
</table>
</form>
<br><br>
</div>
</body>
</html>