查询NULL处理

查询NULL值的处理代码如下:

func queryNULL(db * sql.DB){
        var err        error
        var rows     * sql.Rows
        var valInt     sql.NullInt32
        var valString  sql.NullString
        var selectSQL  string = "select col1, col2 from testcase1"
        rows, err = db.Query(selectSQL)
        getError(err)
        defer rows.Close()
        for rows.Next(){
                rows.Scan(&valInt, &valString)
                if valInt.Valid{
                        fmt.Println(valInt.Int32)
                } else {
                        //空值
                }
                if valString.Valid {
                        fmt.Println(valString.String)
                } else {
                        //空值
                }
        }
}