Examples of org.openqreg.bean.ContainerintervalBean

org.openqreg.bean.ContainerintervalBean
This is the Bean class for the containerinterval table.

* @throws SQLException
*/
public static Collection<ContainerintervalBean> findAll(Connection con) throws SQLException {
PreparedStatement pStmt = null;
ResultSet rs = null;
ContainerintervalBean valueObject = null;
Collection<ContainerintervalBean> col = Collections.synchronizedList(new ArrayList<ContainerintervalBean>());
try{
pStmt = con.prepareStatement(FIND_ALL_STATEMENT);
rs = pStmt.executeQuery();
while (rs.next()){
valueObject = populate(rs);
valueObject.afterPopulate(con);
col.add(valueObject);
}
return col;
}finally{
if(null!=rs){

View Full Code Here

* @throws SQLException
*/
public static Object findByPrimaryKey(Connection con, PrimaryKey key) throws SQLException {
PreparedStatement pStmt = null;
ResultSet rs = null;
ContainerintervalBean valueObject = null;
ContainerintervalKey primaryKey = (ContainerintervalKey) key;
try{
pStmt = con.prepareStatement(ContainerintervalBeanBase.SELECT_STATEMENT);
pStmt.setObject(1, primaryKey.getAutoid());
pStmt.setObject(2, primaryKey.getOrdernumber());
rs = pStmt.executeQuery();
while (rs.next()){
valueObject = populate(rs);
valueObject.afterPopulate(con);
}
return valueObject;
}finally{
if(null!=rs){
rs.close();

View Full Code Here

    // elementId);
    // for (VarintervalBean intervalBean : col) {
    // intervalBean.remove(con);
    // }
    int orderNr = 0;
    ContainerintervalBean containerIntervalBean = null;
    for (Node node : intervalList) {
      containerIntervalBean = new ContainerintervalBean();
      containerIntervalBean.setAutoid(autoId);
      containerIntervalBean.setId(elementId);
      String start = node.valueOf("@start");
      if (start != null && !start.equals("")) {
        containerIntervalBean.setValidfrom(Converter
            .stringToSqlDate(start));
      }
      String stop = node.valueOf("@stop");
      if (stop != null && !stop.equals("")) {
        containerIntervalBean.setValidto(Converter
            .stringToSqlDate(stop));
      }


      containerIntervalBean.setOrdernumber(new Integer(orderNr));
      containerIntervalBean.create(con);
      orderNr++;
    }
  }

View Full Code Here

* @return A populated ContainerintervalBean
* 
* @throws SQLException
*/
protected static ContainerintervalBean populate(ResultSet rs) throws SQLException {
ContainerintervalBean valueObject = new ContainerintervalBean();
valueObject.setAutoid((Long)rs.getObject(1));
valueObject.setId((String)rs.getObject(2));
valueObject.setValidfrom((java.sql.Date)rs.getObject(3));
valueObject.setValidto((java.sql.Date)rs.getObject(4));
valueObject.setOrdernumber((Integer)rs.getObject(5));
return valueObject;
}

View Full Code Here

TOP

Related Classes of org.openqreg.bean.ContainerintervalBean

org.openqreg.bean.base.ContainerintervalFinderBase

org.openqreg.reader.XmlVariableReader

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.