SSM学习笔记（一）------整合springMvc+c3p0+myBatis+dataSources

最新推荐文章于 2021-03-18 22:52:55 发布

小生不财

最新推荐文章于 2021-03-18 22:52:55 发布

阅读量254

点赞数

分类专栏： javaWeb Java spring MySQL ORM 文章标签： spingmvc java MySql Mybatis dataSorces

本文链接：https://blog.csdn.net/qq_40551061/article/details/84990494

版权

Java 同时被 3 个专栏收录

12 篇文章 0 订阅

订阅专栏

ORM

10 篇文章 0 订阅

订阅专栏

spring

7 篇文章 0 订阅

订阅专栏

一、简介

此次整合主要是帮助自己理解和使用spring的相关框架，对以前所学的相关框架知识进行回顾（重点主要讲解文件配置），然后根据用户请求到响应这个过程中涉及的操作一步一步为大家配置spring环境。

1.1项目结构

1.2.文件解析

1.2.1结构展示（其余文件不做解释，属于基础配置）

二、具体步骤

2.1需求

实现员工查询列表，从数据里面读取员工信息

2.2jar包

包括：spring（包括springmvc）、mybatis、mybatis-spring整合包、数据库驱动、第三方连接池。

注（下载地址：https://pan.baidu.com/s/19A5IqID9-N5KIOhcYKQvfw）

2.3Dao

2.3.1jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/db_emp_system
jdbc.username=root
jdbc.password=
jdbc.maxWait=1000
jdbc.initialSize=20
jdbc.maxActive=1000
jdbc.maxIdle=10
jdbc.minIdle=5

2.3.2 log4j.properties

log4j.rootLogger=INFO, Console 
#Console  
log4j.appender.Console=org.apache.log4j.ConsoleAppender  
log4j.appender.Console.layout=org.apache.log4j.PatternLayout  
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n 
log4j.logger.java.sql.ResultSet=INFO  
log4j.logger.org.apache=INFO  
log4j.logger.java.sql.Connection=DEBUG  
log4j.logger.java.sql.Statement=DEBUG  
log4j.logger.java.sql.PreparedStatement=DEBUG

2.3.3mybaits-config.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>
<mappers>
	<mapper resource="com\emp\dao\EmpMapper.xml"/>
</mappers>
</configuration>

2.3.4spring-mybatis.xml

配置数据源、事务管理，配置SqlSessionFactory、mapper扫描器

<?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:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd">
    <!-- 开启注解 扫描com.iflytek下的所有的对象 -->
    <context:component-scan base-package="com.emp">
       <context:exclude-filter type="annotation"
           expression="org.springframework.stereotype.Controller" />
    </context:component-scan>
    <!-- 引入jdbc配置文件 -->
    <context:property-placeholder location="jdbc.properties" />
    <!--创建jdbc数据源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
       destroy-method="close">
       <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="initialSize" value="${jdbc.initialSize}" />
       <property name="maxActive" value="${jdbc.maxActive}" />
       <property name="maxIdle" value="${jdbc.maxIdle}" />
       <property name="minIdle" value="${jdbc.minIdle}" />
    </bean>
    <!-- 创建SqlSessionFactory，同时指定数据源 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
       <property name="dataSource" ref="dataSource" />
       <property name="configLocation" value="classpath:mybaits-config.xml"></property>
       <property name="mapperLocations" value="classpath:mappers/*.xml" />
       <property name="typeAliasesPackage" value="com.iflytek.domain" />
    </bean>
    <!-- 配置SqlSessionTemplate -->
    <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
       <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />
    </bean>
    <!-- 配置mybatis mapper接口 -->
    <!-- 可以给你的mapper接口生成 代理对象 并且把该代理对象放到IOC容器中  -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
       <property name="basePackage" value="com.iflytek.dao" />
       <property name="sqlSessionTemplateBeanName" value="sqlSessionTemplate" />
    </bean>
    <!-- 事务配置 -->
    <bean id="transactionManager"
       class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
       <property name="dataSource" ref="dataSource" />
    </bean>
    <!-- 使用annotation注解方式配置事务 -->
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
</beans>

2.3.5EmpMapper.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.emp.mapper">
   
   <select id="getEmp" resultMap="Emp">
   		select empId,name from db_emp 
   </select>
   <resultMap type="com.emp.entity.Emp" id="Emp">
   		<result property="empId" column="empId"/>
   		<result property="name" column="name"/>
   </resultMap>
</mapper>

2.3.6EmpMapper.java

package com.emp.dao;

import java.util.List;

import com.emp.entity.Emp;

public interface EmpMapper {
	public List<Emp> getEmp();
}

2.3.7EmpMapperImpl.java

package com.emp.dao;

import java.util.List;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import com.emp.entity.Emp;
@Repository
public class EmpMapperImpl extends SqlSessionDaoSupport implements EmpMapper {

	@Autowired
	@Override
	public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {
		// TODO Auto-generated method stub
		super.setSqlSessionFactory(sqlSessionFactory);
	}
	@Override
	public List<Emp> getEmp() {
		// TODO Auto-generated method stub
		List<Emp> empList = this.getSqlSession().selectList("com.emp.mapper.getEmp");
		return empList;
	}
}

2.4Service

2.4.1EmpService

package com.emp.service;

import java.util.List;

import com.emp.entity.Emp;

public interface EmpService {
	public List<Emp> ShowEmp();
}

2.4.2EmpServiceImpl

package com.emp.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.emp.dao.EmpMapper;
import com.emp.entity.Emp;
@Service
public class EmpServiceImpl implements EmpService {
	@Autowired(required=true)
	private EmpMapper mapper;
	@Override
	public List<Emp> ShowEmp() {
		// TODO Auto-generated method stub
		List<Emp> empList= mapper.getEmp();
		for (Emp emp : empList) {
			System.out.println(emp.getEmpId()+":"+emp.getName());
		}
		return empList;
	}
	
}

2.5Action

2.5.1spingmvc-servlet.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:mvc="http://www.springframework.org/schema/mvc"
    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/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">
	<!-- 开启注解 扫描com.iflytek下的所有的对象 -->
	<context:component-scan base-package="classpath:com.emp" />
	<!-- 默认的注解映射的支持 -->
	<mvc:annotation-driven>
		<mvc:message-converters>
			<ref bean="stringHttpMessageConverter" />
			<ref bean="fastJsonHttpMessageConverter" />
		</mvc:message-converters>
	</mvc:annotation-driven>
	<!-- 视图解释类 -->
	<bean
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/jsp/" />
		<property name="suffix" value=".jsp" /><!--可为空,方便实现自已的依据扩展名来选择视图解释类的逻辑 -->
		<property name="viewClass"
			value="org.springframework.web.servlet.view.JstlView" />
	</bean>
	<!-- 不拦截静态资源 -->
	<mvc:resources location="/assets/" mapping="/assets/**" />
	<mvc:resources location="/ueditor/" mapping="/ueditor/**" />
	<bean id="stringHttpMessageConverter"
		class="org.springframework.http.converter.StringHttpMessageConverter">
		<constructor-arg value="UTF-8" index="0"></constructor-arg>
		<!--避免出现乱码 -->
		<property name="supportedMediaTypes">
			<list>
				<value>text/plain;charset=UTF-8</value>
			</list>
		</property>
	</bean>
	<!--避免IE执行AJAX时，返回JSON出现下载文件 -->
	<bean id="fastJsonHttpMessageConverter"
		class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">
		<property name="supportedMediaTypes">
			<list>
				<value>application/json;charset=UTF-8</value>
				<value>text/html;charset=UTF-8</value><!-- 避免IE出现下载JSON文件的情况 -->
			</list>
		</property>
		<property name="features">
			<list>
				<!-- <value>WriteMapNullValue</value> -->
				<value>QuoteFieldNames</value>
				<value>WriteDateUseDateFormat</value>
			</list>
		</property>
	</bean>
	<bean id="multipartResolver"
		class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
		<property name="defaultEncoding" value="utf-8"></property>
		<property name="maxUploadSize" value="10485760000"></property>
		<property name="maxInMemorySize" value="40960"></property>
	</bean>
</beans>

2.5.2web.xml

<?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"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
    id="WebApp_ID" version="3.0">
    <display-name>test</display-name>
    <welcome-file-list>
       <welcome-file>index.html</welcome-file>
       <welcome-file>index.htm</welcome-file>
       <welcome-file>index.jsp</welcome-file>
       <welcome-file>default.html</welcome-file>
       <welcome-file>default.htm</welcome-file>
       <welcome-file>default.jsp</welcome-file>
    </welcome-file-list>
    <!-- Spring配置文件 -->
    <context-param>
       <param-name>contextConfigLocation</param-name>
       <param-value>classpath*:spring-mybaits.xml</param-value>
    </context-param>
    <!-- 编码过滤器 -->
    <filter>
       <filter-name>encodingFilter</filter-name>
       <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
       <async-supported>true</async-supported>
       <init-param>
           <param-name>encoding</param-name>
           <param-value>UTF-8</param-value>
       </init-param>
    </filter>
    <filter-mapping>
       <filter-name>encodingFilter</filter-name>
       <url-pattern>/*</url-pattern>
    </filter-mapping>
    <!-- Spring监听器 -->
    <listener>
       <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <!-- 添加对springmvc的支持 -->
    <servlet>
       <servlet-name>springmvc</servlet-name>
       <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
       <load-on-startup>1</load-on-startup>
       <async-supported>true</async-supported>
    </servlet>
    <servlet-mapping>
       <servlet-name>springmvc</servlet-name>
       <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>

2.5.3EmpController.java

package com.emp.controller;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.emp.entity.Emp;
import com.emp.service.EmpServiceImpl;


@Controller
public class EmpController {
	@Autowired(required=true)
	private EmpServiceImpl es;
	@RequestMapping("/show.do")
	public String showEmp(HttpServletRequest req) {
		List<Emp> empList = es.ShowEmp();
		req.setAttribute("EMP", empList);
		return "show";
	}
}

2.6请求测试（只是简单写了一个请求，看到帖子的朋友，可以根据自己的业务自己尝试）

2.6.1index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<a href="show.do">展示结果</a>
</body>
</html>

2.7结果展示

小生不财

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
SSM学习笔记（一）------整合springMvc+c3p0+myBatis+dataSources

一、简介此次整合主要是帮助自己理解和使用spring的相关框架，对以前所学的相关框架知识进行回顾（重点主要讲解文件配置），然后根据用户请求到响应这个过程中涉及的操作一步一步为大家配置spring环境。1.1项目结构1.2.文件解析1.2.1结构展示（其余文件不做解释，属于基础配置）二、具体步骤2.1需求实现员工查询列表，从数据里面读取员工信息2.2jar包...
复制链接

扫一扫