Package com.bleujin.framework.db.procedure

Examples of com.bleujin.framework.db.procedure.IUserProcedure.addParam()

56
57
58
59
60
61
62
63
64
65
66
      assertEquals(5, rows.getRowCount()) ;
    }
 
  public void testProcedure2() throws Exception {
    IUserProcedure upt = dc.createUserProcedure("demoSp2(?,?)") ;
    upt.addParam("abcdefg" ).addParam(4) ;
   
    int rowcount = upt.execUpdate() ;
      assertEquals(1, rowcount) ;
    }
 
View Full Code Here
31
32
33
34
35
36
37
38
39
    recreate.execUpdate();
  }

  public void xtestUpdate() throws Exception {
    IUserProcedure upt = dc.createUserProcedure("temp@insertChain");
    upt.addParam("param1", 1).addParam("param2", 2);
    upt.execUpdate();
  }
}
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
        final DBController dc = new DBController(atask.getDBManager()) ;
        new Thread(){
            public void run(){
                try {
                    IUserProcedure upt = dc.createUserProcedure("OnlyAdmin@addLongTimeProcedure(?,?,?)") ;
                    upt.addParam(0, procName) ;
                    upt.addParam(1, procFullName.length() > 1000 ? procFullName.substring(0, 1000) : procFullName) ;
                    upt.addParam(2, misecond) ;
                    upt.execUpdate() ;
                }
                catch(SQLException ex) {
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
        new Thread(){
            public void run(){
                try {
                    IUserProcedure upt = dc.createUserProcedure("OnlyAdmin@addLongTimeProcedure(?,?,?)") ;
                    upt.addParam(0, procName) ;
                    upt.addParam(1, procFullName.length() > 1000 ? procFullName.substring(0, 1000) : procFullName) ;
                    upt.addParam(2, misecond) ;
                    upt.execUpdate() ;
                }
                catch(SQLException ex) {
                    ex.printStackTrace();
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
            public void run(){
                try {
                    IUserProcedure upt = dc.createUserProcedure("OnlyAdmin@addLongTimeProcedure(?,?,?)") ;
                    upt.addParam(0, procName) ;
                    upt.addParam(1, procFullName.length() > 1000 ? procFullName.substring(0, 1000) : procFullName) ;
                    upt.addParam(2, misecond) ;
                    upt.execUpdate() ;
                }
                catch(SQLException ex) {
                    ex.printStackTrace();
                }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
 
 
 
  public void testNamedProcedure() throws Exception {
    IUserProcedure upt = dc.createUserProcedure("sample@insertWith(:a, :b)") ;
    upt.addParam("a", 1) ;
    upt.addParam("b", "abc") ;
    upt.execUpdate() ;
   
    Rows rows = dc.getRows("select * from update_sample") ;
    assertEquals(1, rows.getRowCount()) ;
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
 
 
  public void testNamedProcedure() throws Exception {
    IUserProcedure upt = dc.createUserProcedure("sample@insertWith(:a, :b)") ;
    upt.addParam("a", 1) ;
    upt.addParam("b", "abc") ;
    upt.execUpdate() ;
   
    Rows rows = dc.getRows("select * from update_sample") ;
    assertEquals(1, rows.getRowCount()) ;
  }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
    cmd.execUpdate() ;
  }
 
  public void testProcedureUpdate() throws Exception {
    IUserProcedure upt = dc.createUserProcedure("Sample@insertWith(?,?)") ;
    upt.addParam(1).addParam("abc") ;
   
    upt.execUpdate() ;
  }
 
  public void testProcedureQuery() throws Exception {
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
 
  public void testProcedureQuery() throws Exception {
    testProcedureUpdate() ;
   
    IUserProcedure upt = dc.createUserProcedure("Sample@selectBy(?)") ;
    upt.addParam(1);
   
    Rows rows = upt.execQuery() ;
   
    assertEquals(1, rows.getRowCount()) ;
    assertEquals("abc", rows.firstRow().getString("b")) ;
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
  public void testDefault() throws Exception {
   
    // example 1
    DBController dc = DBController.getTestInstance() ;
    IUserProcedure u1 = dc.createUserProcedure("emp@add(?,?)") ;
    u1.addParam(110).addParam("bleujin") ;
    u1.execUpdate() ;

    // example
    IUserProcedure u2 = dc.createUserProcedure("emp@list()") ;
    Rows rows = u2.execQuery() ;
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.