Mybatis 可以说是 ibatis 的升级版 ,MyBatis 提供了更为强大的功能,同时并没有损失其易用性,相反,在很多地方都借助于 JDK 的泛型和注解特性进行了简化
Mybatis 配置文件需要
properties:
jdbc.username= jdbc.password= jdbc.url= jdbc.driver=
创建sql以及写sql的时候也会有略微不同
ibatis
A.LSH as lsh, A.CLRQ as clrq,
A.LSH = #lsh#
to_char(A.CLRQ,'yyyy-mm-dd') = #clrqString#
INSERT INTO VEH_LOG( LSH, CLRQ, ) VALUES ( #lsh:VARCHAR#, #clrq:TIMESTAMP#, )
UPDATE VEH_LOG SET LSH = #lsh#, SET CLRQ = #clrq#
YWLX = #ywlx:CHAR#
WHERE LSH = #lsh#, CLRQ = #clrq#
DELETE FROM VEH_LOG A WHERE A.LSH = #lsh#, A.CLRQ = #clrq#
DELETE FROM VEH_LOG A
mybatis
INSERT INTO business(id,img_file_name,title,subtitle,price,distance,number,`desc`,city,category,star_total_num,comment_total_num) VALUES(null,#{imgFileName},#{title},#{subtitle},#{price},#{distance},#{number},#{desc},#{city},#{category},#{starTotalNum},#{commentTotalNum})
UPDATE business SET img_file_name=#{imgFileName},title=#{title},subtitle=#{subtitle},price=#{price},distance=#{distance},number=#{number}, `desc`=#{desc},city=#{city},category=#{category},star_total_num=#{starTotalNum},comment_total_num=#{commentTotalNum} WHERE id=#{id}
以上是个人在开发中jue得的不同之处
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/198516.html原文链接:https://javaforall.net
