大家看我的博客也有一段时间了,前面出了Spring和SringMVC的教程,现在就出一个综合性的教程把前面学的串联起来。
开发环境:1.开发工具:Idea
2.Jdk版本:8
3.数据库连接架包:8以上即可
我们来回顾一下需要那些架包
废话不多说,开始上手代码 1.创建一个maven项目,并引用以下架包1.第一SSM框架的基础Jar包springwebmvc
2.Mybaits和Juint,Servlet
3.进行事物管理的Jdbc,以及连接池的Druid
4.简化实体类开发的lombok和转换Json格式的FastJson
2.见一个Config包,用来写配置类org.springframework spring-webmvc5.3.19 org.springframework spring-jdbc5.3.19 mysql mysql-connector-java8.0.28 org.mybatis mybatis3.5.6 org.mybatis mybatis-spring2.0.7 org.springframework spring-test5.3.19 javax.servlet servlet-api2.5 javax.servlet.jsp jsp-api2.2 javax.servlet jstl1.2 com.alibaba druid1.2.8 com.alibaba fastjson1.2.78 org.projectlombok lombok1.18.22 junit junit4.13.2 org.slf4j slf4j-api1.7.20 ch.qos.logback logback-classic1.2.3 ch.qos.logback logback-core1.2.3
1.建一个applicationContextConfig.java
@Configuration
@ComponentScan(value = "com.yunhuisu",excludeFilters = {@ComponentScan.Filter(type = FilterType.ANNOTATION,classes = Controller.class)})
@Import({DataSourceConfig.class,MybatisConfig.class})
public class ApplicationContextConfig {
}
2.建一个DataSourceConfig.java用来写数据源和开启事务,这里还有一个数据库连接配置文件db.properties
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.PropertySource;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import javax.sql.DataSource;
@PropertySource("classpath:db.properties")
@EnableTransactionManagement
public class DataSourceConfig {
@Value("${db.driver}")
private String driver;
@Value("${db.url}")
private String url;
@Value("${db.username}")
private String username;
@Value("${db.password}")
private String password;
@Bean
public DataSource setDataSource() {
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setDriverClassName(driver);
druidDataSource.setUrl(url);
druidDataSource.setUsername(username);
druidDataSource.setPassword(password);
return druidDataSource;
}
@Bean
public PlatformTransactionManager setTransactionManager(@Autowired DataSource dataSource) {
DataSourceTransactionManager dataSourceTransactionManager = new DataSourceTransactionManager();
dataSourceTransactionManager.setDataSource(dataSource);
return dataSourceTransactionManager;
}
}
db.properties
db.driver=com.mysql.cj.jdbc.Driver db.url=jdbc:mysql:///ssmbuild db.username=root db.password=123456
3.建mybatis的配置类
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.Bean;
import javax.sql.DataSource;
public class MybatisConfig {
@Bean
public SqlSessionFactoryBean setSqlSessionFactoryBean(@Autowired DataSource dataSource,@Autowired ApplicationContext applicationContext) {
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
sqlSessionFactoryBean.setDataSource(dataSource);
sqlSessionFactoryBean.setTypeAliasesPackage("com.yunhuisu.pojo");
sqlSessionFactoryBean.setConfigLocation(applicationContext.getResource("classpath:mybatis-config.xml"));
return sqlSessionFactoryBean;
}
@Bean
public MapperScannerConfigurer setMapperScannerConfigurer() {
MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
mapperScannerConfigurer.setBasePackage("com.yunhuisu.mapper");
return mapperScannerConfigurer;
}
}
以及可建可不建的mybatis-config.xml,我这里建了是为了开启SLF4J日志
顺带把SLF4J日志的配置文件也一起建立了logback.xml
[%level] %blue(%d{HH:mm:ss.SSS}) %cyan([%thread]) %boldGreen(%logger{15}) - %msg %n
4.最后来建SpringMVC的配置类
sprinmvcServlet.java这个类就类似于你们在web.xml里面配置的一些东西
import org.springframework.web.filter.CharacterEncodingFilter;
import org.springframework.web.servlet.support.AbstractAnnotationConfigDispatcherServletInitializer;
import javax.servlet.Filter;
public class SpringmvcServlet extends AbstractAnnotationConfigDispatcherServletInitializer {
protected Class>[] getRootConfigClasses() {
return new Class[]{ApplicationContextConfig.class};
}
protected Class>[] getServletConfigClasses() {
return new Class[]{SpringmvcConfig.class};
}
protected String[] getServletMappings() {
return new String[]{"/"};
}
@Override
protected Filter[] getServletFilters() {
CharacterEncodingFilter filter = new CharacterEncodingFilter();
filter.setEncoding("UTF-8");
return new Filter[]{filter};
}
}
还要建一个类springmvcConfig.java
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.view.InternalResourceViewResolver;
@Configuration
@ComponentScan(value = "com.yunhuisu.controller")
public class SpringmvcConfig {
@Bean
public InternalResourceViewResolver viewResolver() {
InternalResourceViewResolver viewResolver = new InternalResourceViewResolver();
viewResolver.setPrefix("/WEB-INF/");
viewResolver.setSuffix(".jsp");
return viewResolver;
}
}
3.设计数据库
CREATE DATABASE `ssm`; USE `ssm`; DROp TABLE IF EXISTS `books`; CREATE TABLE `books` ( `bookID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '书id', `bookName` VARCHAr(100) NOT NULL COMMENT '书名', `bookCounts` INT(11) NOT NULL COMMENT '数量', `detail` VARCHAr(200) NOT NULL COMMENT '描述', KEY `bookID` (`bookID`) ); INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`)VALUES (1,'Java',1,'从入门到放弃'), (2,'MySQL',10,'从删库到跑路'), (3,'Linux',5,'从进门到进牢');4.建与数据库相对于的实体类和Mapper映射
1.在pojo包下面建Books.java类
import lombok.Data;
@Data
public class Books {
private int bookID;
private String bookName;
private String bookCounts;
private String detail;
}
2.在mapper包下面建BookMapper.java
import com.yunhuisu.pojo.Books;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Component;
import java.util.List;
@Component
public interface BookMapper {
@Select("SELECT * FROM books")
List findAllBook();
@Select("SELECT * FROM books WHERe bookID = #{bookID}")
Books findByIdBook(@Param("bookID")int bookID);
@Insert("INSERT INTO books(bookName, bookCounts, detail) VALUES (#{bookName}, #{bookCounts}, #{detail})")
boolean addBook(Books books);
@Update("UPDATE books SET bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail} WHERe bookID = #{bookID}")
boolean updateBook(Books books);
@Delete("DELETE FROM books WHERe bookID = #{bookID}")
boolean byIdDeleteBook(@Param("bookID")int bookID);
}
5.在Service层对数据进行处理
1.建一个BookService.java
import com.yunhuisu.pojo.Books;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
@Transactional
@Service
public interface BookService {
List findAllBook();
Books findByIdBook(int bookID);
boolean addBook(Books books);
boolean updateBook(Books books);
boolean byIdDeleteBook(int bookID);
}
2.在Impl进行实现,建BookServiceImpl.java
import com.yunhuisu.mapper.BookMapper;
import com.yunhuisu.pojo.Books;
import com.yunhuisu.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class BookServiceImpl implements BookService {
@Autowired
BookMapper bookMapper;
public List findAllBook() {
return bookMapper.findAllBook();
}
@Override
public Books findByIdBook(int bookID) {
return bookMapper.findByIdBook(bookID);
}
@Override
public boolean addBook(Books books) {
return bookMapper.addBook(books);
}
@Override
public boolean updateBook(Books books) {
return bookMapper.updateBook(books);
}
@Override
public boolean byIdDeleteBook(int bookID) {
return bookMapper.byIdDeleteBook(bookID);
}
}
6.最后来建Controller层
import com.alibaba.fastjson.JSON;
import com.yunhuisu.pojo.Books;
import com.yunhuisu.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import java.util.List;
@Controller
public class BookController {
@Autowired
BookService bookService;
@RequestMapping(value = "/findBook", produces = "text/html;charset=utf-8")
@ResponseBody
public String findBook() {
List books = bookService.findAllBook();
String resultBooks = JSON.toJSONString(books);
return resultBooks;
}
@RequestMapping(value = "/findByIdBook/{id}" , produces = "text/html;charset=utf-8")
@ResponseBody
public String findByIdBook(@PathVariable("id") int id) {
Books byIdBook = bookService.findByIdBook(id);
String resultBook = JSON.toJSONString(byIdBook);
return resultBook;
}
@RequestMapping(value = "/addBook",produces = "text/html;charset=utf-8")
@ResponseBody
public String addBook(Books books) {
boolean insertResult = bookService.addBook(books);
return insertResult == true ? "插入成功" : "插入失败";
}
@RequestMapping(value = "/updateBook",produces = "text/html;charset=utf-8")
@ResponseBody
public String updateBook(Books books) {
boolean updateResult = bookService.addBook(books);
return updateResult == true ? "修改成功" : "修改失败";
}
@RequestMapping(value = "/deleteByIdBook/{id}",produces = "text/html;charset=utf-8")
@ResponseBody
public String deleteByIdBook(@PathVariable("id") int id) {
boolean deleteResult = bookService.byIdDeleteBook(id);
return deleteResult == true ? "删除成功" : "删除失败";
}
}
最后我们用Postman来测试我们写的接口
1.查询全部书接口
2.通过Id查询书接口
3.插入一本书接口
4.修改一本书接口
5.通过Id删除书接口



