mysql 原生 添加数据_Golang原生sql操作Mysql数据库增删改查

Golang要操作mysql数据库，首先需要在当期系统配置GOPATH，因为需要使用go get命令把驱动包下载到GOPATH下使用。

首先配置好你的GOPATH，执行以下命令，下载安装mysql驱动，下载完成之后会在GOPATH下的src/github.com目录下

//路由文件

package routers

import (

"github.com/astaxie/beego"

"mypro/controllers"

)

func init() {

beego.Router("/", &controllers.MainController{})

beego.Router("/collection", &controllers.CollectionController{})

beego.Router("/getmovieinfo/?:id", &controllers.GetMovieInfoController{},"get:Get")

beego.Router("/postmovieinfo", &controllers.GetMovieInfoController{},"post:Post") //post

beego.Router("/editmovieinfo/?:id", &controllers.GetMovieInfoController{},"get:Edit") //post

beego.Router("/editmovieinfo", &controllers.GetMovieInfoController{},"post:EditPost") //post

beego.Router("/deletemovieinfo/?:id", &controllers.GetMovieInfoController{},"get:Delete") //post

beego.Router("/addmovieinfo", &controllers.GetMovieInfoController{},"post:Add") //post

beego.Router("/addmovieinfoview", &controllers.GetMovieInfoController{},"get:AddView") //post

}

//控制器文件

package controllers

import (

"fmt"

"github.com/astaxie/beego"

"mypro/models"

"strings"

)

type GetMovieInfoController struct {

beego.Controller

}

type MovieInfo struct {

Id int64

Movie_name stri