spring+springmvc+ibatis整合注解方式实例

1.需求说明

实现用户通过数据库验证登录需求，采用Myeclipse+Tomcat 6.0+Mysql 5.0+JDK 1.6

2.数据库表

开发所用是Mysql数据库,只建立单张用户表T_USER,表结构如下：

sql语句如下：

CREATE TABLE `t_user` (

`ID` int(11) NOT NULL auto_increment,

`USERNAME` varchar(255) default NULL,

`PASSWORD` varchar(255) default NULL,

PRIMARY KEY (`ID`)

);

3.构建源代码目录

4.用到的jar包(见附件Archive.rar)

5.各项Xml配置文件详解

(1)web.xml文件(Tomcat使用)

服务器根据配置内容初始化spring框架，springmvc框架和log4j日志框架

xmlns="https://www.360docs.net/doc/3513472869.html,/xml/ns/javaee"

xmlns:xsi="https://www.360docs.net/doc/3513472869.html,/2001/XMLSchema-instance"

xsi:schemaLocation="https://www.360docs.net/doc/3513472869.html,/xml/ns/javaee

https://www.360docs.net/doc/3513472869.html,/xml/ns/javaee/web-app_2_5.xsd">

ISS

Spring,SpringMvc,Ibatis

webAppRootKey

spring_springmvc_ibatis.root

log4jConfigLocation

/WEB-INF/classes/log4j.properties

contextConfigLocation

/WEB-INF/classes/applicationContext.xml

characterEncodingFilter

org.springframework.web.filter.CharacterEncodingFil ter

encoding

UTF-8

forceEncoding

true

characterEncodingFilter

/*

springSecurityFilterChain

org.springframework.web.filter.DelegatingFil terProxy

springSecurityFilterChain

/*

org.springframework.web.util.Log4jConfigLi stener

org.springframework.web.context.ContextLoaderList ener

springmvc

org.springframework.web.servlet.DispatcherServlet< /servlet-class>

contextConfigLocation

/WEB-INF/classes/springmvc-servlet.xml

2

springmvc

/

60

index.jsp

https://www.360docs.net/doc/3513472869.html,ng.Exception

/WEB-INF/jsp/exception.jsp

(2)springmvc-servlet.xml(Springmvc框架配置文件)

该文件是springmvc框架配置文件，也是它的核心文件

xmlns:xsi="https://www.360docs.net/doc/3513472869.html,/2001/XMLSchema-instance"

xmlns:mvc="https://www.360docs.net/doc/3513472869.html,/schema/mvc"

xmlns:context="https://www.360docs.net/doc/3513472869.html,/schema/context" xsi:schemaLocation="

https://www.360docs.net/doc/3513472869.html,/schema/beans

https://www.360docs.net/doc/3513472869.html,/schema/beans/spring-beans-3.0.xsd https://www.360docs.net/doc/3513472869.html,/schema/mvc

https://www.360docs.net/doc/3513472869.html,/schema/mvc/spring-mvc-3.0.xsd

https://www.360docs.net/doc/3513472869.html,/schema/context

https://www.360docs.net/doc/3513472869.html,/schema/context/spring-context-3.0. xsd">

class="org.springframework.web.servlet.mvc.annotation.AnnotationM ethodHandlerAdapter"/>

class="org.springframework.web.servlet.view.InternalResourceViewR esolver">

value="org.springframework.web.servlet.view.JstlView"/>

class="org.springframework.web.servlet.handler.SimpleMappingExcep tionResolver">

key="org.springframework.web.multipart.MaxUploadSizeExceededExcep tion">common/fileerror

(3)applicationContext.xml(Spring框架配置文件)

xmlns:xsi="https://www.360docs.net/doc/3513472869.html,/2001/XMLSchema-instance"

xmlns:mvc="https://www.360docs.net/doc/3513472869.html,/schema/mvc"

xmlns:context="https://www.360docs.net/doc/3513472869.html,/schema/context" xmlns:aop="https://www.360docs.net/doc/3513472869.html,/schema/aop"

xmlns:tx="https://www.360docs.net/doc/3513472869.html,/schema/tx"

xsi:schemaLocation="

https://www.360docs.net/doc/3513472869.html,/schema/beans

https://www.360docs.net/doc/3513472869.html,/schema/beans/spring-beans-3.0.xsd https://www.360docs.net/doc/3513472869.html,/schema/mvc

https://www.360docs.net/doc/3513472869.html,/schema/mvc/spring-mvc-3.0.xsd

https://www.360docs.net/doc/3513472869.html,/schema/context

https://www.360docs.net/doc/3513472869.html,/schema/context/spring-context-3.0. xsd

https://www.360docs.net/doc/3513472869.html,/schema/tx

https://www.360docs.net/doc/3513472869.html,/schema/tx/spring-tx-3.0.xsd https://www.360docs.net/doc/3513472869.html,/schema/aop

https://www.360docs.net/doc/3513472869.html,/schema/aop/spring-aop-3.0.xsd" default-autowire="byName">

class="org.springframework.beans.factory.config.PropertyPlacehold erConfigurer">

jdbc.properties

class="https://www.360docs.net/doc/3513472869.html,mons.dbcp.BasicDataSource">

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

class="org.springframework.orm.ibatis.SqlMapClientTemplate">

class="org.springframework.jdbc.datasource.DataSourceTransactionM anager">

(4)jdbc.properties(数据源属性文件)

数据源连接信息的源出处，目前配置了三种数据库Oracle，DB2和Mysql

# Database Connectivity

# Oracle

#driver = oracle.jdbc.driver.OracleDriver

#url = jdbc:oracle:thin:@localhost:1521:oracl

#username = scott

#password = tiger

# DB2

#driver = com.ibm.db2.jcc.DB2Driver

#url = jdbc:db2://10.1.10.162:50000/mydb

#username = root

#password = root

# Mysql

driver = com.mysql.jdbc.Driver

url =

jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncodin g=utf-8

username = root

password = 1234

initialPoolSize = 1

minPoolSize = 1

maxPoolSize =10

(5)log4j.properties(log4j框架属性文件)

log4j日志属性配置文件

# log4j.properties

log4j.rootLogger=warn,console

log4j.appender.console=org.apache.log4j.ConsoleAppender

https://www.360docs.net/doc/3513472869.html,yout=org.apache.log4j.PatternLayout

https://www.360docs.net/doc/3513472869.html,yout.ConversionPattern=[%d] [%t]

(%F:%L) %-5p %c - %m%n

log4j.appender.console.Encoding=GB18030

log4j.appender.file=org.apache.log4j.RollingFileAppender

log4j.appender.file.MaxFileSize=10240KB

log4j.appender.file.MaxBackupIndex=100

log4j.appender.file.Encoding=GB18030

https://www.360docs.net/doc/3513472869.html,yout=org.apache.log4j.PatternLayout

https://www.360docs.net/doc/3513472869.html,yout.ConversionPattern=[%d] [%t]

(%F:%L) %-5p %c - %m%n

log4j.appender.ROLLING_FILE_CUSTOMER=org.apache.log4j.RollingFile Appender

log4j.appender.ROLLING_FILE_CUSTOMER.Threshold=debug

log4j.appender.ROLLING_FILE_CUSTOMER.Append=true

log4j.appender.ROLLING_FILE_CUSTOMER.MaxFileSize=1024KB

log4j.appender.ROLLING_FILE_CUSTOMER.MaxBackupIndex=30

log4j.appender.ROLLING_FILE_https://www.360docs.net/doc/3513472869.html,yout=org.apache.log4j.Patt ernLayout

log4j.appender.ROLLING_FILE_https://www.360docs.net/doc/3513472869.html,yout.ConversionPattern=%d - %c:%L - %-5p %c %x - %m%n

log4j.appender.ROLLING_FILE_WORKMANAGER=org.apache.log4j.RollingF ileAppender

log4j.appender.ROLLING_FILE_WORKMANAGER.Threshold=debug

log4j.appender.ROLLING_FILE_WORKMANAGER.Append=true

log4j.appender.ROLLING_FILE_WORKMANAGER.MaxFileSize=1024KB

log4j.appender.ROLLING_FILE_WORKMANAGER.MaxBackupIndex=30

log4j.appender.ROLLING_FILE_https://www.360docs.net/doc/3513472869.html,yout=org.apache.log4j.P atternLayout

log4j.appender.ROLLING_FILE_https://www.360docs.net/doc/3513472869.html,yout.ConversionPattern= %d - %c:%L - %-5p %c %x - %m%n

log4j.appender.ROLLING_FILE_RSS=org.apache.log4j.RollingFileAppen der

log4j.appender.ROLLING_FILE_RSS.Threshold=debug

log4j.appender.ROLLING_FILE_RSS.Append=true

log4j.appender.ROLLING_FILE_RSS.MaxFileSize=1024KB

log4j.appender.ROLLING_FILE_RSS.MaxBackupIndex=30

log4j.appender.ROLLING_FILE_https://www.360docs.net/doc/3513472869.html,yout=org.apache.log4j.PatternLa yout

log4j.appender.ROLLING_FILE_https://www.360docs.net/doc/3513472869.html,yout.ConversionPattern=%d - %c:%L - %-5p %c %x - %m%n

(6)sqlMapConfig.xml(Ibatis框架配置文件)

该文件主要负责指定sql映射文件，即与model层对象对应的映射文件

"https://www.360docs.net/doc/3513472869.html,/dtd/sql-map-config-2.dtd">

useStatementNamespaces="false"/>

6.Java代码编写

根据包目录，可以看出分成model层,dao层,service层和web层,另外附加test层,用于java环境测试

(1)model层(User.java+User.xml)

User.java代码

package com.archie.model;

public class User {

private int id;

private String username;

private String password;

public User(){

}

public User(int id){

this.id = id;

}

public User(int id, String username){

this.id = id;

https://www.360docs.net/doc/3513472869.html,ername = username;

}

public User(String username, String password) {

https://www.360docs.net/doc/3513472869.html,ername = username;

this.password = password;

}

public User(int id, String username, String password){

this.id = id;

https://www.360docs.net/doc/3513472869.html,ername = username;

this.password = password;

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {

https://www.360docs.net/doc/3513472869.html,ername = username;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

}

User.xml代码(model层对象的sql映射文件,被dao层调用,本质是sql语句集合,

所有相关的sql均于此)

select * from t_user

parameterClass="int">

select * from t_user where id=#id#

select count(*) from t_user

parameterClass="User">

select * from t_user

(username like '%$username$%')

(password like '%$password$%')

select * from t_user where username=#username# and password=#password#

insert into t_user(id,username,password)

values(null,#username#,#password#)

update t_user

set username = #username#,

password=#password#

where id=#id#

delete from t_user where id=#id#

delete from t_user

(username like '%$username$%')

(password like '%$password$%')

(2)dao层(数据服务层,BaseDao.java+UserDao.java)

BaseDao.java(公共Dao,其他Dao均继承它)

package com.archie.dao;

import javax.annotation.PostConstruct;

import javax.annotation.Resource;

import

org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; import com.ibatis.sqlmap.client.SqlMapClient;

public class BaseDao extends SqlMapClientDaoSupport {

@Resource(name="sqlMapClient") //通过bean名称注入

private SqlMapClient sqlMapClient;

@PostConstruct //完成sqlMapClient初始化工作

public void initSqlMapClient(){

super.setSqlMapClient(sqlMapClient);

}

UserDao.java(user数据服务层)

package com.archie.dao;

import java.util.List;

import https://www.360docs.net/doc/3513472869.html,ponent;

import https://www.360docs.net/doc/3513472869.html,er;

@Component //将UserDao类注入到bean里面

public class UserDao extends BaseDao {

public boolean addUser(User user) throws Exception{

User bean =

(User)getSqlMapClientTemplate().insert("insertUser", user);

return bean != null ? true : false;

}

public boolean deleteUser(int id) throws Exception{

int result =

getSqlMapClientTemplate().delete("deleteUser", id);

return result > 0 ? true : false;

}

public User getUserById(int id) throws Exception{

return

(User)getSqlMapClientTemplate().queryForObject("findUserByID", id);

}

@SuppressWarnings("unchecked")

public List getAllUsers() throws Exception{

return

getSqlMapClientTemplate().queryForList("findAllUser");

}

public boolean updateUser(User user) throws Exception{ int result =

getSqlMapClientTemplate().update("updateUser", user);

return result > 0 ? true : false;

}

public User getUserByNameAndPassword(User user) throws Exception{

return

(User)getSqlMapClientTemplate().queryForObject("findUserByNameAnd Password", user);

}

public int getTotalCount() throws Exception{

return

(Integer)getSqlMapClientTemplate().queryForObject("getTotalCount" );

}

@SuppressWarnings("unchecked")

public List getUsersByLike(User user) throws Exception{

return

getSqlMapClientTemplate().queryForList("searchUsers", user);

}

public int deleteUserByLike(User user) throws Exception{ int result =

getSqlMapClientTemplate().delete("deleteUserByLike", user);

if (result > 0) {

System.out.println("模糊删除成功！");

}else {

System.out.println("没有匹配的记录1");

}

return result;

}

}

(3)service层(业务服务层,UserService.java)

UserService.java代码如下

package com.archie.service;

import java.util.List;

import javax.annotation.Resource;

import https://www.360docs.net/doc/3513472869.html,ponent;

import org.springframework.transaction.annotation.Transactional;

import https://www.360docs.net/doc/3513472869.html,erDao;

import https://www.360docs.net/doc/3513472869.html,er;

@Component //将UserService类注入到bean里面

@Transactional //注入事务管理

public class UserService {

@Resource(name="userDao") // 通过名称注入到bean里面

private UserDao userDao;

public User login(User user) throws Exception{

return userDao.getUserByNameAndPassword(user);

}

public void addUser(User user) throws Exception{

userDao.addUser(user);

}

public void deleteUser(int id) throws Exception{

boolean bool = userDao.deleteUser(id);

if (!bool) {

System.out.println("删除的记录不存在！");

throw new RuntimeException();

}

}

public User getUserById(int id) throws Exception{

User user = userDao.getUserById(id);

if (user == null) {

return null;

}

return userDao.getUserById(id);

}

public void updateUser(User user) throws Exception{

userDao.updateUser(user);

}

public int getTotalCount() throws Exception{

return userDao.getTotalCount();

}

@SuppressWarnings("unchecked")

public List getUsersByLike(User user) throws Exception{

return userDao.getUsersByLike(user);

}

public int deleteUserByLike(User user) throws Exception{ return userDao.deleteUserByLike(user);

}

public void insertUsers(List list) throws Exception{ for (int i = 0; i < list.size(); i++) {

if (i > 3) {

System.out.println("列表太长，中断事务");

throw new RuntimeException("中断事务异常,当列表长度大于3的时候故意抛出，看看事务是否回滚");

}

User user = list.get(i);

userDao.addUser(user);

}

}

}

(4)web层(界面控制层,UserController.java)

UserController.java

package com.archie.web;

import javax.annotation.Resource;

import javax.servlet.http.HttpSession;

import javax.validation.Valid;

import org.springframework.stereotype.Controller;

import org.springframework.validation.BindingResult;

import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.servlet.ModelAndView;

import https://www.360docs.net/doc/3513472869.html,er;

import https://www.360docs.net/doc/3513472869.html,erService;

@Controller

@RequestMapping("/user/*")

public class UserController {