senddocformpersistentbase.java

OA典型例子

	  bean.setDocId( idGeneratorManager.setNextValue("SendDocForm"));
    }
    catch(SQLException se){
      se.printStackTrace();
    }
    }


  /**
    * Insert a new record
    */
  public void insert(Connection conn) throws SQLException {
    PreparedStatement pstmt = null;
    pstmt = conn.prepareStatement("INSERT INTO SendDocForm ( docId,docKind,docTitle,createDate,creator,createUnitId,secret,emergency,saveTime,docNoPre,yearNo,waterNo,publishDate,publishPerson,allSignPerson,dealPerson,checkPerson,printUnit,printDate,mainDealunit,combine,combineUnit,sendTo,cc,reportTo,inerTo,subject,sealTime,sealPerson,sealName,sendTime,sendPerson,filePages,attachmentPages,printnumber,delPerson,delTime,delYy,docMemo,status,sealConfirm ) 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.setTimestamp ( 13, new java.sql.Timestamp ( bean.getPublishDate ().getTime() ) );
    pstmt.setString ( 14, bean.getPublishPerson() );
    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.getCombine() );
    pstmt.setString ( 22, bean.getCombineUnit() );
    pstmt.setString ( 23, bean.getSendTo() );
    pstmt.setString ( 24, bean.getCc() );
    pstmt.setString ( 25, bean.getReportTo() );
    pstmt.setString ( 26, bean.getInerTo() );
    pstmt.setString ( 27, bean.getSubject() );
    pstmt.setTimestamp ( 28, new java.sql.Timestamp ( bean.getSealTime ().getTime() ) );
    pstmt.setString ( 29, bean.getSealPerson() );
    pstmt.setString ( 30, bean.getSealName() );
    pstmt.setTimestamp ( 31, new java.sql.Timestamp ( bean.getSendTime ().getTime() ) );
    pstmt.setString ( 32, bean.getSendPerson() );
    pstmt.setInt ( 33, bean.getFilePages().intValue() );
    pstmt.setInt ( 34, bean.getAttachmentPages().intValue() );
    pstmt.setInt ( 35, bean.getPrintnumber().intValue() );
    pstmt.setString ( 36, bean.getDelPerson() );
    pstmt.setTimestamp ( 37, new java.sql.Timestamp ( bean.getDelTime ().getTime() ) );
    pstmt.setString ( 38, bean.getDelYy() );
    pstmt.setString ( 39, bean.getDocMemo() );
    pstmt.setString ( 40, bean.getStatus() );
    pstmt.setString ( 41, bean.getSealConfirm() );
    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 SendDocForm SET " +
             "docId = ?," +
             "docKind = ?," +
             "docTitle = ?," +
             "createDate = ?," +
             "creator = ?," +
             "createUnitId = ?," +
             "secret = ?," +
             "emergency = ?," +
             "saveTime = ?," +
             "docNoPre = ?," +
             "yearNo = ?," +
             "waterNo = ?," +
             "publishDate = ?," +
             "publishPerson = ?," +
             "allSignPerson = ?," +
             "dealPerson = ?," +
             "checkPerson = ?," +
             "printUnit = ?," +
             "printDate = ?," +
             "mainDealunit = ?," +
             "combine = ?," +
             "combineUnit = ?," +
             "sendTo = ?," +
             "cc = ?," +
             "reportTo = ?," +
             "inerTo = ?," +
             "subject = ?," +
             "sealTime = ?," +
             "sealPerson = ?," +
             "sealName = ?," +
             "sendTime = ?," +
             "sendPerson = ?," +
             "filePages = ?," +
             "attachmentPages = ?," +
             "printnumber = ?," +
             "delPerson = ?," +
             "delTime = ?," +
             "delYy = ?," +
             "docMemo = ?," +
             "status = ?, " +
             "sealConfirm = ? " +
             "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.setTimestamp ( 13, new java.sql.Timestamp ( bean.getPublishDate ().getTime() ) );
    pstmt.setString ( 14, bean.getPublishPerson () );
    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.getCombine () );
    pstmt.setString ( 22, bean.getCombineUnit () );
    pstmt.setString ( 23, bean.getSendTo () );
    pstmt.setString ( 24, bean.getCc () );
    pstmt.setString ( 25, bean.getReportTo () );
    pstmt.setString ( 26, bean.getInerTo () );
    pstmt.setString ( 27, bean.getSubject () );
    pstmt.setTimestamp ( 28, new java.sql.Timestamp ( bean.getSealTime ().getTime() ) );
    pstmt.setString ( 29, bean.getSealPerson () );
    pstmt.setString ( 30, bean.getSealName () );
    pstmt.setTimestamp ( 31, new java.sql.Timestamp ( bean.getSendTime ().getTime() ) );
    pstmt.setString ( 32, bean.getSendPerson () );
    pstmt.setInt ( 33, bean.getFilePages ().intValue() );
    pstmt.setInt ( 34, bean.getAttachmentPages ().intValue() );
    pstmt.setInt ( 35, bean.getPrintnumber ().intValue() );
    pstmt.setString ( 36, bean.getDelPerson () );
    pstmt.setTimestamp ( 37, new java.sql.Timestamp ( bean.getDelTime ().getTime() ) );
    pstmt.setString ( 38, bean.getDelYy () );
    pstmt.setString ( 39, bean.getDocMemo () );
    pstmt.setString ( 40, bean.getStatus () );
    pstmt.setString ( 41, bean.getSealConfirm () );
    pstmt.setInt ( 42, 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 SendDocForm " + 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 SendDocForm 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 SendDocForm ";
    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;
  }

}