mysql 重复列名如何查询

xujinyao 2012-06-04 10:33:47

SQL语句:
SELECT DISTINCT '供应' AS 0module_name,'0' AS 0is_catattr,'Supply' AS 0table_name,(SELECT COUNT(*) FROM supply WHERE DAY(supply.in_date)=DAY(NOW()) AND MONTH(supply.in_date)=MONTH(NOW()) AND YEAR(supply.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM supply WHERE info_state='0') AS 0countaudit,'求购' AS 0module_name,'1' AS 0is_catattr,'Buy' AS 0table_name,(SELECT COUNT(*) FROM buy WHERE DAY(buy.in_date)=DAY(NOW()) AND MONTH(buy.in_date)=MONTH(NOW()) AND YEAR(buy.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM buy WHERE info_state='0') AS 0countaudit,'产品' AS 0module_name,'1' AS 0is_catattr,'Product' AS 0table_name,(SELECT COUNT(*) FROM product WHERE DAY(product.in_date)=DAY(NOW()) AND MONTH(product.in_date)=MONTH(NOW()) AND YEAR(product.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM product WHERE info_state='0') AS 0countaudit,'企业' AS 0module_name,'1' AS 0is_catattr,'Member' AS 0table_name,(SELECT COUNT(*) FROM member WHERE DAY(member.in_date)=DAY(NOW()) AND MONTH(member.in_date)=MONTH(NOW()) AND YEAR(member.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM member WHERE info_state='0') AS 0countaudit,'资讯' AS 0module_name,'1' AS 0is_catattr,'News' AS 0table_name,(SELECT COUNT(*) FROM news WHERE DAY(news.in_date)=DAY(NOW()) AND MONTH(news.in_date)=MONTH(NOW()) AND YEAR(news.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM news WHERE info_state='0') AS 0countaudit,'展会' AS 0module_name,'1' AS 0is_catattr,'Showinfo' AS 0table_name,(SELECT COUNT(*) FROM showinfo WHERE DAY(showinfo.in_date)=DAY(NOW()) AND MONTH(showinfo.in_date)=MONTH(NOW()) AND YEAR(showinfo.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM showinfo WHERE info_state='0') AS 0countaudit,'招聘' AS 0module_name,'1' AS 0is_catattr,'Job' AS 0table_name,(SELECT COUNT(*) FROM job WHERE DAY(job.in_date)=DAY(NOW()) AND MONTH(job.in_date)=MONTH(NOW()) AND YEAR(job.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM job WHERE info_state='0') AS 0countaudit,'人才' AS 0module_name,'1' AS 0is_catattr,'Resume' AS 0table_name,(SELECT COUNT(*) FROM resume WHERE DAY(resume.in_date)=DAY(NOW()) AND MONTH(resume.in_date)=MONTH(NOW()) AND YEAR(resume.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM resume WHERE info_state='0') AS 0countaudit,'知道' AS 0module_name,'1' AS 0is_catattr,'Ask' AS 0table_name,(SELECT COUNT(*) FROM ask WHERE DAY(ask.in_date)=DAY(NOW()) AND MONTH(ask.in_date)=MONTH(NOW()) AND YEAR(ask.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM ask WHERE info_state='0') AS 0countaudit,'专题' AS 0module_name,'1' AS 0is_catattr,'Subject' AS 0table_name,(SELECT COUNT(*) FROM subject WHERE DAY(subject.in_date)=DAY(NOW()) AND MONTH(subject.in_date)=MONTH(NOW()) AND YEAR(subject.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM subject WHERE info_state='0') AS 0countaudit,'图库' AS 0module_name,'1' AS 0is_catattr,'Gallery' AS 0table_name,(SELECT COUNT(*) FROM gallery WHERE DAY(gallery.in_date)=DAY(NOW()) AND MONTH(gallery.in_date)=MONTH(NOW()) AND YEAR(gallery.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM gallery WHERE info_state='0') AS 0countaudit,'视频' AS 0module_name,'1' AS 0is_catattr,'Video' AS 0table_name,(SELECT COUNT(*) FROM video WHERE DAY(video.in_date)=DAY(NOW()) AND MONTH(video.in_date)=MONTH(NOW()) AND YEAR(video.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM video WHERE info_state='0') AS 0countaudit,'下载' AS 0module_name,'1' AS 0is_catattr,'Download' AS 0table_name,(SELECT COUNT(*) FROM download WHERE DAY(download.in_date)=DAY(NOW()) AND MONTH(download.in_date)=MONTH(NOW()) AND YEAR(download.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM download WHERE info_state='0') AS 0countaudit,'品牌' AS 0module_name,'1' AS 0is_catattr,'Brand' AS 0table_name,(SELECT COUNT(*) FROM brand WHERE DAY(brand.in_date)=DAY(NOW()) AND MONTH(brand.in_date)=MONTH(NOW()) AND YEAR(brand.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM brand WHERE info_state='0') AS 0countaudit,'分类信息' AS 0module_name,'0' AS 0is_catattr,'Classified' AS 0table_name,(SELECT COUNT(*) FROM classified WHERE DAY(classified.in_date)=DAY(NOW()) AND MONTH(classified.in_date)=MONTH(NOW()) AND YEAR(classified.in_date)=YEAR(NOW())) AS 0todaycount,(SELECT COUNT(*) FROM classified WHERE info_state='0') AS 0countaudit From member;

查询结果:
| 0module_name | 0is_catattr | 0table_name | 0todaycount | 0countaudit | 0modul
_name | 0is_catattr | 0table_name | 0todaycount | 0countaudit | 0module_name |
is_catattr | 0table_name | 0todaycount | 0countaudit | 0module_name | 0is_catat
r | 0table_name | 0todaycount | 0countaudit | 0module_name | 0is_catattr | 0tab
e_name | 0todaycount | 0countaudit | 0module_name | 0is_catattr | 0table_name |
0todaycount | 0countaudit | 0module_name | 0is_catattr | 0table_name | 0todayco
nt | 0countaudit | 0module_name | 0is_catattr | 0table_name | 0todaycount | 0co
ntaudit | 0module_name | 0is_catattr | 0table_name | 0todaycount | 0countaudit
0module_name | 0is_catattr | 0table_name | 0todaycount | 0countaudit | 0module
name | 0is_catattr | 0table_name | 0todaycount | 0countaudit | 0module_name | 0
s_catattr | 0table_name | 0todaycount | 0countaudit | 0module_name | 0is_catatt
| 0table_name | 0todaycount | 0countaudit | 0module_name | 0is_catattr | 0tabl
_name | 0todaycount | 0countaudit | 0module_name | 0is_catattr | 0table_name |
todaycount | 0countaudit |
+--------------+-------------+-------------+-------------+-------------+-------

| 供应 | 0 | Supply | 0 | 0 | 求购
| 1 | Buy | 0 | 0 | 产品 |
| Product | 0 | 0 | 企业 | 1
| Member | 0 | 0 | 资讯 | 1 | News
| 0 | 0 | 展会 | 1 | Showinfo |
0 | 0 | 招聘 | 1 | Job |
0 | 0 | 人才 | 1 | Resume | 0 |
0 | 知道 | 1 | Ask | 0 | 0
专题 | 1 | Subject | 0 | 0 | 图库
| 1 | Gallery | 0 | 0 | 视频 | 1
| Video | 0 | 0 | 下载 | 1
| Download | 0 | 0 | 品牌 | 1 | Brand
| 0 | 0 | 分类信息 | 0 | Classified |
0 | 0 |

ibates 可以用HashMap取出来,如果改用jdbc如何查询

...全文