查询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 {
//空值
}
}
}