go语言 mysql操作

import("fmt"
       "net"
       "strings"
       "database/sql"

       _ "github.com/go-sql-driver/mysql"
       "encoding/json"
       //"bytes"
       "bytes"
       "io"
       //"time"
       "time"
)

type Net_tcp_pt struct {
       Address      string
       State        string
       Program_name string
}
type Net_tcp_pt_slice struct {
       N []Net_tcp_pt
}

func insert_net_pt_info(net_pt_info  []Net_tcp_pt , clientarr string , timenow string ,servertime string)string{

       db, err := sql.Open("mysql", "root:jingxin@tcp(127.0.0.1:3306)/system_visit")
       defer db.Close()
       stmt_net_pt, err := db.Prepare("INSERT INTO remot_os_net_pt (remote_server_ip, remote_server_mac,remote_server_time,remote_server_address,remote_server__state,remote_server__Program_name,input_time) VALUES (?, ?, ?, ?, ?, ?, ?)")
       checkErr(err)
       defer  stmt_net_pt.Close()
       var info_len = len(net_pt_info)
       i := 0
       for i = 0; i < info_len; i++{
              //my_net_pt := &Net_tcp_pt{}
              //err := json.Unmarshal([]byte(net_pt_info[i]), &my_net_pt)
              //if err != nil{
              //
              //}
              var my_net_pt = net_pt_info[i]
              fmt.Println(my_net_pt)
              stmt_net_pt.Exec(clientarr , "",servertime,my_net_pt.Address,my_net_pt.State,my_net_pt.Program_name,timenow)
       }

       return ""
}