1 package com.knowgate.training; 2 3 34 35 import java.util.Date ; 36 import java.sql.SQLException ; 37 import java.sql.PreparedStatement ; 38 import java.sql.CallableStatement ; 39 import java.sql.ResultSet ; 40 41 import com.knowgate.jdc.JDCConnection; 42 import com.knowgate.acl.ACLUser; 43 import com.knowgate.dataobjs.DB; 44 import com.knowgate.dataobjs.DBPersist; 45 import com.knowgate.crm.Contact; 46 import com.knowgate.misc.Gadgets; 47 48 53 54 public class Absentism extends DBPersist { 55 56 public Absentism() { 57 super(DB.k_absentisms, "Absentism"); 58 } 59 60 public Absentism(String sGuAbsentism) { 61 super(DB.k_absentisms, "Absentism"); 62 put(DB.gu_absentism, sGuAbsentism); 63 } 64 65 public Absentism(JDCConnection oConn, String sGuAbsentism) 66 throws SQLException { 67 super(DB.k_absentisms, "Absentism"); 68 load(oConn, new Object []{sGuAbsentism}); 69 } 70 71 73 public AcademicCourseAlumni getAlumni(JDCConnection oConn) throws SQLException { 74 AcademicCourseAlumni oAlmn; 75 if (isNull(DB.gu_alumni) || isNull(DB.gu_acourse)) { 76 oAlmn = null; 77 } else { 78 oAlmn = new AcademicCourseAlumni(); 79 if (!oAlmn.load(oConn, new Object []{get(DB.gu_acourse),get(DB.gu_alumni)})) 80 oAlmn = null; 81 } return oAlmn; 83 } 85 87 public Contact getContact(JDCConnection oConn) throws SQLException { 88 AcademicCourseAlumni oAlmn = getAlumni(oConn); 89 if (null==oAlmn) 90 return null; 91 else 92 return oAlmn.getContact(oConn); 93 } 95 97 public AcademicCourse getAcademicCourse(JDCConnection oConn) throws SQLException { 98 AcademicCourse oAcrs; 99 if (isNull(DB.gu_acourse)) { 100 oAcrs = null; 101 } else { 102 oAcrs = new AcademicCourse(); 103 if (!oAcrs.load(oConn, new Object []{get(DB.gu_acourse)})) 104 oAcrs = null; 105 } return oAcrs; 107 } 109 111 public Subject getSubject(JDCConnection oConn) throws SQLException { 112 Subject oSbjct; 113 if (isNull(DB.gu_subject)) { 114 oSbjct = null; 115 } else { 116 oSbjct = new Subject(); 117 if (!oSbjct.load(oConn, new Object []{get(DB.gu_subject)})) 118 oSbjct = null; 119 } return oSbjct; 121 } 123 125 public ACLUser getWriter(JDCConnection oConn) throws SQLException { 126 ACLUser oUsr = new ACLUser(); 127 if (!oUsr.load(oConn, new Object []{get(DB.gu_writer)})) 128 oUsr = null; 129 return oUsr; 130 } 132 134 public boolean store(JDCConnection oConn) throws SQLException { 135 if (!AllVals.containsKey(DB.dt_modified)) 136 AllVals.put(DB.dt_modified, new Date ()); 137 if (!AllVals.containsKey(DB.gu_absentism)) 138 AllVals.put(DB.gu_absentism, Gadgets.generateUUID()); 139 return super.store(oConn); 140 } 141 142 144 public boolean delete(JDCConnection oConn) throws SQLException { 145 return Absentism.delete(oConn, getString(DB.gu_absentism)); 146 } 147 148 150 public static boolean delete (JDCConnection oConn, String sGuAbsentism) 151 throws SQLException { 152 PreparedStatement oStmt = oConn.prepareStatement("DELETE FROM "+DB.k_absentisms+" WHERE "+DB.gu_absentism+"=?"); 153 oStmt.setString(1, sGuAbsentism); 154 int iAffected = oStmt.executeUpdate(); 155 oStmt.close(); 156 return (iAffected!=0); 157 } 158 159 162 public static final short ClassId = 64; 163 164 } 165
| Popular Tags
|