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

Interface AwfulTableMapper

public interface AwfulTableMapper

  • 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(Integer customerId)
      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})"}) @Options(useGeneratedKeys=true, keyProperty="customerId") 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") @Options(useGeneratedKeys=true, keyProperty="customerId") int insertSelective(AwfulTable row)
      This method was generated by MyBatis Generator. This method corresponds to the database table awful table

    • selectByExampleWithRowbounds

      @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> selectByExampleWithRowbounds(AwfulTableExample example, org.apache.ibatis.session.RowBounds rowBounds)
      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(Integer customerId)
      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