package uk.ac.ebi.intenz.mapper;
   
   import java.sql.CallableStatement;
   import java.sql.Connection;
   import java.sql.SQLException;
   import java.sql.Types;
   
   /**
    * Provides methods for audit package access.
   *
   * @author Michael Darsow
   * @version $Revision: 1.2 $ $Date: 2008/01/28 12:33:07 $
   */
  public class AuditPackageMapper {
  
    public static final String STANDARD_REMARK = "Update by web application.";
  
    public AuditPackageMapper() {
    }
  
    private String callStatement() {
      return "{CALL enzyme.auditpackage.setremark(?)}";
    }
  
    /**
     * Sets a remark in the audit tables.
     *
     * @param remark Remark to be stored in the audit tables.
     * @param con    The connection.
     * @throws SQLException
     */
    public void setRemark(String remark, Connection con) throws SQLException {
      CallableStatement cStmt = null;
  
      try {
        cStmt = con.prepareCall(callStatement());
        if (remark == null){
      	  cStmt.setNull(1, Types.VARCHAR);
        } else {
      	  cStmt.setString(1, remark);
        }
        cStmt.executeUpdate();
      } finally {
        cStmt.close();
      }
    }
  
  }