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

Interface MyObjectMapper

All Superinterfaces:
BaseInterface
public interface MyObjectMapper extends BaseInterface

  • Method Details

    • countByExample

      @SelectProvider(type=MyObjectSqlProvider.class, method="countByExample") long countByExample(MyObjectCriteria example)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • deleteByExample

      @DeleteProvider(type=MyObjectSqlProvider.class, method="deleteByExample") int deleteByExample(MyObjectCriteria example)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • deleteByPrimaryKey

      @Delete({"delete from PKFIELDS","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) int deleteByPrimaryKey(MyObjectKey key)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • insert

      @Insert({"insert into PKFIELDS (ID2, ID1, ","FIRSTNAME, ","LASTNAME, DATEFIELD, ","TIMEFIELD, ","TIMESTAMPFIELD, DECIMAL60FIELD, ","DECIMAL100FIELD, DECIMAL155FIELD, ","\"wierd$Field\", \"birth date\", ","STRINGBOOLEAN)","values (#{id2,jdbcType=INTEGER}, #{id1,jdbcType=INTEGER}, ","#{firstname,jdbcType=VARCHAR,typeHandler=mbg.test.mb3.common.FirstNameTypeHandler}, ","#{lastname,jdbcType=VARCHAR}, #{startDate,jdbcType=DATE}, ","#{timefield,jdbcType=TIME,typeHandler=mbg.test.mb3.common.MyTimeTypeHandler}, ","#{timestampfield,jdbcType=TIMESTAMP}, #{decimal60field,jdbcType=DECIMAL}, ","#{decimal100field,jdbcType=DECIMAL}, #{decimal155field,jdbcType=DECIMAL}, ","#{wierdField,jdbcType=INTEGER}, #{birthDate,jdbcType=DATE}, ","#{stringboolean,jdbcType=CHAR})"}) int insert(MyObject row)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • insertSelective

      @InsertProvider(type=MyObjectSqlProvider.class, method="insertSelective") int insertSelective(MyObject row)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • selectByExample

      @SelectProvider(type=MyObjectSqlProvider.class, method="selectByExample") @Result(column="A_ID2",property="id2",jdbcType=INTEGER,id=true) @Result(column="A_ID1",property="id1",jdbcType=INTEGER,id=true) @Result(column="A_FIRSTNAME",property="firstname",typeHandler=FirstNameTypeHandler.class,jdbcType=VARCHAR) @Result(column="A_LASTNAME",property="lastname",jdbcType=VARCHAR) @Result(column="A_DATEFIELD",property="startDate",jdbcType=DATE) @Result(column="A_TIMEFIELD",property="timefield",typeHandler=MyTimeTypeHandler.class,jdbcType=TIME) @Result(column="A_TIMESTAMPFIELD",property="timestampfield",jdbcType=TIMESTAMP) @Result(column="A_DECIMAL60FIELD",property="decimal60field",jdbcType=DECIMAL) @Result(column="A_DECIMAL100FIELD",property="decimal100field",jdbcType=DECIMAL) @Result(column="A_DECIMAL155FIELD",property="decimal155field",jdbcType=DECIMAL) @Result(column="A_wierd$Field",property="wierdField",jdbcType=INTEGER) @Result(column="A_birth date",property="birthDate",jdbcType=DATE) @Result(column="A_STRINGBOOLEAN",property="stringboolean",jdbcType=CHAR) List<MyObject> selectByExample(MyObjectCriteria example)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • selectByPrimaryKey

      @Select({"select","A.ID2 as A_ID2, A.ID1 as A_ID1, A.FIRSTNAME as A_FIRSTNAME, A.LASTNAME as A_LASTNAME, ","A.DATEFIELD as A_DATEFIELD, A.TIMEFIELD as A_TIMEFIELD, A.TIMESTAMPFIELD as A_TIMESTAMPFIELD, ","A.DECIMAL60FIELD as A_DECIMAL60FIELD, A.DECIMAL100FIELD as A_DECIMAL100FIELD, ","A.DECIMAL155FIELD as A_DECIMAL155FIELD, A.\"wierd$Field\" as \"A_wierd$Field\", ","A.\"birth date\" as \"A_birth date\", A.STRINGBOOLEAN as A_STRINGBOOLEAN","from PKFIELDS A","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) @Result(column="A_ID2",property="id2",jdbcType=INTEGER,id=true) @Result(column="A_ID1",property="id1",jdbcType=INTEGER,id=true) @Result(column="A_FIRSTNAME",property="firstname",typeHandler=FirstNameTypeHandler.class,jdbcType=VARCHAR) @Result(column="A_LASTNAME",property="lastname",jdbcType=VARCHAR) @Result(column="A_DATEFIELD",property="startDate",jdbcType=DATE) @Result(column="A_TIMEFIELD",property="timefield",typeHandler=MyTimeTypeHandler.class,jdbcType=TIME) @Result(column="A_TIMESTAMPFIELD",property="timestampfield",jdbcType=TIMESTAMP) @Result(column="A_DECIMAL60FIELD",property="decimal60field",jdbcType=DECIMAL) @Result(column="A_DECIMAL100FIELD",property="decimal100field",jdbcType=DECIMAL) @Result(column="A_DECIMAL155FIELD",property="decimal155field",jdbcType=DECIMAL) @Result(column="A_wierd$Field",property="wierdField",jdbcType=INTEGER) @Result(column="A_birth date",property="birthDate",jdbcType=DATE) @Result(column="A_STRINGBOOLEAN",property="stringboolean",jdbcType=CHAR) MyObject selectByPrimaryKey(MyObjectKey key)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • updateByExampleSelective

      @UpdateProvider(type=MyObjectSqlProvider.class, method="updateByExampleSelective") int updateByExampleSelective(@Param("row") MyObject row, @Param("example") MyObjectCriteria example)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • updateByExample

      @UpdateProvider(type=MyObjectSqlProvider.class, method="updateByExample") int updateByExample(@Param("row") MyObject row, @Param("example") MyObjectCriteria example)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • updateByPrimaryKeySelective

      @UpdateProvider(type=MyObjectSqlProvider.class, method="updateByPrimaryKeySelective") int updateByPrimaryKeySelective(MyObject row)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • updateByPrimaryKey

      @Update({"update PKFIELDS","set FIRSTNAME = #{firstname,jdbcType=VARCHAR,typeHandler=mbg.test.mb3.common.FirstNameTypeHandler},","LASTNAME = #{lastname,jdbcType=VARCHAR},","DATEFIELD = #{startDate,jdbcType=DATE},","TIMEFIELD = #{timefield,jdbcType=TIME,typeHandler=mbg.test.mb3.common.MyTimeTypeHandler},","TIMESTAMPFIELD = #{timestampfield,jdbcType=TIMESTAMP},","DECIMAL60FIELD = #{decimal60field,jdbcType=DECIMAL},","DECIMAL100FIELD = #{decimal100field,jdbcType=DECIMAL},","DECIMAL155FIELD = #{decimal155field,jdbcType=DECIMAL},","\"wierd$Field\" = #{wierdField,jdbcType=INTEGER},","\"birth date\" = #{birthDate,jdbcType=DATE},","STRINGBOOLEAN = #{stringboolean,jdbcType=CHAR}","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) int updateByPrimaryKey(MyObject row)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS