JDBC(주소록 프로그램 개발)

이번 글에서는 주소록 프로그램을 개발 해 볼 것입니다.

1. 주소록 목록 화면 만들기

2. 주소로 스타일시트

3. 주소록 입력 화면 만들기

4. 주소록 수정 화면 만들기

5. 데이터베이스 테이블 생성

6. 오류 처리 화면 만들기

7. AddrBook 클래스 만들기

package jspbook;

import java.sql.*;

import java.util.*;

public class AddrBean { 

Connection conn = null;

PreparedStatement pstmt = null;

String jdbc_driver = "com.mysql.jdbc.Driver";

String jdbc_url = "jdbc:mysql://127.0.0.1:3306/jspdb"; 

void connect() {

try {

Class.forName(jdbc_driver);

conn = DriverManager.getConnection(jdbc_url,"jspbook"," ");

} catch (Exception e) {

e.printStackTrace();

}

}

void disconnect() {

if(pstmt != null) {

try {

pstmt.close();

} catch (SQLException e) {

e.printStackTrace();

}

} 

if(conn != null) {

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public boolean updateDB(AddrBook addrbook) {

connect();

String sql ="update addrbook set ab_name=?, ab_email=?, ab_birth=?, ab_tel=?, ab_comdept=?, ab_memo=? where ab_id=?";

 

try {

pstmt = conn.prepareStatement(sql);

pstmt.setString(1,addrbook.getAb_name());

pstmt.setString(2,addrbook.getAb_email());

pstmt.setString(3, addrbook.getAb_birth());

pstmt.setString(4,addrbook.getAb_tel());

pstmt.setString(5,addrbook.getAb_comdept());

pstmt.setString(6,addrbook.getAb_memo());

pstmt.setInt(7,addrbook.getAb_id());

pstmt.executeUpdate();

} catch (SQLException e) {

e.printStackTrace();

return false;

}

finally {

disconnect();

}

return true;

}

public boolean deleteDB(int gb_id) {

connect();

String sql ="delete from addrbook where ab_id=?";

try {

pstmt = conn.prepareStatement(sql);

pstmt.setInt(1,gb_id);

pstmt.executeUpdate();

} catch (SQLException e) {

e.printStackTrace();

return false;

}

finally {

disconnect();

}

return true;

}

public boolean insertDB(AddrBook addrbook) {

connect();

String sql ="insert into addrbook(ab_name,ab_email,ab_birth,ab_tel,ab_comdept,ab_memo) values(?,?,?,?,?,?)";

try {

pstmt = conn.prepareStatement(sql);

pstmt.setString(1,addrbook.getAb_name());

pstmt.setString(2,addrbook.getAb_email());

pstmt.setString(3, addrbook.getAb_birth());

pstmt.setString(4,addrbook.getAb_tel());

pstmt.setString(5,addrbook.getAb_comdept());

pstmt.setString(6,addrbook.getAb_memo());

pstmt.executeUpdate();

} catch (SQLException e) {

e.printStackTrace();

return false;

}

finally {

disconnect();

}

return true;

}

public AddrBook getDB(int gb_id) {

connect();

String sql = "select * from addrbook where ab_id=?";

AddrBook addrbook = new AddrBook();

try {

pstmt = conn.prepareStatement(sql);

pstmt.setInt(1,gb_id);

ResultSet rs = pstmt.executeQuery();

// 데이터가 하나만 있으므로 rs.next()를 한번만 실행 한다.

rs.next();

addrbook.setAb_id(rs.getInt("ab_id"));

addrbook.setAb_name(rs.getString("ab_name"));

addrbook.setAb_email(rs.getString("ab_email"));

addrbook.setAb_birth(rs.getString("ab_birth"));

addrbook.setAb_tel(rs.getString("ab_tel"));

addrbook.setAb_comdept(rs.getString("ab_comdept"));

addrbook.setAb_memo(rs.getString("ab_memo"));

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

finally {

disconnect();

}

return addrbook;

}

public ArrayList<AddrBook> getDBList() {

connect();

ArrayList<AddrBook> datas = new ArrayList<AddrBook>();

String sql = "select * from addrbook order by ab_id desc";

try {

pstmt = conn.prepareStatement(sql);

ResultSet rs = pstmt.executeQuery();

while(rs.next()) {

AddrBook addrbook = new AddrBook();

addrbook.setAb_id(rs.getInt("ab_id"));

addrbook.setAb_name(rs.getString("ab_name"));

addrbook.setAb_email(rs.getString("ab_email"));

addrbook.setAb_comdept(rs.getString("ab_comdept"));

addrbook.setAb_birth(rs.getString("ab_birth"));

addrbook.setAb_tel(rs.getString("ab_tel"));

addrbook.setAb_memo(rs.getString("ab_memo"));

datas.add(addrbook);

}

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

finally {

disconnect();

}

return datas;

}

}