Package common.db

Examples of common.db.QueryRunner

54
55
56
57
58
59
60
61
62
63
64
65
66
    new TestMain().run();
  }

  public void deleteMultyByNumber(Integer[] indexDelete)
  {
    QueryRunner queryRunner = new QueryRunner(dbParam);

    for(Integer i : indexDelete)
    {
      queryRunner.update(sqlRes.query("deleteMultyByNumber"), i);
    }

  }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
  }

  public void testMultyInsert()
  {
    QueryRunner queryRunner = new QueryRunner(dbParam);

    for(int i = 0; i < 10; i++)
    {
      queryRunner.update(sqlRes.query("multyInsert"),"name "+i,i);
    }
  }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
  }

  public void testMultySelect()
  {
    //new QueryRunner(); rad sa predefinisanim DBParam, pogledaj u klasi
    QueryRunner queryRunner = new QueryRunner(dbParam); // new QuerryRunner(dbParam); da radis sa proizvoljnom bazom
    List<Proba> lists = queryRunner.query(sqlRes.query("multySelect"), ProbaRowProcessor.getListHandler());
    for (Proba p : lists)
    {
      System.out.println("testMultySelect:" + p.toString());
    }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101


  public void testInsert()
  {
    QueryRunner queryRunner = new QueryRunner(dbParam);
    Integer i = (Integer)queryRunner.insertWithKeyReturn(sqlRes.query("testInsert"),
        "name_example",
        10 );
    ;

    System.out.println("Inserted "+i);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
    //System.out.println("Key returned "+p.toString());
  }

  public void testUpdate()
  {
    QueryRunner queryRunner = new QueryRunner(dbParam);

    queryRunner.update(sqlRes.query("testUpdate"),"gg_ttt", 5);

  }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
  }

  public void testDeleteAll()
  {
    QueryRunner queryRunner = new QueryRunner(dbParam);

    Integer rowDelted = queryRunner.update(sqlRes.query("testDeleteAll"));
    System.out.println("Count of row deleted"+rowDelted);



  }
View Full Code Here
96
97
98
99
100
101
102
  }

  public static QueryRunner getQuerryRunner()
  {
    return new QueryRunner(dbParam);
  }
View Full Code Here
TOP

Related Classes of common.db.QueryRunner

  • common.db.test.TestMain
  • common.db.test.TestSmartFildAdder
  • java.util.regex.Matcher
    • 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.