SSM框架详细整合教程（Spring+SpringMVC+MyBatis）(1)

最新推荐文章于 2024-07-16 08:36:30 发布

2301_79655438

最新推荐文章于 2024-07-16 08:36:30 发布

阅读量454

点赞数 12

分类专栏：程序员文章标签： spring mybatis 单元测试

本文链接：https://blog.csdn.net/2301_79655438/article/details/138354984

版权

程序员专栏收录该内容

228 篇文章 0 订阅

订阅专栏

org.springframework

spring-test

${spring.version}

org.springframework

spring-core

${spring.version}

org.springframework

spring-oxm

${spring.version}

org.springframework

spring-tx

${spring.version}

org.springframework

spring-jdbc

${spring.version}

org.springframework

spring-aop

${spring.version}

org.springframework

spring-context

${spring.version}

org.springframework

spring-context-support

${spring.version}

org.springframework

spring-expression

${spring.version}

org.springframework

spring-orm

${spring.version}

org.springframework

spring-web

${spring.version}

org.springframework

spring-webmvc

${spring.version}

org.springframework

spring-aspects

${spring.version}

org.mybatis

mybatis

${mybatis.version}

org.mybatis

mybatis-spring

1.2.2

mysql

mysql-connector-java

5.1.35

commons-dbcp

1.4

jstl

1.2

taglibs

standard

1.1.2

log4j

${log4j.version}

org.slf4j

slf4j-api

${slf4j.version}

org.slf4j

slf4j-log4j12

${slf4j.version}

com.alibaba

fastjson

1.2.6

org.codehaus.jackson

jackson-mapper-asl

1.9.13

commons-fileupload

1.3.1

commons-io

2.4

commons-codec

1.10

net.sourceforge.jexcelapi

jxl

2.6

org.apache.poi

poi

3.8

org.apache.poi

poi-ooxml

3.9

Maven_Project

org.apache.maven.plugins

maven-compiler-plugin

2.3.2

1.7

2、在src/main/resources下添加如下配置文件

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:p=“http://www.springframework.org/schema/p”

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-3.1.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.1.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

<context:annotation-config />

<context:component-scan base-package=“com.chillax” />

**jdbc.properties，**有多人反映直接复制时，第一行的driver最后面多了个空格，请注意

driver=com.mysql.jdbc.Driver

url=jdbc:mysql://127.0.0.1:3306/maventest

username=root

password=root

#定义初始连接数

initialSize=0

#定义最大连接数

maxActive=20

#定义最大空闲

maxIdle=20

#定义最小空闲

minIdle=1

#定义最长等待时间

maxWait=60000

log4j.properties

#定义LOG输出级别

log4j.rootLogger=INFO,Console,File

#定义日志输出目的地为控制台

log4j.appender.Console=org.apache.log4j.ConsoleAppender

log4j.appender.Console.Target=System.out

#可以灵活地指定日志输出格式，下面一行是指定具体的格式

log4j.appender.Console.layout = org.apache.log4j.PatternLayout

log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n

#文件大小到达指定尺寸的时候产生一个新的文件

log4j.appender.File = org.apache.log4j.RollingFileAppender

#指定输出目录

log4j.appender.File.File = logs/ssm.log

#定义文件最大大小

log4j.appender.File.MaxFileSize = 10MB

输出所以日志，如果换成DEBUG表示输出DEBUG以上级别日志

log4j.appender.File.Threshold = ALL

log4j.appender.File.layout = org.apache.log4j.PatternLayout

log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH:mm:ss}][%c]%m%n

spring-dao.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:p=“http://www.springframework.org/schema/p”

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-3.1.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.1.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

spring-db.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:p=“http://www.springframework.org/schema/p”

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-3.1.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.1.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

spring-tx.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: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”

xmlns:mvc=“http://www.springframework.org/schema/mvc”

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.1.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.1.xsd

http://www.springframework.org/schema/aop

http://www.springframework.org/schema/aop/spring-aop-3.1.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx-3.1.xsd">

<bean id=“transactionManager”

class=“org.springframework.jdbc.datasource.DataSourceTransactionManager”>

aop:config

<aop:pointcut id=“allServiceMethod” expression=“execution(* com.chillax.service..(…))”/>

<aop:advisor pointcut-ref=“allServiceMethod” advice-ref=“TxAdvice” />

</aop:config>

<tx:advice id=“TxAdvice” transaction-manager=“transactionManager”>

tx:attributes

<tx:method name=“*” propagation=“REQUIRED” rollback-for=“java.lang.Exception”/>

</tx:attributes>

</tx:advice>

3、在WEB-INF文件夹下添加/修改以下配置文件

spring-mvc.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:p=“http://www.springframework.org/schema/p”

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-3.1.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.1.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

<mvc:annotation-driven />

mvc:default-servlet-handler/

<context:component-scan base-package=“com.chillax.controller” />

web.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”

version=“3.0”>

Archetype Created Web Application

/index.jsp

contextConfigLocation

classpath:applicationContext.xml

org.springframework.web.context.ContextLoaderListener

encodingFilter

org.springframework.web.filter.CharacterEncodingFilter

true

encoding

UTF-8

encodingFilter

SpringMVC

org.springframework.web.servlet.DispatcherServlet

contextConfigLocation

/WEB-INF/spring-mvc.xml

true

SpringMVC

4、在src/main/java下添加如下包和类

UserController.java

package com.chillax.controller;

import java.util.List;

import javax.annotation.Resource;

import javax.servlet.http.HttpServletRequest;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

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

import com.chillax.dto.User;

import com.chillax.service.IUserService;

@Controller

@RequestMapping(“/user”)

public class UserController {

@Resource

private IUserService userService;

@RequestMapping(“/userList”)

public String userList(HttpServletRequest request,Model model){

List uList = userService.getAllUser();

model.addAttribute(“uList”, uList);

return “userList”;

}

@RequestMapping(“/showUser”)

public String showUser(HttpServletRequest request,Model model){

int userId = Integer.parseInt(request.getParameter(“id”));

User user = userService.getUserById(userId);

model.addAttribute(“user”, user);

return “showUser”;

}

@RequestMapping(“/addUserUI”)

public String addUserUI(){

return “addUser”;

}

@RequestMapping(“/addUser”)

public String addUser(HttpServletRequest request,Model model){

User user = new User();

user.setName(String.valueOf(request.getParameter(“name”)));

user.setPassword(String.valueOf(request.getParameter(“password”)));

user.setAge(Integer.parseInt(String.valueOf(request.getParameter(“age”))));

userService.addUser(user);

return “redirect:/user/userList”;

}

IUserDao.java

package com.chillax.dao;

import java.util.List;

import java.util.Map;

import com.chillax.dto.User;

public interface IUserDao {

public User queryByPrimaryKey(Integer id);

public List getAllUser();

public void insertUser(User user);

public void insertUserByBatch(List list);

public void deleteByPrimaryKey(Integer id);

public void delteUserByBatch(Map<String,Object> params);

public void updateByPrimaryKey(User user);

}

User.java

package com.chillax.dto;

public class User {

private Integer id;

private String name;

private String password;

private Integer age;

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password == null ? null : password.trim();

}

public Integer getAge() {

return age;

}

public void setAge(Integer age) {

this.age = age;

}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

id, name, password, age

<select id=“queryByPrimaryKey” resultMap=“BaseResultMap”

parameterType=“java.lang.Integer”>

select

from user

where id = #{id,jdbcType=INTEGER}

select

from user

insert into user

id,

name,

password,

age,

#{id,jdbcType=INTEGER},

#{name,jdbcType=VARCHAR},

#{password,jdbcType=VARCHAR},

#{age,jdbcType=INTEGER},

insert into USER

(ID,

NAME,

PASSWORD,

AGE)

select A.* from

(

select

#{user.id,jdbcType=INTEGER},

#{user.name,jdbcType=VARCHAR},

#{user.password,jdbcType=VARCHAR},

总目录展示

该笔记共八个节点（由浅入深），分为三大模块。

高性能。秒杀涉及大量的并发读和并发写，因此支持高并发访问这点非常关键。该笔记将从设计数据的动静分离方案、热点的发现与隔离、请求的削峰与分层过滤、服务端的极致优化这4个方面重点介绍。

一致性。秒杀中商品减库存的实现方式同样关键。可想而知，有限数量的商品在同一时刻被很多倍的请求同时来减库存，减库存又分为“拍下减库存”“付款减库存”以及预扣等几种，在大并发更新的过程中都要保证数据的准确性，其难度可想而知。因此，将用一个节点来专门讲解如何设计秒杀减库存方案。

高可用。虽然介绍了很多极致的优化思路，但现实中总难免出现一些我们考虑不到的情况，所以要保证系统的高可用和正确性，还要设计一个PlanB来兜底，以便在最坏情况发生时仍然能够从容应对。笔记的最后，将带你思考可以从哪些环节来设计兜底方案。

篇幅有限，无法一个模块一个模块详细的展示（这些要点都收集在了这份《高并发秒杀顶级教程》里），麻烦各位转发一下（可以帮助更多的人看到哟！）

由于内容太多，这里只截取部分的内容。

age,

#{id,jdbcType=INTEGER},

#{name,jdbcType=VARCHAR},

#{password,jdbcType=VARCHAR},

#{age,jdbcType=INTEGER},

insert into USER

(ID,

NAME,

PASSWORD,

AGE)

select A.* from

(

select

#{user.id,jdbcType=INTEGER},

#{user.name,jdbcType=VARCHAR},

#{user.password,jdbcType=VARCHAR},

总目录展示

该笔记共八个节点（由浅入深），分为三大模块。

[外链图片转存中…(img-PKSMHYAI-1714476628772)]

[外链图片转存中…(img-sCGuhpEi-1714476628773)]

由于内容太多，这里只截取部分的内容。

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

2301_79655438

关注

12
点赞
踩
13

收藏

觉得还不错? 一键收藏
0
评论
SSM框架详细整合教程（Spring+SpringMVC+MyBatis）(1)

spring框架包 startspring-oxmspring-txspring-aopspring-ormspring-webspring框架包 endmybatis框架包 startmybatis1.2.2mybatis框架包 end数据库驱动mysql5.1.35导入dbcp的jar包，用来在applicationContext.xml中配置数据库1.4jstl标签类jstljstl1.2taglibsstandard1.1.2log start。
复制链接

扫一扫