JAVA DB SQLITE DELETE

메인 코드

메인 메서드에서 값을 DTO클레스에 있는 생성자로 보내준 후 LibrarySystem_DAO클레스에서 DTO에 임시 저장한 값들을 delete매서드로 가져와 sql 구문을 이용해 해당 _id값을 찾아 삭제하게 된다

	case "삭제":
			_id = tfID.getText();
			LibrarySystem_DTO dtoDel = new LibrarySystem_DTO(_id);
			
			dao = new LibrarySystem_DAO();
			dao.DELETE(dtoDel._id);
			
			tfID.setText("");
			tfNum.setText("");
			tfName.setText("");
			tfPhone.setText("");
			tfTemp.setText("");
			tfIdentity.setText("");
			
			model.setDataVector(dao.getListVector(), dao.getTableHeader());
			
			break;

Delete 매서드

	//__________DELETE__________//
		public void DELETE(String _id) {
			Connection conn = null;
			PreparedStatement ps = null;
			
			String sql = "DELETE FROM "+MemberstableName + " WHERE _id = ?;";
			conn = getConn();
			try {
				ps = conn.prepareStatement(sql);
				ps.setString(1, _id);
				ps.executeUpdate();
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
				e.printStackTrace();
			}
		}
    }

 

LibrarySystem_DTO 생성자

public class LibrarySystem_DTO {
	String _id;
	String num;
	String name;
	String phone;
	String temp;
	String identity;
	
	public LibrarySystem_DTO() {
		// TODO Auto-generated constructor stub
	}
	
	public LibrarySystem_DTO(String _id) {
		this._id = _id;
	}
	
	public LibrarySystem_DTO(String num, String name, String phone, String temp, String identity ) {
		this.num = num;
		this.name = name;
		this.phone = phone;
		this.temp = temp;
		this.identity = identity;
	}
	
	public LibrarySystem_DTO(String _id , String num, String name, String phone, String temp, String identity ) {
		this._id = _id;
		this.num = num;
		this.name = name;
		this.phone = phone;
		this.temp = temp;
		this.identity = identity;
	}
 }