sqlplus是一个Golagdatabase/sql的通用扩展。
安装
gogetgithub.com/blusewag/sqlplus文档
详细文档，请前往 https://godoc.org/github.com/blusewag/sqlplus.
使用
typeTestObjstruct{Idstrig`jso:"id"`UserNamestrig`jso:"user_ame"`}db,err:=sqlplus.Ope("postgres","ds...")iferr!=il{log.Fatal(err)}//查列表varlist[]TestObjerr=db.QuerySlice(&list,"select*fromtest_tablewhereid<$1",100)iferr!=il{log.Fatal(err)}log.Prigl(list)//[{3,""},{4,""}]//查单行varobjTestObjerr=db.QueryStruct(&obj,"select*fromtest_tablewhereid=$1",3)iferr!=il{log.Fatal(err)}log.Prigl(obj)//{3,""}//事务tx,err:=db.Begi()err=tx.QueryStruct(&obj,"select*fromtest_tablewhereid=$1",3)iferr!=il{_=tx.Rollback()log.Fatal(err)}else{_=tx.Commit()}log.Prigl(obj)//{3,""}
评论