Struts 2.1.6精简实例系列教程(3):新闻管理Model层的开发(整合iBatis) - 编程入门网
作者 佚名技术
来源 NET编程
浏览
发布时间 2012-06-20
quot;cn.simple.pojo.Article" /> <!-- Result maps describe the mapping between the columns returned from a query, and the class properties. A result map isn''t necessary if the columns (or aliases) match to the properties exactly. --> <resultMap id="ArticleResult" class="Article"> <result property="id" column="ID" /> <result property="title" column="TITLE"/> <result property="author" column="AUTHOR"/> <result property="content" column="CONTENT"/> <result property="pubtime" column="PUBTIME"/> </resultMap> <!-- Select with no parameters using the result map for Account class. --> <select id="selectAllArticles" resultMap="ArticleResult"> select * from article </select> <!-- A simpler select example without the result map. Note the aliases to match the properties of the target result class. --> <select id="selectArticleById" parameterClass="int" resultClass="Article"> select ID as id, TITLE as title, AUTHOR as author, CONTENT as content, PUBTIME as pubtime from Article where ID=#id# </select> <!-- Insert example, using the Account parameter class --> <insert id="insertArticle" parameterClass="Article"> insert into article ( TITLE, AUTHOR, CONTENT, PUBTIME ) values ( #title#, #author#, #content#, #pubtime# ) </insert> <!-- Update example, using the Account parameter class --> <update id="updateArticle" parameterClass="Article"> update article set TITLE = #title#, AUTHOR = #author#, CONTENT = #content#, PUBTIME = #pubtime# where ID = #id# </update> <!-- Delete example, using an integer as the parameter class --> <delete id="deleteArticleById" parameterClass="int"> delete |
凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务,公司网站:http://www.lingzhong.cn 为了给广大客户了解更多的技术信息,本技术文章收集来源于网络,凌众科技尊重文章作者的版权,如果有涉及你的版权有必要删除你的文章,请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息,谢谢! |
你可能对下面的文章感兴趣
关于Struts 2.1.6精简实例系列教程(3):新闻管理Model层的开发(整合iBatis) - 编程入门网的所有评论