周道格的部落格

import(
 "database/sql"
 _ "github.com/go-sql-driver/mysql"
)

var connectionString = fmt.Sprintf(
"%s:%s@tcp(%s:3306)/%s?allowNativePasswords=true",
 db_userName, db_password, db_host, db_name)

func Test(name string, passwrd string, phone string) string {
   db, err := sql.Open("mysql", connectionString)
   if err != nil {
      return err.Error()
   }
   defer db.Close()
   cmd, err := db.Exec("INSERT INTO TableName(UserName, 
            Password,PhoneNumb) VALUE(?,?,?)", name, passwrd, phone)
   if err != nil {
      return err.Error()
   }

   _, err = cmd.RowsAffected()
   if err != nil {
      return err.Error()
   } else {
      return "SUCCESS"
   }
}