5859606162636465666768
{ QueryRunner queryRunner = new QueryRunner(dbParam); for(Integer i : indexDelete) { queryRunner.update(sqlRes.query("deleteMultyByNumber"), i); } } public void testMultyInsert()
6970717273747576777879
{ QueryRunner queryRunner = new QueryRunner(dbParam); for(int i = 0; i < 10; i++) { queryRunner.update(sqlRes.query("multyInsert"),"name "+i,i); } } public void testMultySelect() {
105106107108109110111112113114115
public void testUpdate() { QueryRunner queryRunner = new QueryRunner(dbParam); queryRunner.update(sqlRes.query("testUpdate"),"gg_ttt", 5); } public void testDeleteAll() {
113114115116117118119120121122123
public void testDeleteAll() { QueryRunner queryRunner = new QueryRunner(dbParam); Integer rowDelted = queryRunner.update(sqlRes.query("testDeleteAll")); System.out.println("Count of row deleted"+rowDelted); }