String sql="select userid ,username,now() as time from usercode where userid='wb' "; ... System.out.print(rmeta.getColumnName(3)); //取不到"time",取出来的为null,为什么呢? ...
to Davis129(混浊の水): 没错,这就是我遇到的并且想要解决的问题呀!真是奇怪,但如果在后台运行,显示的列名time 如下图所示: mysql> select userid ,username,now() as time from usercode where userid='wb' ; +--------+----------+---------------------+ | userid | username | time | +--------+----------+---------------------+ | wb | 卫斌 | 2006-06-12 11:18:11 | +--------+----------+---------------------+ 1 row in set (0.00 sec)
select now() as time from dual
测试通不过。
...
System.out.print(rmeta.getColumnName(3)); //取不到"time",取出来的为null,为什么呢?
...
没错,这就是我遇到的并且想要解决的问题呀!真是奇怪,但如果在后台运行,显示的列名time
如下图所示:
mysql> select userid ,username,now() as time from usercode where userid='wb' ;
+--------+----------+---------------------+
| userid | username | time |
+--------+----------+---------------------+
| wb | 卫斌 | 2006-06-12 11:18:11 |
+--------+----------+---------------------+
1 row in set (0.00 sec)
for(int i=1;i<=numColumns;i++)
{
System.out.print(rmeta.getColumnLabel(i));
System.out.print("|");
}
......