guidocformpersistentbase.java

OA典型例子

  /**
    * Insert a new record
    */
  public void insert(Connection conn) throws SQLException {
    PreparedStatement pstmt = null;
    pstmt = conn.prepareStatement("INSERT INTO GuiDocForm ( docId,docKind,docTitle,CreateDate,creator,createunitId,secret,emergency,saveTime,docNoPre,yearNo,waterNo,publishPerson,publishDate,allSignPerson,dealPerson,checkPerson,printUnit,printDate,mainDealUnit,sendTo,cc,reportTo,inerTo,subject,allUnit,sendUnitName,sendUnitId,sendTime,sendPerson,sealTime,sealPerson,sealName,signTime,signPerson,filePages,attachmentPages,printnumber,guiUnitId,guiPerson,guiDate,guiId,guiType,status,receiveType,receiveDate,memo,sendDocId ) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )");
    pstmt.setInt ( 1, bean.getDocId().intValue() );
    pstmt.setString ( 2, bean.getDocKind() );
    pstmt.setString ( 3, bean.getDocTitle() );
    pstmt.setTimestamp ( 4, new java.sql.Timestamp ( bean.getCreateDate ().getTime() ) );
    pstmt.setString ( 5, bean.getCreator() );
    pstmt.setString ( 6, bean.getCreateUnitId() );
    pstmt.setString ( 7, bean.getSecret() );
    pstmt.setString ( 8, bean.getEmergency() );
    pstmt.setString ( 9, bean.getSaveTime() );
    pstmt.setString ( 10, bean.getDocNoPre() );
    pstmt.setString ( 11, bean.getYearNo() );
    pstmt.setString ( 12, bean.getWaterNo() );
    pstmt.setString ( 13, bean.getPublishPerson() );
    pstmt.setTimestamp ( 14, new java.sql.Timestamp ( bean.getPublishDate ().getTime() ) );
    pstmt.setString ( 15, bean.getAllSignPerson() );
    pstmt.setString ( 16, bean.getDealPerson() );
    pstmt.setString ( 17, bean.getCheckPerson() );
    pstmt.setString ( 18, bean.getPrintUnit() );
    pstmt.setTimestamp ( 19, new java.sql.Timestamp ( bean.getPrintDate ().getTime() ) );
    pstmt.setString ( 20, bean.getMainDealUnit() );
    pstmt.setString ( 21, bean.getSendTo() );
    pstmt.setString ( 22, bean.getCc() );
    pstmt.setString ( 23, bean.getReportTo() );
    pstmt.setString ( 24, bean.getInerTo() );
    pstmt.setString ( 25, bean.getSubject() );
    pstmt.setString ( 26, bean.getAllUnit() );
    pstmt.setString ( 27, bean.getSendUnitName() );
    pstmt.setString ( 28, bean.getSendUnitId() );
    pstmt.setTimestamp ( 29, new java.sql.Timestamp ( bean.getSendTime ().getTime() ) );
    pstmt.setString ( 30, bean.getSendPerson() );
    pstmt.setTimestamp ( 31, new java.sql.Timestamp ( bean.getSealTime ().getTime() ) );
    pstmt.setString ( 32, bean.getSealPerson() );
    pstmt.setString ( 33, bean.getSealName() );
    pstmt.setTimestamp ( 34, new java.sql.Timestamp ( bean.getSignTime ().getTime() ) );
    pstmt.setString ( 35, bean.getSignPerson() );
    pstmt.setInt ( 36, bean.getFilePages().intValue() );
    pstmt.setInt ( 37, bean.getAttachmentPages().intValue() );
    pstmt.setInt ( 38, bean.getPrintnumber().intValue() );
    pstmt.setString ( 39, bean.getGuiUnitId() );
    pstmt.setString ( 40, bean.getGuiPerson() );
    pstmt.setTimestamp ( 41, new java.sql.Timestamp ( bean.getGuiDate ().getTime() ) );
    pstmt.setString ( 42, bean.getGuiId() );
    pstmt.setString ( 43, bean.getGuiType() );
    pstmt.setString ( 44, bean.getStatus() );
    pstmt.setString ( 45, bean.getReceiveType() );
    pstmt.setTimestamp ( 46, new java.sql.Timestamp ( bean.getReceiveDate ().getTime() ) );
    pstmt.setString ( 47, bean.getMemo() );
    pstmt.setString ( 48, bean.getSendDocId() );
    pstmt.executeUpdate();
    pstmt.close();
    recordExists = true;
  }

  /**
    * Update an existing record
    * (including the primary key)
    */
  public void update(Connection conn) throws SQLException{
    PreparedStatement pstmt = null;
    pstmt = conn.prepareStatement("UPDATE GuiDocForm SET " +
             "docId = ?," +
             "docKind = ?," +
             "docTitle = ?," +
             "CreateDate = ?," +
             "creator = ?," +
             "createunitId = ?," +
             "secret = ?," +
             "emergency = ?," +
             "saveTime = ?," +
             "docNoPre = ?," +
             "yearNo = ?," +
             "waterNo = ?," +
             "publishPerson = ?," +
             "publishDate = ?," +
             "allSignPerson = ?," +
             "dealPerson = ?," +
             "checkPerson = ?," +
             "printUnit = ?," +
             "printDate = ?," +
             "mainDealUnit = ?," +
             "sendTo = ?," +
             "cc = ?," +
             "reportTo = ?," +
             "inerTo = ?," +
             "subject = ?," +
             "allUnit = ?," +
             "sendUnitName = ?," +
             "sendUnitId = ?," +
             "sendTime = ?," +
             "sendPerson = ?," +
             "sealTime = ?," +
             "sealPerson = ?," +
             "sealName = ?," +
             "signTime = ?," +
             "signPerson = ?," +
             "filePages = ?," +
             "attachmentPages = ?," +
             "printnumber = ?," +
             "guiUnitId = ?," +
             "guiPerson = ?," +
             "guiDate = ?," +
             "guiId = ?," +
             "guiType = ?," +
             "status = ?," +
             "receiveType = ?," +
             "receiveDate = ?," +
             "memo = ?," +
             "sendDocId = ? " +
             "WHERE docId = ?" );
    pstmt.setInt ( 1, bean.getDocId ().intValue() );
    pstmt.setString ( 2, bean.getDocKind () );
    pstmt.setString ( 3, bean.getDocTitle () );
    pstmt.setTimestamp ( 4, new java.sql.Timestamp ( bean.getCreateDate ().getTime() ) );
    pstmt.setString ( 5, bean.getCreator () );
    pstmt.setString ( 6, bean.getCreateUnitId () );
    pstmt.setString ( 7, bean.getSecret () );
    pstmt.setString ( 8, bean.getEmergency () );
    pstmt.setString ( 9, bean.getSaveTime () );
    pstmt.setString ( 10, bean.getDocNoPre () );
    pstmt.setString ( 11, bean.getYearNo () );
    pstmt.setString ( 12, bean.getWaterNo () );
    pstmt.setString ( 13, bean.getPublishPerson () );
    pstmt.setTimestamp ( 14, new java.sql.Timestamp ( bean.getPublishDate ().getTime() ) );
    pstmt.setString ( 15, bean.getAllSignPerson () );
    pstmt.setString ( 16, bean.getDealPerson () );
    pstmt.setString ( 17, bean.getCheckPerson () );
    pstmt.setString ( 18, bean.getPrintUnit () );
    pstmt.setTimestamp ( 19, new java.sql.Timestamp ( bean.getPrintDate ().getTime() ) );
    pstmt.setString ( 20, bean.getMainDealUnit () );
    pstmt.setString ( 21, bean.getSendTo () );
    pstmt.setString ( 22, bean.getCc () );
    pstmt.setString ( 23, bean.getReportTo () );
    pstmt.setString ( 24, bean.getInerTo () );
    pstmt.setString ( 25, bean.getSubject () );
    pstmt.setString ( 26, bean.getAllUnit () );
    pstmt.setString ( 27, bean.getSendUnitName () );
    pstmt.setString ( 28, bean.getSendUnitId () );
    pstmt.setTimestamp ( 29, new java.sql.Timestamp ( bean.getSendTime ().getTime() ) );
    pstmt.setString ( 30, bean.getSendPerson () );
    pstmt.setTimestamp ( 31, new java.sql.Timestamp ( bean.getSealTime ().getTime() ) );
    pstmt.setString ( 32, bean.getSealPerson () );
    pstmt.setString ( 33, bean.getSealName () );
    pstmt.setTimestamp ( 34, new java.sql.Timestamp ( bean.getSignTime ().getTime() ) );
    pstmt.setString ( 35, bean.getSignPerson () );
    pstmt.setInt ( 36, bean.getFilePages ().intValue() );
    pstmt.setInt ( 37, bean.getAttachmentPages ().intValue() );
    pstmt.setInt ( 38, bean.getPrintnumber ().intValue() );
    pstmt.setString ( 39, bean.getGuiUnitId () );
    pstmt.setString ( 40, bean.getGuiPerson () );
    pstmt.setTimestamp ( 41, new java.sql.Timestamp ( bean.getGuiDate ().getTime() ) );
    pstmt.setString ( 42, bean.getGuiId () );
    pstmt.setString ( 43, bean.getGuiType () );
    pstmt.setString ( 44, bean.getStatus () );
    pstmt.setString ( 45, bean.getReceiveType () );
    pstmt.setTimestamp ( 46, new java.sql.Timestamp ( bean.getReceiveDate ().getTime() ) );
    pstmt.setString ( 47, bean.getMemo () );
    pstmt.setString ( 48, bean.getSendDocId () );
    pstmt.setInt ( 49, bean.getDocId ().intValue() );
    pstmt.executeUpdate();
    pstmt.close();
  }


  /**
    * Delete an existing record
    */
  public static void delete(Connection conn, String where) throws SQLException{
    Statement stmt = conn.createStatement();
    String sql = "DELETE FROM GuiDocForm " + where;
    stmt.execute(sql);
    stmt.close();
  }

  /**
    * Delete an existing record using a prepared statement
    */
  public void delete(Connection conn) throws SQLException{
    PreparedStatement pstmt = null;
    pstmt = conn.prepareStatement("DELETE FROM GuiDocForm WHERE docId = ?");
    pstmt.setInt( 1, bean.getDocId ().intValue() );
    pstmt.executeUpdate();
    pstmt.close();
  }

  /**
    * get total count of a range of records from a connection, according to the where clause
    */
  protected static int getCount(Connection conn, String where) throws SQLException{
    Statement s = conn.createStatement();

    String sql = "SELECT count(docId) FROM GuiDocForm ";
    if(where.length() > 0) {
      where = where.toLowerCase();
      if (where.indexOf("order") > 0) {
	where = where.substring(0,where.lastIndexOf("order"));
      }
      sql = sql + where;
    }

    ResultSet rs = s.executeQuery( sql );

    int count = 0;
    if( rs.next()){
      count = rs.getInt(1);
    }
    rs.close();
    s.close();
    return count;
  }

}