{"id":438,"date":"2017-08-02T15:36:44","date_gmt":"2017-08-02T15:36:44","guid":{"rendered":"http:\/\/happily70.dothome.co.kr\/?p=438"},"modified":"2017-08-02T15:36:44","modified_gmt":"2017-08-02T15:36:44","slug":"dto-%ec%99%80-dao","status":"publish","type":"post","link":"http:\/\/happily70.dothome.co.kr\/?p=438","title":{"rendered":"DTO \uc640 DAO"},"content":{"rendered":"

DAO(Data Access Object)<\/strong>\ub294 DB\ub97c \uc0ac\uc6a9\ud574 \ub370\uc774\ud130\ub97c \uc870\ud654\ud558\uac70\ub098 \uc870\uc791\ud558\ub294 \uae30\ub2a5\uc744
\n\uc804\ub2f4\ud558\ub3c4\ub85d \ub9cc\ub4e0 \uc624\ube0c\uc81d\ud2b8\ub97c \ub9d0\ud55c\ub2e4.<\/p>\n

\uc0ac\uc6a9\uc790\ub294 \uc790\uc2e0\uc774 \ud544\uc694\ud55c Interface\ub97c DAO\uc5d0\uac8c \ub358\uc9c0\uace0 DAO\ub294 \uc774 \uc778\ud130\ud398\uc774\uc2a4\ub97c
\n\uad6c\ud604\ud55c \uac1d\uccb4\ub97c \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud3b8\ub9ac\ud558\uac8c \uc0ac\uc6a9 \ud560 \uc218 \uc788\ub3c4\ub85d \ubc18\ud658\ud574\uc90d\ub2c8\ub2e4.<\/p>\n

DB\uc5d0 \ub300\ud55c \uc811\uadfc\uc744 DAO\uac00 \ub2f4\ub2f9\ud558\ub3c4\ub85d \ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d1\uc138\uc2a4\ub97c DAO\uc5d0\uc11c\ub9cc
\n\ud558\uac8c \ub418\uba74 \ub2e4\uc218\uc758 \uc6d0\uaca9\ud638\ucd9c\uc744 \ud1b5\ud55c \uc624\ubc84\ud5e4\ub4dc\ub97c VO\ub098 DTO\ub97c \ud1b5\ud574 \uc904\uc77c \uc218 \uc788\uace0
\n\ub2e4\uc218\uc758 DB \ud638\ucd9c\ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \ub2e8\uc21c\ud788 \uc77d\uae30\ub9cc \ud558\ub294 \uc5f0\uc0b0\uc774\ubbc0\ub85c
\n\ud2b8\ub79c\uc7ad\uc158 \uac04\uc758 \uc624\ubc84\ud5e4\ub4dc\ub97c \uac10\uc18c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

DTO(Data Transfer Object)<\/strong>\ub294 VO(Value Object)\ub85c \ubc14\uafd4 \ub9d0\ud560 \uc218 \uc788\ub294\ub370
\n\uacc4\uce35\uac04 \ub370\uc774\ud130 \uad50\ud658\uc744 \uc704\ud55c \uc790\ubc14\ube48\uc988\ub97c \ub9d0\ud55c\ub2e4. \uc5ec\uae30\uc11c \ub9d0\ud558\ub294 \uacc4\uce35\uac04\uc758
\n\ucee8\ud2b8\ub864\ub7ec, \ubdf0, \ube44\uc988\ub2c8\uc2a4 \uacc4\uce35, \ud37c\uc2dc\uc2a4\ud134\uc2a4 \uacc4\uce35\uc744 \ub9d0\ud558\uba70 \uac01 \uacc4\uce35\uac04 \ub370\uc774\ud130 \uad50\ud658\uc744
\n\uc704\ud55c \uac1d\uccb4\ub97c DTO \ub610\ub294 VO\ub77c\uace0 \ubd80\ub978\ub2e4.<\/p>\n

\ub300\ud45c\uc801\uc778 DTO\ub85c\ub294 \ud3fc\ub370\uc774\ud130\ube48, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\ube48 \ub4f1\uc774 \uc788\uc73c\uba70, \uac01 \ud3fc\uc694\uc18c\ub098,
\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub808\ucf54\ub4dc\uc758 \ub370\uc774\ud130\ub97c \ub9e4\ud551\ud558\uae30 \uc704\ud55c \ub370\uc774\ud130 \uac1d\uccb4\ub97c \ub9d0\ud55c\ub2e4. \uc989 \ud3fc \ud544\ub4dc\ub4e4\uc758
\n\uc774\ub984\uc744 \uadf8\ub300\ub85c \uac00\uc9c0\uace0 \uc788\ub294 \uc790\ubc14\ube48 \uac1d\uccb4\ub97c \ud3fc \ud544\ub4dc\uc640 \uadf8\ub300\ub85c \ub9e4\ud551\ud558\uc5ec \ube44\uc988\ub2c8\uc2a4 \uacc4\uce35\uc73c\ub85c
\n\ubcf4\ub0bc \ub54c \uc0ac\uc6a9\ud558\ub098\ub2e4. \uc774\ub7f0 \uac1d\uccb4\ub97c DTO\ub77c\uace0 \ubd80\ub974\uba70 VO(Value Object) \ud328\ud134\uc774\ub77c\uace0\ub3c4 \ud55c\ub2e4.
\nVO \ud328\ud134\uc740 \ub370\uc774\ud130 \uc804\ub2ec\uc744 \uc704\ud55c \uac00\uc7a5 \ud6a8\uc728\uc801\uc778 \ubc29\ubc95\uc774\uc9c0\ub9cc, \ud074\ub798\uc2a4 \uc120\uc5b8\uc744 \uc704\ud574 \ub9ce\uc740
\n\ucf54\ub4dc\uac00 \ud544\uc694\ud558\ub2e4\ub294 \ub2e8\uc810\uc774 \uc788\ub2e4.<\/p>\n

\uc77c\ubc18\uc801\uc778 DTO\ub294 \ub85c\uc9c1\uc744 \uac16\uace0 \uc788\uc9c0 \uc54a\ub2e4. \uc21c\uc218\ud55c \ub370\uc774\ud130 \uac1d\uccb4\uc774\uba70 \uc18d\uc0c1\uacfc \uadf8 \uc18d\uc131\uc5d0
\n\uc811\uadfc\ud558\uae30 \uc704\ud55c getter, setter \uba54\uc18c\ub4dc\ub9cc \uac00\uc9c4 \ud074\ub798\uc2a4\ub97c \ub9d0\ud55c\ub2e4. \uc5ec\uae30\uc5d0 \ucd94\uac00\uc801\uc73c\ub85c
\ntoString(), equals(), \ub4f1\uc758 Object \ud074\ub798\uc2a4 \uba54\uc18c\ub4dc\ub97c \uc791\uc131\ud560 \uc218 \uc788\ub2e4.<\/p>\n

\uc989, \uacc4\uce35 \uac04\uc758 \ub370\uc774\ud130 \uc804\ub2ec\uc5d0 \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130 \uac1d\uccb4\ub4e4\uc744 \ub9d0\ud55c\ub2e4.<\/p>\n

1. DTO \ud074\ub798\uc2a4 \uc608\uc81c<\/p>\n

public class DTOBean {<\/p>\n

private String name;<\/p>\n

private int value;<\/p>\n

private String data;<\/p>\n

public String getName() {
\n return name;
\n }<\/p>\n

public void setName(String name) {
\n this.name = name;
\n }<\/p>\n

public int getValue() {
\n return value;
\n }<\/p>\n

public void setValue(int value) {
\n this.value = value;
\n }<\/p>\n

public String getData() {
\n return data;
\n }<\/p>\n

public void setData(String data) {
\n this.data = data;
\n }
\n}<\/p>\n

2. DAO \ud074\ub798\uc2a4 \uc608\uc81c<\/p>\n

\/\/DB\uc640 \uc5f0\uacb0\ud560 Connection\uc744 \uac00\uc838\uc628\ub2e4.
\n\/\/\uc5b4\ub5a4 DB\ub97c \uc0ac\uc6a9\ud560 \uac83\uc774\uba70, \uc5b4\ub5a4 \ub4dc\ub77c\uc774\ube0c\uc640 \ub85c\uadf8\uc778 \uc815\ubcf4\ub97c \uc0ac\uc6a9\ud560 \uac83\uc778\uac00.
\n\/\/\uc791\uc5c5\uc774 \ub05d\ub098\uba74 \uc0ac\uc6a9\ud55c \ub9ac\uc18c\uc2a4\ub97c \uc2dc\uc2a4\ud15c\uc5d0 \ub3cc\ub824\uc900\ub2e4.
\npublic class TestDao {<\/p>\n

public void add(DTOBean dto) throws ClassNotFoundException, SQLException{
\n Class.forName(“com.mysql.jdbc.Driver”);<\/p>\n

Connection c= DriverManager.getConnection(“jdbc:mysql:\/\/localhost\/springbook”, “spring”, “book”);<\/p>\n

PreparedStatement ps = c.prepareStatement(“insert into users(id,name,password) value(?,?,?)”);<\/p>\n

ps.setString(1, dto.getName());
\n ps.setInt(2, dto.getValue());
\n ps.setString(3, dto.getData());<\/p>\n

ps.executeUpdate();<\/p>\n

ps.close();
\n c.close();
\n }
\n}<\/p>\n","protected":false},"excerpt":{"rendered":"

DAO(Data Access Object)\ub294 DB\ub97c \uc0ac\uc6a9\ud574 \ub370\uc774\ud130\ub97c \uc870\ud654\ud558\uac70\ub098 \uc870\uc791\ud558\ub294 \uae30\ub2a5\uc744 \uc804\ub2f4\ud558\ub3c4\ub85d \ub9cc\ub4e0 \uc624\ube0c\uc81d\ud2b8\ub97c \ub9d0\ud55c\ub2e4. \uc0ac\uc6a9\uc790\ub294 \uc790\uc2e0\uc774 \ud544\uc694\ud55c Interface\ub97c DAO\uc5d0\uac8c \ub358\uc9c0\uace0 DAO\ub294 \uc774 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uad6c\ud604\ud55c \uac1d\uccb4\ub97c \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud3b8\ub9ac\ud558\uac8c \uc0ac\uc6a9 \ud560 \uc218 \uc788\ub3c4\ub85d \ubc18\ud658\ud574\uc90d\ub2c8\ub2e4. DB\uc5d0 \ub300\ud55c \uc811\uadfc\uc744 DAO\uac00 \ub2f4\ub2f9\ud558\ub3c4\ub85d \ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d1\uc138\uc2a4\ub97c DAO\uc5d0\uc11c\ub9cc \ud558\uac8c \ub418\uba74 \ub2e4\uc218\uc758 \uc6d0\uaca9\ud638\ucd9c\uc744 \ud1b5\ud55c \uc624\ubc84\ud5e4\ub4dc\ub97c VO\ub098 DTO\ub97c \ud1b5\ud574 \uc904\uc77c \uc218 \uc788\uace0 \ub2e4\uc218\uc758 DB \ud638\ucd9c\ubb38\uc81c\ub97c<\/p>\n