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

1.需求说明实现用户通过数据库验证登录需求，采用Myeclipse+Tomcat 6.0+Mysql 5.0+JDK 1.62.数据库表开发所用是Mysql数据库,只建立单张用户表T_USER,表结构如下： 字段名称数据类型字段描述IDint用户编号USERNAMEVARCHAR用户名PASSWORDVARCHAR用户登录密码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日志框架 ISS Spring,SpringMvc,Ibatis webAppRootKey spring_springmvc_ibatis.root log4jConfigLocation/WEB-INF/classes/perties contextConfigLocation /WEB-INF/classes/applicationContext.xml characterEncodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding UTF-8 forceEncoding true characterEncodingFilter /* springSecurityFilterChainorg.springframework.web.filter.DelegatingFilterProxy springSecurityFilterChain /* org.springframework.web.util.Log4jConfigListener org.springframework.web.context.ContextLoaderListener springmvc org.springframework.web.servlet.DispatcherServlet contextConfigLocation /WEB-INF/classes/springmvc-servlet.xml 2 springmvc / 60 index.jsp java.lang.Exception/WEB-INF/jsp/exception.jsp (2)springmvc-servlet.xml(Springmvc框架配置文件)该文件是springmvc框架配置文件，也是它的核心文件 common/fileerror (3)applicationContext.xml(Spring框架配置文件) !- 启动spring注解,当自动扫描启动后,该配置可以去掉 - !- 启动spring注解,等同于 context:annotation-config - perties !- 配置事务特性 - !- 配置事务代理拦截器 PROPAGATION_REQUIREDPROPAGATION_REQUIREDPROPAGATION_REQUIREDPROPAGATION_REQUIRED,readOnly - !- 配置哪些类的方法需要进行事务管理 - !- 配置Dao实例 - !- 配置Service实例 - !- 添加了事务的管理类 - (4)perties(数据源属性文件)数据源连接信息的源出处，目前配置了三种数据库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:/62:50000/mydb#username = root#password = root# Mysqldriver = com.mysql.jdbc.Driverurl = jdbc:mysql:/localhost:3306/mydb?useUnicode=true&characterEncoding=utf-8username = rootpassword = 1234initialPoolSize = 1minPoolSize = 1maxPoolSize =10(5)perties(log4j框架属性文件)log4j日志属性配置文件# pertieslog4j.rootLogger=warn,consolelog4j.appender.console=org.apache.log4j.ConsoleAppenderlog4j.appender.console.layout=org.apache.log4j.PatternLayoutlog4j.appender.console.layout.ConversionPattern=%d %t (%F:%L) %-5p %c - %m%nlog4j.appender.console.Encoding=GB18030log4j.appender.file=org.apache.log4j.RollingFileAppenderlog4j.appender.file.MaxFileSize=10240KBlog4j.appender.file.MaxBackupIndex=100log4j.appender.file.Encoding=GB18030log4j.appender.file.layout=org.apache.log4j.PatternLayoutlog4j.appender.file.layout.ConversionPattern=%d %t (%F:%L) %-5p %c - %m%nlog4j.appender.ROLLING_FILE_CUSTOMER=org.apache.log4j.RollingFileAppenderlog4j.appender.ROLLING_FILE_CUSTOMER.Threshold=debuglog4j.appender.ROLLING_FILE_CUSTOMER.Append=truelog4j.appender.ROLLING_FILE_CUSTOMER.MaxFileSize=1024KBlog4j.appender.ROLLING_FILE_CUSTOMER.MaxBackupIndex=30log4j.appender.ROLLING_FILE_CUSTOMER.layout=org.apache.log4j.PatternLayoutlog4j.appender.ROLLING_FILE_CUSTOMER.layout.ConversionPattern=%d - %c:%L - %-5p %c %x - %m%nlog4j.appender.ROLLING_FILE_WORKMANAGER=org.apache.log4j.RollingFileAppenderlog4j.appender.ROLLING_FILE_WORKMANAGER.Threshold=debuglog4j.appender.ROLLING_FILE_WORKMANAGER.Append=truelog4j.appender.ROLLING_FILE_WORKMANAGER.MaxFileSize=1024KBlog4j.appender.ROLLING_FILE_WORKMANAGER.MaxBackupIndex=30log4j.appender.ROLLING_FILE_WORKMANAGER.layout=org.apache.log4j.PatternLayoutlog4j.appender.ROLLING_FILE_WORKMANAGER.layout.ConversionPattern=%d - %c:%L - %-5p %c %x - %m%nlog4j.appender.ROLLING_FILE_RSS=org.apache.log4j.RollingFileAppenderlog4j.appender.ROLLING_FILE_RSS.Threshold=debuglog4j.appender.ROLLING_FILE_RSS.Append=truelog4j.appender.ROLLING_FILE_RSS.MaxFileSize=1024KBlog4j.appender.ROLLING_FILE_RSS.MaxBackupIndex=30log4j.appender.ROLLING_FILE_RSS.layout=org.apache.log4j.PatternLayoutlog4j.appender.ROLLING_FILE_RSS.layout.ConversionPattern=%d - %c:%L - %-5p %c %x - %m%n(6)sqlMapConfig.xml(Ibatis框架配置文件)该文件主要负责指定sql映射文件，即与model层对象对应的映射文件 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; this.username = username; public User(String username, String password) this.username = username;this.password = password; public User(int id, String username, String password) this.id = id; this.username = 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) this.username = 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 select * from t_user where id=#id# select count(*) from t_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 org.springframework.stereotype.Component;import com.archie.model.User;Component /将UserDao类注入到bean里面public class UserDao extends BaseDao public boolean addUser(User user) throws ExceptionUser bean = (User)getSqlMapClientTemplate().insert(insertUser, user);return bean != null ? true : false;public boolean deleteUser(int id) throws Exceptionint result = getSqlMapClientTemplate().delete(deleteUser, id);return result 0 ? true : false;public User getUserById(int id) throws Exceptionreturn (User)getSqlMapClientTemplate().queryForObject(findUserByID, id);SuppressWarnings(unchecked)public List getAllUsers() throws Exceptionreturn getSqlMapClientTemplate().queryForList(findAllUser);public boolean updateUser(User user) throws Exceptionint result = getSqlMapClientTemplate().update(updateUser, user);return result 0 ? true : false;public User getUserByNameAndPassword(User user) throws Exceptionreturn (User)getSqlMapClientTemplate().queryForObject(findUserByNameAndPassword, user);public int getTotalCount() throws Exceptionreturn (Integer)getSqlMapClientTemplate().queryForObject(getTotalCount);SuppressWarnings(unchecked)public List getUsersByLike(User user) throws Exceptionreturn getSqlMapClientTemplate().queryForList(searchUsers, user);public int deleteUserByLike(User user) throws Exce