SpringMVC + Spring + SpringJDBC整合

SpringMVC +Spring+ SpringJDBC整合实例。文件结构：

 

3S3（3Spring3.x）的整合大致如下：

1）web.xml的配置：

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

<? xml version = "1.0" encoding = "UTF-8" ?> < web-app xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns = "http://java.sun.com/xml/ns/javaee" xmlns:web = "http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation = "http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version = "3.0" >    < display-name ></ display-name >    < welcome-file-list >      < welcome-file >index.jsp</ welcome-file >    </ welcome-file-list >    < listener >      < listener-class >org.springframework.web.util.IntrospectorCleanupListener</ listener-class >    </ listener >    < servlet >      < servlet-name >spring</ servlet-name >      < servlet-class >org.springframework.web.servlet.DispatcherServlet</ servlet-class >      < init-param >        < param-name >contextConfigLocation</ param-name >        < param-value >classpath:*applicationContext.xml</ param-value >      </ init-param >      < load-on-startup >1</ load-on-startup >    </ servlet >    < servlet-mapping >      < servlet-name >spring</ servlet-name >      < url-pattern >*.do</ url-pattern >    </ servlet-mapping >    <!-- 统一字符编码为UTF-8 -->    < filter >      < filter-name >setcharacter</ filter-name >      < filter-class >org.springframework.web.filter.CharacterEncodingFilter</ filter-class >      < init-param >        < param-name >encoding</ param-name >        < param-value >utf-8</ param-value >      </ init-param >    </ filter >    < filter-mapping >      < filter-name >setcharacter</ filter-name >      < url-pattern >/*</ url-pattern >    </ filter-mapping > </ web-app >

 2）applicationContext.xml的配置：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115

<? 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:p = "http://www.springframework.org/schema/p"      xmlns:context = "http://www.springframework.org/schema/context"      xmlns:aop = "http://www.springframework.org/schema/aop" xmlns:tx = "http://www.springframework.org/schema/tx"      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/tx         http://www.springframework.org/schema/tx/spring-tx-3.0.xsd         http://www.springframework.org/schema/aop         http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">        < context:property-placeholder location = "classpath:jdbc.properties" />        <!-- 扫描类包，将标注Spring注解的类自动转化Bean，同时完成Bean的注入 -->      < context:component-scan base-package = "com.controller" />      < context:component-scan base-package = "com.service" />      < context:component-scan base-package = "com.dao" />        <!-- 配置数据源 -->      < bean id = "dataSource" class = "com.mchange.v2.c3p0.ComboPooledDataSource"          destroy-method = "close" >          < property name = "driverClass" >              < value >${jdbc.driverClassName}</ value >          </ property >          < property name = "jdbcUrl" >              < value >${jdbc.url}</ value >          </ property >          < property name = "user" >              < value >${jdbc.username}</ value >          </ property >          < property name = "password" >              < value >${jdbc.password}</ value >          </ property >          <!--连接池中保留的最小连接数。 -->          < property name = "minPoolSize" >              < value >5</ value >          </ property >          <!--连接池中保留的最大连接数。Default: 15 -->          < property name = "maxPoolSize" >              < value >30</ value >          </ property >          <!--初始化时获取的连接数，取值应在minPoolSize与maxPoolSize之间。Default: 3 -->          < property name = "initialPoolSize" >              < value >10</ value >          </ property >          <!--最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->          < property name = "maxIdleTime" >              < value >60</ value >          </ property >          <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->          < property name = "acquireIncrement" >              < value >5</ value >          </ property >          <!--JDBC的标准参数，用以控制数据源内加载的PreparedStatements数量。但由于预缓存的statements 属于单个connection而不是整个连接池。所以设置这个参数需要考虑到多方面的因素。              如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default: 0 -->          < property name = "maxStatements" >              < value >0</ value >          </ property >          <!--每60秒检查所有连接池中的空闲连接。Default: 0 -->          < property name = "idleConnectionTestPeriod" >              < value >60</ value >          </ property >          <!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->          < property name = "acquireRetryAttempts" >              < value >30</ value >          </ property >          <!--获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效 保留，并在下次调用getConnection()的时候继续尝试获取连接。如果设为true，那么在尝试              获取连接失败后该数据源将申明已断开并永久关闭。Default: false -->          < property name = "breakAfterAcquireFailure" >              < value >true</ value >          </ property >          <!--因性能消耗大请只在需要的时候使用它。如果设为true那么在每个connection提交的 时候都将校验其有效性。建议使用idleConnectionTestPeriod或automaticTestTable              等方法来提升连接测试的性能。Default: false -->          < property name = "testConnectionOnCheckout" >              < value >false</ value >          </ property >      </ bean >        <!-- 配置Jdbc模板 -->      < bean id = "jdbcTemplate" class = "org.springframework.jdbc.core.JdbcTemplate" >          < property name = "dataSource" ref = "dataSource" ></ property >      </ bean >        <!-- 配置事务管理器 -->      < bean id = "transactionManager"          class = "org.springframework.jdbc.datasource.DataSourceTransactionManager"          p:dataSource-ref = "dataSource" />        <!-- 通过AOP配置提供事务增强，让service包下所有Bean的所有方法拥有事务 -->      < aop:config proxy-target-class = "true" >          < aop:pointcut id = "serviceMethod"              expression = " execution(* com.service..*(..))" />          < aop:advisor pointcut-ref = "serviceMethod" advice-ref = "txAdvice" />      </ aop:config >      < tx:advice id = "txAdvice" transaction-manager = "transactionManager" >          < tx:attributes >              < tx:method name = "*" />          </ tx:attributes >      </ tx:advice >        <!-- 启动Spring MVC的注解功能，完成请求和注解POJO的映射 -->      < bean          class = "org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" />                  <!-- 配置视图解析器，将ModelAndView及字符串解析为具体的页面 -->      < bean          class = "org.springframework.web.servlet.view.InternalResourceViewResolver"          p:viewClass = "org.springframework.web.servlet.view.JstlView" p:prefix = "/WEB-INF/jsp/"          p:suffix = ".jsp" />   </ beans >

3）jdbc.properties的配置:

?

1 2 3 4

jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql: //localhost:3306/test2 jdbc.username=root jdbc.password= 123456

4)log4j.properties的配置:

?

1 2 3 4 5

log4j.rootLogger=DEBUG,A1 # \u8f93\u51fa\u5230\u63a7\u5236\u53f0 log4j.appender.A1=org.apache.log4j.ConsoleAppender log4j.appender.A1.layout=org.apache.log4j.PatternLayout log4j.appender.A1.layout.ConversionPattern=%d{yyyy-MM-dd HH\:mm\:ss} [\u65E5\u5FD7\u4FE1\u606F] %m%n

 5)User.java

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

package com.model;   import java.io.Serializable;   @SuppressWarnings ( "serial" ) public class User  implements Serializable {            private int id;      private String userName;      private String password;            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;      }      public int getId() {          return id;      }      public void setId( int id) {          this .id = id;      }         }

6)UserController.java

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56

package com.controller;   import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView;   import com.model.User; import com.service.UserService;   @Controller public class UserComtroller {            @Autowired      private UserService userService;            @RequestMapping ( "/user/loginView" )      public String loginView(){          return "login" ;      }            @RequestMapping ( "/user/registerView" )      public String registerView(){          return "register" ;      }            @RequestMapping ( "/user/login" )      public ModelAndView login(User user){          ModelAndView mav =  new ModelAndView();          User u = userService.loginCheck(user);          if ( null ==u){              mav.setViewName( "login" );              mav.addObject( "errorMsg" , "用户名或密码有误！" );              return mav;          }          else {              mav.setViewName( "success" );              mav.addObject( "user" , u);              return mav;          }      }            @RequestMapping ( "/user/register" )      public ModelAndView register(User user){          ModelAndView mav =  new ModelAndView();          if (userService.register(user)){              mav.setViewName( "register_succ" );              return mav;          }          else {              mav.setViewName( "register" );              mav.addObject( "errorMsg" , "用户名已被占用，请更换！！" );              return mav;          }      } }

7)UserService Interface

?

1 2 3 4 5 6 7 8 9

package com.service;   import com.model.User;     public interface UserService {      public boolean register(User user);      public User loginCheck(User user); }

8)UserServiceImp.java

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

package com.service.implement;   import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;   import com.dao.UserDao; import com.model.User; import com.service.UserService;   @Service public class UserServiceImpl  implements UserService {        @Autowired      private UserDao userDao;            @Override      public User loginCheck(User user) {          User u  = userDao.findUserByUserName(user.getUserName());          System.out.println( "id=" +u.getId()+ ",  userName=" +u.getUserName()+ ", password=" +u.getPassword());          if (user.getPassword().equals(u.getPassword())){              return u;          }          else {              return null ;          }      }        @Override      public boolean register(User user) {          User u =  userDao.findUserByUserName(user.getUserName());          if (u.getId()== 0 ){              userDao.register(user);              return true ;          }          else {              System.out.println( "id=" +u.getId()+ ",  userName=" +u.getUserName()+ ", password=" +u.getPassword());              return false ;          }      }   }

9)UserDao Interface

?

1 2 3 4 5 6 7 8

package com.dao;   import com.model.User;   public interface UserDao {      public void register(User user);      public User findUserByUserName( final String userName); }

10)UserDaoImpl.java

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

package com.dao.implement;   import java.sql.ResultSet; import java.sql.SQLException;   import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowCallbackHandler; import org.springframework.stereotype.Repository;   import com.dao.UserDao; import com.model.User;   @Repository public class UserDaoImpl  implements UserDao {            @Autowired      private JdbcTemplate jdbcTemplate;        @Override      public void register(User user) {          String sqlStr =  "insert into user(uname,pwd) values(?,?)" ;          Object[] params =  new Object[]{user.getUserName(),user.getPassword()};          jdbcTemplate.update(sqlStr, params);      }        @Override      public User findUserByUserName(String userName) {          String sqlStr =  "select id,uname,pwd from user where uname=?" ;          final User user =  new User();          jdbcTemplate.query(sqlStr,  new Object[]{userName},  new RowCallbackHandler() {              @Override              public void processRow(ResultSet rs)  throws SQLException {                  user.setId(rs.getInt( "id" ));                  user.setUserName(rs.getString( "uname" ));                  user.setPassword(rs.getString( "pwd" ));              }          });          return user;      }   }

11）单元测试：test/com.service.implement

-UserServiceImplTest.java

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39

package com.service.implement;   import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;   import com.model.User; import com.service.UserService;     @RunWith (SpringJUnit4ClassRunner. class ) @ContextConfiguration (locations= "/applicationContext.xml" ) public class UserServiceTest {            @Autowired      private UserService userService;            @Test      public void testLoginCheck(){          User user =  new User();          user.setUserName( "manager2" );          user.setPassword( "123" );          if ( null !=userService.loginCheck(user))              System.out.println( "------OK!!-----" );          else              System.out.println( "------Sorry!!-----" );      }            @Test      public void testRegister(){          User user =  new User();          user.setUserName( "manager" );          user.setPassword( "123" );          System.out.println(userService.register(user));      }   }

12）测试结果：