SqlHelper重构

在机房重构的时候有用到SqlHelper（点击查看），当时什么都不懂。后来经过不断的使用，开始理解其中的意思。后来发现原来的SqlHelper写的有点繁琐。对于每个操作都需要写两次，来区分是否带参数。这次，重构一版，来改善一下它的缺点。 长度可变参数params 首先，我们来看一下长度可变参数params。举两个例子来说明  第一个 class Program     {...

SqlHelper

http://www.douban.com/doulist/38811866/
http://www.douban.com/doulist/38811867/
http://www.douban.com/doulist/38812106/
http://www.douban.com/doulist/38812107/
http://www.douban.com/doulist/38812108/
http://www.douban.com/doulist/38812109/
http://www.douban.com/doulist/38812111/
http://www.douban.com/doulist/38812112/
http://www.douban.com/doulist/38812114/
http://www.douban.com/doulist/38812115/
http://www.douban.com/doulist/38812116/
http://www.douban.com/doulist/38812117/
http://www.douban.com/doulist/38812118/
http://www.douban.com/doulist/38812119/
http://www.douban.com/doulist/38812120/
http://www.douban.com/doulist/38812121/
http://www.douban.com/doulist/38812122/
http://www.douban.com/doulist/38812124/
http://www.douban.com/doulist/38812125/
http://www.douban.com/doulist/38812126/
http://www.douban.com/doulist/38812127/
http://www.douban.com/doulist/38812128/
http://www.douban.com/doulist/38812129/
http://www.douban.com/doulist/38812130/
http://www.douban.com/doulist/38812131/
http://www.douban.com/doulist/38812132/
http://www.douban.com/doulist/38812133/
http://www.douban.com/doulist/38812134/
http://www.douban.com/doulist/38812135/
http://www.douban.com/doulist/38812136/
http://www.douban.com/doulist/38812137/
http://www.douban.com/doulist/38812138/
http://www.douban.com/doulist/38812139/
http://www.douban.com/doulist/38812140/
http://www.douban.com/doulist/38812141/
http://www.douban.com/doulist/38812142/
http://www.douban.com/doulist/38812143/
http://www.douban.com/doulist/38812144/
http://www.douban.com/doulist/38812145/
http://www.douban.com/doulist/38812147/
http://www.douban.com/doulist/38812148/
http://www.douban.com/doulist/38812149/
http://www.douban.com/doulist/38812150/
http://www.douban.com/doulist/38812151/
http://www.douban.com/doulist/38812152/
http://www.douban.com/doulist/38812153/
http://www.douban.com/doulist/38812154/
http://www.douban.com/doulist/38812155/
http://www.douban.com/doulist/38812156/
http://www.douban.com/doulist/38812157/
http://www.douban.com/doulist/38812158/
http://www.douban.com/doulist/38812162/
http://www.douban.com/doulist/38812163/
http://www.douban.com/doulist/38812165/
http://www.douban.com/doulist/38812166/
http://www.douban.com/doulist/38812167/
http://www.douban.com/doulist/38812168/
http://www.douban.com/doulist/38812169/
http://www.douban.com/doulist/38812170/
http://www.douban.com/doulist/38812172/
http://www.douban.com/doulist/38812173/
http://www.douban.com/doulist/38812174/
http://www.douban.com/doulist/38812175/
http://www.douban.com/doulist/38812176/
http://www.douban.com/doulist/38812177/
http://www.douban.com/doulist/38812178/
http://www.douban.com/doulist/38812179/
http://www.douban.com/doulist/38812180/
http://www.douban.com/doulist/38812181/
http://www.douban.com/doulist/38812182/
http://www.douban.com/doulist/38812183/
http://www.douban.com/doulist/38812184/
http://www.douban.com/doulist/38812186/
http://www.douban.com/doulist/38812187/
http://www.douban.com/doulist/38812188/
http://www.douban.com/doulist/38812189/
http://www.douban.com/doulist/38812190/
http://www.douban.com/doulist/38812191/
http://www.douban.com/doulist/38812193/
http://www.douban.com/doulist/38812194/
http://www.douban.com/doulist/38812195/
http://www.douban.com/doulist/38812196/
http://www.douban.com/doulist/38812197/
http://www.douban.com/doulist/38812198/
http://www.douban.com/doulist/38812199/
http://www.douban.com/doulist/38812200/
http://www.douban.com/doulist/38812201/
http://www.douban.com/doulist/38812202/
http://www.douban.com/doulist/38812203/
http://www.douban.com/doulist/38812204/
http://www.douban.com/doulist/38812205/
http://www.douban.com/doulist/38812206/
http://www.douban.com/doulist/38812208/
http://www.douban.com/doulist/38812209/
http://www.douban.com/doulist/38812211/
http://www.douban.com/doulist/38812212/
http://www.douban.com/doulist/38812213/
http://www.douban.com/doulist/38812214/
http://www.douban.com/doulist/38812215/
http://www.douban.com/doulist/38812216/
http://www.douban.com/doulist/38812217/
http://www.douban.com/doulist/38812218/
http://www.douban.com/doulist/38812219/
http://www.douban.com/doulist/38812220/
http://www.douban.com/doulist/38812221/
http://www.douban.com/doulist/38812222/
http://www.douban.com/doulist/38812223/
http://www.douban.com/doulist/38812224/
http://www.douban.com/doulist/38812226/
http://www.douban.com/doulist/38812227/
http://www.douban.com/doulist/38812228/
http://www.douban.com/doulist/38812229/
http://www.douban.com/doulist/38812231/
http://www.douban.com/doulist/38812232/
http://www.douban.com/doulist/38812233/
http://www.douban.com/doulist/38812235/
http://www.douban.com/doulist/38812236/
http://www.douban.com/doulist/38812238/
http://www.douban.com/doulist/38812239/
http://www.douban.com/doulist/38812240/
http://www.douban.com/doulist/38812241/
http://www.douban.com/doulist/38812242/
http://www.douban.com/doulist/38812243/
http://www.douban.com/doulist/38812244/
http://www.douban.com/doulist/38812245/
http://www.douban.com/doulist/38812247/
http://www.douban.com/doulist/38812248/
http://www.douban.com/doulist/38812249/
http://www.douban.com/doulist/38812251/
http://www.douban.com/doulist/38812252/
http://www.douban.com/doulist/38812253/
http://www.douban.com/doulist/38812254/
http://www.douban.com/doulist/38812255/
http://www.douban.com/doulist/38812256/
http://www.douban.com/doulist/38812257/
http://www.douban.com/doulist/38812258/
http://www.douban.com/doulist/38812259/
http://www.douban.com/doulist/38812260/
http://www.douban.com/doulist/38812261/
http://www.douban.com/doulist/38812262/
http://www.douban.com/doulist/38812264/
http://www.douban.com/doulist/38812265/
http://www.douban.com/doulist/38812266/
http://www.douban.com/doulist/38812267/
http://www.douban.com/doulist/38812268/
http://www.douban.com/doulist/38812269/
http://www.douban.com/doulist/38812270/
http://www.douban.com/doulist/38812271/
http://www.douban.com/doulist/38812273/
http://www.douban.com/doulist/38812274/
http://www.douban.com/doulist/38812275/
http://www.douban.com/doulist/38812276/
http://www.douban.com/doulist/38812277/
http://www.douban.com/doulist/38812278/
http://www.douban.com/doulist/38812279/
http://www.douban.com/doulist/38812280/
http://www.douban.com/doulist/38812281/
http://www.douban.com/doulist/38812282/
http://www.douban.com/doulist/38812285/
http://www.douban.com/doulist/38812286/
http://www.douban.com/doulist/38812287/
http://www.douban.com/doulist/38812288/
http://www.douban.com/doulist/38812289/
http://www.douban.com/doulist/38812290/
http://www.douban.com/doulist/38812291/
http://www.douban.com/doulist/38812292/
http://www.douban.com/doulist/38812293/
http://www.douban.com/doulist/38812294/
http://www.douban.com/doulist/38812295/
http://www.douban.com/doulist/38812296/
http://www.douban.com/doulist/38812297/
http://www.douban.com/doulist/38812298/
http://www.douban.com/doulist/38812299/
http://www.douban.com/doulist/38812300/
http://www.douban.com/doulist/38812301/
http://www.douban.com/doulist/38812302/
http://www.douban.com/doulist/38812303/
http://www.douban.com/doulist/38812305/
http://www.douban.com/doulist/38812306/
http://www.douban.com/doulist/38812307/
http://www.douban.com/doulist/38812309/
http://www.douban.com/doulist/38812310/
http://www.douban.com/doulist/38812312/
http://www.douban.com/doulist/38812313/
http://www.douban.com/doulist/38812314/
http://www.douban.com/doulist/38812315/
http://www.douban.com/doulist/38812316/
http://www.douban.com/doulist/38812318/
http://www.douban.com/doulist/38812319/
http://www.douban.com/doulist/38812320/
http://www.douban.com/doulist/38812321/
http://www.douban.com/doulist/38812322/
http://www.douban.com/doulist/38812323/
http://www.douban.com/doulist/38812325/
http://www.douban.com/doulist/38812326/
http://www.douban.com/doulist/38812327/
http://www.douban.com/doulist/38812328/
http://www.douban.com/doulist/38812329/
http://www.douban.com/doulist/38812330/
http://www.douban.com/doulist/38812331/
http://www.douban.com/doulist/38812332/
http://www.douban.com/doulist/38812333/
http://www.douban.com/doulist/38812334/
http://www.douban.com/doulist/38812335/
http://www.douban.com/doulist/38812336/
http://www.douban.com/doulist/38812337/
http://www.douban.com/doulist/38812338/
http://www.douban.com/doulist/38812339/
http://www.douban.com/doulist/38812340/
http://www.douban.com/doulist/38812341/
http://www.douban.com/doulist/38812342/
http://www.douban.com/doulist/38812343/
http://www.douban.com/doulist/38812344/
http://www.douban.com/doulist/38812345/
http://www.douban.com/doulist/38812346/
http://www.douban.com/doulist/38812347/
http://www.douban.com/doulist/38812348/
http://www.douban.com/doulist/38812349/
http://www.douban.com/doulist/38812350/
http://www.douban.com/doulist/38812351/
http://www.douban.com/doulist/38812352/
http://www.douban.com/doulist/38812354/
http://www.douban.com/doulist/38812355/
http://www.douban.com/doulist/38812356/
http://www.douban.com/doulist/38812357/
http://www.douban.com/doulist/38812358/
http://www.douban.com/doulist/38812359/
http://www.douban.com/doulist/38812360/
http://www.douban.com/doulist/38812361/
http://www.douban.com/doulist/38812362/
http://www.douban.com/doulist/38812363/
http://www.douban.com/doulist/38812364/
http://www.douban.com/doulist/38812365/
http://www.douban.com/doulist/38812366/
http://www.douban.com/doulist/38812367/
http://www.douban.com/doulist/38812368/
http://www.douban.com/doulist/38812369/
http://www.douban.com/doulist/38812370/
http://www.douban.com/doulist/38812371/
http://www.douban.com/doulist/38812372/
http://www.douban.com/doulist/38812373/
http://www.douban.com/doulist/38812374/
http://www.douban.com/doulist/38812375/
http://www.douban.com/doulist/38812376/
http://www.douban.com/doulist/38812377/
http://www.douban.com/doulist/38812378/
http://www.douban.com/doulist/38812381/
http://www.douban.com/doulist/38812382/
http://www.douban.com/doulist/38812383/
http://www.douban.com/doulist/38812384/
http://www.douban.com/doulist/38812385/
http://www.douban.com/doulist/38812386/
http://www.douban.com/doulist/38812387/
http://www.douban.com/doulist/38812389/
http://www.douban.com/doulist/38812390/
http://www.douban.com/doulist/38812391/
http://www.douban.com/doulist/38812392/
http://www.douban.com/doulist/38812393/
http://www.douban.com/doulist/38812396/
http://www.douban.com/doulist/38812397/
http://www.douban.com/doulist/38812398/
http://www.douban.com/doulist/38812399/
http://www.douban.com/doulist/38812400/
http://www.douban.com/doulist/38812401/
http://www.douban.com/doulist/38812402/
http://www.douban.com/doulist/38812403/
http://www.douban.com/doulist/38812404/
http://www.douban.com/doulist/38812405/
http://www.douban.com/doulist/38812406/
http://www.douban.com/doulist/38812407/
http://www.douban.com/doulist/38812408/
http://www.douban.com/doulist/38812409/
http://www.douban.com/doulist/38812410/
http://www.douban.com/doulist/38812411/
http://www.douban.com/doulist/38812412/
http://www.douban.com/doulist/38812413/
http://www.douban.com/doulist/38812414/
http://www.douban.com/doulist/38812415/
http://www.douban.com/doulist/38812416/
http://www.douban.com/doulist/38812417/
http://www.douban.com/doulist/38812418/
http://www.douban.com/doulist/38812419/
http://www.douban.com/doulist/38812421/
http://www.douban.com/doulist/38812422/
http://www.douban.com/doulist/38812423/
http://www.douban.com/doulist/38812424/
http://www.douban.com/doulist/38812425/
http://www.douban.com/doulist/38812426/
http://www.douban.com/doulist/38812427/
http://www.douban.com/doulist/38812428/
http://www.douban.com/doulist/38812430/
http://www.douban.com/doulist/38812431/
http://www.douban.com/doulist/38812432/
http://www.douban.com/doulist/38812433/
http://www.douban.com/doulist/38812434/
http://www.douban.com/doulist/38812435/
http://www.douban.com/doulist/38812436/
http://www.douban.com/doulist/38812437/
http://www.douban.com/doulist/38812438/
http://www.douban.com/doulist/38812439/
http://www.douban.com/doulist/38812440/
http://www.douban.com/doulist/38812442/
http://www.douban.com/doulist/38812443/
http://www.douban.com/doulist/38812444/
http://www.douban.com/doulist/38812445/
http://www.douban.com/doulist/38812446/
http://www.douban.com/doulist/38812448/
http://www.douban.com/doulist/38812449/
http://www.douban.com/doulist/38812450/
http://www.douban.com/doulist/38812451/
http://www.douban.com/doulist/38812452/
http://www.douban.com/doulist/38812454/
http://www.douban.com/doulist/38812455/
http://www.douban.com/doulist/38812456/
http://www.douban.com/doulist/38812458/
http://www.douban.com/doulist/38812459/
http://www.douban.com/doulist/38812460/
http://www.douban.com/doulist/38812461/
http://www.douban.com/doulist/38812462/
http://www.douban.com/doulist/38812463/
http://www.douban.com/doulist/38812464/
http://www.douban.com/doulist/38812465/
http://www.douban.com/doulist/38812466/
http://www.douban.com/doulist/38812467/
http://www.douban.com/doulist/38812469/
http://www.douban.com/doulist/38812470/
http://www.douban.com/doulist/38812471/
http://www.douban.com/doulist/38812473/
http://www.douban.com/doulist/38812474/
http://www.douban.com/doulist/38812475/