Interface PkfieldsMapper
public interface PkfieldsMapper
-
Method Summary
Modifier and TypeMethodDescriptionintdeleteByPrimaryKey(Integer id2, Integer id1) This method was generated by MyBatis Generator.intThis method was generated by MyBatis Generator.This method was generated by MyBatis Generator.selectByPrimaryKey(Integer id2, Integer id1) This method was generated by MyBatis Generator.intThis method was generated by MyBatis Generator.
-
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})"}) int insert(Pkfields row) This method was generated by MyBatis Generator. This method corresponds to the database table PKFIELDS -
selectByPrimaryKey
@Select({"select","ID2, ID1, FIRSTNAME, LASTNAME, DATEFIELD, TIMEFIELD, TIMESTAMPFIELD, DECIMAL30FIELD, ","DECIMAL60FIELD, DECIMAL100FIELD, DECIMAL155FIELD, wierd$Field, \"birth date\", ","STRINGBOOLEAN","from PKFIELDS","where ID2 = #{id2,jdbcType=INTEGER}","and ID1 = #{id1,jdbcType=INTEGER}"}) @Result(column="ID2",property="id2",jdbcType=INTEGER,id=true) @Result(column="ID1",property="id1",jdbcType=INTEGER,id=true) @Result(column="FIRSTNAME",property="firstname",jdbcType=VARCHAR) @Result(column="LASTNAME",property="lastname",jdbcType=VARCHAR) @Result(column="DATEFIELD",property="datefield",jdbcType=DATE) @Result(column="TIMEFIELD",property="timefield",jdbcType=TIME) @Result(column="TIMESTAMPFIELD",property="timestampfield",jdbcType=TIMESTAMP) @Result(column="DECIMAL30FIELD",property="decimal30field",jdbcType=DECIMAL) @Result(column="DECIMAL60FIELD",property="decimal60field",jdbcType=DECIMAL) @Result(column="DECIMAL100FIELD",property="decimal100field",jdbcType=DECIMAL) @Result(column="DECIMAL155FIELD",property="decimal155field",jdbcType=DECIMAL) @Result(column="wierd$Field",property="wierdField",jdbcType=INTEGER) @Result(column="birth date",property="birthDate",jdbcType=DATE) @Result(column="STRINGBOOLEAN",property="stringboolean",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","ID2, ID1, FIRSTNAME, LASTNAME, DATEFIELD, TIMEFIELD, TIMESTAMPFIELD, DECIMAL30FIELD, ","DECIMAL60FIELD, DECIMAL100FIELD, DECIMAL155FIELD, wierd$Field, \"birth date\", ","STRINGBOOLEAN","from PKFIELDS"}) @Result(column="ID2",property="id2",jdbcType=INTEGER,id=true) @Result(column="ID1",property="id1",jdbcType=INTEGER,id=true) @Result(column="FIRSTNAME",property="firstname",jdbcType=VARCHAR) @Result(column="LASTNAME",property="lastname",jdbcType=VARCHAR) @Result(column="DATEFIELD",property="datefield",jdbcType=DATE) @Result(column="TIMEFIELD",property="timefield",jdbcType=TIME) @Result(column="TIMESTAMPFIELD",property="timestampfield",jdbcType=TIMESTAMP) @Result(column="DECIMAL30FIELD",property="decimal30field",jdbcType=DECIMAL) @Result(column="DECIMAL60FIELD",property="decimal60field",jdbcType=DECIMAL) @Result(column="DECIMAL100FIELD",property="decimal100field",jdbcType=DECIMAL) @Result(column="DECIMAL155FIELD",property="decimal155field",jdbcType=DECIMAL) @Result(column="wierd$Field",property="wierdField",jdbcType=INTEGER) @Result(column="birth date",property="birthDate",jdbcType=DATE) @Result(column="STRINGBOOLEAN",property="stringboolean",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}","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
-