173-beego预处理

beego预处理




stmt,err := conn.Prepare("insert into tb_user values(?,?)")
if err!=nil {
	beego.Error("预处理创建失败",err)
}

//使用stmt
stmt.Exec("Alice","123")
//此时就将Alice和123两个值
//填充到了sql语句中

count,err := result.RowsAffected()
beego.Info("受影响行数",count)






stmt,err := conn.Prepare("select * from tb_user where name =?")
rows,err := stmt.Query("Alice")

var name,pwd string
for rows.Next(){
	rows.Scan(&name,&pwd)
	beego.Info("name=",name,"pwd=",pwd)
}