Package mbg.test.mb3.generated.annotated.hierarchical.mapper

Interface AwfulTableMapper

public interface AwfulTableMapper

Method Summary

Modifier and Type	Method	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.

Method Details

countByExample

@SelectProvider(type=AwfulTableSqlProvider.class,
                method="countByExample")
long countByExample(AwfulTableExample example)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

deleteByExample

@DeleteProvider(type=AwfulTableSqlProvider.class,
                method="deleteByExample")
int deleteByExample(AwfulTableExample example)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

deleteByPrimaryKey

@Delete({"delete from \"awful table\"","where \"CuStOmEr iD\" = #{customerId,jdbcType=INTEGER}"})
int deleteByPrimaryKey(AwfulTableKey key)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

insert

@Insert({"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)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

insertSelective

@InsertProvider(type=AwfulTableSqlProvider.class,
                method="insertSelective")
@SelectKey(statement="CALL IDENTITY()",
           keyProperty="customerId",
           before=false,
           resultType=java.lang.Integer.class)
int insertSelective(AwfulTable row)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

selectByExample

@SelectProvider(type=AwfulTableSqlProvider.class,
                method="selectByExample")
@Result(column="A_CuStOmEr iD",property="customerId",jdbcType=INTEGER,id=true) @Result(column="A_first name",property="firstFirstName",jdbcType=VARCHAR) @Result(column="A_FIRST_NAME",property="secondFirstName",jdbcType=VARCHAR) @Result(column="A_FIRSTNAME",property="thirdFirstName",jdbcType=VARCHAR) @Result(column="A_last name",property="lastName",jdbcType=VARCHAR) @Result(column="A_E_MAIL",property="eMail",jdbcType=VARCHAR) @Result(column="A__id1",property="id1",jdbcType=INTEGER) @Result(column="A_$id2",property="id2",jdbcType=INTEGER) @Result(column="A_id5_",property="id5",jdbcType=INTEGER) @Result(column="A_id6$",property="id6",jdbcType=INTEGER) @Result(column="A_id7$$",property="id7",jdbcType=INTEGER) @Result(column="A_EMAILADDRESS",property="emailaddress",jdbcType=VARCHAR) @Result(column="A_from",property="from",jdbcType=VARCHAR) @Result(column="A_ACTIVE",property="active",jdbcType=BIT) @Result(column="A_ACTIVE1",property="active1",jdbcType=BOOLEAN) @Result(column="A_ACTIVE2",property="active2",jdbcType=BIT) @Result(column="A_CLASS",property="dbClass",jdbcType=VARCHAR)
List<AwfulTable> selectByExample(AwfulTableExample example)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

selectByPrimaryKey

@Select({"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}"})
@Result(column="A_CuStOmEr iD",property="customerId",jdbcType=INTEGER,id=true) @Result(column="A_first name",property="firstFirstName",jdbcType=VARCHAR) @Result(column="A_FIRST_NAME",property="secondFirstName",jdbcType=VARCHAR) @Result(column="A_FIRSTNAME",property="thirdFirstName",jdbcType=VARCHAR) @Result(column="A_last name",property="lastName",jdbcType=VARCHAR) @Result(column="A_E_MAIL",property="eMail",jdbcType=VARCHAR) @Result(column="A__id1",property="id1",jdbcType=INTEGER) @Result(column="A_$id2",property="id2",jdbcType=INTEGER) @Result(column="A_id5_",property="id5",jdbcType=INTEGER) @Result(column="A_id6$",property="id6",jdbcType=INTEGER) @Result(column="A_id7$$",property="id7",jdbcType=INTEGER) @Result(column="A_EMAILADDRESS",property="emailaddress",jdbcType=VARCHAR) @Result(column="A_from",property="from",jdbcType=VARCHAR) @Result(column="A_ACTIVE",property="active",jdbcType=BIT) @Result(column="A_ACTIVE1",property="active1",jdbcType=BOOLEAN) @Result(column="A_ACTIVE2",property="active2",jdbcType=BIT) @Result(column="A_CLASS",property="dbClass",jdbcType=VARCHAR)
AwfulTable selectByPrimaryKey(AwfulTableKey key)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

updateByExampleSelective

@UpdateProvider(type=AwfulTableSqlProvider.class,
                method="updateByExampleSelective")
int updateByExampleSelective(@Param("row")
 AwfulTable row,
 @Param("example")
 AwfulTableExample example)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

updateByExample

@UpdateProvider(type=AwfulTableSqlProvider.class,
                method="updateByExample")
int updateByExample(@Param("row")
 AwfulTable row,
 @Param("example")
 AwfulTableExample example)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

updateByPrimaryKeySelective

@UpdateProvider(type=AwfulTableSqlProvider.class,
                method="updateByPrimaryKeySelective")
int updateByPrimaryKeySelective(AwfulTable row)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table

updateByPrimaryKey

@Update({"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)

This method was generated by MyBatis Generator. This method corresponds to the database table awful table