s_insertArticleType


1   package smile.stored;
2   
3   import java.util.*;
4   import java.sql.*;
5   
6   /**
7    * s_insertArticleType is an implements the ProcedureInterface and is a
8    * sub-class of StoredProcedure. This class inserts article types in the
9    * database. Copyright 2002 Smile Les motoristes Internet http://www.smile.fr/
10   * Contact cofax@smile.fr for further information
11   * 
12   * @author Smile Les motoristes Internet
13   * @created March 22, 2002
14   */
15  public class s_insertArticleType extends StoredProcedure implements ProcedureInterface {
16  
17      String   articleTypeID;
18  
19      String   pubName;
20  
21      String   articleType;
22  
23      String   articleTypeName;
24  
25      String   articleTypeCategory;
26  
27      String   articleTypeMappingCode;
28  
29      String   articleTypeDisplayOnIndex;
30  
31      String   articleTypeDesc;
32  
33      String   articleTypeImage;
34  
35      String   articleTypeByline;
36  
37      String   articleTypeTitle;
38  
39      String   articleTypeLeadIn;
40  
41      String   articleTypeEmail;
42  
43      String   articleTypeBio;
44  
45      String   articleTypeShirtTail;
46  
47      String   disableArticleType;
48  
49      /**
50       * Constructor for the s_insertArticleType object
51       */
52      public s_insertArticleType() {
53      }
54  
55      /**
56       * Description of the Method
57       * 
58       * @param initData
59       *            Description of the Parameter
60       * @param con
61       *            Description of the Parameter
62       */
63      public void init(HashMap initData, Connection con) {
64          // on initialise le hashmap de donnees et la connection de l'objet
65          super.init(initData, con);
66          // on initialise les propprietes de l'objet
67          articleTypeID = utils.getString(data, "ARTICLETYPEID", "");
68          pubName = utils.getString(data, "PUBNAME", "");
69          articleType = utils.getString(data, "ARTICLETYPE", "");
70          articleTypeName = utils.getString(data, "ARTICLETYPENAME", "");
71          articleTypeCategory = utils.getString(data, "ARTICLETYPECATEGORY", "");
72          articleTypeMappingCode = utils.getString(data, "ARTICLETYPEMAPPINGCODE", "");
73          articleTypeDisplayOnIndex = utils.getString(data, "ARTICLETYPEDISPLAYONINDEX", "1");
74          articleTypeDesc = utils.getString(data, "ARTICLETYPEDESC", "");
75          articleTypeImage = utils.getString(data, "ARTICLETYPEIMAGE", "");
76          articleTypeByline = utils.getString(data, "ARTICLETYPEBYLINE", "");
77          articleTypeTitle = utils.getString(data, "ARTICLETYPETITLE", "");
78          articleTypeLeadIn = utils.getString(data, "ARTICLETYPELEADIN", "");
79          articleTypeEmail = utils.getString(data, "ARTICLETYPEEMAIL", "");
80          articleTypeBio = utils.getString(data, "ARTICLETYPEBIO", "");
81          articleTypeShirtTail = utils.getString(data, "ARTICLETYPESHIRTTAIL", "");
82          disableArticleType = utils.getString(data, "DISABLEARTICLETYPE", "0");
83  
84      }
85  
86      /**
87       * Description of the Method
88       * 
89       * @exception SQLException
90       *                Description of the Exception
91       */
92      public void checkAction() throws SQLException {
93          execStatementToRS("SELECT * FROM tblarticletypes WHERE articleTypeID =  '" + articleTypeID + "'");
94          if (Integer.parseInt(articleTypeID) > 0 && psResult.next()) {
95              action = "update";
96          } else if (Integer.parseInt(articleTypeID) == 0) {
97              action = "insert";
98          } else {
99              throw new SQLException("ERROR: ARTICLETYPEID DOES NOT EXIST.");
100         }
101         close();
102     }
103 
104     /**
105      * Description of the Method
106      * 
107      * @exception SQLException
108      *                Description of the Exception
109      */
110     public void checkParams() throws SQLException {
111         if (articleTypeID.equals("") || pubName.equals("") || articleType.equals("") || articleTypeName.equals("") || articleTypeCategory.equals("")
112                 || articleTypeMappingCode.equals("")) {
113             System.err.println("articleTypeID " + articleTypeID);
114             System.err.println("pubName " + pubName);
115             System.err.println("articleType " + articleType);
116             System.err.println("articleTypeName " + articleTypeName);
117             System.err.println("articleTypeCategory " + articleTypeCategory);
118             System.err.println("articelTypeMappingCode " + articleTypeMappingCode);
119             throw new SQLException("ERROR: REQUIRED FIELDS WERE NOT SENT.");
120         }
121 
122         execStatementToRS("SELECT * FROM tblpublications WHERE pubName = '" + pubName + "'");
123         if (!psResult.next()) {
124             throw new SQLException("ERROR: PUBLICATION DOES NOT EXIST.");
125         }
126         close();
127         // FX : clause FROM modified to look at the right table.
128         execStatementToRS("SELECT distinct articleTypeCategory FROM tblarticletypecategories WHERE  articleTypeCategory = '" + articleTypeCategory + "'");
129         if (!psResult.next()) {
130             throw new SQLException("ERROR: CATEGORY CODE DOES NOT EXIST.");
131         }
132         close();
133 
134         execStatementToRS("SELECT distinct mappingCode FROM tblsections WHERE mappingCode = '" + articleTypeMappingCode + "'");
135         if (!psResult.next()) {
136             throw new SQLException("ERROR: MAPPING CODE DOES NOT EXIST.");
137         }
138         close();
139     }
140 
141     /**
142      * Description of the Method
143      * 
144      * @exception SQLException
145      *                Description of the Exception
146      */
147     public void executeAction() throws SQLException {
148         if (action.equals("update")) {
149             StringBuffer   v_sb = new StringBuffer  ();
150             v_sb.append("UPDATE tblarticletypes").append(" SET pubName = '" + pubName + "',").append(" articleType = '" + articleType + "',").append(
151                     " articleTypeName = '" + articleTypeName + "',").append(" articleTypeCategory = '" + articleTypeCategory + "',").append(
152                     " articleTypeMappingCode = '" + articleTypeMappingCode + "',").append(" articleTypeDisplayOnIndex = '" + articleTypeDisplayOnIndex + "',")
153                     .append(" articleTypeDesc = '" + articleTypeDesc + "',").append(" articleTypeImage = '" + articleTypeImage + "',").append(
154                             " articleTypeByline = '" + articleTypeByline + "',").append(" articleTypeTitle = '" + articleTypeTitle + "',").append(
155                             " articleTypeLeadIn = '" + articleTypeLeadIn + "',").append(" articleTypeEmail = '" + articleTypeEmail + "',").append(
156                             " articleTypeBio = '" + articleTypeBio + "',").append(" articleTypeShirtTail = '" + articleTypeShirtTail + "',").append(
157                             " disableArticleType = '" + disableArticleType + "',")
158                     .append(" articleTypeUpdateDate = '" + sdf.format(new java.util.Date  ()) + "'").append(" WHERE articleTypeID  = '" + articleTypeID + "'");
159 
160             execStatement(v_sb.toString());
161         } else if (action.equals("insert")) {
162             StringBuffer   v_sb = new StringBuffer  ();
163             v_sb.append("INSERT INTO tblarticletypes ").append("(pubName,").append("articleType,").append("articleTypeName,").append("articleTypeCategory,")
164                     .append("articleTypeMappingCode,").append("articleTypeDisplayOnIndex,").append("articleTypeDesc,").append("articleTypeImage,").append(
165                             "articleTypeByline,").append("articleTypeTitle,").append("articleTypeLeadIn,").append("articleTypeEmail,")
166                     .append("articleTypeBio,").append("articleTypeShirtTail,").append("disableArticleType,").append("articleTypeUpdateDate)").append(
167                             " VALUES ('" + pubName + "',").append("'" + articleType + "',").append("'" + articleTypeName + "',").append(
168                             "'" + articleTypeCategory + "',").append("'" + articleTypeMappingCode + "',").append("'" + articleTypeDisplayOnIndex + "',")
169                     .append("'" + articleTypeDesc + "',").append("'" + articleTypeImage + "',").append("'" + articleTypeByline + "',").append(
170                             "'" + articleTypeTitle + "',").append("'" + articleTypeLeadIn + "',").append("'" + articleTypeEmail + "',").append(
171                             "'" + articleTypeBio + "',").append("'" + articleTypeShirtTail + "',").append("'" + disableArticleType + "',").append(
172                             "'" + sdf.format(new java.util.Date  ()) + "')");
173 
174             execStatement(v_sb.toString());
175         }
176         execStatementToRS(queryResultOk);
177     }
178 }
179
A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame
Popular Tags