Package se.rupy.pool

Examples of se.rupy.pool.Connection.prepareStatement()

104
105
106
107
108
109
110
111
112
113
114
      if(Sprout.SQL.driver().equals("org.postgresql.Driver") ||
          Sprout.SQL.driver().equals("oracle.jdbc.OracleDriver")) {
        sql = "SELECT count(*) AS count FROM poll_table WHERE poll_type = " + type;
      }
     
      stmt = conn.prepareStatement(sql);
      result = stmt.executeQuery();
      if(result.next()) {
        return result.getLong("count");
      }
    } catch(SQLException e) {
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
     
      if(Sprout.SQL.driver().equals("oracle.jdbc.OracleDriver")) {
        sql = "SELECT poll_node FROM poll_table WHERE poll_type = " + type + " AND ROWNUM BETWEEN " + start * limit + " AND " + (start * limit + limit) + " " + order;
      }
     
      stmt = conn.prepareStatement(sql);
      result = stmt.executeQuery();
      while(result.next()) {
        list.add(find(result.getLong(Sprout.SQL.driver().equals("com.mysql.jdbc.Driver") ? "node" : "poll_node")));
      }
    } catch(SQLException e) {
View Full Code Here
229
230
231
232
233
234
235
236
237
238
239
      if(Sprout.SQL.driver().equals("org.postgresql.Driver") ||
          Sprout.SQL.driver().equals("oracle.jdbc.OracleDriver")) {
        sql = "SELECT count(DISTINCT n.node_id) AS count " + from(query);
      }
     
      stmt = conn.prepareStatement(sql);
     
      byte[] data = ("%" + query + "%").getBytes("UTF-8");

      if(Sprout.SQL.driver().equals("oracle.jdbc.OracleDriver")) {
        data = query.getBytes("UTF-8");
View Full Code Here
279
280
281
282
283
284
285
286
287
288
289
     
      if(Sprout.SQL.driver().equals("oracle.jdbc.OracleDriver")) {
        sql = "SELECT DISTINCT n.node_date, n.node_id " + from(query) + " AND ROWNUM BETWEEN " + start * limit + " AND " + (start * limit + limit) + " ORDER BY n.node_date DESC";
      }
     
      stmt = conn.prepareStatement(sql);
     
      byte[] data = ("%" + query + "%").getBytes("UTF-8");

      if(Sprout.SQL.driver().equals("oracle.jdbc.OracleDriver")) {
        data = query.getBytes("UTF-8");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.