廣工數(shù)據(jù)庫(kù)課程設(shè)計(jì)報(bào)告-全文預(yù)覽
【正文】 mapper resource=/po//mapper resource=/po//mapper resource=/po//mapper resource=/po///mappers/configurationsrc//po/：?xml version= encoding=UTF8 ?!DOCTYPE mapper PUBLIC // mapper namespace=UserMap insert id=addUser parameterType=User insert into t_user (id,username, password,name,sex,mobile,imageurl) values ({id},{username},{password},{name}, {sex},{mobile},{},{imageurl}) /insert delete id=deleteUserById parameterType=String delete from t_user where id = {id} /delete update id=updataUser parameterType=User update t_user set password = {password}, name = {name} , sex = {sex}, mobile = {mobile}, = {}, imageurl = {imageurl} where id = {id} /update select id=findUserByUserName parameterType=string resultType=User select * from t_user where username = {username} /select select id=findUserById parameterType=string 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 sele
規(guī)章制度相關(guān)推薦
鄂ICP備17016276號(hào)-1