JSP - 간단한 게시판 구현하기(외전) - MemberDAO,DTO (2022-09-29)

1. 서론

 

보통 이건 관련 내용 설명하면서 제시하는데 

그냥 올려두겠다

 

2. 본론

 

MemberDTO.java

 

package session_quiz;
/*
 테이블 이름 : session_quiz
 테이블 컬럼 : 아래의 멤버필드를 참고하여 생성, 크기는 자유
 
SQL> CREATE TABLE session_quiz(
  2  id varchar2(10),
  3  pw varchar2(10),
  4  username varchar2(15),
  5  address varchar2(20),
  6  mobile varchar2(15)
  7  );

SQL> INSERT INTO session_quiz VALUES('admin', '1234', '관리자', '서울시', '010-1234-1234');
SQL> commit;

 */
public class MemberDTO {
	private String id; // 고갱님의 아이디
	private String pw; // 고갱님의 비밀번호
	private String confirm; // 고갱님의 비밀번호 확인
	private String userName; // 고갱님의 이름
	private String address; // 고갱님의 주소
	private String mobile; // 고갱님의 전화번호
	
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getPw() {
		return pw;
	}
	public void setPw(String pw) {
		this.pw = pw;
	}
	public String getConfirm() {
		return confirm;
	}
	public void setConfirm(String confirm) {
		this.confirm = confirm;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public String getMobile() {
		return mobile;
	}
	public void setMobile(String mobile) {
		this.mobile = mobile;
	}

 

 

MemberDAO.java

 

package session_quiz;

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

public class MemberDAO {
	
	private Connection con;

	public MemberDAO() {
		String url = "jdbc:oracle:thin:@localhost:1521:xe";
		String user = "<오라클 설치 시 설정한 아이디>";
		String password = "<오라클 설치 시 설정한 비밀번호>";
		
		try {
			Class.forName("oracle.jdbc.OracleDriver");
			con = DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void insert(MemberDTO member) {
		String sql = "INSERT INTO session_quiz VALUES(?,?,?,?,?)";
		
		PreparedStatement ps = null;
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1, member.getId());
			ps.setString(2, member.getPw());
			ps.setString(3, member.getUserName());
			ps.setString(4, member.getAddress());
			ps.setString(5, member.getMobile());
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public MemberDTO selectId(String id) {
		String sql = "SELECT * FROM session_quiz WHERE id=?";
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1, id);
			rs = ps.executeQuery();
			if(rs.next()) {
				MemberDTO member = new MemberDTO();
				member.setId(rs.getString("id"));
				member.setPw(rs.getString("pw"));
				member.setUserName(rs.getString("username"));
				member.setAddress(rs.getString("address"));
				member.setMobile(rs.getString("mobile"));
				return member;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}
	
	public ArrayList<MemberDTO> selectAll() {
		ArrayList<MemberDTO> members = new ArrayList<MemberDTO>();
		
		String sql = "SELECT * FROM session_quiz";
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next()) {
				MemberDTO member = new MemberDTO();
				member.setId(rs.getString("id"));
				member.setPw(rs.getString("pw"));
				member.setUserName(rs.getString("username"));
				member.setAddress(rs.getString("address"));
				member.setMobile(rs.getString("mobile"));
				members.add(member);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return members;
	}
	
	public void update(MemberDTO member) {
		String sql = "UPDATE session_quiz SET ";
		sql += "pw=?, username=?, address=?, mobile=? WHERE id=?";
		
		PreparedStatement ps = null;
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1, member.getPw());
			ps.setString(2, member.getUserName());
			ps.setString(3, member.getAddress());
			ps.setString(4, member.getMobile());
			ps.setString(5, member.getId());
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public void delete(String id) {
		String sql = "DELETE FROM session_quiz WHERE id=?";
		
		PreparedStatement ps = null;
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1, id);
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

 

 

3. 결론

 

고향으로 온 느낌(편안)