ibatis开发人员指南(翻译自ibatis_db_guide-1-2-8)2.htm

ibatis学习资料

      as weightInKilograms,<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">PER_HEIGHT_M 
      as heightInMeters<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">FROM 
      PERSON<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">WHERE 
      PER_ID = #value#<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;/mapped-statement&gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;!--</SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> 
      Use Person object (JavaBean) properties as parameters for insert. Each of 
      the<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt">parameters</SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> 
      in the #hash# symbols is a JavaBeans property. 
      --&gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;mapped-statement 
      name="insertPerson" &gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">INSERT 
      INTO<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">PERSON 
      (PER_ID, PER_FIRST_NAME, PER_LAST_NAME,<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">PER_BIRTH_DATE, 
      PER_WEIGHT_KG, PER_HEIGHT_M)<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">VALUES 
      (#id#, #firstName#, #lastName#,<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">#birthDate#, 
      #weightInKilograms#, #heightInMeters#)<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;/mapped-statement&gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;!--</SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> 
      Use Person object (JavaBean) properties as parameters for update. Each of 
      the<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt">parameters</SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> 
      in the #hash# symbols is a JavaBeans property. 
      --&gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;mapped-statement 
      name="updatePerson" &gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">UPDATE 
      PERSON<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">SET 
      (PER_ID = PER_FIRST_NAME = #firstName#,<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">PER_LAST_NAME 
      = #lastName#, PER_BIRTH_DATE = #birthDate#,<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">PER_WEIGHT_KG 
      = #weightInKilograms#,<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">PER_HEIGHT_M 
      = #heightInMeters#)<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 42pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 4.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">WHERE 
      PER_ID = #id#<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;/mapped-statement&gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;!--</SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> 
      Use Person object (JavaBean) “id” properties as parameters for delete. 
      Each of the<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt">parameters</SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> 
      in the #hash# symbols is a JavaBeans property. 
      --&gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;mapped-statement 
      name="deletePerson" &gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 31.5pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 3.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">DELETE 
      PERSON<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 31.5pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 3.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">WHERE 
      PER_ID = #id#<O:P></O:P></SPAN></B></P>
      <P class=smallFont 
      style="MARGIN-LEFT: 21pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 2.0gd" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;/mapped-statement&gt;<O:P></O:P></SPAN></B></P>
      <P class=smallFont style="TEXT-ALIGN: left; mso-layout-grid-align: none" 
      align=left><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN></B></P>
      <P class=MsoNormal style="TEXT-ALIGN: left; mso-layout-grid-align: none" 
      align=left><SPAN class=smallFont><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&lt;/sql-map&gt;</SPAN></B><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN></SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><O:P></O:P></SPAN></P><PRE class=smallFont></PRE></TD></TR></TBODY></TABLE>
<P><STRONG>Fast Track: Programming with the SQL Map Framework</STRONG></P>
<P>&nbsp;&nbsp;&nbsp;&nbsp; 
现在我们已经完成了所有的配置和映射，剩下的就是写JAVA代码了。第一步是配置SQL　Map。加载我们前面配置好的SQL Map 
XML文件是很简单的。加载XML以后，就可以在框架里使用资源类。</P>
<TABLE width="90%" bgColor=#cccccc border=1>
  <TBODY>
  <TR>
    <TD class=smallFont>String resource = 
      “com/ibatis/example/sql-map-config.xml”;<BR>Reader reader = 
      Resources.getResourceAsReader (resource);<BR>SqlMap sqlMap = 
      XmlSqlMapBuilder.buildSqlMap(reader);</TD></TR></TBODY></TABLE>
<P>SQL Map对象是线程安全的，意味着是长期生存的。对于一个运行的系统来说，你只要配置一次。所以它可以很好的成为一个基类的静态对象（比如，一个BASE 
Dao类），也许你更喜欢集中配置并成为全局可见，你可以把它包装在你自己的工具类中。比如说：</P>
<TABLE width="90%" bgColor=#cccccc border=1>
  <TBODY>
  <TR>
    <TD>
      <P class=MsoNormal style="TEXT-ALIGN: left; mso-layout-grid-align: none" 
      align=left><SPAN class=GramE><B><SPAN lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">private</SPAN></B></SPAN><B><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> 
      <SPAN class=SpellE>MyAppSqlConfig</SPAN> {<O:P></O:P></SPAN></B></P>
      <P class=MsoNormal 
      style="MARGIN-LEFT: 10.5pt; TEXT-ALIGN: left; mso-layout-grid-align: none; mso-para-margin-left: 1.0gd" 
      align=left><SPAN class=GramE><B><SPAN lang=EN-US