Run
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 | package bank1013; import java.util.Scanner; public class BankRun { public static void main(String[] args) { Scanner sc = new Scanner(System.in); BankService se = new BankService(); boolean run = true; while(run) { System.out.println("================================================="); System.out.println("\t잘오셨습니다~~ 통장 텅텅빈 현우의 수입지출명부입니다"); System.out.println("================================================="); System.out.println("1.수입 입력 2.지출 입력 3.조회 4.잔고 5.수정 6.삭제 7.종료"); int no = sc.nextInt(); if(no < 1 || no > 6)break; switch (no) { case 1: // 수입 입력 se.suip(); break; case 2: // 지출 입력 se.jichul(); break; case 3: // 조회 se.list(); break; case 4: // 잔고 se.balance(); break; case 5: // 수정 se.update(); break; case 6: // 삭제 se.delete(); break; } } System.out.println("================================================="); System.out.println("\t 오늘도 고생하셨습니다 또 작성하시려면 들러주세요 !!"); System.out.println("================================================="); sc.close(); } } | cs |
VO
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 | package bank1013; public class BankVO { private int idx; private int suip; private int jichul; private String wdate; private String bigo; private String upaf; private int upaf2; private String upbe; public String getUpaf() { return upaf; } public void setUpaf(String upaf) { this.upaf = upaf; } public int getUpaf2() { return upaf2; } public void setUpaf2(int upaf2) { this.upaf2 = upaf2; } public String getUpbe() { return upbe; } public void setUpbe(String upbe) { this.upbe = upbe; } private int balance; public int getIdx() { return idx; } public void setIdx(int idx) { this.idx = idx; } public int getSuip() { return suip; } public void setSuip(int suip) { this.suip = suip; } public int getJichul() { return jichul; } public void setJichul(int jichul) { this.jichul = jichul; } public String getWdate() { return wdate; } public void setWdate(String wdate) { this.wdate = wdate; } public String getBigo() { return bigo; } public void setBigo(String bigo) { this.bigo = bigo; } public int getBalance() { return balance; } public void setBalance(int balance) { this.balance = balance; } @Override public String toString() { return "BankVO [idx=" + idx + ", suip=" + suip + ", jichul=" + jichul + ", wdate=" + wdate + ", bigo=" + bigo + ", upaf=" + upaf + ", upaf2=" + upaf2 + ", upbe=" + upbe + ", balance=" + balance + "]"; } } | cs |
Service
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 | package bank1013; import java.util.ArrayList; import java.util.Scanner; public class BankService { Scanner sc = new Scanner(System.in); BankDAO dao = new BankDAO(); BankVO vo = new BankVO(); public void suip() { System.out.println("\t*수입*"); System.out.println("금액을 입력해주세요"); vo.setSuip(sc.nextInt()); System.out.println("날짜를 입력해주세요"); vo.setWdate(sc.next()); System.out.println("비고를 입력해주세요"); vo.setBigo(sc.next()); dao.suip(vo); } public void jichul() { System.out.println("\t*지출*"); System.out.println("금액을 입력해주세요"); vo.setJichul(sc.nextInt()); System.out.println("날짜를 입력해주세요"); vo.setWdate(sc.next()); System.out.println("비고를 입력해주세요"); vo.setBigo(sc.next()); dao.jichul(vo); } public void list() { ArrayList<BankVO> vos = null; BankVO vo = new BankVO(); System.out.println("어떤걸 조회하실건가요?"); System.out.println("-------------------------------------------------"); System.out.println("1.전체조회 2.날짜별조회 3.수입만조회 4.지출만조회 5.용돈조회"); int no = sc.nextInt(); System.out.println("-------------------------------------------------"); while(true) { if(no == 1) { System.out.println("전체내역을 출력하겠습니까? 아니면 다시 선택하시겠습니까? 1.내역 2.초기선택창");int in = sc.nextInt(); if(in == 2) { return; } else { System.out.println("번호\t수입\t지출\t날짜\t\t잔고\t비고"); vos = dao.list1(); for(int i = 0; i < vos.size(); i++) { vo = vos.get(i); System.out.print(vo.getIdx()+"\t"+vo.getSuip()+"\t"+vo.getJichul()+"\t"+vo.getWdate().substring(0,10)+"\t"+vo.getBalance()+"\t"+vo.getBigo()); System.out.println(); } return; } } else if(no == 2) { System.out.println("날짜별내역만 출력하겠습니까? 아니면 다시 선택하시겠습니까? 1.내역 2.초기선택창");int in = sc.nextInt(); if(in == 2) { return; } else { System.out.println("언제적 나의 흔적을 보고싶은거지? yyyy-mm-dd 형식으로 입력해주세요");vo.setWdate(sc.next()); System.out.println("-------------------------------------------------"); System.out.println("번호\t수입\t지출\t날짜\t\t비고"); vos = dao.list2(vo); for(int i = 0; i < vos.size(); i++) { vo = vos.get(i); System.out.println(vo.getIdx()+"\t"+vo.getSuip()+"\t"+vo.getJichul()+"\t"+vo.getWdate().substring(0,10 )+"\t"+vo.getBigo()); } System.out.println("-------------------------------------------------"); return; } } else if(no == 3) { System.out.println("수입내역만 출력하겠습니까? 아니면 다시 선택하시겠습니까? 1.내역 2.초기선택창");int in = sc.nextInt(); if(in == 2) { return; } else { System.out.println("\t**수입내역** "); System.out.println("-------------------------------------------------"); System.out.println("번호\t수입\t날짜\t\t비고"); vos = dao.list3(); for(int i = 0; i < vos.size(); i++) { vo = vos.get(i); System.out.println(vo.getIdx()+"\t"+vo.getSuip()+"\t"+vo.getWdate().substring(0,10)+"\t"+vo.getBigo()); } System.out.println("-------------------------------------------------"); return; } } else if(no == 4) { System.out.println("지출내역만 출력하겠습니까? 아니면 다시 선택하시겠습니까? 1.내역 2.초기선택창");int in = sc.nextInt(); if(in == 2) { return; } else { System.out.println("\t**지출내역** "); System.out.println("-------------------------------------------------"); System.out.println("번호\t지출\t날짜\t\t비고"); vos = dao.list4(); for(int i = 0; i < vos.size(); i++) { vo = vos.get(i); System.out.println(vo.getIdx()+"\t"+vo.getJichul()+"\t"+vo.getWdate().substring(0,10)+"\t"+vo.getBigo()); } System.out.println("-------------------------------------------------"); return; } } else if(no == 5) { System.out.println("용돈내역만 출력하겠습니까? 아니면 다시 선택하시겠습니까? 1.내역 2.초기선택창");int in = sc.nextInt(); if(in == 2) { return; } else { System.out.println("\t**용돈내역** "); System.out.println("-------------------------------------------------"); System.out.println("번호\t수입\t지출\t날짜\t\t비고"); vos = dao.list5(); for(int i = 0; i < vos.size(); i++) { vo = vos.get(i); System.out.println(vo.getIdx()+"\t"+vo.getSuip()+"\t"+vo.getJichul()+"\t"+vo.getWdate().substring(0,10)+"\t"+vo.getBigo()); } System.out.println("-------------------------------------------------"); return; } } } } public void balance() { int sumsuip = dao.su(); int sumjichul = dao.su2(); int sum = sumsuip - sumjichul; if(sum < 0) sum = 0; System.out.println("================================================"); System.out.println("현재 총 잔액 : " +String.format("%,10d", sum)+"원"); System.out.println("================================================"); } public void update() { BankVO vo = new BankVO(); System.out.println("수정하러 들어온거 맞죠? 맞다면 '1' 아니라면 '2'입력"); int in = sc.nextInt(); if(in == 2) { return; } else { ArrayList<BankVO> vos = new ArrayList<>(); vos = dao.list1(); System.out.println("번호\t수입\t지출\t날짜\t잔고\t비고"); for(int i = 0; i < vos.size(); i++) { vo = vos.get(i); System.out.print(vo.getIdx()+"\t"+vo.getSuip()+"\t"+vo.getJichul()+"\t"+vo.getWdate().substring(0,10)+"\t"+vo.getBalance()+"\t"+vo.getBigo()); System.out.println(); } System.out.println("어떤걸 수정하실거죠? 번호 입력해주세요"); vo.setIdx(sc.nextInt()); System.out.println("어떤걸 수정할실지 입력해주세요"); System.out.println("1.수입 2.지출 3.날짜 4.비고"); String upbe = sc.next(); if(upbe.equals("수입") || upbe.equals("1")) { System.out.println("수입내역의 수정하실 내용을 입력해주세요 숫자만 입력해주세요"); vo.setUpaf2(sc.nextInt()); dao.update1(vo); } else if(upbe.equals("지출")|| upbe.equals("2")) { System.out.println("지출내역의 수정하실 내용을 입력해주세요 숫자만 입력해주세요"); vo.setUpaf2(sc.nextInt()); dao.update2(vo); } else if(upbe.equals("날짜")|| upbe.equals("3")) { System.out.println("수정하실 날짜를 입력해주세요 yyyy-mm-dd 형식으로 입력해주세요"); String upin = sc.next(); vo.setUpaf(upin); dao.update3(vo); } else if(upbe.equals("비고")|| upbe.equals("4")) { System.out.println("어떻게 비고를 수정하실지 입력해주세요 (최대 50자 이내)"); vo.setUpaf(sc.next()); dao.update4(vo); } return; } } public void delete() { BankVO vo = new BankVO(); System.out.println("삭제하러 들어온거 맞죠? 맞다면 '1' 아니라면 '2'입력"); int in = sc.nextInt(); if(in == 2) { return; } else { ArrayList<BankVO> vos = new ArrayList<>(); vos = dao.list1(); System.out.println("번호\t수입\t지출\t날짜\t\t잔고\t비고"); for(int i = 0; i < vos.size(); i++) { vo = vos.get(i); System.out.print(vo.getIdx()+"\t"+vo.getSuip()+"\t"+vo.getJichul()+"\t"+vo.getWdate().substring(0,10)+"\t"+vo.getBalance()+"\t"+vo.getBigo()); System.out.println(); } System.out.println("어떤걸 삭제하실거죠? 번호 입력해주세요"); vo.setIdx(sc.nextInt()); System.out.println("정말로 "+vo.getIdx()+"번 자료를 삭제하시겠습니까? Y/N"); String yn = sc.next().toUpperCase(); if(yn.equals("N"))return; else { dao.delete(vo); } } } } | cs |
DAO
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 | package bank1013; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; public class BankDAO { Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; String sql = ""; BankVO vo = null; public BankDAO() { try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/javaworks"; String user = "javaworks"; String pwd = "1234"; conn = DriverManager.getConnection(url, user, pwd); } catch (ClassNotFoundException e) { System.out.println("드라이버 못찾음"); } catch (SQLException e) { System.out.println("DB 연동 실패"); } } public void connClose() { try { conn.close(); } catch (SQLException e) {} } public void pstmtClose() { if(pstmt != null) { try { pstmt.close(); } catch (SQLException e) {} } } public void rsClose() { if(rs != null) { try { rs.close(); pstmt.close(); } catch (SQLException e) {} } } // 수입 저장 입력 public void suip(BankVO vo) { try { sql = "insert into bank (suip,wdate,bigo) values(?,?,?)"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, vo.getSuip()); pstmt.setString(2, vo.getWdate()); pstmt.setString(3, vo.getBigo()); pstmt.executeUpdate(); System.out.println("저장되었습니다"); } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { pstmtClose(); } } public void jichul(BankVO vo) { try { sql = "insert into bank (jichul,wdate,bigo) values(?,?,?)"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, vo.getJichul()); pstmt.setString(2, vo.getWdate()); pstmt.setString(3, vo.getBigo()); pstmt.executeUpdate(); System.out.println("저장되었습니다"); } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { pstmtClose(); } } // 전체조회 public ArrayList<BankVO> list1() { ArrayList<BankVO> vos = new ArrayList<>(); try { sql = "select * from bank order by idx"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()) { BankVO vo = new BankVO(); vo.setIdx(rs.getInt("idx")); vo.setSuip(rs.getInt("suip")); vo.setJichul(rs.getInt("jichul")); vo.setWdate(rs.getString("wdate")); vo.setBigo(rs.getString("bigo")); vos.add(vo); } } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { rsClose(); } return vos; } // 날짜별조회 public ArrayList<BankVO> list2(BankVO vo) { ArrayList<BankVO> vos = new ArrayList<>(); try { sql = "select * from bank where wdate = ? order by idx"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, vo.getWdate()); rs = pstmt.executeQuery(); while(rs.next()) { vo = new BankVO(); vo.setIdx(rs.getInt("idx")); vo.setSuip(rs.getInt("suip")); vo.setJichul(rs.getInt("jichul")); vo.setWdate(rs.getString("wdate")); vo.setBigo(rs.getString("bigo")); vos.add(vo); } } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { rsClose(); } return vos; } //수입 내역만 조회 public ArrayList<BankVO> list3() { ArrayList<BankVO> vos = new ArrayList<>(); sql = "select idx,suip,wdate,bigo from bank where suip > 0"; try { pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()) { vo = new BankVO(); vo.setIdx(rs.getInt("idx")); vo.setSuip(rs.getInt("suip")); vo.setWdate(rs.getString("wdate")); vo.setBigo(rs.getString("bigo")); vos.add(vo); } } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { rsClose(); } return vos; } //지출내역만 조회 public ArrayList<BankVO> list4() { ArrayList<BankVO> vos = new ArrayList<>(); sql = "select idx,jichul,wdate,bigo from bank where jichul > 0"; try { pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()) { vo = new BankVO(); vo.setIdx(rs.getInt("idx")); vo.setJichul(rs.getInt("jichul")); vo.setWdate(rs.getString("wdate")); vo.setBigo(rs.getString("bigo")); vos.add(vo); } } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { rsClose(); } return vos; } //비고가 용돈인 내역만 조회 public ArrayList<BankVO> list5() { ArrayList<BankVO> vos = new ArrayList<>(); sql = "select * from bank where bigo = ?"; try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, "용돈"); rs = pstmt.executeQuery(); while(rs.next()) { vo = new BankVO(); vo.setIdx(rs.getInt("idx")); vo.setSuip(rs.getInt("suip")); vo.setJichul(rs.getInt("jichul")); vo.setWdate(rs.getString("wdate")); vo.setBigo(rs.getString("bigo")); vos.add(vo); } } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { rsClose(); } return vos; } //잔고 구하기위한 수입 public int su() { int sumsuip = 0; try { sql = "select sum(suip) as suip from bank "; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); if(rs.next()) { sumsuip += rs.getInt("suip"); } } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { rsClose(); } return sumsuip; } //잔고 구하기위한 지출 public int su2() { int sumjichul = 0; try { sql = "select sum(jichul) as suip from bank "; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); if(rs.next()) { sumjichul += rs.getInt("suip"); } } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { rsClose(); } return sumjichul; } // 수정 수입 public void update1(BankVO vo) { try { sql = "update bank set suip = ? where idx = ?"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, vo.getUpaf2()); pstmt.setInt(2, vo.getIdx()); pstmt.executeUpdate(); System.out.println("성공적으로 수정완료되셨습니다 !!!"); } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { pstmtClose(); } } // 수정 지출 public void update2(BankVO vo) { try { sql = "update bank set jichul = ? where idx = ?"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, vo.getUpaf2()); pstmt.setInt(2, vo.getIdx()); pstmt.executeUpdate(); System.out.println("성공적으로 수정완료되셨습니다 !!!"); } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { pstmtClose(); } } // 수정 날짜 public void update3(BankVO vo) { try { sql = "update bank set wdate = ? where idx = ?"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, vo.getUpaf()); pstmt.setInt(2, vo.getIdx()); pstmt.executeUpdate(); System.out.println("성공적으로 수정완료되셨습니다 !!!"); } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { pstmtClose(); } } // 수정 비고 public void update4(BankVO vo) { try { sql = "update bank set bigo = ? where idx = ?"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, vo.getUpaf()); pstmt.setInt(2, vo.getIdx()); pstmt.executeUpdate(); System.out.println("성공적으로 수정완료되셨습니다 !!!"); } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { pstmtClose(); } } public void delete(BankVO vo) { try { sql = "delete from bank where idx = ?"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, vo.getIdx()); pstmt.executeUpdate(); System.out.println("성공적으로 삭제완료되셨습니다 !!!"); } catch (SQLException e) { System.out.println("SQL에러 : "+e.getMessage()); }finally { pstmtClose(); } } } | cs |
완스엉~
첫댓글 잘 처리 하셨네요.
날짜 내림차순으로 출력처리하면 좋을듯 하고, 전체내용 출력의 줄(열)도 잘 맞춰보시면 좋을것 같고...
잔고에 대한 처리를 하려고 한것 같은데, 완성된다면 더 좋겠죠.
수고하셨습니다.