iBatis使用（1）之照猫画虎

1,在web.xml加入Spring的Config配置

xml 代码

<context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>
   /WEB-INF/dataAccess.xml  /WEB-INF/applicationContext.xml
  </param-value>
 </context-param>

2,用spring的MVC，还要加入Spring的Dispatcher，（这里的servlet-name指定了MVC的配置文件ibatis-servlet.xml，也是一个spring的配置文件）

xml 代码

<servlet>
  <servlet-name>ibatis</servlet-name>
  <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  <load-on-startup>2</load-on-startup>
 </servlet>
 <servlet-mapping>
  <servlet-name>ibatis</servlet-name>
  <url-pattern>*.go</url-pattern>
 </servlet-mapping>

3,dataAccess.xml中加入iBatis的配置

xml 代码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  <property name="driverClassName" value="org.gjt.mm.mysql.Driver"/>
  <property name="url" value="jdbc:mysql://localhost:3306/pulan?useUnicode=true&amp;&amp;characterEncoding=GBK"/>
  <property name="username" value="root"/>
  <property name="password" value=""/>
 </bean>
 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource" ref="dataSource"/>
 </bean>
 <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="configLocation" value="WEB-INF/sql-map-config.xml"/>
  <property name="dataSource" ref="dataSource"/>
 </bean>

 <bean id="lineDAO" class="dao.ibatis.dao.LineDAOImpl">
  <property name="sqlMapClient" ref="sqlMapClient"/>
 </bean>

 <bean id="stationDAO" class="dao.ibatis.dao.StationDAOImpl">
  <property name="sqlMapClient" ref="sqlMapClient"/>
 </bean>

 <bean id="meterDAO" class="dao.ibatis.dao.MeterDAOImpl">
  <property name="sqlMapClient" ref="sqlMapClient"/>
 </bean>
 <bean id="dataDAO" class="dao.ibatis.dao.DataDAOImpl">
  <property name="sqlMapClient" ref="sqlMapClient"/>
 </bean>
</beans>

sql-map-client.xml配置

xml 代码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
    "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
 <sqlMap resource="dao/ibatis/maps/Line.xml"/>
 <sqlMap resource="dao/ibatis/maps/Station.xml"/>
 <sqlMap resource="dao/ibatis/maps/Meter.xml"/>
 <sqlMap resource="dao/ibatis/maps/Data.xml"/>

</sqlMapConfig>

5，Station.xml

xml 代码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Station">
  <resultMap id="result" class="dao.ibatis.db.Station">
   <result property="stationID" column="StationID" columnIndex="1"/>
   <result property="stationNumber" column="StationNumber" columnIndex="2"/>
   <result property="stationName" column="StationName" columnIndex="3"/>
   <result property="stationAddress" column="StationAddress" columnIndex="4"/>
   <result property="stationType" column="StationType" columnIndex="5"/>
   <result property="assessType" column="assessType" columnIndex="6"/>
   <result property="transformerCapacity" column="TransformerCapacity" columnIndex="7"/>
   <result property="lineID" column="LineID" columnIndex="8"/>
  </resultMap>

  <select id="getStationList" resultMap="result">
    select *  from station
  </select>
  <select id="getStationListByLineID"
   parameterClass="java.lang.String"
   resultMap="result">
    select *  from station  where `LineID` = #value#
  </select>

</sqlMap>

6,Station.java ----POJO

java 代码

package dao.ibatis.db;
import java.io.Serializable;
public class Station implements Serializable {

   private int stationID;
   private String stationNumber;
   private String stationName;
   private String stationAddress;
   private int stationType;
   private int assessType;
   private int transformerCapacity;
   private int lineID;
 public int getAssessType() {
  return assessType;
 }
 public void setAssessType(int assessType) {
  this.assessType = assessType;
 }
 public int getLineID() {
  return lineID;
 }
 public void setLineID(int lineID) {
  this.lineID = lineID;
 }
 public String getStationAddress() {
  return stationAddress;
 }
 public void setStationAddress(String stationAddress) {
  this.stationAddress = stationAddress;
 }
 public int getStationID() {
  return stationID;
 }
 public void setStationID(int stationID) {
  this.stationID = stationID;
 }
 public String getStationName() {
  return stationName;
 }
 public void setStationName(String stationName) {
  this.stationName = stationName;
 }
 public String getStationNumber() {
  return stationNumber;
 }
 public void setStationNumber(String stationNumber) {
  this.stationNumber = stationNumber;
 }
 public int getStationType() {
  return stationType;
 }
 public void setStationType(int stationType) {
  this.stationType = stationType;
 }
 public int getTransformerCapacity() {
  return transformerCapacity;
 }
 public void setTransformerCapacity(int transformerCapacity) {
  this.transformerCapacity = transformerCapacity;
 }


}

7,StationDAO,StationDAOImpl数据访问

java 代码

package dao.ibatis.dao;
import java.util.List;
public interface StationDAO {
 public List getStationList(int LineID);
}

package dao.ibatis.dao;
import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
public class StationDAOImpl extends SqlMapClientDaoSupport implements
  StationDAO {
 public List getStationList(int LineID) {
  // TODO Auto-generated method stub
  if(LineID <= 0){
   return getSqlMapClientTemplate().queryForList("getStationList", null);
  }else{
   return getSqlMapClientTemplate().queryForList("getStationListByLineID", String.valueOf(LineID));
  }
 }
}

ibatis-serlet.xml定义动作

xml 代码

<bean name="/listStation.go" class="net.fox.web.ListStationController">
  <property name="ibatis" ref="ibatis"/> //这里的ibatis不是servlet名字，而是一个Spring的bean
   //定义在applicationContext.xml里
 </bean>

9。ibatis(property)

xml 代码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
 <bean id="baseTransactionProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
  <property name="transactionManager"><ref bean="transactionManager"/></property>
  <property name="transactionAttributes">
   <props>
    <prop key="insert*">PROPAGATION_REQUIRED</prop>
    <prop key="update*">PROPAGATION_REQUIRED</prop>
    <prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
   </props>
  </property>
 </bean>
 <bean id="ibatis" parent="baseTransactionProxy">
  <property name="target">
   <bean class="net.fox.IBatisImpl">
    <property name="lineDAO" ref="lineDAO"/>
    <property name="stationDAO" ref="stationDAO"/>
    <property name="meterDAO" ref="meterDAO"/>
    <property name="dataDAO" ref="dataDAO"/>
   </bean>
  </property>
 </bean>

</beans>

10.ListStationController.java

java 代码

package net.fox.web;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.fox.IBatisImpl;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;
import dao.ibatis.db.Station;
public class ListStationController implements Controller {
  private IBatisImpl ibatis;



  public void setIbatis(IBatisImpl ibatis) {
   this.ibatis = ibatis;
  }
 public ModelAndView handleRequest(HttpServletRequest arg0,
   HttpServletResponse arg1) throws Exception {
  int LineID = Integer.parseInt(arg0.getParameter("line"));
  Map model = new HashMap();
  List l1 = this.ibatis.getStationDAO().getStationList(LineID);
  model.put("stationList", l1);
  return new ModelAndView("ListStation",model);
 }
}

ListStation.jsp (MVC 中的V)

xml 代码

<%@page contentType="text/html;charset=GBK"%>
<%@ taglib prefix="c" uri="/WEB-INF/tld/c.tld" %>
<%@ taglib prefix="fmt" uri="/WEB-INF/tld/fmt.tld" %>
<html><head><title>数据查看</title>
<meta content="text/html; charset=GBK" http-equiv="Content-Type" />
<META HTTP-EQUIV="Cache-Control" CONTENT="max-age=0">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
<meta http-equiv="expires" content="0">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
</head>
<body bgcolor="white">
<center>
  <font size="4"><b>台区列表</b></font>
</center>
<form action="<c:url value="/listMeter.go"/>" method="post">
<table align="center" bgcolor="#008800" border="0" cellspacing="2" cellpadding="3">
  <tr bgcolor="#CCCCCC">  <td><b>选择台区</b></td>  </tr>
  <tr bgcolor="#FFFF88"><td>
   <select name="station">
  <c:forEach var="station" items="${stationList}">
   <option value="<c:out value="${station.stationID}"/>"><c:out value="${station.stationName}"/></option>
  </c:forEach>
 </select>
</td>
</tr>
<tr><td><input type="submit" value="OK"/></td></tr>
</form>
</table>
<%@ include file="footer.jsp" %>

总结：基本上是依靠Spring自带的jpetStore例子来做的，有几个问题，使用的TAGLIb是需要到apache的网站上下载，还有要用到的有cglib，commons，iBatis的jar，cglib是一定要用的