eg:
//预处理方式插入多条数据
func prepareInsert(){
sqlstr := "insert into users(username,password) values(?,?)"
stmt,err := db.Prepare(sqlstr)
if err != nil {
fmt.Printf("prepare failed,err:%v",err)
return
}
// 后续只需要拿到stmt去执行一些操作
//stmt.Exec(20062155,"6546")
var m = map[int]string{
20062144:"666",
56456456:"55564",
45464565:"5445",
}
for k,v := range m{
stmt.Exec(k,v)
}
}