Package org.openqreg.bean

Examples of org.openqreg.bean.SortrowBean

53
54
55
56
57
58
59
60
61
62
63
64
* @return A populated SortrowBean
*
* @throws SQLException
*/
protected static SortrowBean populate(ResultSet rs) throws SQLException {
SortrowBean valueObject = new SortrowBean();
valueObject.setUserid((String)rs.getObject(1));
valueObject.setListname((String)rs.getObject(2));
valueObject.setRowvalue((String)rs.getObject(3));
valueObject.setRoworder((Integer)rs.getObject(4));
return valueObject;
}
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
* @throws SQLException
*/
public static Collection<SortrowBean> findAll(Connection con) throws SQLException {
PreparedStatement pStmt = null;
ResultSet rs = null;
SortrowBean valueObject = null;
Collection<SortrowBean> col = Collections.synchronizedList(new ArrayList<SortrowBean>());
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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
* @throws SQLException
*/
public static Object findByPrimaryKey(Connection con, PrimaryKey key) throws SQLException {
PreparedStatement pStmt = null;
ResultSet rs = null;
SortrowBean valueObject = null;
SortrowKey primaryKey = (SortrowKey) key;
try{
pStmt = con.prepareStatement(SortrowBeanBase.SELECT_STATEMENT);
pStmt.setObject(1, primaryKey.getUserid());
pStmt.setObject(2, primaryKey.getListname());
pStmt.setObject(3, primaryKey.getRowvalue());
rs = pStmt.executeQuery();
while (rs.next()){
valueObject = populate(rs);
valueObject.afterPopulate(con);
}
return valueObject;
}finally{
if(null!=rs){
rs.close();
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
 
  @Test
  public void testCentrenameList(){
    try {
      SortrowBean centrenameList = (SortrowBean)SortrowFinderBase.findByPrimaryKey(new SortrowKey("System", "centrenameList", "CENTRENAME"));
      assertNotNull("Missing sortrow centrenameList", centrenameList);
     
    } catch (SQLException e) {
      fail("Database exception"+ e.getMessage());
    }
View Full Code Here
TOP

Related Classes of org.openqreg.bean.SortrowBean

  • org.openqreg.bean.base.SortrowFinderBase
  • org.openqreg.bean.SortrowTest
    • 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.