ssm整合之搭建环境
1.ssm整合说明如图所示:
声明一下:使用Spring来整合SpringMVC和Mybatis的。
2.环境搭建步骤如下:
1).创建数据库和表结构的代码如下:
CREATE DATABASE ssm; -- 创建ssm数据库
USE ssm; -- 使用ssm数据库
-- 创建account表
CREATE TABLE account(
id INT PRIMARY KEY AUTO_INCREMENT, -- id为int类型的主键和自动增长
NAME VARCHAR(20), -- 账户名
money DOUBLE -- 金额
);
-- 查询account表
SELECT * FROM account;
2).打开IDEA如图所示的界面,点击Create New Project。
2).选择Maven工程,JDK的版本以及骨架,并点击Next。如图所示:
3).填写项目名称和保存的地址,点击Next。如图所示:
4).解决maven项目创建过慢的问题如图所示,输入变量名:archetypeCatalog和变量值:internal,并点击ok和Finish。如图所示:
5).导入相应的jar包的代码如下:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.txw</groupId>
<artifactId>ssm</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<name>ssm Maven Webapp</name>
<!-- FIXME change it to the project's website -->
<url>http://www.example.com</url>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
<!--版本锁定-->
<!--spring的版本-->
<spring.version>5.0.2.RELEASE</spring.version>
<slf4j.version>1.6.6</slf4j.version>
<!--日志的版本-->
<log4j.version>1.2.12</log4j.version>
<!--MySQL的版本-->
<mysql.version>5.1.6</mysql.version>
<!--mybatis的版本-->
<mybatis.version>3.4.5</mybatis.version>
</properties>
<dependencies>
<!-- spring -->
<dependency>
<!--aop相关的技术-->
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.6.8</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<!--context容器-->
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<!--SpringMVC-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<!--事务-->
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<!--jdbc模板技术 -->
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>compile</scope>
</dependency>
<dependency>
<!--MySQL驱动jar包-->
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.version}</version>
</dependency>
<!--servlet的jap-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- log start -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${slf4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${slf4j.version}</version>
</dependency>
<!-- log end -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
<type>jar</type>
<scope>compile</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
</dependencies>
<build>
<finalName>ssm</finalName>
<pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
<plugins>
<plugin>
<artifactId>maven-clean-plugin</artifactId>
<version>3.1.0</version>
</plugin>
<!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.22.1</version>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.2</version>
</plugin>
<plugin>
<artifactId>maven-install-plugin</artifactId>
<version>2.5.2</version>
</plugin>
<plugin>
<artifactId>maven-deploy-plugin</artifactId>
<version>2.8.2</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>
6).如图所示:项目的目录结构没有下载好。
7).在main目录下新建Java和resouces.并设置如图所示:
项目创建如图所示:
8).编写账户的实体类代码如下:
package com.txw.domain;
import lombok.Data;
import lombok.ToString;
import java.io.Serializable;
/**
* 账户的实体类
* @author Adair
*/
@Data // 自动生成set和get方法
@ToString // 重写toString方法
@SuppressWarnings("all") // 注解警告信息
public class Account implements Serializable {
private Integer id; // 账户的id
private String name; // 账户名
private Double money; // 账户的金额
}
9).编写帐户dao接口的代码如下:
package com.txw.dao;
import com.txw.domain.Account;
import java.util.List;
/**
*帐户dao接口
* @author Adair
*/
@SuppressWarnings("all") // 注解警告信息
public interface AccountDao {
/**
*查询所有账户
* @return
*/
public List<Account> findAll();
/**
*保存帐户信息
* @param account
*/
public void saveAccount(Account account);
}
10).编写帐户service接口的代码如下:
package com.txw.service;
import com.txw.domain.Account;
import java.util.List;
/**
* 帐户service接口
* @author Adair
*/
@SuppressWarnings("all") // 注解警告信息
public interface AccountService {
/**
*查询所有账户
* @return
*/
public List<Account> findAll();
/**
*保存帐户信息
* @param account
*/
public void saveAccount(Account account);
}
11).编写账户业务实现类的代码如下:
package com.txw.service.impl;
import com.txw.domain.Account;
import com.txw.service.AccountService;
import java.util.List;
/**
* 账户业务的实现类
* @author Adair
*/
@SuppressWarnings("all") // 注解警告信息
public class AccountServiceImpl implements AccountService {
/**
* 查询所有账户
* @return
*/
@Override
public List<Account> findAll() {
System.out.println("业务层:查询所有账户...");
return null;
}
/**
* 保存帐户信息
* @param account
*/
@Override
public void saveAccount(Account account) {
System.out.println("业务层:保存帐户信息...");
}
}