recvdocformpersistentbase.java

OA典型例子

    */
    public void setPrimaryKey(Connection conn) throws SQLException{
            try{
      IDGeneratorManager idGeneratorManager = new IDGeneratorManager();
	  bean.setDocId( idGeneratorManager.setNextValue("RecvDocForm"));
    }
    catch(SQLException se){
      se.printStackTrace();
    }
    }


  /**
    * Insert a new record
    */
  public void insert(Connection conn) throws SQLException {
    PreparedStatement pstmt = null;
    pstmt = conn.prepareStatement("INSERT INTO RecvDocForm ( docId,docKind,sendDocId,docTitle,CreateDate,creator,createunitId,secret,emergency,saveTime,docNoPre,yearNo,waterNo,publishPerson,publishDate,allSignPerson,dealPerson,checkPerson,printUnit,printDate,mainDealunit,sendTo,cc,reportTo,inerTo,sealName,subject,allUnit,sendUnitName,sendUnitId,sendTime,sendPerson,filePages,attachmentPages,printnumber,ReceiveNo,memo ) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )");
    pstmt.setInt ( 1, bean.getDocId().intValue() );
    pstmt.setString ( 2, bean.getDocKind() );
    pstmt.setInt ( 3, bean.getSendDocId().intValue() );
    pstmt.setString ( 4, bean.getDocTitle() );
    pstmt.setTimestamp ( 5, new java.sql.Timestamp ( bean.getCreateDate ().getTime() ) );
    pstmt.setString ( 6, bean.getCreator() );
    pstmt.setString ( 7, bean.getCreateUnitId() );
    pstmt.setString ( 8, bean.getSecret() );
    pstmt.setString ( 9, bean.getEmergency() );
    pstmt.setString ( 10, bean.getSaveTime() );
    pstmt.setString ( 11, bean.getDocNoPre() );
    pstmt.setString ( 12, bean.getYearNo() );
    pstmt.setString ( 13, bean.getWaterNo() );
    pstmt.setString ( 14, bean.getPublishPerson() );
    pstmt.setTimestamp ( 15, new java.sql.Timestamp ( bean.getPublishDate ().getTime() ) );
    pstmt.setString ( 16, bean.getAllSignPerson() );
    pstmt.setString ( 17, bean.getDealPerson() );
    pstmt.setString ( 18, bean.getCheckPerson() );
    pstmt.setString ( 19, bean.getPrintUnit() );
    pstmt.setTimestamp ( 20, new java.sql.Timestamp ( bean.getPrintDate ().getTime() ) );
    pstmt.setString ( 21, bean.getMainDealunit() );
    pstmt.setString ( 22, bean.getSendTo() );
    pstmt.setString ( 23, bean.getCc() );
    pstmt.setString ( 24, bean.getReportTo() );
    pstmt.setString ( 25, bean.getInerTo() );
    pstmt.setString ( 26, bean.getSealName() );
    pstmt.setString ( 27, bean.getSubject() );
    pstmt.setString ( 28, bean.getAllUnit() );
    pstmt.setString ( 29, bean.getSendUnitName() );
    pstmt.setString ( 30, bean.getSendUnitId() );
    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.getReceiveNo() );
    pstmt.setString ( 37, bean.getMemo() );
    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 RecvDocForm SET " +
             "docId = ?," +
             "docKind = ?," +
             "sendDocId = ?," +
             "docTitle = ?," +
             "CreateDate = ?," +
             "creator = ?," +
             "createunitId = ?," +
             "secret = ?," +
             "emergency = ?," +
             "saveTime = ?," +
             "docNoPre = ?," +
             "yearNo = ?," +
             "waterNo = ?," +
             "publishPerson = ?," +
             "publishDate = ?," +
             "allSignPerson = ?," +
             "dealPerson = ?," +
             "checkPerson = ?," +
             "printUnit = ?," +
             "printDate = ?," +
             "mainDealunit = ?," +
             "sendTo = ?," +
             "cc = ?," +
             "reportTo = ?," +
             "inerTo = ?," +
             "sealName = ?," +
             "subject = ?," +
             "allUnit = ?," +
             "sendUnitName = ?," +
             "sendUnitId = ?," +
             "sendTime = ?," +
             "sendPerson = ?," +
             "filePages = ?," +
             "attachmentPages = ?," +
             "printnumber = ?," +
             "ReceiveNo = ?," +
             "memo = ? " +
             "WHERE docId = ?" );
    pstmt.setInt ( 1, bean.getDocId ().intValue() );
    pstmt.setString ( 2, bean.getDocKind () );
    pstmt.setInt ( 3, bean.getSendDocId ().intValue() );
    pstmt.setString ( 4, bean.getDocTitle () );
    pstmt.setTimestamp ( 5, new java.sql.Timestamp ( bean.getCreateDate ().getTime() ) );
    pstmt.setString ( 6, bean.getCreator () );
    pstmt.setString ( 7, bean.getCreateUnitId () );
    pstmt.setString ( 8, bean.getSecret () );
    pstmt.setString ( 9, bean.getEmergency () );
    pstmt.setString ( 10, bean.getSaveTime () );
    pstmt.setString ( 11, bean.getDocNoPre () );
    pstmt.setString ( 12, bean.getYearNo () );
    pstmt.setString ( 13, bean.getWaterNo () );
    pstmt.setString ( 14, bean.getPublishPerson () );
    pstmt.setTimestamp ( 15, new java.sql.Timestamp ( bean.getPublishDate ().getTime() ) );
    pstmt.setString ( 16, bean.getAllSignPerson () );
    pstmt.setString ( 17, bean.getDealPerson () );
    pstmt.setString ( 18, bean.getCheckPerson () );
    pstmt.setString ( 19, bean.getPrintUnit () );
    pstmt.setTimestamp ( 20, new java.sql.Timestamp ( bean.getPrintDate ().getTime() ) );
    pstmt.setString ( 21, bean.getMainDealunit () );
    pstmt.setString ( 22, bean.getSendTo () );
    pstmt.setString ( 23, bean.getCc () );
    pstmt.setString ( 24, bean.getReportTo () );
    pstmt.setString ( 25, bean.getInerTo () );
    pstmt.setString ( 26, bean.getSealName () );
    pstmt.setString ( 27, bean.getSubject () );
    pstmt.setString ( 28, bean.getAllUnit () );
    pstmt.setString ( 29, bean.getSendUnitName () );
    pstmt.setString ( 30, bean.getSendUnitId () );
    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.getReceiveNo () );
    pstmt.setString ( 37, bean.getMemo () );
    pstmt.setInt ( 38, 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 RecvDocForm " + 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 RecvDocForm 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 RecvDocForm ";
    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;
  }

}