Package mbg.test.mb3.generated.simpleannotated.mapper

Interface PkfieldsMapper

public interface PkfieldsMapper

  • Method Details

    • deleteByPrimaryKey

      @Delete({"delete from PKFIELDS","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) int deleteByPrimaryKey(@Param("id2") Integer id2, @Param("id1") Integer id1)
      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, DECIMAL30FIELD, ","DECIMAL60FIELD, DECIMAL100FIELD, ","DECIMAL155FIELD, \"wierd$Field\", ","\"birth date\", STRINGBOOLEAN)","values (#{id2,jdbcType=INTEGER}, #{id1,jdbcType=INTEGER}, ","#{firstname,jdbcType=VARCHAR}, #{lastname,jdbcType=VARCHAR}, ","#{datefield,jdbcType=DATE}, #{timefield,jdbcType=TIME}, ","#{timestampfield,jdbcType=TIMESTAMP}, #{decimal30field,jdbcType=DECIMAL}, ","#{decimal60field,jdbcType=DECIMAL}, #{decimal100field,jdbcType=DECIMAL}, ","#{decimal155field,jdbcType=DECIMAL}, #{wierdField,jdbcType=INTEGER}, ","#{birthDate,jdbcType=DATE}, #{stringboolean,jdbcType=CHAR,typeHandler=mbg.test.mb3.common.StringBooleanTypeHandler})"}) int insert(Pkfields row)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • selectByPrimaryKey

      @Select({"select","B.ID2 as B_ID2, B.ID1 as B_ID1, B.FIRSTNAME as B_FIRSTNAME, B.LASTNAME as B_LASTNAME, ","B.DATEFIELD as B_DATEFIELD, B.TIMEFIELD as B_TIMEFIELD, B.TIMESTAMPFIELD as B_TIMESTAMPFIELD, ","B.DECIMAL30FIELD as B_DECIMAL30FIELD, B.DECIMAL60FIELD as B_DECIMAL60FIELD, ","B.DECIMAL100FIELD as B_DECIMAL100FIELD, B.DECIMAL155FIELD as B_DECIMAL155FIELD, ","B.\"wierd$Field\" as \"B_wierd$Field\", B.\"birth date\" as \"B_birth date\", ","B.STRINGBOOLEAN as B_STRINGBOOLEAN","from PKFIELDS B","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) @Result(column="B_ID2",property="id2",jdbcType=INTEGER,id=true) @Result(column="B_ID1",property="id1",jdbcType=INTEGER,id=true) @Result(column="B_FIRSTNAME",property="firstname",jdbcType=VARCHAR) @Result(column="B_LASTNAME",property="lastname",jdbcType=VARCHAR) @Result(column="B_DATEFIELD",property="datefield",jdbcType=DATE) @Result(column="B_TIMEFIELD",property="timefield",jdbcType=TIME) @Result(column="B_TIMESTAMPFIELD",property="timestampfield",jdbcType=TIMESTAMP) @Result(column="B_DECIMAL30FIELD",property="decimal30field",jdbcType=DECIMAL) @Result(column="B_DECIMAL60FIELD",property="decimal60field",jdbcType=DECIMAL) @Result(column="B_DECIMAL100FIELD",property="decimal100field",jdbcType=DECIMAL) @Result(column="B_DECIMAL155FIELD",property="decimal155field",jdbcType=DECIMAL) @Result(column="B_wierd$Field",property="wierdField",jdbcType=INTEGER) @Result(column="B_birth date",property="birthDate",jdbcType=DATE) @Result(column="B_STRINGBOOLEAN",property="stringboolean",typeHandler=StringBooleanTypeHandler.class,jdbcType=CHAR) Pkfields selectByPrimaryKey(@Param("id2") Integer id2, @Param("id1") Integer id1)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • selectAll

      @Select({"select","B.ID2 as B_ID2, B.ID1 as B_ID1, B.FIRSTNAME as B_FIRSTNAME, B.LASTNAME as B_LASTNAME, ","B.DATEFIELD as B_DATEFIELD, B.TIMEFIELD as B_TIMEFIELD, B.TIMESTAMPFIELD as B_TIMESTAMPFIELD, ","B.DECIMAL30FIELD as B_DECIMAL30FIELD, B.DECIMAL60FIELD as B_DECIMAL60FIELD, ","B.DECIMAL100FIELD as B_DECIMAL100FIELD, B.DECIMAL155FIELD as B_DECIMAL155FIELD, ","B.\"wierd$Field\" as \"B_wierd$Field\", B.\"birth date\" as \"B_birth date\", ","B.STRINGBOOLEAN as B_STRINGBOOLEAN","from PKFIELDS B","order by ID1, ID2"}) @Result(column="B_ID2",property="id2",jdbcType=INTEGER,id=true) @Result(column="B_ID1",property="id1",jdbcType=INTEGER,id=true) @Result(column="B_FIRSTNAME",property="firstname",jdbcType=VARCHAR) @Result(column="B_LASTNAME",property="lastname",jdbcType=VARCHAR) @Result(column="B_DATEFIELD",property="datefield",jdbcType=DATE) @Result(column="B_TIMEFIELD",property="timefield",jdbcType=TIME) @Result(column="B_TIMESTAMPFIELD",property="timestampfield",jdbcType=TIMESTAMP) @Result(column="B_DECIMAL30FIELD",property="decimal30field",jdbcType=DECIMAL) @Result(column="B_DECIMAL60FIELD",property="decimal60field",jdbcType=DECIMAL) @Result(column="B_DECIMAL100FIELD",property="decimal100field",jdbcType=DECIMAL) @Result(column="B_DECIMAL155FIELD",property="decimal155field",jdbcType=DECIMAL) @Result(column="B_wierd$Field",property="wierdField",jdbcType=INTEGER) @Result(column="B_birth date",property="birthDate",jdbcType=DATE) @Result(column="B_STRINGBOOLEAN",property="stringboolean",typeHandler=StringBooleanTypeHandler.class,jdbcType=CHAR) List<Pkfields> selectAll()
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

    • updateByPrimaryKey

      @Update({"update PKFIELDS","set FIRSTNAME = #{firstname,jdbcType=VARCHAR},","LASTNAME = #{lastname,jdbcType=VARCHAR},","DATEFIELD = #{datefield,jdbcType=DATE},","TIMEFIELD = #{timefield,jdbcType=TIME},","TIMESTAMPFIELD = #{timestampfield,jdbcType=TIMESTAMP},","DECIMAL30FIELD = #{decimal30field,jdbcType=DECIMAL},","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,typeHandler=mbg.test.mb3.common.StringBooleanTypeHandler}","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) int updateByPrimaryKey(Pkfields row)
      This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS