idea搭建ssm项目全过程详解：

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 {

    @Autowired
    private BookService bookService;

    @RequestMapping("/allBook")
    public String list(Model model) {
        List list = 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 {
    //增加一个Book
    int addBook(Books book);
    //根据id删除一个Book
    int deleteBookById(int id);
    //更新Book
    int updateBook(Books books);
    //根据id查询,返回一个Book
    Books queryBookById(int id);
    //查询全部Book,返回list集合
    List queryAllBook();
}

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层的操作
    @Autowired
    private 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 List queryAllBook() {
        return bookMapper.queryAllBook();
    }
}

Mapper 接口类：

package com.demo.mapper;

import com.demo.bean.Books;

import java.util.List;

public interface BookMapper {

        //增加一个Book
        int addBook(Books book);

        //根据id删除一个Book
        int deleteBookById(int id);

        //更新Book
        int updateBook(Books books);

        //根据id查询,返回一个Book
        Books queryBookById(int id);

        //查询全部Book,返回list集合
        List queryAllBook();


}

以及Mapper.xml






    
    
        insert into ssmbuild.books(bookName,bookCounts,detail)
        values (#{bookName}, #{bookCounts}, #{detail})
    

    
    
        delete from ssmbuild.books where bookID=#{bookID}
    

    
    
        update ssmbuild.books
        set 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