[Java & Oracle] member 테이블에 값 입력, 수정, 삭제 VO, DAO, Main

create table member(
id varchar2(20) primary key,
pwd varchar2(20) not null,
name varchar2(20),
email varchar2(50)
);

 

vo, dao, main 클래스 만들기

3명 추가

1명 수정 (id로 찾아서 pwd, name 수정)

1명 삭제 (id로 찾기)

 

▼ VO

package member;

public class MemberVo {
	private int id;
	private int pwd;
	private String name;
	private String email;
	
	public MemberVo() {}
	
	public MemberVo(int id, int pwd, String name, String email) {
		super();
		this.id = id;
		this.pwd = pwd;
		this.name = name;
		this.email = email;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public int getPwd() {
		return pwd;
	}

	public void setPwd(int pwd) {
		this.pwd = pwd;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	@Override
	public String toString() {
		return "MemberVo [id=" + id + ", pwd=" + pwd + ", name=" + name + ", email=" + email + "]";
	}
}

---------------------------------

▼ DAO

package member;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import conn.DBConnect;

public class MemberDao {
	private DBConnect dbconn;

	public MemberDao() {
		dbconn = DBConnect.getInstance();
	}

	// insert
	public void insert(MemberVo vo) {
		Connection conn = dbconn.conn();
		String sql = "insert into member values(?, ?, ?, ?)";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, vo.getId());
			pstmt.setInt(2, vo.getPwd());
			pstmt.setString(3, vo.getName());
			pstmt.setString(4, vo.getEmail());
			int num = pstmt.executeUpdate();
			System.out.println(num + "줄이 추가되었습니다.");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

	// update (id -> pwd, name)
	public void update(MemberVo vo) {
		Connection conn = dbconn.conn();
		String sql = "update member set pwd = ?, name = ? where Id = ?";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, vo.getPwd());
			pstmt.setString(2, vo.getName());
			pstmt.setInt(3, vo.getId());
			int num = pstmt.executeUpdate();
			System.out.println(num + "줄이 수정되었습니다.");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

	// delete (id)
	public void delete(int id) {
		Connection conn = dbconn.conn();
		String sql = "delete member where Id = ?";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, id);
			int num = pstmt.executeUpdate();
			System.out.println(num + "줄이 삭제되었습니다.");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}

---------------------------------

▼ Main

package member;

public class MemberMain {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		MemberDao dao = new MemberDao();
		
		dao.insert(new MemberVo(1, 1111, "aaa", "aaa@gmail.con"));
		dao.insert(new MemberVo(2, 2222, "bbb", "bbb@gmail.con"));
		dao.insert(new MemberVo(3, 3333, "ccc", "ccc@gmail.con"));
		
		dao.update(new MemberVo(2, 4444, "ddd", null));
		
		dao.delete(1);
	}
}

---------------------------------