KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > smile > stored > s_deleteMultiMedia


1 package smile.stored;
2
3 import java.util.*;
4 import java.sql.*;
5 import java.io.*;
6
7 /**
8  * s_deleteMultimedia is an implements the ProcedureInterface and is a sub-class
9  * of StoredProcedure. This class deletes multimedia from the 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_deleteMultiMedia extends StoredProcedure implements ProcedureInterface {
18
19     // proprietes propres a cette stored proc
20 String JavaDoc idNum;
21
22     String JavaDoc itemID;
23
24     public s_deleteMultiMedia() {
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 proprietes de l'objet
31 idNum = utils.getString(data, "MULTIMEDIAID", "");
32
33     }
34
35     public void checkParams() throws SQLException {
36         if (idNum.equals("")) {
37             throw new SQLException("ERROR: REQUIRED FIELDS WERE NOT SENT.");
38         }
39     }
40
41     public void checkAction() throws SQLException {
42     }
43
44     public void executeAction() throws SQLException {
45
46         StringBuffer JavaDoc v_sbSelect = new StringBuffer JavaDoc();
47         v_sbSelect.append("SELECT DISTINCT itemID").append(" FROM tblmultimedia ").append(" WHERE multimediaID = '" + idNum + "'");
48         itemID = execStatementToValue(v_sbSelect.toString());
49
50         StringBuffer JavaDoc v_sb = new StringBuffer JavaDoc();
51         v_sb.append("DELETE from tblmultimedia ").append("WHERE multimediaID = '" + idNum + "'");
52         execStatement(v_sb.toString());
53
54         StringBuffer JavaDoc v_sbUpdate = new StringBuffer JavaDoc();
55         v_sbUpdate.append("UPDATE tblarticles ").append(" SET UpdateDate = '" + sdf.format(new java.util.Date JavaDoc()) + "'").append(
56                 " WHERE itemID = '" + itemID + "'");
57         execStatement(v_sbUpdate.toString());
58
59         execStatementToRS(queryResultOk);
60
61     }
62 }
Popular Tags