springMVC+Mybatis整合环境搭建

1、Spring与Mybatis整合环境搭建本文主要介绍Spring Mybatis的常用整合方法。目录一、 准备1二、 配置文件21. 数据库连接基本信息 perties 22. 在数据库中创建表与及相应的序列 23. 创建相应的 JavaBean34. 准备表的映射文件 UserTable.xml45. 总酉己置文件 sqlMapConfig.xml46.Spring 酉己置文件 beans.xml57.相应的 DAO67.1 IUserDAO.java67.2UseDAOImpl7三、测试8一、准备1.mybatis-spring-1.1.1.jar 或者更高版本 下载地址：

2、 http:/code.google.Com/p/mybatis/在这个jar包里有spring和mybatis的jar包需要一同导入。如果其他版本没有的话，可以 去他们的官方下载。2.如果需要对数据库操作可能还需要引用到的jar 包有commons-dbcp.jar,commons-pool.jar,commons-io.jar以及对应的数据库马区动，我这里使用的是oracle数据库，所以jar包ojdbc6.jar3.JAVA环境需要安装JRM者JDK版本最好1.6或者以上。设置好环境变量。4.IDE工具（Eclipse当然也可以用其他的）二、配置文件1. 数据库连接基本信息 jdbc.p

3、roperties连接数据库的一些基本信息，放在src下driverClassName= oracle.jdbc.driver.OracleDriverurl= jdbc:oracle:thin::1521:orclusername= adminpassword= adminmaxActive= 255maxIdle= 20maxWait= 100具体的一些信息，你可以根据自己的数据库情况进行一定的修改。2. 在数据库中创建表与及相应的序列Create table usertable(Userid int primary key,Username varchar2(32) n

4、ot null,Password varchar2(32) );Create sequence usertable_seq start with 1 increment by 1 nocahe;Commit;3. 创建相应的JavaBeanpackagecom.springmybatis.po;publicclass UserTableprivateint userId ;private private publicStringuserName ;Stringpassword;UserTable()publicint getUserId()returnuserId ;publicthisvoi

5、d setUserId(.userId = userId;int userId )publicString getUserName()returnuserName ;public void setUserName( String userName )this.userName = userName;publicString getPassword()returnpassword ;void setPassword( String password )publicthis . password = password; 4. 准备表的映射文件 UserTable.xml<? xml vers

6、ion ="1.0" encoding ="UTF-8" ?> <! DOCTYPE mapper PUBLIC "-//DTD Mapper 3.0/EN""/dtd/mybatis-3-mapper.dtd"<mapper namespace ="com.springmybatis.po.UserTable"><resultMaptype ="UserTable"id ="us

7、erMap" >< idproperty< idproperty< idproperty</ resultMap >="userId" column ="userid" ></ id >="userName"column="password"column="username"></ id >="password"></ id ><select id ="getU

8、ser" parameterType ="UserTable"resultMap= "userMap" >select userId,userName from usertable where userId=#userId</ select ><insert id ="addUser" parameterType ="UserTable" > insert into usertable(userid,username,password)values(userid_seq.ne

9、xtval,#userName,#password)</ insert ><update id ="updateUser" parameterType ="UserTable" > update usertable set username=#userName,password=#password where userid=#userId</ update ></ mapper >5. 总配置文件 sqlMapConfig.xml对于熟悉Mybatis这个orm框架的肯定知道，我们一般都需要一个对数据库操作

10、的总配置文件。<? xml version ="1.0" encoding ="UTF-8"?><! DOCTYPE configuration PUBLIC "-//DTD Config 3.0/EN""/dtd/mybatis-3-config.dtd"> <configuration ><!- 别名-><typeAliases ><typeAlias type ="com.spr

11、ingmybatis.po.UserTable"alias ="UserTable" /></ typeAliases >< mappers >= "com/springmybatis/po/UserTable.xml"/><mapper resource </ mappers ></ configuration >6.Spring 酉己置文件 beans.xml<? xml version ="1.0" encoding ="UTF-8&qu

12、ot; ?> <beans xmlns ="/schema/beans"xmlns:xsi ="/2001/XMLSchema-instance"xsi:schemaLocation ="/schema/beans/schema/beans/spring-beans.xsd"><!- config db pr

13、operty file location -><bean id ="propertyConfigurer"class ="org.springframework.beans.factory.config.PropertyPlaceholderCo nfigurer" ><property name ="locations" > <list ><value >perties </ value ></ list ></ property &

14、gt;</ bean ><bean id ="dataSource" destroy-method ="close"class ="mons.dbcp.BasicDataSource"><property name ="driverClassName" ><value >$driverClassName </ value ></ property><propertyname ="url"><value &g

15、t;$u _ </ value ></ property><propertyname ="username"><value >$username </ value > </ property><propertyname ="password"><value > $password </ value > </ property><propertyname ="maxActive"><value >

16、;$maxActive </ value > </ property><propertyname ="maxIdle"><value >$maxIdle </ value > </ property><propertyname ="maxWait"><value >$(maxWait) </ value ></ property >< propertyname ="validationQuery"><

17、;value >select count(1) from Dual</ value ></ property><!- test when get connection -><propertyname ="testOnBorrow"><value >true </ value ></ property><!- test when return connection to pool -><propertyname ="testOnReturn">

18、<value >true </ value ></ property><propertyname ="testWhileIdle"><value >true </ value ></ property></ bean ><!- 创建SqlSessionFactory，同时指定数据源 -><bean id ="sqlSessionFactory"class ="org.mybatis.spring.SqlSessionFactoryB

19、ean">< property name ="dataSource" ref ="dataSource" />< property name = "configLocation"value ="classpath:sqlMapConfig.xml"></ property ></ bean ><bean id ="userDAO" class ="com.springmybatis.dao.UserDAOImpl&q

20、uot;>< property name = "sqlSessionFactory" ref = "sqlSessionFactory" ></ property > </ bean ></ beans >7.相应的DAO7.1 lUserDAO.javapackage com.springmybatis.dao;import com.springmybatis.po.UserTable;public interface/*lUserDAO* add user into db* param userT

21、able necessary user information* return add if succeed*/public boolean addUser(UserTable userTable);/* validate user* param userTable* return*/publicboolean checkUser(UserTable userTable);public boolean updateUser( UserTable userTable );7.2UseDAOImplpackage com.springmybatis.dao;import org.apache.ib

22、atis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import com.springmybatis.po.UserTable;public class UserDAOImpl implements IUserDAOprivate SqlSessionFactory sqlSessionFactory;public SqlSessionFactory getSqlSessionFactory()return sqlSessionFactory;public void setSqlSessionFa

23、ctory( SqlSessionFactory sqlSessionFactory )(this.sqISessionFactory = sqISessionFactory;public boolean addUser( UserTable userTable )(SqlSession session = this.getSqlSessionFactory().openSession();int i1 = session.insert( "addUser", userTable );session.close();return i1 != 0 ;public boolea

24、n updateUser( UserTable userTable )(SqlSession session = this.getSqlSessionFactory().openSession();int i = session.update( "updateUser", userTable );return i != 0;public boolean checkUser( UserTable userTable )(return false;二、测试package com.springmybatis.dao;import org.springframework.beans.BeansException;import o