解决mysql数据重复问题

http://blog.tianya.cn/blogger/post_read.asp?BlogID=4221189&PostID=47881614

Mysql点滴－where clause is ambiguous

http://todaydiy.blog.163.com/blog/static/10418968720102213232170/

  <select id="ibatorgenerated_selectMyAnswersByExample" resultMap="ibatorgenerated_BaseResultMap" parameterClass="com.yzy.admin.bo.QuestionCriteria" >
	SELECT yzy_question.id, yzy_question.user_id, yzy_question.question_title, yzy_question.question_labels, yzy_question.create_time,
	  yzy_question.question_two, yzy_question.question_pageview, yzy_question.question_answernum
    FROM yzy_question
    inner join yzy_quanswer ON yzy_question.id = yzy_quanswer.question_id
    <isParameterPresent >
      <include refid="yzy_question.ibatorgenerated_Example_Where_Clause" />
      <isNotNull property="orderByClause" >
        order by $orderByClause$
      </isNotNull>
      <isNotNull property="limit" >
        limit $limit$
      </isNotNull>
      <isNotNull property="offset" >
        offset $offset$
      </isNotNull>
    </isParameterPresent>
    GROUP BY yzy_question.id
  </select>

把“GROUP BY yzy_question.id”放在了最后才不报错。

在QuestionCriteria.java中增加方法，避免出现“where clause is ambiguous”

//由于关联表，所以增加此方法
public Criteria andQuanswerUserIdEqualTo(Long value) {
	addCriterion("yzy_quanswer.user_id =", value, "Quanswer.userId");
	return this;
}