【正文】 resultType=User select * from t_user where id = {id} /select select id=randomGetUsers resultType=User select * from t_user order by rand() limit 9 /select/mappersrc//po/：?xml version= encoding=UTF8 ?!DOCTYPE mapper PUBLIC // mapper namespace=ArticleMap ! 注意groupId這個(gè)字段 resultMap type=Article id=findNewArticlesMap result column=userId property=userId / association property=user column=userId javaType=User select= / /resultMap resultMap type=Article id=findArticleByIdMap result column=userId property=userId / association property=user column=userId javaType=User select= / /resultMap resultMap type=Article id=findArticlesByUserIdMap result column=id property=id / association property=ments column=id javaType=arrayList select= / /resultMap insert id=addArticle parameterType=Article insert into t_article(id,userId,groupId,title,date,content,praise,isPublish) values ({id},{userId},{groupsId},{title},{date},{content},{praise},{isPublish}) /insert delete id=deleteArticleById parameterType=string delete from t_article where id = {id} /delete select id=findNewArticles parameterType=Page resultMap=findNewArticlesMap select * from t_article where isPublish = 1 order by date desc limit {firstResult},{maxResults} /select select id=findArticleById parameterType=string resultMap=findArticleByIdMap select * from t_article where id = {id} /select select id=findArticleOfCommentById parameterType=string resultType=Article select * from t_article where id = {id} /select select id=findPraiseHighArticles resultType=Article select * from t_article where isPublish = 1 order by praise desc limit 0,9 /select select id=findArticleByGroupsId parameterType=string resultType=Article select * from t_article where groupId = {groupsId} /select select id=findArticlesByUserId parameterType=Page resultMap=findArticlesByUserIdMap select * from t_article where userId = {condition} order by date desc limit {firstResult},{maxResults} /select select id=getArticleSizeByUserId parameterType=string resultType=Article select * from t_article where userId = {userId} /select select id=getPublicArticleSize resultType=Article select * from t_article where isPublish = 1 /select/mappersrc//po/：?xml version= encoding=UTF8 ?!DOCTYPE mapper PUBLIC // mapper namespace=CommentMap resultMap type=Comment id=findCommentsByArticleIdMap result column=userId property=userId / association property=user column=userId javaType=User select= / /resultMap resultMap type=Comment id=findNewCommentsMap result column=articleId property=articleId / association property=article column=articleId javaType=Article select