KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > smile > stored > s_deleteGroupType


1 package smile.stored;
2
3 import java.util.*;
4 import java.sql.*;
5
6 /**
7  * s_deleteGroupType is an implements the ProcedureInterface and is a sub-class
8  * of StoredProcedure. This class deletes security group types 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_deleteGroupType extends StoredProcedure implements ProcedureInterface {
18
19     // proprietes propres a cette stored proc
20 String JavaDoc in_groupTypeID;
21
22     public s_deleteGroupType() {
23     }
24
25     public void init(HashMap initData, Connection con) {
26         // on initialise le hashmap de donnees et la connection de l'objet
27 super.init(initData, con);
28         // on initialise les propprietes de l'objet
29 in_groupTypeID = utils.getString(data, "GROUPTYPEID", "");
30     }
31
32     public void checkAction() throws SQLException {
33     }
34
35     public void checkParams() throws SQLException {
36     }
37
38     public void executeAction() throws SQLException {
39         StringBuffer JavaDoc v_sb = new StringBuffer JavaDoc();
40         v_sb.append("DELETE FROM tblpermgrouptype ").append(" WHERE groupTypeID = '" + in_groupTypeID + "'");
41
42         execStatement(v_sb.toString());
43
44         execStatementToRS(queryResultOk);
45     }
46 }
Popular Tags