Package com.bleujin.framework.db.procedure

Examples of com.bleujin.framework.db.procedure.IUserCommand

19
20
21
22
23
24
25
26
    assertEquals(3, rows.nextPageRows().getRowCount()) ;
  }

 
  public void testMSSQLViewPlan() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
    cmd.printPlan(System.out) ;
  }
View Full Code Here
4
5
6
7
8
9
10
11
12
13
14
import com.bleujin.framework.util.Debug;

public class TestModify extends DBTestCase{

  public void testCallMethod() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
   
    Rows rows = cmd.execQuery() ;
    Debug.debug(rows) ;
   
  }
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
    }
  }

 
  public void testPageSpeed() throws Exception {
    final IUserCommand cmd = dc.createUserCommand("select * from millon_tblt") ;
    cmd.setPage(Page.TEN) ;
   
    Thread[] ts = new Thread[20] ;
    for (int i = 0; i < ts.length; i++) {
      ts[i] = new Thread(){
        public void run(){
          try {
            cmd.execQuery();
          } catch (SQLException e) {
            e.printStackTrace();
          }
        }
      } ;
View Full Code Here
14
15
16
17
18
19
20
21
22
23
24
25
public class TestUserProcedures extends DBTestCase{

  public void testUserProceduresQuery() throws Exception {
    UserProcedures upts = dc.createUserProcedures("dual") ;
   
    IUserCommand cmd1 = dc.createUserCommand("select * from dual");
    IUserCommand cmd2 = dc.createUserCommand("select * from copy_tblc");
    upts.add(cmd1) ;
    upts.add(cmd2) ;
   
   
    Rows rows = upts.execQuery() ;
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
  public void testUserProceduresUpdate() throws Exception {
    dc.execUpdate("truncate table framework_test_tblc#") ;
   
    UserProcedures upts = dc.createUserProcedures("dual") ;
   
    IUserCommand cmd1 = dc.createUserCommand("insert into framework_test_tblc# values(1, 'BlaBla')");
    IUserCommand cmd2 = dc.createUserCommand("insert into framework_test_tblc# values(2, 'alBalB')");
    upts.add(cmd1) ;
    upts.add(cmd2) ;
   
    int result = upts.execUpdate() ;
    assertEquals(2, result) ;
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
59
  public void testTransaction() throws Exception {
    dc.execUpdate("truncate table framework_test_tblc#") ;
   
    UserProcedures upts = dc.createUserProcedures("dual") ;
   
    IUserCommand cmd1 = dc.createUserCommand("insert into framework_test_tblc# values(1, 'BlaBla')");
    IUserCommand cmd2 = dc.createUserCommand("insert into framework_test_tblc# values(2, '012345678901234567890123456789')"); // over length
    upts.add(cmd1) ;
    upts.add(cmd2) ;
   
    try {
      int result = upts.execUpdate() ;
View Full Code Here
36
37
38
39
40
41
42
43
    Rows rows = (Rows)result.get("plan");
  }
 
 
  public void testViewPlan() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc where no1 < 10") ;
    cmd.printPlan(System.out) ;
  }
View Full Code Here
TOP

Related Classes of com.bleujin.framework.db.procedure.IUserCommand

  • com.bleujin.framework.db.DBController
  • com.bleujin.framework.db.function.TestPage
  • com.bleujin.framework.db.function.TestPlan
  • com.bleujin.framework.db.function.TestUserCommand
  • com.bleujin.framework.db.function.TestUserProcedures
  • com.bleujin.framework.db.mssql.TestFirst
  • com.bleujin.framework.db.mysql.TestFirst
  • com.bleujin.framework.db.mysql.TestPage
  • com.bleujin.framework.db.mysql.TestPlan
  • com.bleujin.framework.db.mysql.TestUserCommand
    • 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.