Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package main
- import (
- "database/sql"
- _ "DBAndProtobuf_Gotest/github.com/go-sql-driver/mysql"
- "fmt"
- )
- var(
- dbhostsip = "127.0.0.1:3306" //IP地址
- dbusername = "root" //数据库的用户名
- dbpassword = "123456" //登录数据库的密码
- dbname = "userif" //数据库表名
- )
- func main() {
- db,err := sql.Open("mysql","root:123456@tcp(127.0.0.1:3306)/dbtest?charset=utf8") //dbtest为我新建立的数据库名
- checkErr(err)
- //插入数据
- stmt,err := db.Prepare("INSERT userif SET userid=?,username=?,departname=?,created=?")
- checkErr(err)
- res,err := stmt.Exec(20180670,"lianlian","Resotry","2018-06-20")
- checkErr(err)
- id,err := res.LastInsertId()
- checkErr(err)
- fmt.Println(id)
- //更新数据
- stmt,err = db.Prepare("UPDATE userif SET username=? where userid=?")
- checkErr(err)
- res,err = stmt.Exec("happy",20180620)
- checkErr(err)
- affect,err := res.RowsAffected()
- checkErr(err)
- fmt.Println(affect)
- //查询数据
- rows,err := db.Query("SELECT * FROM userif")
- checkErr(err)
- for rows.Next(){
- var userid int
- var username string
- var departname string
- var created string
- err = rows.Scan(&userid,&username,&departname,&created)
- checkErr(err)
- fmt.Println(userid)
- fmt.Println(username)
- fmt.Println(departname)
- fmt.Println(created)
- }
- //删除数据
- stmt,err = db.Prepare("DELETE from userif where userid=?")
- checkErr(err)
- res,err = stmt.Exec(20180651)
- checkErr(err)
- affect,err = res.RowsAffected()
- checkErr(err)
- fmt.Println(affect)
- //关闭数据库
- db.Close()
- }
- func checkErr(err error){
- if err != nil{
- panic(err)
- }
- }
Add Comment
Please, Sign In to add comment