Spirng ibatis web 简单示例

<context-param>

加载
/WEB-INF/applicationContext.xml

<servlet>
接收mvc分发

org.springframework.web.servlet.DispatcherServlet
<param-value>/WEB-INF/roadrantz-servlet.xml

<servlet-mapping>对应的结尾名

<url-pattern>*.do</url-pattern>

监听器
加载spring上下文
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

加载属性文件
<beanid="propertyConfigurer"

class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

加载数据源文件
<beanid="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close">

关联ibatis
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">

<propertyname="dataSource"ref="dataSource"/>

<propertyname="configLocation"value="/WEB-INF/roadrantz-ibatis.xml"/>

</bean>

Mvc mapping对应文件applicationContent.xml加载过
<beanid="urlMapping"class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">

<prop key="/home.do">homePageController</prop>
加载bean
<beanid="homePageController"class="com.roadrantz.mvc.HomePageController">

<propertyname="sqlDao"ref="sqlDao"/>

</bean>

加载ibatis配置文件,本文件在
applicationContent.xml

对应模板文件
<beanid="viewResolver"class="org.springframework.web.servlet.view.InternalResourceViewResolver">

<propertyname="prefix">

<value>/tpl/</value>

</property>

<propertyname="suffix">

<value>.jsp</value>

</property>

</bean>
<sqlMapConfig>

<sqlMapresource="com/roadrantz/entity/testst.xml"/>

<sqlMapresource="com/roadrantz/entity/testst_msbv.xml"/>

jdbc.driverClassName =org.gjt.mm.mysql.Driver

jdbc.password
=admin

jdbc.url
=jdbc:mysql://localhost/mspring?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8

jdbc.username
=root

Ibatis配置文件，对应class和数据表文件配置
<sqlMapnamespace="test">

<resultMapclass="com.roadrantz.entity.Test"id="result">

<resultproperty="id"column="id"jdbcType="Integer"/>

<resultproperty="name"column="name"jdbcType="VARCHAR"/>

</resultMap>

<selectid="getAllTests"esultMap="result">

select * from Testst

</select>

publicList getAll() {

return
this.getSqlMapClientTemplate().queryForList("getAllTests",null);

}

模板文件
return new ModelAndView("home","rants","test==========");
对应文件名