01: /*
02: Copyright (C) 2003 Know Gate S.L. All rights reserved.
03: C/Oņa, 107 1š2 28050 Madrid (Spain)
04:
05: Redistribution and use in source and binary forms, with or without
06: modification, are permitted provided that the following conditions
07: are met:
08:
09: 1. Redistributions of source code must retain the above copyright
10: notice, this list of conditions and the following disclaimer.
11:
12: 2. The end-user documentation included with the redistribution,
13: if any, must include the following acknowledgment:
14: "This product includes software parts from hipergate
15: (http://www.hipergate.org/)."
16: Alternately, this acknowledgment may appear in the software itself,
17: if and wherever such third-party acknowledgments normally appear.
18:
19: 3. The name hipergate must not be used to endorse or promote products
20: derived from this software without prior written permission.
21: Products derived from this software may not be called hipergate,
22: nor may hipergate appear in their name, without prior written
23: permission.
24:
25: This library is distributed in the hope that it will be useful,
26: but WITHOUT ANY WARRANTY; without even the implied warranty of
27: MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
28:
29: You should have received a copy of hipergate License with this code;
30: if not, visit http://www.hipergate.org or mail to info@hipergate.org
31: */
32:
33: package com.knowgate.addrbook;
34:
35: import java.sql.SQLException;
36: import java.sql.PreparedStatement;
37:
38: import com.knowgate.debug.DebugFile;
39: import com.knowgate.jdc.JDCConnection;
40: import com.knowgate.dataobjs.DB;
41: import com.knowgate.dataobjs.DBPersist;
42:
43: /**
44: * @author Sergio Montoro Ten
45: * @version 1.0
46: */
47:
48: public class FellowTitle extends DBPersist {
49:
50: public FellowTitle() {
51: super (DB.k_lu_fellow_titles, "FellowTitle");
52: }
53:
54: public FellowTitle(String sIdWorkArea, String sDeTitle) {
55: super (DB.k_lu_fellow_titles, "FellowTitle");
56:
57: put(DB.gu_workarea, sIdWorkArea);
58: put(DB.de_title, sDeTitle);
59: }
60:
61: public boolean delete(JDCConnection oConn) throws SQLException {
62: PreparedStatement oStmt;
63: String sSQL = "UPDATE " + DB.k_lu_fellow_titles + " SET "
64: + DB.id_boss + "=NULL WHERE " + DB.id_boss + "=?";
65:
66: if (DebugFile.trace)
67: DebugFile.writeln("Connection.prepareStatement(" + sSQL
68: + ")");
69:
70: oStmt = oConn.prepareStatement(sSQL);
71: oStmt.setString(1, getString(DB.de_title));
72: oStmt.executeUpdate();
73: oStmt.close();
74:
75: return super .delete(oConn);
76: } // delete
77:
78: }
|