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

Interface MyObjectMapper

All Superinterfaces:
BaseInterface
public interface MyObjectMapper extends BaseInterface

  • Method Details

    • countByExample

      long countByExample(MyObjectCriteria example)

    • deleteByExample

      int deleteByExample(MyObjectCriteria example)

    • deleteByPrimaryKey

      @Delete({"delete from PKFIELDS","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) int deleteByPrimaryKey(MyObjectKey key)

    • 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)

    • insertSelective

      int insertSelective(MyObject row)

    • selectByExample

      List<MyObject> selectByExample(MyObjectCriteria example)

    • 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}"}) @ResultMap("mbg.test.mb3.generated.mixed.miscellaneous.mapper.MyObjectMapper.BaseResultMap") MyObject selectByPrimaryKey(MyObjectKey key)

    • updateByExampleSelective

      int updateByExampleSelective(@Param("row") MyObject row, @Param("example") MyObjectCriteria example)

    • updateByExample

      int updateByExample(@Param("row") MyObject row, @Param("example") MyObjectCriteria example)

    • updateByPrimaryKeySelective

      int updateByPrimaryKeySelective(MyObject row)

    • 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)