使用idea开发工具,整合spring+springmvc+mybatis

本文详细介绍了如何在Maven Web项目中整合Spring、Spring MVC和MyBatis,包括配置依赖、编写配置文件、创建控制器和服务层等内容。

一、创建一个maven的web项目

二、集成spring和springmvc

1.在已经生成的pom文件中添加

<properties>
	<org.springframework.version>4.1.6.RELEASE</org.springframework.version>
</properties>
	
<dependencies>
    <!-- spring -->
	<dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context-support</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
</dependencies>

2.创建applicationContext.xml文件

<?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:context="http://www.springframework.org/schema/context"
		   xmlns:task="http://www.springframework.org/schema/task"
		   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task.xsd">


	</beans>

3.创建springMvc.xml文件,并配置

<?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:mvc="http://www.springframework.org/schema/mvc"
		   xmlns:context="http://www.springframework.org/schema/context"
		   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

		<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
			<property name="prefix" value="/WEB-INF/pages/"/>
			<property name="suffix" value=".jsp"/>
		</bean>

		<mvc:annotation-driven>
			<mvc:message-converters>
				<bean class="org.springframework.http.converter.StringHttpMessageConverter">
					<property name="supportedMediaTypes">
						<list>
							<value>text/plain;charset=UTF-8</value>
							<value>text/html;charset=UTF-8</value>
						</list>
					</property>
				</bean>
			</mvc:message-converters>
		</mvc:annotation-driven>

	</beans>
4.配置web.xml文件
<!DOCTYPE web-app PUBLIC
			"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
			"http://java.sun.com/dtd/web-app_2_3.dtd" >

	<web-app>
	  <display-name>Archetype Created Web Application</display-name>

	  <filter>
		<filter-name>encodingFilter</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>
		<init-param>
		  <param-name>forceEncoding</param-name>
		  <param-value>true</param-value>
		</init-param>
	  </filter>

	  <filter-mapping>
		<filter-name>encodingFilter</filter-name>
		<url-pattern>/*</url-pattern>
	  </filter-mapping>


	  <servlet>
		<servlet-name>ssmTest</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
		  <param-name>contextConfigLocation</param-name>
		  <param-value>classpath*:springMvc.xml;classpath*:/applicationContext.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	  </servlet>
	  <servlet-mapping>
		<servlet-name>ssmTest</servlet-name>
		<url-pattern>/</url-pattern>
	  </servlet-mapping>
	</web-app>

5.创建Controller

	package com.test.controller;

	import org.springframework.stereotype.Controller;
	import org.springframework.web.bind.annotation.RequestMapping;

	@Controller
	@RequestMapping("/")
	public class IndexController {

		@RequestMapping("index")
		public String toIndex(){
			return "index";
		}
		
	}

注:把controller所在的包,配置到springMvc扫描标签中

6.在WEB-INF/pages/下创建 index.jsp视图(省略)

7.修改springMvc.xml文件,添加扫描包

<context:component-scan base-package="com.test.controller"/>

8.测试,访问:http://localhost:8080/index

遇到的问题:
1、archetypeCatalog=internal,在创建项目的时候,有一步需要添加这个键值对,否则构建maven项目会很慢
2、创建好的项目可能会没有resources系统目录,可手动添加该文件夹,然后在 File-Project Structure中,选择Modules中设置成resources
3、配置文件、controller等写好后,需要clean、package才能生成部署包
4、在配置Tomcat的时候,在Deployment一项,需要选择package生成的部署包,才能运行

三、集成mybatis

1.pom文件添加

<!-- mybatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.1</version>
    </dependency>

    <!-- mysql-jdbc -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>

    <!--mybatis-spring整合包,这样就可以通过spring配置bean的方式进行mybatis配置了,不然需要单独使用mybatis的配置-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.1</version>
    </dependency>

    <!-- 导入dbcp的jar包,用来在spring-mybatis.xml中配置数据库 -->
    <dependency>
      <groupId>commons-dbcp</groupId>
      <artifactId>commons-dbcp</artifactId>
      <version>1.4</version>
    </dependency>

2.在resources下创建文件夹config和数据库配置文件jdbc.properties(数据库自己建,配置根据实际情况修改)

#数据库连接配置
	jdbc.driver=com.mysql.jdbc.Driver
	jdbc.url=jdbc:mysql://localhost:3306/smoke_detector
	jdbc.username=root
	jdbc.password=root

	#connection pool settings
	#定义最小空闲
	jdbc.pool.minIdle=1
	#定义最大空闲
	jdbc.pool.maxIdle=20
	#定义最大连接数
	jdbc.pool.maxActive=20
	#定义最长等待时间
	jdbc.pool.maxWait=60000

3.在 applicationContext.xml中添加

<!-- jdbc.properties里面的值,会在mybatis的数据源中用到,多个文件放在list标签中 -->
<bean id="propertyConfigurer"
	  class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
	<!--
	<property name="location">
		<value>classpath:config/conf.properties</value>
	</property>
	-->
	<property name="locations">
		<list>
			<value>classpath:config/jdbc.properties</value>
		</list>
	</property>
</bean>

<!-- 使用注解式注入 -->
<context:annotation-config />
<!-- 导入数据库配置 -->
<import resource="spring-mybatis.xml" />

4.创建spring-mybatis.xml

	<?xml version="1.0" encoding="UTF-8"?>
	<beans xmlns="http://www.springframework.org/schema/beans"
		   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
		   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache.xsd">

		<!--数据源配置,${}里面的值在application-context中加载了-->
		<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
			<property name="driverClassName" value="${jdbc.driver}"/>
			<property name="url" value="${jdbc.url}"/>
			<property name="username" value="${jdbc.username}"/>
			<property name="password" value="${jdbc.password}"/>

			<property name="maxActive" value="${jdbc.pool.maxActive}"/>

			<property name="maxIdle" value="${jdbc.pool.maxIdle}"/>

			<property name="minIdle" value="${jdbc.pool.minIdle}"/>

			<property name="maxWait" value="${jdbc.pool.maxWait}"/>
		</bean>

		<!--mybatis与spring的整合,不需要mybatis自己的配置映射文件-->
		<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
			<!--配置连接数据库数据源-->
			<property name="dataSource" ref="dataSource"/>
			<!--配置Mapper文件所在位置-->
			<property name="mapperLocations" value="classpath*:mapper/*.xml"/>
		</bean>

		<!--MapperScannerConfigurer将会扫描basePackage并自动装配-->
		<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
			<!-- DAO接口所在包名,Spring会自动查找其下的类 -->
			<property name="basePackage" value="com.test.dao.mapper"/>
			<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
		</bean>

		<!-- 事务管理 -->
		<bean id="transactionManager"
			  class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
			<property name="dataSource" ref="dataSource" />
		</bean>

	</beans>
注:里面扫描的Mapper和Mapper的映射文件路径,要根据实际修改

5.创建实体对象Test

	package com.test.entity;

	public class Test {
		private int id;
		private String name;
		private int age;

		public int getId() {
			return id;
		}

		public void setId(int id) {
			this.id = id;
		}

		public String getName() {
			return name;
		}

		public void setName(String name) {
			this.name = name;
		}

		public int getAge() {
			return age;
		}

		public void setAge(int age) {
			this.age = age;
		}
	}

6.创建表的接口文件TestMapper

	package com.test.dao.mapper;

	import com.test.entity.Test;

	public interface TestMapper {

		//添加数据
		public Integer addTest(Test test);
	}

7.在resources目录下,创建目录mapper,和映射文件TestMapper.xml

	<?xml version="1.0" encoding="UTF-8" ?>
	<!DOCTYPE mapper
			PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
			"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
	<mapper namespace="com.test.dao.mapper.TestMapper">
		<resultMap type="com.test.entity.Test" id="testResult">
			<id property="id" column="id" />
			<result property="name" column="name" />
			<result property="age" column="age" />
		</resultMap>

		<insert id="addTest" parameterType="com.test.entity.Test">
				insert into t_test (name,age) values(#{name},#{age})
			</insert>

	</mapper>

注:映射文件里面的Mapper路径要根据实际修改

8.创建service接口ITestService和实现类TestServiceImpl

	package com.test.service;

	import com.test.entity.Test;

	public interface ITestService {

		//添加数据
		public Integer addTest(Test test);
	}
	package com.test.service.impl;

	import com.test.dao.mapper.TestMapper;
	import com.test.entity.Test;
	import com.test.service.ITestService;
	import org.springframework.stereotype.Service;

	import javax.annotation.Resource;

	@Service
	public class TestServiceImpl implements ITestService {

		@Resource
		private TestMapper testMapper;

		@Override
		public Integer addTest(Test test) {
			testMapper.addTest(test);
			return 0;
		}
	}

注意:创建完成后把接口所在的包,配置到spring扫描标签中

9.在包com.test.controller中新建TestController

	package com.test.controller;

	import com.test.entity.Test;
	import com.test.service.ITestService;
	import org.springframework.stereotype.Controller;
	import org.springframework.web.bind.annotation.RequestMapping;

	import javax.annotation.Resource;

	@Controller
	@RequestMapping("/")
	public class TestController {
		@Resource
		private ITestService testService;

		@RequestMapping("/add")
		public void add(){

			Test t = new Test();
			t.setName("test");
			t.setAge(22);
			testService.addTest(t);
		}
	}
10.测试,访问:http://localhost:8080/add,查看数据库的数据是不是增加了



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值