책 삭제할때 책에 딸려있는 즐겨찾기,리뷰 같이삭제

jug112564 · jug112564 · commit f84f2c0e00fe · 2021-12-22T22:38:45.000+09:00
diff --git a/src/view/EditableBookInfo.java b/src/view/EditableBookInfo.java
@@ -137,7 +137,7 @@ public void mouseClicked(MouseEvent e) {
 			@Override
 			public void mouseClicked(MouseEvent e) {
 
-				String sql = "UPDATE BOOK\r\n"
+				String sql1 = "UPDATE BOOK\r\n"
 						+ "SET BOOK_PRE = FALSE\r\n"
 						+ "WHERE BOOK_ISBN = ?;";
 				
@@ -151,17 +151,32 @@ public void mouseClicked(MouseEvent e) {
 						JOptionPane.showMessageDialog(null, "�뿩���� �����Դϴ�.", "���� ���� ����",
 								JOptionPane.ERROR_MESSAGE);
 					} else {
-						PreparedStatement ps = dbConn.conn.prepareStatement(sql);
+						PreparedStatement ps1 = dbConn.conn.prepareStatement(sql1);
 
-						ps.setString(1, book_ISBN);	//���� PK
+						ps1.setString(1, book_ISBN);	//���� PK
 						
-						int count = ps.executeUpdate();
-						if (count == 0) {
+						int count1 = ps1.executeUpdate();
+						
+						//���ã�� ����
+						String sql2="DELETE from FAVORITES\r\n"
+								+ "WHERE FAVORITES.BOOK_ISBN = '"+book_ISBN+"';";
+						PreparedStatement ps2 = dbConn.conn.prepareStatement(sql2);
+						int count2 = ps2.executeUpdate();
+						
+						//���� ����
+						String sql3="DELETE from REVIEW\r\n"
+								+ "WHERE REVIEW.BOOK_ISBN = '"+book_ISBN+"';";
+						PreparedStatement ps3=dbConn.conn.prepareStatement(sql3);
+						int count3 = ps3.executeUpdate();
+						
+						if (count1 == 0||count2==0||count3==0) {
 							JOptionPane.showMessageDialog(null, "���� ������ �����Ͽ����ϴ�.", "���� ���� ����",
 									JOptionPane.ERROR_MESSAGE);
 						} else {
 							JOptionPane.showMessageDialog(null, "���� ������ �����Ͽ����ϴ�.", "���� ���� ����",
 									JOptionPane.NO_OPTION);
+							
+
 						}
 					}
 				} catch (SQLException e1) {
