Package org.openqreg.bean

Examples of org.openqreg.bean.UsercentregroupBean


* @return A populated UsercentregroupBean
*
* @throws SQLException
*/
protected static UsercentregroupBean populate(ResultSet rs) throws SQLException {
UsercentregroupBean valueObject = new UsercentregroupBean();
valueObject.setUserid((String)rs.getObject(1));
valueObject.setCentreid((String)rs.getObject(2));
valueObject.setUsergroupid((String)rs.getObject(3));
valueObject.setStatus((Integer)rs.getObject(4));
valueObject.setCreatedby((String)rs.getObject(5));
valueObject.setTscreated((java.sql.Timestamp)rs.getObject(6));
valueObject.setUpdatedby((String)rs.getObject(7));
valueObject.setTsupdated((java.sql.Timestamp)rs.getObject(8));
return valueObject;
}
View Full Code Here


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

TOP

Related Classes of org.openqreg.bean.UsercentregroupBean

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.