KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > smile > stored > s_deleteArticle


1 package smile.stored;
2
3 import java.util.*;
4 import java.sql.*;
5
6 /**
7  * s_deleteArticle is an implements the ProcedureInterface and is a sub-class of
8  * StoredProcedure. This class deletes articles from the database.
9  *
10  * Copyright 2002 Smile Les motoristes Internet http://www.smile.fr/ Contact
11  * cofax@smile.fr for further information
12  *
13  * @author Smile - Badr Chentouf
14  * @author Smile - Matthieu Bureau
15  *
16  */
17
18 public class s_deleteArticle extends StoredProcedure implements ProcedureInterface {
19
20     // proprietes propres a cette stored proc
21 String JavaDoc itemID;
22
23     String JavaDoc filename;
24
25     public s_deleteArticle() {
26     }
27
28     public void init(HashMap initData, Connection con) {
29         // on initialise le hashmap de donnees et la connection de l'objet
30 super.init(initData, con);
31         // on initialise les propprietes de l'objet
32 itemID = utils.getString(data, "ITEMID", "");
33         filename = utils.getString(data, "FILENAME", "");
34     }
35
36     public void checkParams() throws SQLException {
37         if (itemID.equals(""))
38             throw new SQLException("s_deleteArticle: ERROR: required field ITEMID was not sent.");
39     }
40
41     public void checkAction() throws SQLException {
42     }
43
44     public void executeAction() throws SQLException {
45         StringBuffer JavaDoc v_sb = new StringBuffer JavaDoc();
46         v_sb.append("DELETE FROM tblarticlepreload ").append(" WHERE itemID = " + itemID);
47         execStatement(v_sb.toString());
48
49         StringBuffer JavaDoc v_sbDelete1 = new StringBuffer JavaDoc();
50         v_sbDelete1.append("DELETE FROM tblarticleorder ").append("where itemID = " + itemID);
51         execStatement(v_sbDelete1.toString());
52
53         StringBuffer JavaDoc v_sbDelete3 = new StringBuffer JavaDoc();
54         v_sbDelete3.append("DELETE FROM tblarticles ").append("where itemID = " + itemID);
55         execStatement(v_sbDelete3.toString());
56
57         StringBuffer JavaDoc v_sbDelete4 = new StringBuffer JavaDoc();
58         v_sbDelete4.append("DELETE FROM tblmultimedia ").append("where itemID = " + itemID);
59         execStatement(v_sbDelete4.toString());
60
61         StringBuffer JavaDoc v_sbDelete5 = new StringBuffer JavaDoc();
62         v_sbDelete5.append("DELETE FROM tblrelatedlinks WHERE link LIKE '%" + filename + ".htm' ");
63         execStatement(v_sbDelete5.toString());
64
65         StringBuffer JavaDoc v_sbDelete6 = new StringBuffer JavaDoc();
66         v_sbDelete6.append("DELETE FROM tblrelatedlinks ").append("where itemID = " + itemID);
67         execStatement(v_sbDelete6.toString());
68
69         execStatementToRS(queryResultOk);
70     }
71 }
Popular Tags