狂神說SpringMVC05：整合SSM框架

https://mp.weixin.qq.com/s?__biz=Mzg2NTAzMTExNg==&mid=2247484004&idx=1&sn=cef9d881d0a8d7db7e8ddc6a380a9a76&scene=19#wechat_redirect

根據自己的環境參考狂神的視頻進行了SSM框架整合,用于備忘

1. 創建數據庫

2. IDEA創建maven項目.在pom.xml中設設置java conpiler版本(jdk13)

3. 導入依賴 jnuit 數據庫驅動 數據庫連接 Severlet JSp

4. maven 資源過濾

<?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> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> </resources> </build> <groupId>org.example</groupId> <artifactId>ssm</artifactId> <version>1.0-SNAPSHOT</version> <properties> <maven.compiler.source>13</maven.compiler.source> <maven.compiler.target>13</maven.compiler.target> </properties> <dependencies> <!--Junit--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <!--數據庫驅動--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.47</version> </dependency> <!-- 數據庫連接池 --> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version> </dependency> <!--Servlet - JSP --> <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> <!--Mybatis--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.2</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.6</version> </dependency> <!--Spring--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.3.4</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.3.4</version> </dependency> </dependencies></project>

5. 創建兩個項目的目錄結構以及Spring 和 Mybatis的配置文件

<?xml version='1.0' encoding='UTF-8'?><beans xmlns='http://www.springframework.org/schema/beans' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd'></beans>

<?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></configuration>Mybatis

6. 配置數據庫屬性

jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTCjdbc.username=rootjdbc.password=root

7. 創建Book實體類(使用lombok插件),編寫Dao層mapper接口,在mybatis配置中注冊mapper

package com.projectname.pojo;import lombok.AllArgsConstructor;import lombok.Data;import lombok.NoArgsConstructor;@Data@AllArgsConstructor@NoArgsConstructorpublic class Book { private int bookID; private String bookName; private int bookCounts; private String detail;}

package com.projectname.dao;import com.projectname.pojo.Book;import java.util.List;public interface DaoBook { //增加一個Book int addBook(Book book); //根據id刪除一個Book int deleteBookById(int id); //更新Book int updateBook(Book books); //根據id查詢,返回一個Book Book queryBookById(int id); //查詢全部Book,返回list集合 List<Book> queryAllBook();}

<?xml version='1.0' encoding='UTF-8' ?><!DOCTYPE mapper PUBLIC '-//mybatis.org//DTD Mapper 3.0//EN' 'http://mybatis.org/dtd/mybatis-3-mapper.dtd'><mapper namespace='com.kuang.dao.BookMapper'> <!--增加一個Book--> <insert parameterType='Books'> insert into ssmbuild.books(bookName,bookCounts,detail) values (#{bookName}, #{bookCounts}, #{detail}) </insert> <!--根據id刪除一個Book--> <delete parameterType='int'> delete from ssmbuild.books where bookID=#{bookID} </delete> <!--更新Book--> <update parameterType='Books'> update ssmbuild.books set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail} where bookID = #{bookID} </update> <!--根據id查詢,返回一個Book--> <select resultType='Books'> select * from ssmbuild.books where bookID = #{bookID} </select> <!--查詢全部Book--> <select resultType='Books'> SELECT * from ssmbuild.books </select></mapper>

<?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><mappers><mapper resource='com/projectname/dao/BookMapper.xml'/></mappers></configuration>

8. 編寫service層的接口和實現類代碼

package com.projectname.service;import com.projectname.pojo.Book;import java.util.List;public interface BookService { //增加一個Book int addBook(Book book); //根據id刪除一個Book int deleteBookById(int id); //更新Book int updateBook(Book books); //根據id查詢,返回一個Book Book queryBookById(int id); //查詢全部Book,返回list集合 List<Book> queryAllBook();}

package com.projectname.service;import com.projectname.dao.BookMapper;import com.projectname.pojo.Book;import java.util.List;public class BookServiceImpl implements BookService { //調用dao層的操作，設置一個set接口，方便Spring管理 private BookMapper bookMapper; public void setBookMapper(BookMapper bookMapper) { this.bookMapper = bookMapper; } public int addBook(Book book) { return bookMapper.addBook(book); } public int deleteBookById(int id) { return bookMapper.deleteBookById(id); } public int updateBook(Book books) { return bookMapper.updateBook(books); } public Book queryBookById(int id) { return bookMapper.queryBookById(id); } public List<Book> queryAllBook() { return bookMapper.queryAllBook(); }}Spring

9. 使用Spring編寫Mybatis配置文件: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 http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd'> <context:property-placeholder location='classpath:database.properties'/> <!-- 2.數據庫連接池 --> <!--數據庫連接池 dbcp 半自動化操作 不能自動連接 c3p0 自動化操作（自動的加載配置文件 并且設置到對象里面） --> <bean 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}'/> <!-- c3p0連接池的私有屬性 --> <property name='maxPoolSize' value='30'/> <property name='minPoolSize' value='10'/> <!-- 關閉連接后不自動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'> <!-- 注入數據庫連接池 --> <property name='dataSource' ref='dataSource'/> <!-- 配置MyBaties全局配置文件:mybatis-config.xml --> <property name='configLocation' value='classpath:mybatis-configuration.xml'/> </bean> <!-- 4.配置掃描Dao接口包，動態實現Dao接口注入到spring容器中 --> <!--解釋 ：https://www.cnblogs.com/jpfss/p/7799806.html--> <bean class='org.mybatis.spring.mapper.MapperScannerConfigurer'> <!-- 注入sqlSessionFactory --> <property name='sqlSessionFactoryBeanName' value='sqlSessionFactory'/> <!-- 給出需要掃描Dao接口包 --> <property name='basePackage' value='com.projectname.dao'/> </bean></beans>

10. Spring 整合service層

spring-service

<?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 http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd'> <!-- 掃描service相關的bean --> <context:component-scan base-package='com.projectname.service' /> <!--BookServiceImpl注入到IOC容器中--> <bean class='com.projectname.service.BookServiceImpl'> <property name='bookMapper' ref='bookMapper'/> </bean> <!-- 配置事務管理器 --> <bean class='org.springframework.jdbc.datasource.DataSourceTransactionManager'> <!-- 注入數據庫連接池 --> <property name='dataSource' ref='dataSource' /> </bean></beans>Spring MVC層

11. configuate the web.xml

<?xml version='1.0' encoding='UTF-8'?><web-app xmlns='http://xmlns.jcp.org/xml/ns/javaee' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd' version='4.0'> <!-- 配置SpringMVC --> <!-- 1.開啟SpringMVC注解驅動 --> <servlet> <servlet-name>DispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <!--一定要注意:我們這里加載的是總的配置文件，之前被這里坑了！--> <param-value>classpath:applicationContext.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>DispatcherServlet</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <!--encodingFilter--> <filter> <filter-name>encodingFilter</filter-name> <filter-class> org.springframework.web.filter.CharacterEncodingFilter </filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!--Session過期時間--> <session-config> <session-timeout>15</session-timeout> </session-config></web-app>

12. 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:mvc='http://www.springframework.org/schema/mvc' xmlns:context='http://www.springframework.org/schema/context' xsi:schemaLocation='http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd'> <!-- 配置SpringMVC --> <!-- 1.開啟SpringMVC注解驅動 --> <mvc:annotation-driven /> <!-- 2.靜態資源默認servlet配置--> <mvc:default-servlet-handler/> <!-- 3.配置jsp 顯示ViewResolver視圖解析器 --> <bean class='org.springframework.web.servlet.view.InternalResourceViewResolver'> <property name='viewClass' value='org.springframework.web.servlet.view.JstlView' /> <property name='prefix' value='/WEB-INF/jsp/' /> <property name='suffix' value='.jsp' /> </bean> <!-- 4.掃描web相關的bean --> <context:component-scan base-package='com.projectname.controller' /></beans>

13. configuate 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:mvc='http://www.springframework.org/schema/mvc' xmlns:context='http://www.springframework.org/schema/context' xsi:schemaLocation='http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd'> <import resource='spring-dao.xml'/> <import resource='spring-service.xml'/> <import resource='spring-mvc.xml'/></beans>一些雜七雜八的配置

14. 添加日志功能

<settings> <setting name='logImpl' value='STDOUT_LOGGING'/></settings>

15. add lib

File -> Project Structure->ArtifactsType -> Bundle

new directory lib

到此這篇關于IDEA SSM框架整合配置及步驟詳解的文章就介紹到這了,更多相關IDEA SSM框架整合配置內容請搜索好吧啦網以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持好吧啦網！