一其掂、mySql連接
1、引入驅動包和xorm
import "github.com/go-xorm/xorm"
import _ "github.com/go-sql-driver/mysql"
2潦蝇、連接數(shù)據(jù)庫
engine,err:=xorm.NewEngine("mysql","user:pwd@tcp(127.0.0.1:3306)/db_name?charset=utf8")
if config.ENV !=config.RELEASE{
engine.ShowSQL(true)
}
}
3款熬、查詢
db.QueryString("select *from tbl_name where id=? and user_name=?",id,userName)
db.QueryInterface("select *from tbl_name where id=? and user_name=?",id,userName)
4、插入
此處插入用其他方式會報錯攘乒，不知為何
insertSQl :=fmt.Sprintf("insert into tbl_name(user_name,id) values('%s','%s')",userName,id)
_,err := db.Exec(insertSQl)
5贤牛、刪除
此處插入用其他方式會報錯，不知為何
deleteSql :=fmt.Sprintf("delete from tbl_name where id='%s' ",id)
_, err := db.Exec(deleteSql)
5则酝、存儲過程
sql1 :=fmt.Sprintf("EXEC tbl_name_XX?@id=?,@status=?,@msg=?")
res1,err1 := sqlEngine.QueryInterface(sql1,id,0,"")
