import "database/sql" 使用的数据表:
CREATE TABLE `userinfo` ( 代码:
package main
import(
"database/sql" "fmt" _"github.com/go-sql-driver/mysql"
)
func main(){
db,err:=sql.Open("mysql","root:root@tcp(localhost:8889)/ghj1976test?charset=utf8") checkErr(err)
//插入数据 stmt,err:=db.Prepare("INSERT userinfo SET username=?,departname=?,created=?") checkErr(err)
res,err:=stmt.Exec("ghj1976","RD部门","2013-03-18") checkErr(err)
res,err=stmt.Exec("astaxie","RD部门","2012-12-09") checkErr(err)
id,err:=res.LastInsertId()
checkErr(err)
fmt.Println(id)
//修改数据 stmt,err=db.Prepare("update user info set username=? where uid=?") checkErr(err)
res,err=stmt.Exec("astaxieupdate",id) checkErr(err)
affect,err:=res.RowsAffected()
checkErr(err)
fmt.Println(affect)
//搜索数据 rows,err:=db.Query("SELECT * FROM userinfo") checkErr(err)
for rows.Next(){ var uid int var username string var department string var created string err=rows.Scan(&uid,&username,&department,&created)
checkErr(err)
fmt.Println(uid)
fmt.Println(username)
fmt.Println(department)
fmt.Println(created)
}
//删除数据 stmt,err=db.Prepare("delete from user info where uid=?") checkErr(err)
res,err=stmt.Exec(id)
checkErr(err)
affect,err=res.RowsAffected()
checkErr(err)
fmt.Println(affect) db.Close()
} func checkErr(err error){ if err!=nil{ panic(err) }
} db.Prepare()函数用来返回准备要执行的sql操作,然后返回准备完毕的执行状态。 |
|
来自: 昵称13039494 > 《go语言》