查询语句

查询语句的代码如下：

func prepareStatement1(db * sql.DB){
        var err       error
        var stmt    * sql.Stmt
        var rows    * sql.Rows
        var val1      int      = 10
        var querySQL  string   = "select col2 from testcase1 where col1 = :1"
        //准备查询语句
        stmt, err = db.Prepare(querySQL)
        defer stmt.Close()
        getError(err)

        rows, err = stmt.Query(val1)
        getError(err)
        for rows.Next() {
                var val2 string
                rows.Scan(&val2)
                fmt.Println(val2)
        }
}