public interface AwfulTableMapper
Modifier and Type | Method and Description |
---|---|
int |
deleteByPrimaryKey(Integer customerId)
This method was generated by MyBatis Generator.
|
int |
insert(AwfulTable row)
This method was generated by MyBatis Generator.
|
List<AwfulTable> |
selectAll()
This method was generated by MyBatis Generator.
|
AwfulTable |
selectByPrimaryKey(Integer customerId)
This method was generated by MyBatis Generator.
|
int |
updateByPrimaryKey(AwfulTable row)
This method was generated by MyBatis Generator.
|
@Delete(value={"delete from \"awful table\"","where \"CuStOmEr iD\" = #{customerId,jdbcType=INTEGER}"}) int deleteByPrimaryKey(Integer customerId)
@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})"}) @Options(useGeneratedKeys=true, keyProperty="customerId") int insert(AwfulTable row)
@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}"}) @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(Integer customerId)
@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"}) @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> selectAll()
@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–2022 MyBatis.org. All rights reserved.