一个ibatis生成JAVA相关配置文件的工具,非常好用,
地址:http://www.ibatis3.com/
会自动生成dao,xml,以及相应的service文件
对于多表查询,可以在相应的结果的XML里面查询,
如下面的SQL语句,查询的是PS_ARTIST表的信息,但是后面有相应的判断,如果用IBATIS自身的查询的话,会写多次嵌套,这样写就很容易实现查询了!
<select id="selectSearchbyNameAndPage" resultMap="BaseResultMap" parameterType="java.util.Map" >
select g.art_id as ART_ID, g.art_12530id as ART_12530ID,g.art_name as ART_NAME,g.art_ename as ART_ENAME,
g.art_simple_py as ART_SIMPLE_PY,g.art_sex as ART_SEX,g.art_area as ART_AREA, g.art_birthday as ART_BIRTHDAY,g.art_infor as ART_INFOR,
g.art_intro as ART_INTRO,g.art_tblog as ART_TBLOG,g.art_pic_path as ART_PIC_PATH,g.art_album_count as ART_ALBUM_COUNT,
g.art_track_count as ART_TRACK_COUNT,g.art_hot as ART_HOT,g.art_time as ART_TIME,g.art_tblog_type as ART_TBLOG_TYPE
from PHONECLIENT_V.PS_ARTIST g where g.art_id not in(select f.fav_cid from PHONECLIENT_V.PS_USER_FAV f where f.fav_uid=#{mobile} and f.fav_state=1 )
and(g.art_name like #{singername} or g.art_simple_py like #{singername} or g.art_ename like #{singername})
超级强的语句,完成推荐歌手的列表
1、用户未关注的
2、系统推荐的顺序排序
3、未推荐的按时间
select aa.art_id as ART_ID, aa.art_12530id as ART_12530ID,aa.art_name as ART_NAME,aa.art_ename as ART_ENAME,
aa.art_simple_py as ART_SIMPLE_PY,aa.art_sex as ART_SEX,aa.art_area as ART_AREA, aa.art_birthday as ART_BIRTHDAY,aa.art_infor as ART_INFOR,
aa.art_intro as ART_INTRO,aa.art_tblog as ART_TBLOG,aa.art_pic_path as ART_PIC_PATH,aa.art_album_count as ART_ALBUM_COUNT,
aa.art_track_count as ART_TRACK_COUNT,aa.art_hot as ART_HOT,aa.art_time as ART_TIME,aa.art_tblog_type as ART_TBLOG_TYPE from (
select g.art_id as ART_ID, g.art_12530id as ART_12530ID,g.art_name as ART_NAME,g.art_ename as ART_ENAME,
g.art_simple_py as ART_SIMPLE_PY,g.art_sex as ART_SEX,g.art_area as ART_AREA, g.art_birthday as ART_BIRTHDAY,g.art_infor as ART_INFOR,
g.art_intro as ART_INTRO,g.art_tblog as ART_TBLOG,g.art_pic_path as ART_PIC_PATH,g.art_album_count as ART_ALBUM_COUNT,
g.art_track_count as ART_TRACK_COUNT,g.art_hot as ART_HOT,g.art_time as ART_TIME,g.art_tblog_type as ART_TBLOG_TYPE,
NVL(g1.hc_sequence,0) as hc_sequence
from PHONECLIENT_V.PS_ARTIST g
left join (select h.hc_cid as hc_cid , h.hc_sequence as hc_sequence from PHONECLIENT_V.PS_HOT h where h.hc_type = 1) g1
on g.art_id=g1.hc_cid
where g.art_id not in(select f.fav_cid from PHONECLIENT_V.PS_USER_FAV f where f.fav_uid=#{mobile} and f.fav_state=1 )
order by g1.hc_sequence) aa order by aa.hc_sequence desc ,aa.ART_ID
</select>
分享到:
相关推荐
在ibatis日志信息中打印SQL语句的方法(个人总结)
iBatis最全的动态SQL语句,你需要的都有,资源在于大家共享
ibatis常用的sql语句,很全的一篇文档。。。
ibatis常用sql语句,简单易懂,方便查询,初学者宝典
ibatis16个常用sql语句
用Ibatis时,配置sql语句时候 如果直接从sql里面把语句拷出来,玩玩格式不严谨,我写了这个工具来帮助我们格式化sql语句
ibatis sql 语句的编写 ,包括增删改查,很简单 很实用 ,对初学者是很好的选择
ibatis sql语句对条件中特殊字符% # 处理
WAS上log4j日志不能输出(ibatis)sql语句解决办法[借鉴].pdf
sql语句中用问号代替参数
主要是关于oracle ibatis 的一些sql
通过java程序查看ibatis配置文件中的sql语句(注:无法查看变量值)
因为要下载其它的文件,所以从网站复制了一些其它的资源进行上传。但是这个资源是相当有用的。这里感谢之前总结相关技术的人员。谢谢
NULL 博文链接:https://hqhe-nj.iteye.com/blog/342372
在java的控制台中看到的sql日志通常是如下的样子, Preparing: SELECT in (0,1) ORDER BY i.... 使用方法复制sql语句包括prepare丢到第一个文本框中,然后点start。转换好的就在下面了。 程序的页面可以直接双击打开。
生成数据库表结构: 根据解析得到的SQL语句中的表名、字段名、数据类型等信息,动态地生成相应的数据库表结构。这可以通过编程语言与数据库操作的API来实现,比如Java中的JDBC或者MyBatis/iBatis提供的API。 执行SQL...
将日志输出的sql语句中的问号 ? 替换成真正的参数值。 通过 "Tools -> MyBatis Log Plugin" 菜单或快捷键 "Ctrl+Shift+Alt+O" 启用。 点击窗口左边的 "Filter" 按钮,可以过滤不想要输出的sql语句。 点击窗口左边...
ibatis2包和能显示执行的sql语句的ibatis2.jar 能够显示所执行的sql
原生封装sql语句,增删改查,附带连接数据库
SQL Map使用简单的XML配置文件将Java Bean映射成SQL语句,对比其他的数据库持续层和ORM框架(如JDO的实现,Hibernate等),SQL Map最大的优点在于它简单易学。要使用SQL Map,只要熟悉Java Bean,XML和SQL,就能使您...