java--快速输出sql语句

String SUBBRANCHNAME_all ="秦农碑林支行长安路支行,秦农碑林支行红会路支行,秦农碑林支行建西街支行,秦农碑林支行安东街支行,秦农碑林支行旅馆村支行,秦农碑林支行文艺路支??,秦农碑林支行文艺南路支行,秦农碑林支行雁塔路支行,秦农碑林支行乐居场支行,秦农碑林支行柿园路支行,秦农碑林支行火炬路支行,秦农碑林支行南沙村支行,秦农碑林支行环城东路支行,秦农碑林支行兴庆支行,秦农碑林支行测绘路支行,秦农曲江支行管理中心,秦农曲江支行等驾坡支行,秦农曲江支行营业部,秦农曲江支行观音庙支行,秦农曲江支行曲江池支行,秦农曲江支行千户村支行,秦农曲江支行幸福南路支行,秦农曲江支行翠华路支行,秦农曲江支行大雁塔支行,秦农曲江支行铁炉庙支行,秦农曲江支行三兆村支行,秦农曲江支行雁南路支行,秦农曲江支行雁南五路支行,秦农曲江支行雁翔路支行,秦农新城支行和信市场支行,秦农新城支行建工路支行,秦农新城支行高楼村支行,秦农新城支行长缨西路支行,秦农新城支行长乐中路支行,秦农新城支行兴工路支行,秦农新城支行胡家庙支行,秦农新城支行爱民路支行,秦农新城支行营业室,秦农新城支行华清东路支行,秦农新城支行永乐路支行,秦农新城支行长乐西路支行,秦农临潼联社营业部,秦农临潼联社北关分社,秦农临潼联社斜口信用社,秦农临潼联社行者信用社,秦农临潼联社骊山信用社,秦农临潼联社步行街分社,秦农临潼联社人民西路分社,秦农临潼联社秦陵信用社,秦农临潼联社兵马俑分社,秦农临潼联社代王信用社,秦农临潼联社新丰信用社,秦农临潼联社零口信用社,秦农临潼联社马额信用社,秦农临潼联社铁炉信用社,秦农临潼联社相桥信用社,秦农临潼联社栎阳信用社,秦农临潼联社任留信用社,秦农临潼联社雨金信用社,秦农临潼联社城区信用社,秦农临潼联社东大街分社,秦农临潼联社韩峪分社,秦农临潼联社西泉分社,秦农临潼联社贾堡分社,秦农临潼联社何寨信用社,秦农临潼联社新丰火车站分社,秦农临潼联社土桥信用社,秦农临潼联社纸李分社,秦农临潼联社穆寨信用社,秦农临潼联社油槐信用社,秦农临潼联社徐杨信用社,秦农临潼联社新市信用社,秦农临潼联社北田分社,秦农临潼联社交口分社,秦农临潼联社滩张分社,秦农临潼联社骊苑分社,秦农临潼联社东岳分社";
String SUBBRANCHNAME[] = SUBBRANCHNAME_all.split(",");

String INNERBANKCODE_all ="010103,010139,010129,010131,010107,010113,010114,010133,010109,010115,010116,010150,010151,011317,010210,015399,010248,010207,010260,010263,010247,010284,010206,010242,010245,010262,010281,010265,010264,010111,010250,010405,011302,011305,011306,011307,011313,011316,011318,011319,011326,010601,010602,010603,010604,010605,010608,010611,010612,010613,010614,010615,010616,010617,010618,010619,010620,010621,010622,010623,010626,010628,010629,010631,010634,010635,010636,010637,010638,010639,010642,010643,010645,010646,010647,010648,010649";
String INNERBANKCODE[] = INNERBANKCODE_all.split(",");

String ATTICEPOINTCODE_all ="8661000005008,8661000005010,8661000005011,8661000005012,8661000005015,8661000005016,8661000005017,8661000005019,8661000005020,8661000005021,8661000005022,8661000005023,8661000005024,8661000005028,8661000005030,8661000005129,8661000005130,8661000005131,8661000005132,8661000005133,8661000005134,8661000005135,8661000005136,8661000005137,8661000005138,8661000005139,8661000005140,8661000005141,8661000005142,8661000005143,8661000005144,8661000005145,8661000005146,8661000005147,8661000005148,8661000005149,8661000005150,8661000005151,8661000005152,8661000005153,8661000005154,8661000005247,8661000005248,8661000005249,8661000005250,8661000005251,8661000005252,8661000005253,8661000005254,8661000005255,8661000005256,8661000005257,8661000005258,8661000005259,8661000005260,8661000005261,8661000005262,8661000005263,8661000005264,8661000005265,8661000005266,8661000005267,8661000005268,8661000005269,8661000005270,8661000005271,8661000005272,8661000005273,8661000005274,8661000005275,8661000005276,8661000005277,8661000005278,8661000005279,8661000005280,8661000005281,8661000005282";
String ATTICEPOINTCODE[] = ATTICEPOINTCODE_all.split(",");

for(int i=0;i<SUBBRANCHNAME.length;i++){
System.out.println("insert into ge_qinnong_atticepointcode (ID, SUBBRANCHNAME, SUBBRANCHCODE, INNERBANKCODE, SALEMANCODE, ATTICEPOINTCODE, MANAGECOM)");
System.out.println("values (sys_guid(), '"+SUBBRANCHNAME[i]+"', '27"+INNERBANKCODE[i]+"', '"+INNERBANKCODE[i]+"', '0000090456', '"+ATTICEPOINTCODE[i]+"', '8661970022');");
}

posted on 2018-12-17 17:36  it小精灵  阅读(1347)  评论(0编辑  收藏  举报

导航