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

Interface PkfieldsMapper

public interface PkfieldsMapper

Method Summary

Modifier and Type	Method	Description
long	countByExample(PkfieldsExample example)	This method was generated by MyBatis Generator.
int	deleteByExample(PkfieldsExample example)	This method was generated by MyBatis Generator.
int	deleteByPrimaryKey(Integer id2, Integer id1)	This method was generated by MyBatis Generator.
int	insert(Pkfields row)	This method was generated by MyBatis Generator.
int	insertSelective(Pkfields row)	This method was generated by MyBatis Generator.
List<Pkfields>	selectByExample(PkfieldsExample example)	This method was generated by MyBatis Generator.
List<Pkfields>	selectByExampleWithRowbounds(PkfieldsExample example, org.apache.ibatis.session.RowBounds rowBounds)	This method was generated by MyBatis Generator.
Pkfields	selectByPrimaryKey(Integer id2, Integer id1)	This method was generated by MyBatis Generator.
int	updateByExample(Pkfields row, PkfieldsExample example)	This method was generated by MyBatis Generator.
int	updateByExampleSelective(Pkfields row, PkfieldsExample example)	This method was generated by MyBatis Generator.
int	updateByPrimaryKey(Pkfields row)	This method was generated by MyBatis Generator.
int	updateByPrimaryKeySelective(Pkfields row)	This method was generated by MyBatis Generator.

Method Details

countByExample

@SelectProvider(type=PkfieldsSqlProvider.class,
                method="countByExample")
long countByExample(PkfieldsExample example)

This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

deleteByExample

@DeleteProvider(type=PkfieldsSqlProvider.class,
                method="deleteByExample")
int deleteByExample(PkfieldsExample 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(@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

insertSelective

@InsertProvider(type=PkfieldsSqlProvider.class,
                method="insertSelective")
int insertSelective(Pkfields row)

This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

selectByExampleWithRowbounds

@SelectProvider(type=PkfieldsSqlProvider.class,
                method="selectByExample")
@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> selectByExampleWithRowbounds(PkfieldsExample example,
 org.apache.ibatis.session.RowBounds rowBounds)

This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

selectByExample

@SelectProvider(type=PkfieldsSqlProvider.class,
                method="selectByExample")
@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> selectByExample(PkfieldsExample example)

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

updateByExampleSelective

@UpdateProvider(type=PkfieldsSqlProvider.class,
                method="updateByExampleSelective")
int updateByExampleSelective(@Param("row")
 Pkfields row,
 @Param("example")
 PkfieldsExample example)

This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

updateByExample

@UpdateProvider(type=PkfieldsSqlProvider.class,
                method="updateByExample")
int updateByExample(@Param("row")
 Pkfields row,
 @Param("example")
 PkfieldsExample example)

This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS

updateByPrimaryKeySelective

@UpdateProvider(type=PkfieldsSqlProvider.class,
                method="updateByPrimaryKeySelective")
int updateByPrimaryKeySelective(Pkfields 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},","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