1,创建maven项目:
然后,点击next
其次
2,在pom.xml导入相关依赖:(如果idea没有集成maven需要先集成maven)
org.springframework spring-beans 4.1.6.RELEASE org.springframework spring-aop 4.1.6.RELEASE org.springframework spring-context 4.1.6.RELEASE org.springframework spring-webmvc 4.1.6.RELEASE org.springframework spring-tx 4.1.6.RELEASE org.springframework spring-jdbc 4.1.6.RELEASE org.mybatis mybatis 3.2.8 org.mybatis mybatis-spring 1.2.1 c3p0 c3p0 0.9.1.1 commons-fileupload commons-fileupload 1.3.1 dom4j dom4j 1.6.1 mysql mysql-connector-java 5.0.8 com.alibaba fastjson 1.2.47 javax.servlet jstl 1.2 log4j log4j 1.2.17 javax.servlet javax.servlet-api 3.1.0 provided org.projectlombok lombok 1.18.6 junit junit 4.12 org.springframework.boot spring-boot-devtools runtime true src/main/java **/*.xml src/main/resources org.apache.maven.plugins maven-compiler-plugin 3.0 1.8 1.8 UTF-8 org.apache.maven.plugins maven-resources-plugin 2.6 UTF-8
3,将项目变成web项目
4,创建需要的包
5,创建查询书籍测试各个测试类
Books实体类:
package com.demo.bean;import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor;@Data @AllArgsConstructor @NoArgsConstructor public class Books {private int bookID;private String bookName;private int bookCounts;private String detail; }
Controller控制类:
package com.demo.controller;import com.demo.bean.Books; import com.demo.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping;import java.util.List;@Controller @RequestMapping("/book") public class BookController {@Autowiredprivate BookService bookService;@RequestMapping("/allBook")public String list(Model model) {Listlist = bookService.queryAllBook();model.addAttribute("list", list);return "allBook";} }
Service 接口类,实现类:
package com.demo.service; import com.demo.bean.Books;import java.util.List;//BookService:底下需要去实现,调用dao层 public interface BookService {//增加一个Bookint addBook(Books book);//根据id删除一个Bookint deleteBookById(int id);//更新Bookint updateBook(Books books);//根据id查询,返回一个BookBooks queryBookById(int id);//查询全部Book,返回list集合ListqueryAllBook(); }
package com.demo.service.impl;import com.demo.bean.Books; import com.demo.mapper.BookMapper; import com.demo.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;import java.util.List;@Service public class BookServiceImpl implements BookService {//调用mapper层的操作@Autowiredprivate BookMapper bookMapper;public int addBook(Books book) {return bookMapper.addBook(book);}public int deleteBookById(int id) {return bookMapper.deleteBookById(id);}public int updateBook(Books books) {return bookMapper.updateBook(books);}public Books queryBookById(int id) {return bookMapper.queryBookById(id);}public ListqueryAllBook() {return bookMapper.queryAllBook();} }
Mapper 接口类:
package com.demo.mapper;import com.demo.bean.Books;import java.util.List;public interface BookMapper {//增加一个Bookint addBook(Books book);//根据id删除一个Bookint deleteBookById(int id);//更新Bookint updateBook(Books books);//根据id查询,返回一个BookBooks queryBookById(int id);//查询全部Book,返回list集合ListqueryAllBook();}
以及Mapper.xml
insert into ssmbuild.books(bookName,bookCounts,detail)values (#{bookName}, #{bookCounts}, #{detail}) delete from ssmbuild.books where bookID=#{bookID} update ssmbuild.booksset bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail}where bookID = #{bookID}
6,创建配置文件
jdbc.properties文件:
jdbc_myql.user=root jdbc_myql.password=root jdbc_myql.driverClass=com.mysql.jdbc.Driver jdbc_myql.jdbcUrl=jdbc:mysql://localhost:3306/ssmbuild?useUnicode=true&characterEncoding=UTF-8 #注意:上面红色标记的是自己的数据库用户名,密码和库名。 #--连接池 #---连接池中保留的最大连接数 默认值: 15---- jdbc.maxPoolSize=30 #---连接池中保留的最小连接数,默认为:3--- jdbc.minPoolSize=4 #!-- 初始化连接池中的连接数,取值应在minPoolSize与maxPoolSize之间,默认为3-- jdbc.initialPoolSize=3 #--最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。默认值: 0 -- jdbc.maxIdleTime=60 #--后等待获取新连接的时间,超时后将抛出SQLException jdbc.checkoutTimeout=5000 #--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。默认值: 3 jdbc.acquireIncrement=5
springContext.xml文件:
${jdbc_myql.user} ${jdbc_myql.password} ${jdbc_myql.driverClass} ${jdbc_myql.jdbcUrl} ${jdbc.maxPoolSize} ${jdbc.minPoolSize} ${jdbc.initialPoolSize} ${jdbc.maxIdleTime} ${jdbc.checkoutTimeout} ${jdbc.acquireIncrement}
springMVC文件:
${jdbc_myql.user} ${jdbc_myql.password} ${jdbc_myql.driverClass} ${jdbc_myql.jdbcUrl} ${jdbc.maxPoolSize} ${jdbc.minPoolSize} ${jdbc.initialPoolSize} ${jdbc.maxIdleTime} ${jdbc.checkoutTimeout} ${jdbc.acquireIncrement}
7,在WEB-INF下添加jsp包:
8,配置web.xml文件:
DispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath*:config/springMVC.xml 1 DispatcherServlet / contextConfigLocation classpath*:config/springContext.xml org.springframework.web.context.ContextLoaderListener encodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding utf-8 encodingFilter /* 15
9.创建数据库ssmbuild
1,创建数据库语法:create database ssmbuild;
注意:修改数据库编码utf-8
2,创建,设计表( 注意:数据库和表的编码格式都是:utf-8)
3,插入数据
10,配置tomcat测试
启动没问题
浏览器访问:
点击进入页面,查询出数据
总结:
1.以上是我总结的ssm框架基础整合
2.如果有其他功能实现,再加配置和依赖
3.希望大家喜欢,有问题可以私信或者评论区问我!!!
上一篇:12_AJAX
下一篇:字符串压缩(三)之短字符串压缩