KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > smile > stored > s_deleteRelatedLinkByItemID


1 package smile.stored;
2
3 import java.util.*;
4 import java.sql.*;
5
6 /**
7  * s_deleteRelatedLinkByItemID is an implements the ProcedureInterface and is a
8  * sub-class of StoredProcedure. This class deletes a related link from the
9  * database.
10  *
11  * Copyright 2002 Smile Les motoristes Internet http://www.smile.fr/ Contact
12  * cofax@smile.fr for further information
13  *
14  * @author Smile Les motoristes Internet
15  *
16  */
17 public class s_deleteRelatedLinkByItemID extends StoredProcedure implements ProcedureInterface {
18
19     // proprietes propres a cette stored proc
20 String JavaDoc itemID;
21
22     String JavaDoc link;
23
24     public s_deleteRelatedLinkByItemID() {
25     }
26
27     public void init(HashMap initData, Connection con) {
28         // on initialise le hashmap de donnees et la connection de l'objet
29 super.init(initData, con);
30         // on initialise les propprietes de l'objet
31 itemID = utils.getString(data, "ITEMID", "");
32         link = utils.getString(data, "LINK", "");
33     }
34
35     public void checkParams() throws SQLException {
36         if (itemID.equals("") || link.equals("")) {
37             throw new SQLException("ERROR: REQUIRED FIELDS WERE NOT SENT.");
38         }
39
40     }
41
42     public void checkAction() throws SQLException {
43     }
44
45     public void executeAction() throws SQLException {
46
47         StringBuffer JavaDoc v_sb = new StringBuffer JavaDoc();
48         v_sb.append("DELETE from tblrelatedlinks").append(" WHERE itemID = '" + itemID + "'").append(" AND link = '" + link + "'");
49
50         execStatement(v_sb.toString());
51
52         StringBuffer JavaDoc v_sbUpdate = new StringBuffer JavaDoc();
53         v_sbUpdate.append("UPDATE tblarticles ").append(" SET updateDate = '" + sdf.format(new java.util.Date JavaDoc()) + "' ").append(
54                 " WHERE itemID = '" + itemID + "'");
55
56         execStatement(v_sbUpdate.toString());
57
58         execStatementToRS(queryResultOk);
59
60     }
61 }
Popular Tags