JAVA DB SQLITE INSERT

메인 코드

메인 메서드에서 값을 DTO클레스에 있는 생성자로 보내준 후 LibrarySystem_DAO클레스에서 DTO에 임시 저장한 값들을 Insert매서드로 가져와 sql 구문을 이용해 데이터를 저장하게 된다.

	case "추가":
			_id = tfID.getText();
			num = tfNum.getText();
			name = tfName.getText();
			phone = tfPhone.getText();
			temp = tfTemp.getText();
			identity = tfIdentity.getText();

			
			LibrarySystem_DTO dto = new LibrarySystem_DTO(num,name,phone,temp,identity);
			
			dao = new LibrarySystem_DAO();
			dao.Insert(dto);

Insert 매서드

	//__________INSERT__________//
	public void Insert(LibrarySystem_DTO dto) {
		Connection conn = null;
		PreparedStatement ps = null;

		conn = getConn();
		String sql = "INSERT INTO "+MemberstableName + "(num, name, phone, temp, identity) VALUES (?,?,?,?,?);";
		
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, dto.num);
			ps.setString(2, dto.name);
			ps.setString(3, dto.phone);
			ps.setString(4, dto.temp);
			ps.setString(5, dto.identity);
			
			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;
	}
 }