IDEA搭建SSM整合项目学习笔记

转x33g5p2x  于2021-10-10 转载在 其他  
字(15.0k)|赞(0)|评价(0)|浏览(545)

前言：笔记是参考B站up主遇见狂神说，图片、代码都是哦。因为最近特别喜欢他教的课程，所以就一边跟着学习，一边在blog写笔记~（图片、代码来源狂神说Java，侵权必删！）
狂神说Java学习路线B站网站：https://www.bilibili.com/read/cv5702420

SSM整合：Mybatis层（Model）

1.创建一张表

2.创建maven项目在pom.xml中导入依赖

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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">
  3.     <modelVersion>4.0.0</modelVersion>
  5.     <groupId>com.ckm</groupId>
  6.     <artifactId>ssmStudy</artifactId>
  7.     <version>1.0-SNAPSHOT</version>
  9.     <!-- 依赖：junit,数据库驱动，连接池，servlet,jsp,mybatis,mybatis-spring,spring -->
  10.     <dependencies>
  11.         <!--junit-->
  12.         <dependency>
  13.             <groupId>junit</groupId>
  14.             <artifactId>junit</artifactId>
  15.             <version>4.12</version>
  16.         </dependency>
  17.         <!--数据库驱动-->
  18.         <dependency>
  19.             <groupId>mysql</groupId>
  20.             <artifactId>mysql-connector-java</artifactId>
  21.             <version>5.1.47</version>
  22.         </dependency>
  24.         <!--数据库连接池-->
  25.         <dependency>
  26.             <groupId>com.mchange</groupId>
  27.             <artifactId>c3p0</artifactId>
  28.             <version>0.9.5.5</version>
  29.         </dependency>
  31.         <!--Servlet Jsp -->
  32.         <dependency>
  33.             <groupId>javax.servlet</groupId>
  34.             <artifactId>servlet-api</artifactId>
  35.             <version>2.5</version>
  36.         </dependency>
  37.         <dependency>
  38.             <groupId>javax.servlet.jsp</groupId>
  39.             <artifactId>jsp-api</artifactId>
  40.             <version>2.2</version>
  41.         </dependency>
  42.         <dependency>
  43.             <groupId>javax.servlet</groupId>
  44.             <artifactId>jstl</artifactId>
  45.             <version>1.2</version>
  46.         </dependency>
  48.         <!--Mybatis-->
  49.         <dependency>
  50.             <groupId>org.mybatis</groupId>
  51.             <artifactId>mybatis-spring</artifactId>
  52.             <version>2.0.3</version>
  53.         </dependency>
  54.         <dependency>
  55.             <groupId>org.mybatis</groupId>
  56.             <artifactId>mybatis</artifactId>
  57.             <version>3.5.3</version>
  58.         </dependency>
  60.         <!--Spring-->
  61.         <dependency>
  62.             <groupId>org.springframework</groupId>
  63.             <artifactId>spring-webmvc</artifactId>
  64.             <version>5.3.4</version>
  65.         </dependency>
  66.         <dependency>
  67.             <groupId>org.springframework</groupId>
  68.             <artifactId>spring-jdbc</artifactId>
  69.             <version>5.3.4</version>
  70.         </dependency>
  72.         <!--pojo lombok-->
  73.         <dependency>
  74.             <groupId>org.projectlombok</groupId>
  75.             <artifactId>lombok</artifactId>
  76.             <version>1.18.18</version>
  77.         </dependency>
  78.     </dependencies>
  80.     <!--静态资源导出问题-->
  81.     <build>
  82.         <resources>
  83.             <resource>
  84.                 <directory>src/main/resources</directory>
  85.                 <includes>
  86.                     <include>**/*.properties</include>
  87.                     <include>**/*.xml</include>
  88.                 </includes>
  89.                 <filtering>true</filtering>
  90.             </resource>
  91.             <resource>
  92.                 <directory>src/main/java</directory>
  93.                 <includes>
  94.                     <include>**/*.properties</include>
  95.                     <include>**/*.xml</include>
  96.                 </includes>
  97.                 <filtering>true</filtering>
  98.             </resource>
  99.         </resources>
  100.     </build>
  101. </project>

3.编写mybatis-config.xml

  1. <?xml version="1.0" encoding="UTF8" ?>
  2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
  3. <configuration>
  5.     <!--配置数据源，交给Spring去做-->
  7.     <typeAliases>
  8.         <package name="com.ckm.pojo"/>
  9.     </typeAliases>
  11.     <mappers>
  12.         <mapper class="com.ckm.dao.BookMapper"/>
  13.     </mappers>
  15. </configuration>

4.编写applicationContext.xml

  1. <?xml version="1.0" encoding="UTF8" ?>
  2. <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">
  4.     <import resource="spring-dao.xml"/>
  5.     <import resource="spring-service.xml"/>
  6.     <import resource="spring-mvc.xml"/>
  8. </beans>

5.编写database.properties

  1. jdbc.driver=com.mysql.jdbc.Driver
  2. jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone-Asia/Shanghai
  3. jdbc.username=root
  4. jdbc.password=123456

6.编写pojo实体类Books

  1. package com.ckm.pojo;
  3. import lombok.AllArgsConstructor;
  4. import lombok.Data;
  5. import lombok.NoArgsConstructor;
  7. @Data
  8. @AllArgsConstructor
  9. @NoArgsConstructor
  10. public class Books {
  11.     private int bootID;
  12.     private String bookName;
  13.     private int bookCounts;
  14.     private String detail;
  15. }

7.编写dao层

BookMapper接口

  1. package com.ckm.dao;
  3. import com.ckm.pojo.Books;
  4. import org.apache.ibatis.annotations.Param;
  6. import java.util.List;
  8. public interface BookMapper {
  9.     //增加一本书
  10.     int addBook(Books books);
  12.     //删除一本书
  13.     int deleteBookById(@Param("bookId") int id);
  15.     //更新一本书
  16.     int updateBook(Books books);
  18.     //查询一本书
  19.     Books queryBookById(@Param("bookId")int id);
  21.     //查询全部书
  22.     List<Books> queryAllBook();
  23. }

BookMapper.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="com.ckm.dao.BookMapper">
  4.     <insert id="addBook" parameterType="Books">
  5.         insert into ssmbuild.books (bookName, bookCounts, detail) values (#{bookName},#{bookCounts},#{detail});
  6.     </insert>
  8.     <delete id="deleteBookById" parameterType="int">
  9.         delete from ssmbuild.books where bookID = #{bookId}
  10.     </delete>
  12.     <update id="updateBook" parameterType="Books">
  13.         update ssmbuild.books set bookName = #{bookName},bookCounts=#{bookCounts},detail=#{detail} where bookID=#{bookID};
  14.     </update>
  16.     <select id="queryBookById" resultType="Books">
  17.         select * from ssmbuild.books where bookID=#{bookId};
  18.     </select>
  20.     <select id="queryAllBook" resultType="Books">
  21.         select * from ssmbuild.books;
  22.     </select>
  24. </mapper>

8.编写Service层

BookService接口

  1. package com.ckm.service;
  2. import com.ckm.pojo.Books;
  3. import java.util.List;
  5. public interface BookService {
  6.     //增加一本书
  7.     int addBook(Books books);
  9.     //删除一本书
  10.     int deleteBookById(int id);
  12.     //更新一本书
  13.     int updateBook(Books books);
  15.     //查询一本书
  16.     Books queryBookById(int id);
  18.     //查询全部书
  19.     List<Books> queryAllBook();
  20. }

BookServiceImpl实现类

  1. package com.ckm.service;
  3. import com.ckm.dao.BookMapper;
  4. import com.ckm.pojo.Books;
  6. import java.util.List;
  8. public class BookServiceImpl implements BookService{
  10.     //service层调用dao层 ： 组合dao
  11.     private BookMapper bookMapper;
  13.     public void setBookMapper(BookMapper bookMapper) {
  14.         this.bookMapper = bookMapper;
  15.     }
  17.     public int addBook(Books books) {
  18.         return bookMapper.addBook(books);
  19.     }
  21.     public int deleteBookById(int id) {
  22.         return bookMapper.deleteBookById(id);
  23.     }
  25.     public int updateBook(Books books) {
  26.         return bookMapper.updateBook(books);
  27.     }
  29.     public Books queryBookById(int id) {
  30.         return bookMapper.queryBookById(id);
  31.     }
  33.     public List<Books> queryAllBook() {
  34.         return bookMapper.queryAllBook();
  35.     }
  36. }

SSM整合：Spring层

1.编写spring-dao.xml

  1. <?xml version="1.0" encoding="UTF8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" 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 http://www.springframework.org/schema/context/spring-context-4.2.xsd">
  4.     <!--1.关联数据库配置文件-->
  5.     <context:property-placeholder location="classpath:database.properties"/>
  7.     <!--2.连接池 dbcp:半自动化操作，不能自动连接 c3p0:自动化操作（自动化的加载配置文件，并且可以自动设置到对象中） druid:hikari -->
  8.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  9.         <property name="driverClass" value="${jdbc.driver}"/>
  10.         <property name="jdbcUrl" value="${jdbc.url}"/>
  11.         <property name="user" value="${jdbc.username}"/>
  12.         <property name="password" value="${jdbc.password}"/>
  14.         <!-- c3p0连接池的私有属性 -->
  15.         <property name="maxPoolSize" value="30"/>
  16.         <property name="minPoolSize" value="10"/>
  17.         <!-- 关闭连接后不自动commit -->
  18.         <property name="autoCommitOnClose" value="false"/>
  19.         <!-- 获取连接超时时间 -->
  20.         <property name="checkoutTimeout" value="10000"/>
  21.         <!-- 当获取连接失败重试次数 -->
  22.         <property name="acquireRetryAttempts" value="2"/>
  24.     </bean>
  26.     <!--3.sqlSessionFactory-->
  27.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  28.         <property name="dataSource" ref="dataSource"/>
  29.         <!--绑定mybatis的配置文件-->
  30.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
  31.     </bean>
  33.     <!--配置dao接口扫描包，动态的实现Dao接口可以注入到spring容器中-->
  34.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  35.         <!--注入sqlSessionFactory-->
  36.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
  37.         <!--要扫描的dao包(spring通过反射实现实现类的操作)-->
  38.         <property name="basePackage" value="com.ckm.dao"/>
  39.     </bean>
  41. </beans>

2.编写spring-service.xml

  1. <?xml version="1.0" encoding="UTF8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" 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 http://www.springframework.org/schema/context/spring-context-4.2.xsd">
  4.     <!--扫描service下的包-->
  5.     <context:component-scan base-package="com.ckm.service"/>
  7.     <!--将我们所有的业务类，注入到spring，可以通过配置 或者 注解实现（@Service、@Autowired）-->
  8.     <bean id="BookServiceImpl" class="com.ckm.service.BookServiceImpl">
  9.         <property name="bookMapper" ref="bookMapper"/>
  10.     </bean>
  12.     <!--声明事务配置-->
  13.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  14.         <!--注入数据源-->
  15.         <property name="dataSource" ref="dataSource"/>
  16.     </bean>
  18. </beans>

SSM：SpringMVC层

1.生成web项目

2.编写web.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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">
  4.     <!--DispatcherServlet-->
  5.     <servlet>
  6.         <servlet-name>springmvc</servlet-name>
  7.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  8.         <init-param>
  9.             <param-name>contextConfigLocation</param-name>
  10.             <param-value>classpath:applicationContext.xml</param-value>
  11.         </init-param>
  12.         <load-on-startup>1</load-on-startup>
  13.     </servlet>
  14.     <servlet-mapping>
  15.         <servlet-name>springmvc</servlet-name>
  16.         <url-pattern>/</url-pattern>
  17.     </servlet-mapping>
  18.     
  19.     <!--乱码过滤-->
  20.     <filter>
  21.         <filter-name>encoding</filter-name>
  22.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  23.         <init-param>
  24.             <param-name>encoding</param-name>
  25.             <param-value>utf-8</param-value>
  26.         </init-param>
  27.     </filter>
  28.     <filter-mapping>
  29.         <filter-name>encoding</filter-name>
  30.         <url-pattern>/*</url-pattern>
  31.     </filter-mapping>
  33.     <!--Session-->
  34.     <session-config>
  35.         <session-timeout>15</session-timeout>
  36.     </session-config>
  37. </web-app>

3.编写spring-mvc.xml

  1. <?xml version="1.0" encoding="UTF8"?>
  2. <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 http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd ">
  4.     <!--注解驱动-->
  5.     <mvc:annotation-driven/>
  7.     <!--静态资源过滤-->
  8.     <mvc:default-servlet-handler/>
  10.     <!--扫描包：controller-->
  11.     <context:component-scan base-package="com.ckm.controller"/>
  13.     <!--视图解析器-->
  14.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  15.         <property name="prefix" value="/WEB-INF/jsp/"/>
  16.         <property name="suffix" value=".jsp"/>
  17.     </bean>
  19. </beans>

4.在WEB-INF下创建jsp包

以上就完成了SSM三层的整合！！！

SSM：查询书籍功能

1.编写controller

  1. package com.ckm.controller;
  3. import com.ckm.pojo.Books;
  4. import com.ckm.service.BookService;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.beans.factory.annotation.Qualifier;
  7. import org.springframework.stereotype.Controller;
  8. import org.springframework.ui.Model;
  9. import org.springframework.web.bind.annotation.RequestMapping;
  11. import java.util.List;
  13. @Controller
  14. @RequestMapping("/book")
  15. public class BookController {
  16.     //controller调service层
  17.     @Autowired
  18.     @Qualifier("BookServiceImpl")
  19.     private BookService bookService;
  21.     //查询全部的书籍，并返回到页面
  22.     @RequestMapping("/allBook")
  23.     public String list(Model model){
  24.         List<Books> list = bookService.queryAllBook();
  25.         model.addAttribute("list",list);
  26.         return "allBook";
  27.     }
  28. }

2.编写index.jsp、allBook.jsp

index.jsp

  1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  2. <html>
  3.   <head>
  4.     <title>book</title>
  5.     <style> a{ text-decoration: none; color: black; font-size: 18px; } h3{ width: 180px; height: 38px; margin: 100px auto; text-align: center; line-height: 38px; background: deepskyblue; border-radius: 5px; } </style>
  6.   </head>
  7.   <body>
  9.   <h3>
  10. <%--    <a href="${pageContext.request.contextPath}/book/allBook">进入书籍页面</a>--%>
  11.     <a href="/book/allBook">进入书籍页面</a>
  12.   </h3>
  14.   </body>
  15. </html>

allBook.jsp

  1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  2. <html>
  3. <head>
  4.     <title>书籍展示</title>
  5. </head>
  6. <body>
  7. <h1>书籍展示</h1>
  8. ${list}
  9. </body>
  10. </html>

整个项目结构

版权说明 : 本文为转载文章, 版权归原作者所有 版权申明

原文链接 : https://blog.csdn.net/weixin_44912902/article/details/120685436

内容来源于网络，如有侵权，请联系作者删除！

Javaspringideassmspring学习笔记

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com