Mybatis3+Spring4+SpringMVC4 整合
来源:互联网 发布:网络课件设计师 编辑:程序博客网 时间:2024/04/28 08:03
首先在整合这个框架的时候,想想其一般的步骤是怎样的,先有个步骤之后,不至于在后面的搞混了,这样在整合的时候也比较清晰些。
然后我们就细细的一步一步来整合。
1 创建一个Web项目。
2 导入Mybatis3、Spring4、SpringMVC4、连接数据库(我使用的数据库是mysql)的jar包。
我所用的包:
spring-websocket-4.2.0.RELEASE.jar
3 创建Mybatis3、Spring4、SpringMVC4、连接数据库的配置文件。
4 配置web.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <web-app version="2.5" 3 xmlns="http://java.sun.com/xml/ns/javaee" 4 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 5 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 6 http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> 7 8 <!-- 告知javaEE容器,有哪些内容需要添加到上下文中去 --> 9 <context-param>10 <param-name>contextConfigLocation</param-name>11 <param-value>12 /WEB-INF/classes/applicationContext.xml,13 <!-- /WEB-INF/classes/mvc-servlet.xml -->14 </param-value>15 </context-param> 16 17 18 <!-- 加载LOG4J -->19 <context-param>20 <param-name>log4jConfigLocation</param-name>21 <param-value>/WEB-INF/log4j.xml</param-value>22 </context-param>23 24 <context-param>25 <param-name>log4jRefreshInterval</param-name>26 <param-value>60000</param-value>27 </context-param>28 29 <!-- 动态设置项目的运行路径 -->30 <context-param>31 <param-name>webAppRootKey</param-name>32 <param-value>ssm.root</param-value>33 </context-param>34 35 <!-- 配置静态资源 -->36 <servlet-mapping>37 <servlet-name>default</servlet-name>38 <url-pattern>/static/*</url-pattern>39 </servlet-mapping>40 41 42 <!-- 配置springmvc的前端控制器 -->43 <servlet>44 <servlet-name>mvc</servlet-name>45 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>46 <!-- 默认情况下:DispatcherServlet会寻找WEB-INF下,命名规范为[servlet-name]-servlet.xml文件。如:在上例中,它就会找/WEB-INF/spring-servlet.xml47 如果需要修改,需要在web.xml中的<servlet>标记中增加 <init-param>。。。 </init-param>:-->48 <init-param>49 <param-name>contextConfigLocation</param-name>50 <param-value>/WEB-INF/classes/mvc-servlet.xml</param-value>51 </init-param>52 </servlet>53 <servlet-mapping>54 <servlet-name>mvc</servlet-name>55 <url-pattern>/</url-pattern>56 </servlet-mapping>57 58 <!-- spring框架提供的字符集过滤器 -->59 <!-- spring Web MVC框架提供了org.springframework.web.filter.CharacterEncodingFilter用于解决POST方式造成的中文乱码问题 -->60 <filter>61 <filter-name>encodingFilter</filter-name>62 <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>63 <init-param>64 <param-name>encoding</param-name>65 <param-value>UTF-8</param-value>66 </init-param>67 <!-- force强制,促使 -->68 <init-param>69 <param-name>forceEncoding</param-name>70 <param-value>true</param-value>71 </init-param>72 </filter>73 <filter-mapping>74 <filter-name>encodingFilter</filter-name>75 <url-pattern>/*</url-pattern>76 </filter-mapping>77 78 <!-- 登录过滤器-->79 <filter>80 <filter-name>loginFilter</filter-name>81 <filter-class>com.cy.ssm.filter.LoginFilter</filter-class>82 </filter>83 <filter-mapping>84 <filter-name>loginFilter</filter-name>85 <url-pattern>/*</url-pattern>86 </filter-mapping>87 <!-- 监听器 -->88 <listener>89 <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>90 </listener>91 92 <listener>93 <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>94 </listener>95 96 <welcome-file-list>97 <welcome-file>index.jsp</welcome-file>98 </welcome-file-list>99 </web-app>
5 datasource.properties 连接数据库
1 jdbc.driver=com.mysql.jdbc.Driver2 jdbc.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=UTF-83 jdbc.username=root4 jdbc.password=root
6 mybatis.cfg.xml文件
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE configuration PUBLIC "-//mybatis.org/DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd" ><configuration> </configuration>
7 mvc-servlet.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <beans xmlns="http://www.springframework.org/schema/beans" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" 4 xmlns:mvc="http://www.springframework.org/schema/mvc" 5 xsi:schemaLocation="http://www.springframework.org/schema/beans 6 http://www.springframework.org/schema/beans/spring-beans-3.0.xsd 7 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd 8 http://www.springframework.org/schema/mvc 9 http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">10 11 <!-- 启动注解,注册服务,如验证框架、全局类型转换器-->12 <mvc:annotation-driven/>13 14 15 <!-- 启动自动扫描 -->16 <context:component-scan base-package="com.cy.ssm">17 <!-- 制定扫包规则 ,只扫描使用@Controller注解的JAVA类 -->18 <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>19 </context:component-scan>20 21 22 <!-- 配置视图解析器 -->23 <!--24 prefix和suffix:查找视图页面的前缀和后缀(前缀[逻辑视图名]后缀),25 比如传进来的逻辑视图名为WEB-INF/jsp/hello,则该该jsp视图页面应该存放在“WEB-INF/jsp/hello.jsp”; -->26 <bean class="org.springframework.web.servlet.view.UrlBasedViewResolver">27 <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"></property>28 <property name="prefix" value="/"></property> <!-- 我这里的视图直接放在WebRoot下的 -->29 <property name="suffix" value=".jsp"></property>30 </bean>31 </beans>
8 applicationContext.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <beans xmlns="http://www.springframework.org/schema/beans" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" 4 xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 5 xsi:schemaLocation="http://www.springframework.org/schema/beans 6 http://www.springframework.org/schema/beans/spring-beans-3.0.xsd 7 http://www.springframework.org/schema/aop 8 http://www.springframework.org/schema/aop/spring-aop-3.0.xsd 9 http://www.springframework.org/schema/tx10 http://www.springframework.org/schema/tx/spring-tx-3.1.xsd11 http://www.springframework.org/schema/context12 http://www.springframework.org/schema/context/spring-context-4.2.xsd">13 14 15 <!-- 开启自动扫包 -->16 <context:component-scan base-package="com.cy.ssm">17 <!--制定扫包规则,不扫描@Controller注解的JAVA类,其他的还是要扫描 -->18 <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>19 </context:component-scan>20 21 <!-- 启动AOP支持 -->22 <aop:aspectj-autoproxy/>23 24 <!-- 引入外部数据源配置信息 -->25 <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">26 <property name="locations">27 <value>classpath:datasource.properties</value>28 </property>29 </bean>30 31 <!-- 配置数据源 -->32 <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">33 <property name="driverClassName" value="${jdbc.driver}"></property>34 <property name="url" value="${jdbc.url}"></property>35 <property name="username" value="${jdbc.username}"></property>36 <property name="password" value="${jdbc.password}"></property>37 </bean>38 39 40 <!-- 配置Session工厂 -->41 <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">42 <property name="dataSource" ref="dataSource"></property>43 <!-- 加载mybatis.cfg.xml文件 -->44 <property name="configLocation" value="classpath:mybatis.cfg.xml"></property>45 <!-- 自动扫描需要定义类别名的包,将包内的JAVA类的类名作为类别名 -->46 <property name="typeAliasesPackage" value="com.cy.ssm.beans"></property>47 </bean>48 49 <!-- 自动扫描所有的Mapper接口与文件 -->50 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">51 <property name="basePackage" value="com.cy.ssm.mapper"></property>52 </bean>53 54 <!-- 配置事务管理器 -->55 <bean id="txManager"56 class="org.springframework.jdbc.datasource.DataSourceTransactionManager">57 <property name="dataSource" ref="dataSource"></property>58 </bean>59 60 <!-- 定义个通知,指定事务管理器 -->61 <tx:advice id="txAdvice" transaction-manager="txManager">62 <tx:attributes>63 <tx:method name="delete*" propagation="REQUIRED" read-only="false"64 rollback-for="java.lang.Exception" />65 <tx:method name="save*" propagation="REQUIRED" read-only="false"66 rollback-for="java.lang.Exception" />67 <tx:method name="insert*" propagation="REQUIRED" read-only="false"68 rollback-for="java.lang.Exception" />69 <tx:method name="update*" propagation="REQUIRED" read-only="false"70 rollback-for="java.lang.Exception" />71 <tx:method name="load*" propagation="SUPPORTS" read-only="true"/>72 <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>73 <tx:method name="search*" propagation="SUPPORTS" read-only="true"/>74 <tx:method name="select*" propagation="SUPPORTS" read-only="true"/>75 <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>76 </tx:attributes>77 </tx:advice>78 79 <aop:config>80 <!-- 配置一个切入点 -->81 <aop:pointcut id="serviceMethods" expression="execution(* com.cy.ssm.service.impl.*ServiceImpl.*(..))" />82 <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceMethods" />83 </aop:config>84 85 </beans>
9 配置文件都差不多配置好了,接下来就写个测试的。
UserBean.java
1 package com.cy.ssm.beans; 2 3 import java.io.Serializable; 4 5 public class UserBean implements Serializable { 6 7 8 private static final long serialVersionUID = -2682305557890221059L; 9 private Integer id;10 private String username;11 private String password;12 private Double account;13 public UserBean() {14 super();15 // TODO Auto-generated constructor stub16 }17 public UserBean(Integer id, String username, String password, Double account) {18 super();19 this.id = id;20 this.username = username;21 this.password = password;22 this.account = account;23 }24 public Integer getId() {25 return id;26 }27 public void setId(Integer id) {28 this.id = id;29 }30 31 public String getUsername() {32 return username;33 }34 public void setUsername(String username) {35 this.username = username;36 }37 public String getPassword() {38 return password;39 }40 public void setPassword(String password) {41 this.password = password;42 }43 public Double getAccount() {44 return account;45 }46 public void setAccount(Double account) {47 this.account = account;48 }49 @Override50 public String toString() {51 return "UserBean [account=" + account + ", id=" + id + ", password="52 + password + ", username=" + username + "]";53 }54 }
UserMapper.java
View Code
UserMapper.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 3 <mapper namespace="com.cy.ssm.mapper.UserMapper"> 4 <!-- 自定义返回结果集 --> 5 <resultMap id="userMap" type="UserBean"> 6 <id property="id" column="id" javaType="java.lang.Integer"></id> 7 <result property="username" column="username" javaType="java.lang.String"></result> 8 <result property="password" column="password" javaType="java.lang.String"></result> 9 <result property="account" column="account" javaType="java.lang.Double"></result>10 </resultMap>11 12 <!-- 批量操作和foreach标签 -->13 14 <insert id="batchInsertUser" parameterType="java.util.List">15 insert into t_user values 16 <foreach collection="users" item="users" separator=",">17 (null,#{users.username},#{users.password},#{users.account})18 </foreach>19 </insert>20 21 22 <delete id="batchDeleteUser">23 delete from t_user where id in (24 <foreach collection="list" item="list" separator=",">25 #{id}26 </foreach>27 )28 </delete>29 30 <!--collection 为用于遍历的元素(必选),支持数组、List、Set -->31 <!-- item 表示集合中每一个元素进行迭代时的别名. -->32 <!--separator表示在每次进行迭代之间以什么符号作为分隔 符. -->33 34 <!--#在生成SQL时,对于字符类型参数,会拼装引号35 $在生成SQL时,不会拼装引号,可用于order by之类的参数拼装36 -->37 <select id="pagerUser" parameterType="java.util.Map" resultMap="userMap">38 select * from t_user where 1=139 <if test="username!=null">40 and username like '%${username}%'41 </if>42 limit ${index},${pageSize} 43 </select>44 45 <select id="countUser" parameterType="java.util.Map" resultType="int">46 select count(*) from t_user where 1=1 47 <if test="username != null">48 and username like '%${username}%' 49 </if>50 </select>51 52 </mapper>
ILoginService.java
1 package com.cy.ssm.service; 2 3 4 import com.cy.ssm.beans.UserBean; 5 6 public interface ILoginService { 7 8 public UserBean Login(String username,String password); 9 10 11 }
LoginServiceImpl.java
1 package com.cy.ssm.service.impl; 2 3 import javax.annotation.Resource; 4 5 import org.springframework.stereotype.Service; 6 7 import com.cy.ssm.mapper.UserMapper; 8 import com.cy.ssm.beans.UserBean; 9 import com.cy.ssm.service.ILoginService;10 @Service11 public class LoginServiceImpl implements ILoginService{12 13 @Resource14 private UserMapper um;15 16 17 @Override18 public UserBean Login(String username, String password) {19 return um.login(username, password);20 }21 22 }
LoginController .java
1 package com.cy.ssm.controller; 2 3 4 import javax.annotation.Resource; 5 import javax.servlet.http.HttpServletRequest; 6 7 import org.apache.log4j.Logger; 8 import org.springframework.stereotype.Controller; 9 import org.springframework.web.bind.annotation.RequestMapping;10 import org.springframework.web.servlet.ModelAndView;11 12 import com.cy.ssm.beans.UserBean;13 import com.cy.ssm.service.ILoginService;14 15 16 17 @Controller18 public class LoginController {19 private Logger log = Logger.getLogger(this.getClass());20 21 @Resource22 private ILoginService loginServiceImpl;23 24 @RequestMapping("/login")25 public ModelAndView login(HttpServletRequest req,UserBean user){26 log.info(user);27 28 ModelAndView mv = new ModelAndView();29 UserBean u=loginServiceImpl.Login(user.getUsername(), user.getPassword());30 31 if(u != null){32 33 req.getSession().setAttribute("user", u);34 mv.addObject("password", u.getPassword());35 System.out.println(u.getPassword());36 }37 mv.setViewName("index");38 return mv;39 }40 41 42 43 }
jsp页面;
login.jsp
1 <body>2 <form action="<%=basePath%>login" method="post">3 <input type="text" name="username"/>4 <input type="text" name="password"/>5 <input type="submit" value="提交"/>6 </form>
index.jsp
<body>
${password }
</body>
测试:
点击提交
整体大概就这样了!
我把整个文件上传到:http://pan.baidu.com/s/1hrB1guo
继续我的作业了!
每件事都需要坚持!
0 0
- Mybatis3+Spring4+SpringMVC4 整合
- Mybatis3+Spring4+SpringMVC4 整合
- Mybatis3+Spring4+SpringMVC4 整合
- Mybatis3+Spring4+SpringMVC4 整合
- Mybatis3+Spring4+SpringMVC4 整合
- Mybatis3+Spring4+SpringMVC4 整合
- Mybatis3+Spring4+SpringMVC4 整合
- Spring4+SpringMVC4+MyBatis3.2整合
- Spring4+SpringMVC4+Mybatis3框架整合
- mybatis3+springmvc4+spring4整合教程
- Spring4.2.6+SpringMVC4.2.6+MyBatis3.4.0 整合
- Mybatis3+Spring4+SpringMVC4 框架整合环境搭建
- SSM整合最新版,spring4.2,springmvc4.2,mybatis3.2整合
- SSM整合最新版,spring4.2,springmvc4.2,mybatis3.2整合
- Maven3 + Spring4 + SpringMVC4 + Mybatis3
- Maven3 + Spring4 + SpringMVC4 + Mybatis3
- mybatis3.2.6整合spring4.0和springMVC4.0开发
- 【ssm整合教程】spring4.0.2+springMVC4.0.2+mybatis3.2.6集成
- 如何修改TextView链接点击实现(包含链接生成与点击原理分析)
- Hello World
- Oracle数据库安装完,重启后网络打开超慢解决办法
- 统一处理jersey的异常
- Qt数据库操作,检测表中是否存在某条数据
- Mybatis3+Spring4+SpringMVC4 整合
- yum -y install与yum install有什么不同
- MFC通过ADO操作Access数据库
- [如何编辑PDF]教你怎样编辑修改PDF文件
- Android 以广播的方式监听Home键
- oracle 表空间和用户的创建删除,以及权限
- Android Wear 开发 (一)
- android核心技术与最佳实践笔记(一)
- A Better $state.reload for the AngularJS UI-Router