Package org.jugile.util

Examples of org.jugile.util.DBPool

76
77
78
79
80
81
82
83
84
85
86
87
      c.execute();
    }     
  }

  public static List<Msg> getMessages(String node, int max) {
    DBPool pool = DBPool.getPool();
    DBConnection c = pool.getConnection();
    List<Msg> msgs = new ArrayList<Msg>();
    try {
      String sql ="";
      sql += "select msg_id, nodeid, status, ts from dbmq_queue_t ";
      sql += "where nodeid=? AND status=? ORDER BY ts LIMIT ?";
View Full Code Here
153
154
155
156
157
158
159
160
161
162
163
164
    }
    return msgs;
  }
 
  public static int flush(String name) {
    DBPool pool = DBPool.getPool();
    DBConnection c = pool.getConnection();
    try {
      String sql = "delete from dbmq_queue_t where nodeid=?";
      c.prepare(sql);
      c.param(name);
      int res = c.execute();
View Full Code Here
174
175
176
177
178
179
180
181
182
183
184
185
    }
    return 0;
  }

  public static int flushNotNew(String name) {
    DBPool pool = DBPool.getPool();
    DBConnection c = pool.getConnection();
    try {
      String sql = "delete from dbmq_queue_t where nodeid=? and status!=0";
      c.prepare(sql);
      c.param(name);
      int res = c.execute();
View Full Code Here
10
11
12
13
14
15
16
17
18
19
20
21
import org.jugile.util.Time;

public class DBTest extends JugileTestCase {

  public static void clearDatabase() throws Exception {
    DBPool db = DBPool.getPool();
    DBConnection c = db.getConnection();
    c.updateN("delete from person_t");
    c.updateN("delete from family_t");
    c.updateN("delete from map_person_2friend_family");
    c.updateN("delete from dbmq_queue_t");
    c.updateN("delete from dbmq_messages_t");
View Full Code Here
TOP

Related Classes of org.jugile.util.DBPool

  • org.jugile.daims.Bo
  • org.jugile.daims.BoCollection
  • org.jugile.daims.DBTest
  • org.jugile.daims.DomainCore
  • org.jugile.daims.UpdateDBTest
  • org.jugile.util.DBQueue
  • org.jugile.util.HiLo
  • java.sql.Driver
  • java.sql.Connection
    • 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.