golang-querymore&detele&update&delete

查询多条数据（query_more)

func query_more(userid int){
	//1.SQL语句
	sqlStr := `select userid,username,password from users where userid >?;`
	//2.执行
	rows,err := db.Query(sqlStr,userid)
	if err != nil{
		fmt.Printf("exec %s query failed,err:%v\n",sqlStr,err)
		return
	}
	//3.一定要关闭rows
	defer rows.Close()
	//4.循环取值
	for rows.Next(){
		var u1 users
		err := rows.Scan(&u1.userid,&u1.username,&u1.password)
		if err != nil {
			fmt.Printf("scan failed,err:%v",err)
		}
		fmt.Printf("u1:%#v\n ",u1)
	}
}

插入数据

eg：

func insert(){
	//1.写SQL语句
	sqlStr := `insert into users(userid,username,password) values(15,20062112,"sblmx")`
	//2.exec 
	ret,err := db.Exec(sqlStr)
	if err != nil {
		fmt.Printf("insert failed,err:%v",err)
		return
	}
	// 如果是插入数据的操作，能够拿到插入数据的id
	userid,err := ret.LastInsertId()
	if err != nil {
		fmt.Printf("get userid failed,err:%v\n",err)
		return
	}
	fmt.Printf("userid:",userid)
}

运行结果为：

更新数据

func updateRow(newPassword string,userid int){
	sqlStr := `update users set password = ? where userid = ?`
	ret,err := db.Exec(sqlStr,newPassword,userid)
	if err != nil {
		fmt.Printf("update failed,error: %v",err)
		return 
	}
	n,err := ret.RowsAffected()
	if err != nil {
		fmt.Printf("get id,error: %v",err)
		return 
	}
	fmt.Printf("更细了%d行数据\n",n)
}

删除操作

eg：

//定义删除users数据库中的数据
func delete(userid int){
	sqlStr := "delete from users where userid=?"
	ret,err := db.Exec(sqlStr,userid)
	if err != nil {
		fmt.Printf("delete failed,err:%v",err)
		return
	}
	n,err := ret.RowsAffected()
	if err != nil {
		fmt.Printf("get id,error: %v",err)
		return 
	}
	fmt.Printf("更新了%d行数据\n",n)

}

运行结果是：