环境:win7 MyEclipse10 jdk1.6 tomcat7 SpringMVC2.5 MySQL
从前文
http://340413629-qq-com.iteye.com/blog/2034778
修改而来,目的是加入Mybatis
首先总结一点web.xml的知识
<context-param></context-param> 用来设定web站台的环境参数,它包含两个子元素:
<param-name></param-name> 用来指定参数的名称
<param-value></param-value> 用来设定参数值
比如:
<context-param>
<param-name>my_param</param-name>
<param-value>hello</param-value>
</context-param>
在此设定的参数,可以在servlet中用 getServletContext().getInitParameter("my_param") 来取得
那如下这样写是怎么回事呢
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/*context.xml</param-value>
</context-param>
原来contextConfigLocation 参数定义了要装入的 Spring 配置文件。
据说是这样一个监听器去加载的
<listener>
<listener-class> org.springframework.web.context.ContextLoaderListener listener-class >
</listener>
默认会加载/WEB-INF/下的applicationContext.xml。
但如果配置好contextConfigLocation之后就不加载默认的了
反过来讲此listener也正是为了在服务器启动时加载spring配置文件而存在
以上都是看网上别人的博文,并测试后得知,我并不知道其中原理,所以并不确定。
那来看一下我的web.xml
<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/*context.xml</param-value> </context-param> <servlet> <servlet-name>hello</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>WEB-INF/spring-servlet.xml</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>hello</servlet-name> <url-pattern>*.htm</url-pattern> </servlet-mapping> </web-app>
如上所述context-param就是服务器启动时会被读进内存的,而注册org.springframework.web.context.ContextLoaderListener之后再配置进contextConfigLocation中的就是spring的配置文件
也就是说交给spring管理
我这里只配置了一个我取名spring-db-context.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd"> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath:jdbc.properties</value> </list> </property> </bean> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${driver}" /> <property name="url" value="${url}" /> <property name="username" value="${username}" /> <property name="password" value="${password}" /> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="configLocation" value="classpath:SqlMapConfig.xml"/> </bean> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate"> <constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg> </bean> </beans>
第一个bean是把properties文件读进内存,在本文中可以用${name}来引用
dataSrouce和使用JDBC时是一样的
来看sqlSessionFactory和sqlSession
我记得这样一段代码,在不使用spring时,mybatis是这样生成的
DataSource dataSource = BlogDataSourceFactory.getBlogDataSource();
TransactionFactory transactionFactory = new JdbcTransactionFactory();
Environment environment = new Environment("development", transactionFactory, dataSource);
Configuration configuration = new Configuration(environment);
configuration.addMapper(BlogMapper.class);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
可见,这里是把生成sqlsessionFactory的工作交给了spring来依赖注入
当然,这里必须有mybatis的spring插件包才能跑通
在SqlMapConfig.xml中我几乎什么都没配置,精简期间嘛
<?xml version="1.0" encoding="GB2312" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <mappers> <mapper resource="cn/zinue100/vo/UserMapper.xml" /> </mappers> </configuration>
那来看看Mapper
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="cn.zinue100.vo.UserMapper"> <insert id="insert" parameterType="cn.zinue100.vo.User" useGeneratedKeys="true" keyProperty="id"> INSERT INTO user(username,password,email) VALUES( #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}) </insert> <update id="update" parameterType="cn.zinue100.vo.User"> UPDATE user SET username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR}, email = #{email,jdbcType=VARCHAR} <where> <if test='username!=null'>and username=#{username,jdbcType=VARCHAR}</if> <if test='id!=0'>and id=#{id,jdbcType=INTEGER}</if> </where> </update> <delete id="delete" parameterType="cn.zinue100.vo.User"> delete from user <where> <if test="username!=null">and username=#{username,jdbcType=VARCHAR}</if> <if test="id!=0">and id=#{id,jdbcType=INTEGER}</if> </where> </delete> <select id="selectById" resultType="cn.zinue100.vo.User" parameterType="Integer"> select id,username,password,email from user where id = #{id} </select> <select id="selectByName" resultType="cn.zinue100.vo.User" parameterType="String"> select id,username,password,email from user where username=#{username} </select> <select id="selectAll" resultType="cn.zinue100.vo.User"> select id,username,password,email from user </select> </mapper>
我发现动态SQL已经和我三四年前用的不同了,只需要<where> <if>简洁多了
最后来看看UserDaoImpl.java吧
package cn.zinue100.dao.myBaitsImpl;
import java.util.Map;
import javax.annotation.Resource;
import org.mybatis.spring.SqlSessionTemplate;
import cn.zinue100.dao.UserDao;
import cn.zinue100.vo.User;
public class UserDaoImpl implements UserDao {
private static final String INSERT = "insert";
private static final String UPDATE = "update";
private static final String DELETE = "delete";
private static final String SELECTALL = "selectAll";
private static final String SELECTBYID = "selectById";
private static final String SELECTBYNAME = "selectByName";
private SqlSessionTemplate sqlSession;
public void addUser(User user) {
String sql = this.getStatementId(User.class, INSERT);
this.sqlSession.insert(sql, user);
}
public void deleteUser(User user) {
String sql = this.getStatementId(User.class, DELETE);
this.sqlSession.delete(sql, user);
}
public void updateUser(User user) {
String sql = this.getStatementId(User.class, UPDATE);
sqlSession.update(sql, user);
}
public Map<String, User> getUsers() {
String sql = this.getStatementId(User.class, SELECTALL);
return this.sqlSession.selectMap(sql,"username");
}
public User getUserById(int id) {
String sql = this.getStatementId(User.class, SELECTBYID);
return sqlSession.selectOne(sql, id);
}
public User getUserByName(String name) {
String sql = this.getStatementId(User.class, SELECTBYNAME);
User user = sqlSession.selectOne(sql,name);
return user;
}
private String getStatementId(Class entityClass, String suffix) {
String sqlStr = entityClass.getName() + "Mapper." + suffix;
System.out.println("getStatementId:" + sqlStr);
return sqlStr;
}
public SqlSessionTemplate getSqlSession() {
return sqlSession;
}
@Resource
public void setSqlSession(SqlSessionTemplate sqlSession) {
this.sqlSession = sqlSession;
}
}
最后执行的sql语句用这样一个方法来生成
private String getStatementId(Class entityClass, String suffix) {
String sqlStr = entityClass.getName() + "Mapper." + suffix;
System.out.println("getStatementId:" + sqlStr);
return sqlStr;
}
使用的字符串是刚才Mapper文件的namespace加上id。
因为我的类名和命名空间名一样,只是加了个Mapper,所以用类名(带路径)就可以找到
其他的代码不贴了放在附件中
附件中的lib包只放了需要增加的jar包,如果想凑齐全部jar包,那可以去这个系列前面的所有lib包中找