Package org.openqreg.bean

Examples of org.openqreg.bean.VarscriptBean


* @return A populated VarscriptBean
*
* @throws SQLException
*/
protected static VarscriptBean populate(ResultSet rs) throws SQLException {
VarscriptBean valueObject = new VarscriptBean();
valueObject.setAutoid((Long)rs.getObject(1));
valueObject.setId((String)rs.getObject(2));
valueObject.setScriptname((String)rs.getObject(3));
valueObject.setScriptvalue((String)rs.getObject(4));
valueObject.setOrdernumber((Integer)rs.getObject(5));
return valueObject;
}
View Full Code Here


* @throws SQLException
*/
public static Collection<VarscriptBean> findAll(Connection con) throws SQLException {
PreparedStatement pStmt = null;
ResultSet rs = null;
VarscriptBean valueObject = null;
Collection<VarscriptBean> col = Collections.synchronizedList(new ArrayList<VarscriptBean>());
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;
VarscriptBean valueObject = null;
VarscriptKey primaryKey = (VarscriptKey) key;
try{
pStmt = con.prepareStatement(VarscriptBeanBase.SELECT_STATEMENT);
pStmt.setObject(1, primaryKey.getAutoid());
pStmt.setObject(2, primaryKey.getScriptname());
rs = pStmt.executeQuery();
while (rs.next()){
valueObject = populate(rs);
valueObject.afterPopulate(con);
}
return valueObject;
}finally{
if(null!=rs){
rs.close();
View Full Code Here

    // for (VarscriptBean scriptBean : col) {
    // scriptBean.remove(con);
    // }
    // The attribute must be in the same order because of the schema
    int orderNr = 0;
    VarscriptBean varScriptBean = null;
    for (Node node : scriptList) {
      scriptName = node.getName().trim();
      scriptValue = node.getText().trim();

      varScriptBean = new VarscriptBean();
      varScriptBean.setAutoid(autoId);
      varScriptBean.setId(elementId);
      varScriptBean.setScriptname(scriptName);

      varScriptBean.setOrdernumber(new Integer(orderNr));
      varScriptBean.setScriptvalue(scriptValue);
      varScriptBean.create(con);
      orderNr++;
    }
  }
View Full Code Here

TOP

Related Classes of org.openqreg.bean.VarscriptBean

Copyright © 2018 www.massapicom. All rights reserved.
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.