这里有一个删除方法：

int deleteByPrimaryKey(Integer id);

然后对应的sql的xml如下：

<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
  delete from tablename
  where id = #{id,jdbcType=INTEGER}
</delete>

以上是单个参数一般的写法。
但是如果我下面的同样也是单个参数，但是且报错了:There is no getter for property..！！

DAO:

List<Article> recommandList( Integer siteid);

XML:

<select  id="recommandList" resultMap="BaseResultMap">

  SELECT a.*  from article a where a.id in
  (SELECT atr.article_id from article_tags_relation atr where isdelete =0)
  <if test="siteid !=0">
  and a.article_type_id = #{siteid,jdbcType=INTEGER}
  </if>
  ORDER BY a.publish_time desc

</select>

为什么呢？因为if里面用了mybatis的内置对象，例如这里：“

 <if test="siteid !=0">

”

为了解决这个问题，代码修改：

DAO:

List<Article> recommandList(@Param("siteid") Integer siteid);

如上修改，给siteid @Param注入getter 即可。

TRANSLATE with x English

Arabic	Hebrew	Polish
Bulgarian	Hindi	Portuguese
Catalan	Hmong Daw	Romanian
Chinese Simplified	Hungarian	Russian
Chinese Traditional	Indonesian	Slovak
Czech	Italian	Slovenian
Danish	Japanese	Spanish
Dutch	Klingon	Swedish
English	Korean	Thai
Estonian	Latvian	Turkish
Finnish	Lithuanian	Ukrainian
French	Malay	Urdu
German	Maltese	Vietnamese
Greek	Norwegian	Welsh
Haitian Creole	Persian

  TRANSLATE with COPY THE URL BELOW Back EMBED THE SNIPPET BELOW IN YOUR SITE Enable collaborative features and customize widget: Bing Webmaster Portal Back