SSM - 书籍项目搭建流程
-
先创建数据库,创建表并插入数据。
-
创建 Maven 项目,添加 web 支持
-
添加 pom 依赖
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.16</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.1</version> </dependency> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.1.10.RELEASE</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.2</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.1.10.RELEASE</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.2</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.10</version> </dependency> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>2.9.8</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.60</version> </dependency>
-
静态资源(xml、properties)导出
<!--静态资源导出--> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> <include>**/*.properties</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.xml</include> <include>**/*.properties</include> </includes> <filtering>false</filtering> </resource> </resources> </build>
-
创建 pojo 包以及实体类
-
创建 dao 包、接口以及对应的 mapper.xml
-
创建 db.properties、mybatis-config.xml 以及 spring-dao.xml
-
db.properties
jdbc.driver=com.mysql.cj.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306 jdbc.username=root jdbc.password=root
-
mybatis-config.xml,其它配置交给 spring 管理
<?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> <!--配置别名--> <typeAliases> <package name="cn.coderzb.pojo"/> </typeAliases> <mappers> <mapper class="cn.coderzb.dao.BookMapper"/> </mappers> </configuration>
-
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:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd"> <!--1.读取数据库配置文件--> <context:property-placeholder location="classpath:db.properties"/> <!--2.数据源--> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${jdbc.driver}"/> <property name="jdbcUrl" value="${jdbc.url}"/> <property name="user" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <!--私有属性--> <property name="maxPoolSize" value="30"/> <property name="minPoolSize" value="5"/> <!--关闭连接后不自动commit--> <property name="autoCommitOnClose" value="false"/> <!--获取连接超时时间--> <property name="checkoutTimeout" value="10000"/> <!--获取连接失败后,重试次数--> <property name="acquireRetryAttempts" value="2"/> </bean> <!--3.配置SQLSessionFactory--> <bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactory"> <property name="dataSource" ref="dataSource"/> <!--绑定mybatis配置文件--> <property name="configLocation" value="classpath:mybatis-config.xml"/> </bean> <!--4.配置dao接口扫描,实现dao注入spring--> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <!--注入sqlSessionFactory--> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> <!--要扫描的dao--> <property name="basePackage" value="cn.coderzb.dao"/> </bean> </beans>
-
-
创建 service 包以及 service 接口及其实现类,@Service 注解
-
创建 spring-service.xml 管理 service 实现类,将 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" xsi:schemaLocation="http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd"> <!--扫描service--> <context:component-scan base-package="cn.coderzb.service"/> <!--将所有业务类注入到spring--> <bean id="BookServiceImpl" class="cn.coderzb.service.BookServiceImpl"> <property name="mapper" ref="bookMapper"/> </bean> <!--声明式事务--> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <!--注入数据源--> <property name="dataSource" ref="dataSource"/> </bean> </beans>
-
创建 controller 类、spring-mvc.xml
package cn.coderzb.controller; import cn.coderzb.pojo.Books; import cn.coderzb.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import java.util.List; @Controller @RequestMapping("/book") public class BookController { // 注入service @Autowired @Qualifier("BookServiceImpl") private BookService bookService; // 查询全部书籍,返回给前端 @RequestMapping("/all") public String list(Model model) { List<Books> books = bookService.queryAllBooks(); model.addAttribute("list", books); return "all-book"; } // 跳转到增加书籍页面 @RequestMapping("/add") public String toAddPage() { return "add-book"; } // 添加书籍的请求 @RequestMapping("/addBook") public String addBook(Books book) { bookService.addBook(book); return "redirect:/book/all"; } // 跳转到修改页面 @RequestMapping("/toUpdate/{bookID}") public String toUpdate(@PathVariable int bookID, Model model) { Books books = bookService.queryBookById(bookID); model.addAttribute("book", books); return "update-book"; } // 修改书籍的请求 @RequestMapping("/updateBook") public String updateBook(Books book) { bookService.updateBook(book); return "redirect:/book/all"; } // 删除书籍的请求 @RequestMapping("/deleteBook/{bookID}") public String deleteBook(@PathVariable int bookID) { bookService.deleteBookById(bookID); return "redirect:/book/all"; } }
<?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 https://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd"> <!--注解驱动--> <mvc:annotation-driven/> <!--静态资源过滤--> <mvc:default-servlet-handler/> <!--开启组件扫描--> <context:component-scan base-package="cn.coderzb.controller"/> <!--视图解析器--> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" id="internalResourceViewResolver"> <property name="prefix" value="/WEB-INF/jsp/"/> <property name="suffix" value=".jsp"/> </bean> </beans>