写成
strSQL = "SELECT c.CATNAME as CATNAME, ui.CATID as CATID, ui.USERID as USERID, u.USERNAME as USERNAME " +
....
试试
如果还不行就用rs.getInt(3)吧
strSQL = "SELECT c.CATNAME as CATNAME, ui.CATID as CATID, ui.USERID as USERID, u.USERNAME as USERNAME " +
....
试试
如果还不行就用rs.getInt(3)吧
如果不行,再在取的时候用楼上的方法:rs.getInt("[USERID]")
上面的那些rs.getXXX都注释掉看看,这句会不会错。
原来是要按SELECT字段的顺序get 汗!...“
我刚开始也是这样的。:)
问题解决了别忘了给分哦。