Package org.openqreg.bean

Examples of org.openqreg.bean.BrowserBean

47
48
49
50
51
52
53
54
55
56
57
58
* @return A populated BrowserBean
*
* @throws SQLException
*/
protected static BrowserBean populate(ResultSet rs) throws SQLException {
BrowserBean valueObject = new BrowserBean();
valueObject.setId((Long)rs.getObject(1));
valueObject.setBrowsername((String)rs.getObject(2));
valueObject.setBrowserdisplayname((String)rs.getObject(3));
valueObject.setStatus((Integer)rs.getObject(4));
return valueObject;
}
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
* @throws SQLException
*/
public static Collection<BrowserBean> findAll(Connection con) throws SQLException {
PreparedStatement pStmt = null;
ResultSet rs = null;
BrowserBean valueObject = null;
Collection<BrowserBean> col = Collections.synchronizedList(new ArrayList<BrowserBean>());
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
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
* @throws SQLException
*/
public static Object findByPrimaryKey(Connection con, PrimaryKey key) throws SQLException {
PreparedStatement pStmt = null;
ResultSet rs = null;
BrowserBean valueObject = null;
BrowserKey primaryKey = (BrowserKey) key;
try{
pStmt = con.prepareStatement(BrowserBeanBase.SELECT_STATEMENT);
pStmt.setObject(1, primaryKey.getId());
rs = pStmt.executeQuery();
while (rs.next()){
valueObject = populate(rs);
valueObject.afterPopulate(con);
}
return valueObject;
}finally{
if(null!=rs){
rs.close();
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
    if (hasService(userId, service)) {
      Connection con = null;
      try {
        con = DbHandler.getConnection();
        con.setAutoCommit(false);
        BrowserBean browser = (BrowserBean) BrowserFinderBase
            .findByPrimaryKey(con, new BrowserKey(browserId));
        browser.remove(con);
        con.commit();

      } catch (SQLException sqle) {
        try {
          if (null != con) {
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
    if (hasService(userId, service)) {
      Connection con = null;
      try {
        con = DbHandler.getConnection();
        con.setAutoCommit(true);
        BrowserBean browser = new BrowserBean();
        browser.setBrowsername(browserName);
        browser.setBrowserdisplayname(browserDisplayName);
        browser.setStatus(browserStatus);
       
        browser.create(con);
      } catch (SQLException sqle) {
        try {
          if (null != con) {
            con.rollback();
          }
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
146
147
    if (hasService(userId, service)) {
      Connection con = null;
      try {
        con = DbHandler.getConnection();
        con.setAutoCommit(true);
        BrowserBean browser = (BrowserBean)BrowserFinderBase.findByPrimaryKey(new BrowserKey(browserId));
        browser.setStatus(newStatus);
        browser.store(con);
      } catch (SQLException sqle) {
        try {
          if (null != con) {
            con.rollback();
          }
View Full Code Here
TOP

Related Classes of org.openqreg.bean.BrowserBean

  • org.openqreg.bean.base.BrowserFinderBase
  • org.openqreg.dwr.AjaxBrowserControl
  • java.sql.PreparedStatement
  • java.sql.ResultSet
    • 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.