ibatis java配置文件_ibatis中的xml配置文件

type="com.ecar.eoc.content.music.domain.music.json.MusicTypeJson" />

type="com.ecar.eoc.content.music.domain.music.MusicType" />

TYPE_ID = #typeId:INTEGER#

TYPE_CODE = #typeCode:VARCHAR#

NAME = #name:VARCHAR#

CATEGORY_CODE = #categoryCode:VARCHAR#

LOGO = #logo:VARCHAR#

CP_CODE = #cpCode:VARCHAR#

SUPPLIER_TYPE_CODE = #supplierTypeCode:VARCHAR#

SUPPLIER_CATEGORY_CODE = #supplierCategoryCode:VARCHAR#

IS_VALID = #isValid:VARCHAR#

MD5 = #md5:VARCHAR#

CREATE_TIME = #createTime:DATE#

RANKING IS NULL

RANKING = #ranking:INTEGER#

ORDER BY ORDERBY

select m.TYPE_CODE,m.NAME,m.LOGO

from EOC_CONTENT_MUSIC_TYPE m

where m.CP_CODE=#coCode:VARCHAR# and m.IS_VALID = #isValid:VARCHAR#

select m.TYPE_CODE,m.NAME,m.CATEGORY_CODE,m.CP_CODE,m.SUPPLIER_TYPE_CODE,m.SUPPLIER_CATEGORY_CODE,m.MD5,m.NUM

from EOC_CONTENT_MUSIC_TYPE m

where m.TYPE_CODE=#typeCode:VARCHAR# and m.IS_VALID = #isValid:VARCHAR#

select m.TYPE_CODE,m.NAME,m.CATEGORY_CODE,m.CP_CODE,m.SUPPLIER_TYPE_CODE,m.SUPPLIER_CATEGORY_CODE,m.MD5,m.NUM

from EOC_CONTENT_MUSIC_TYPE m

where m.CP_CODE=#cpCode:VARCHAR# and m.IS_VALID = #isValid:VARCHAR#

UPDATE EOC_CONTENT_MUSIC_TYPE

SET MD5=#md5:VARCHAR#

WHERE TYPE_CODE =#typeCode:VARCHAR#

select TYPE_ID, TYPE_CODE, NAME, CATEGORY_CODE, LOGO, CP_CODE, SUPPLIER_TYPE_CODE,SUPPLIER_CATEGORY_CODE, IS_VALID, MD5, CREATE_TIME,NUM,RANKING,ORDERBY

from EOC_CONTENT_MUSIC_TYPE

LIMIT 20

SELECT (MAX(TYPE_CODE)+1) COUNT FROM EOC_CONTENT_MUSIC_TYPE

DELETE FROM `EOC_CONTENT_MUSIC_TYPE`

INSERT INTO EOC_CONTENT_MUSIC_TYPE

TYPE_ID

TYPE_CODE

NAME

CATEGORY_CODE

LOGO

CP_CODE

SUPPLIER_TYPE_CODE

SUPPLIER_CATEGORY_CODE

IS_VALID

MD5

ORDERBY

NUM

RANKING

CREATE_TIME

)

values

#typeId:INTEGER#

#typeCode:VARCHAR#

#name:VARCHAR#

#categoryCode:VARCHAR#

#logo:VARCHAR#

#cpCode:VARCHAR#

#supplierTypeCode:VARCHAR#

#supplierCategoryCode:VARCHAR#

#isValid:VARCHAR#

#md5:VARCHAR#

#orderBy:INTEGER#

#num:INTEGER#

#ranking:INTEGER#

#createTime:DATE#

)

SELECT LAST_INSERT_ID()

原文：http://www.cnblogs.com/liuying1995/p/5729477.html