public interface PkfieldsMapper
Modifier and Type | Method and 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(PkfieldsKey key)
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.
|
Pkfields |
selectByPrimaryKey(PkfieldsKey key)
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.
|
@SelectProvider(type=PkfieldsSqlProvider.class, method="countByExample") long countByExample(PkfieldsExample example)
@DeleteProvider(type=PkfieldsSqlProvider.class, method="deleteByExample") int deleteByExample(PkfieldsExample example)
@Delete(value={"delete from PKFIELDS","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) int deleteByPrimaryKey(PkfieldsKey key)
@Insert(value={"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})"}) int insert(Pkfields row)
@InsertProvider(type=PkfieldsSqlProvider.class, method="insertSelective") int insertSelective(Pkfields row)
@SelectProvider(type=PkfieldsSqlProvider.class, method="selectByExample") @Arg(column="B_ID2",javaType=java.lang.Integer.class,jdbcType=INTEGER,id=true) @Arg(column="B_ID1",javaType=java.lang.Integer.class,jdbcType=INTEGER,id=true) @Arg(column="B_FIRSTNAME",javaType=java.lang.String.class,jdbcType=VARCHAR) @Arg(column="B_LASTNAME",javaType=java.lang.String.class,jdbcType=VARCHAR) @Arg(column="B_DATEFIELD",javaType=java.util.Date.class,jdbcType=DATE) @Arg(column="B_TIMEFIELD",javaType=java.util.Date.class,jdbcType=TIME) @Arg(column="B_TIMESTAMPFIELD",javaType=java.util.Date.class,jdbcType=TIMESTAMP) @Arg(column="B_DECIMAL30FIELD",javaType=java.lang.Short.class,jdbcType=DECIMAL) @Arg(column="B_DECIMAL60FIELD",javaType=java.lang.Integer.class,jdbcType=DECIMAL) @Arg(column="B_DECIMAL100FIELD",javaType=java.lang.Long.class,jdbcType=DECIMAL) @Arg(column="B_DECIMAL155FIELD",javaType=java.math.BigDecimal.class,jdbcType=DECIMAL) @Arg(column="B_wierd$Field",javaType=java.lang.Integer.class,jdbcType=INTEGER) @Arg(column="B_birth date",javaType=java.util.Date.class,jdbcType=DATE) @Arg(column="B_STRINGBOOLEAN",javaType=java.lang.String.class,jdbcType=CHAR) List<Pkfields> selectByExample(PkfieldsExample example)
@Select(value={"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}"}) @Arg(column="B_ID2",javaType=java.lang.Integer.class,jdbcType=INTEGER,id=true) @Arg(column="B_ID1",javaType=java.lang.Integer.class,jdbcType=INTEGER,id=true) @Arg(column="B_FIRSTNAME",javaType=java.lang.String.class,jdbcType=VARCHAR) @Arg(column="B_LASTNAME",javaType=java.lang.String.class,jdbcType=VARCHAR) @Arg(column="B_DATEFIELD",javaType=java.util.Date.class,jdbcType=DATE) @Arg(column="B_TIMEFIELD",javaType=java.util.Date.class,jdbcType=TIME) @Arg(column="B_TIMESTAMPFIELD",javaType=java.util.Date.class,jdbcType=TIMESTAMP) @Arg(column="B_DECIMAL30FIELD",javaType=java.lang.Short.class,jdbcType=DECIMAL) @Arg(column="B_DECIMAL60FIELD",javaType=java.lang.Integer.class,jdbcType=DECIMAL) @Arg(column="B_DECIMAL100FIELD",javaType=java.lang.Long.class,jdbcType=DECIMAL) @Arg(column="B_DECIMAL155FIELD",javaType=java.math.BigDecimal.class,jdbcType=DECIMAL) @Arg(column="B_wierd$Field",javaType=java.lang.Integer.class,jdbcType=INTEGER) @Arg(column="B_birth date",javaType=java.util.Date.class,jdbcType=DATE) @Arg(column="B_STRINGBOOLEAN",javaType=java.lang.String.class,jdbcType=CHAR) Pkfields selectByPrimaryKey(PkfieldsKey key)
@UpdateProvider(type=PkfieldsSqlProvider.class, method="updateByExampleSelective") int updateByExampleSelective(@Param(value="row") Pkfields row, @Param(value="example") PkfieldsExample example)
@UpdateProvider(type=PkfieldsSqlProvider.class, method="updateByExample") int updateByExample(@Param(value="row") Pkfields row, @Param(value="example") PkfieldsExample example)
@UpdateProvider(type=PkfieldsSqlProvider.class, method="updateByPrimaryKeySelective") int updateByPrimaryKeySelective(Pkfields row)
@Update(value={"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}","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) int updateByPrimaryKey(Pkfields row)
Copyright © 2006–2024 MyBatis.org. All rights reserved.