数据查询

示例如下，省略数据库连接操作：

• 1) 查询多行

func queryWithParam1(db * sql.DB){
        var val1     int
        var val2     string
        var rows *   sql.Rows
        var err      error
        var querySQL string = "select col1, col2 from testcase1 where col1 = :1"

        rows, err = db.Query(querySQL, 10)
getError(err)
        defer rows.Close()
        for rows.Next(){
                rows.Scan(&val1, &val2)
                fmt.Println(val1)
                fmt.Println(val2)
        }
}

• 2) 无参数查询

func queryWithParam2(db * sql.DB){
        var val1     int
        var val2     string
        var rows *   sql.Rows
        var err      error
        var querySQL string = "select col1, col2 from testcase1"

        rows, err = db.Query(querySQL)
        getError(err)
        defer rows.Close()
                for rows.Next(){
                rows.Scan(&val1, &val2)
                fmt.Println(val1)
                fmt.Println(val2)
        }
}

• 3) 查询最多一行

func queryOneRow(db *sql.DB){
        var val1     int
        var val2     string
        var row    * sql.Row
        var err      error
        var querySQL string = "select col1, col2 from testcase1 order by col1 ASC"
        row = db.QueryRow(querySQL)
        err = row.Scan(&val1, &val2)
        getError(err)
        fmt.Println(val1)
        fmt.Println(val2)
}