public interface AwfulTableMapper
Modifier and Type | Method and Description |
---|---|
long |
countByExample(AwfulTableExample example)
This method was generated by MyBatis Generator.
|
int |
deleteByExample(AwfulTableExample example)
This method was generated by MyBatis Generator.
|
int |
deleteByPrimaryKey(AwfulTableKey key)
This method was generated by MyBatis Generator.
|
int |
insert(AwfulTable row)
This method was generated by MyBatis Generator.
|
int |
insertSelective(AwfulTable row)
This method was generated by MyBatis Generator.
|
List<AwfulTable> |
selectByExample(AwfulTableExample example)
This method was generated by MyBatis Generator.
|
AwfulTable |
selectByPrimaryKey(AwfulTableKey key)
This method was generated by MyBatis Generator.
|
int |
updateByExample(AwfulTable row,
AwfulTableExample example)
This method was generated by MyBatis Generator.
|
int |
updateByExampleSelective(AwfulTable row,
AwfulTableExample example)
This method was generated by MyBatis Generator.
|
int |
updateByPrimaryKey(AwfulTable row)
This method was generated by MyBatis Generator.
|
int |
updateByPrimaryKeySelective(AwfulTable row)
This method was generated by MyBatis Generator.
|
long countByExample(AwfulTableExample example)
int deleteByExample(AwfulTableExample example)
@Delete(value={"delete from \"awful table\"","where \"CuStOmEr iD\" = #{customerId,jdbcType=INTEGER}"}) int deleteByPrimaryKey(AwfulTableKey key)
@Insert(value={"insert into \"awful table\" (\"first name\", FIRST_NAME, ","FIRSTNAME, \"last name\", ","E_MAIL, \"_id1\", \"$id2\", ","\"id5_\", \"id6$\", \"id7$$\", ","EMAILADDRESS, \"from\", ","ACTIVE, ACTIVE1, ACTIVE2, ","CLASS)","values (#{firstFirstName,jdbcType=VARCHAR}, #{secondFirstName,jdbcType=VARCHAR}, ","#{thirdFirstName,jdbcType=VARCHAR}, #{lastName,jdbcType=VARCHAR}, ","#{eMail,jdbcType=VARCHAR}, #{id1,jdbcType=INTEGER}, #{id2,jdbcType=INTEGER}, ","#{id5,jdbcType=INTEGER}, #{id6,jdbcType=INTEGER}, #{id7,jdbcType=INTEGER}, ","#{emailaddress,jdbcType=VARCHAR}, #{from,jdbcType=VARCHAR}, ","#{active,jdbcType=BIT}, #{active1,jdbcType=BOOLEAN}, #{active2,jdbcType=BIT}, ","#{dbClass,jdbcType=VARCHAR})"}) @SelectKey(statement="CALL IDENTITY()", keyProperty="customerId", before=false, resultType=java.lang.Integer.class) int insert(AwfulTable row)
int insertSelective(AwfulTable row)
List<AwfulTable> selectByExample(AwfulTableExample example)
@Select(value={"select","A.\"CuStOmEr iD\" as \"A_CuStOmEr iD\", A.\"first name\" as \"A_first name\", ","A.FIRST_NAME as A_FIRST_NAME, A.FIRSTNAME as A_FIRSTNAME, A.\"last name\" as \"A_last name\", ","A.E_MAIL as A_E_MAIL, A.\"_id1\" as \"A__id1\", A.\"$id2\" as \"A_$id2\", A.\"id5_\" as \"A_id5_\", ","A.\"id6$\" as \"A_id6$\", A.\"id7$$\" as \"A_id7$$\", A.EMAILADDRESS as A_EMAILADDRESS, ","A.\"from\" as \"A_from\", A.ACTIVE as A_ACTIVE, A.ACTIVE1 as A_ACTIVE1, A.ACTIVE2 as A_ACTIVE2, ","A.CLASS as A_CLASS","from \"awful table\" A","where \"CuStOmEr iD\" = #{customerId,jdbcType=INTEGER}"}) @ResultMap(value="mbg.test.mb3.generated.mixed.hierarchical.mapper.AwfulTableMapper.BaseResultMap") AwfulTable selectByPrimaryKey(AwfulTableKey key)
int updateByExampleSelective(@Param(value="row") AwfulTable row, @Param(value="example") AwfulTableExample example)
int updateByExample(@Param(value="row") AwfulTable row, @Param(value="example") AwfulTableExample example)
int updateByPrimaryKeySelective(AwfulTable row)
@Update(value={"update \"awful table\"","set \"first name\" = #{firstFirstName,jdbcType=VARCHAR},","FIRST_NAME = #{secondFirstName,jdbcType=VARCHAR},","FIRSTNAME = #{thirdFirstName,jdbcType=VARCHAR},","\"last name\" = #{lastName,jdbcType=VARCHAR},","E_MAIL = #{eMail,jdbcType=VARCHAR},","\"_id1\" = #{id1,jdbcType=INTEGER},","\"$id2\" = #{id2,jdbcType=INTEGER},","\"id5_\" = #{id5,jdbcType=INTEGER},","\"id6$\" = #{id6,jdbcType=INTEGER},","\"id7$$\" = #{id7,jdbcType=INTEGER},","EMAILADDRESS = #{emailaddress,jdbcType=VARCHAR},","\"from\" = #{from,jdbcType=VARCHAR},","ACTIVE = #{active,jdbcType=BIT},","ACTIVE1 = #{active1,jdbcType=BOOLEAN},","ACTIVE2 = #{active2,jdbcType=BIT},","CLASS = #{dbClass,jdbcType=VARCHAR}","where \"CuStOmEr iD\" = #{customerId,jdbcType=INTEGER}"}) int updateByPrimaryKey(AwfulTable row)
Copyright © 2006–2023 MyBatis.org. All rights reserved.