KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > smile > stored > s_deleteMap


1 package smile.stored;
2
3 import java.util.*;
4 import java.sql.*;
5
6 /**
7  * s_deleteMap is an implements the ProcedureInterface and is a sub-class of
8  * StoredProcedure. This class deletes mapping codes (sections) 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_deleteMap extends StoredProcedure implements ProcedureInterface {
18
19     String JavaDoc itemID;
20
21     String JavaDoc mappingCode;
22
23     public s_deleteMap() {
24     }
25
26     public void init(HashMap initData, Connection con) {
27         // on initialise le hashmap de donnees et la connection de l'objet
28 super.init(initData, con);
29         // on initialise les propprietes de l'objet
30 itemID = utils.getString(data, "ITEMID", "");
31         mappingCode = utils.getString(data, "MAPPINGCODE", "");
32     }
33
34     public void checkAction() throws SQLException {
35     }
36
37     public void checkParams() throws SQLException {
38         if (itemID.equals("") || mappingCode.equals("")) {
39             throw new SQLException("ERROR: REQUIRED FIELDS WERE NOT SENT.");
40         }
41     }
42
43     public void executeAction() throws SQLException {
44         StringBuffer JavaDoc v_sb = new StringBuffer JavaDoc();
45         v_sb.append("DELETE FROM tblarticleorder ").append(" WHERE mappingCode = '" + mappingCode + "'").append(" AND itemID = '" + itemID + "'");
46         execStatement(v_sb.toString());
47
48         StringBuffer JavaDoc v_sb2 = new StringBuffer JavaDoc();
49         v_sb2.append("DELETE FROM tblarticlepreload ").append(" WHERE mappingCode = '" + mappingCode + "'").append(" AND itemID = '" + itemID + "'");
50         execStatement(v_sb2.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         execStatementToRS(queryResultOk);
58
59     }
60 }
Popular Tags