IDEA使用Maven整合搭建SSM框架（下）

<?xml version="1.0" encoding="utf-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
         http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
         version="2.4">
    <display-name>Archetype Created Web Application</display-name>
    <!--DispatcherServlet-->
    <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>
复制代码

<?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
   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
   https://www.springframework.org/schema/mvc/spring-mvc.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="org.ymx.Controller" />
</beans>
复制代码

CREATE DATABASE `ssmbuild`;
USE `ssmbuild`;
DROP TABLE IF EXISTS `books`;
CREATE TABLE `books` (
  `bookID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '书id',
  `bookName` VARCHAR(100) NOT NULL COMMENT '书名',
  `bookCounts` INT(11) NOT NULL COMMENT '数量',
  `detail` VARCHAR(200) NOT NULL COMMENT '描述',
  KEY `bookID` (`bookID`)
) ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT  INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`)VALUES 
(1,'Java',1,'从入门到放弃'),
(2,'MySQL',10,'从删库到跑路'),
(3,'Linux',5,'从进门到进牢');
复制代码

}
public Books(int bookID, String bookName, int bookCounts, String detail) {
    this.bookID = bookID;
    this.bookName = bookName;
    this.bookCounts = bookCounts;
    this.detail = detail;
}
public int getBookID() {
    return bookID;
}
public void setBookID(int bookID) {
    this.bookID = bookID;
}
public String getBookName() {
    return bookName;
}
public void setBookName(String bookName) {
    this.bookName = bookName;
}
public int getBookCounts() {
    return bookCounts;
}
public void setBookCounts(int bookCounts) {
    this.bookCounts = bookCounts;
}
public String getDetail() {
    return detail;
}
public void setDetail(String detail) {
    this.detail = detail;
}
复制代码

//根据id删除一个Book
int deleteBookById(int id);
//更新Book
int updateBook(Books books);
//根据id查询,返回一个Book
Books queryBookById(int id);
//查询全部Book,返回list集合
List<Books> queryAllBook();
复制代码

<!--增加一个Book-->
<insert id="addBook" parameterType="Books">
  insert into ssmbuild.books(bookName,bookCounts,detail)
  values (#{bookName}, #{bookCounts}, #{detail})
复制代码

<!--根据id删除一个Book-->
<delete id="deleteBookById" parameterType="int">
  delete from ssmbuild.books where bookID=#{bookID}
复制代码

<!--更新Book-->
<update id="updateBook" parameterType="Books">
  update ssmbuild.books
  set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail}
  where bookID = #{bookID}
复制代码

<!--根据id查询,返回一个Book-->
<select id="queryBookById" resultType="Books">
  select * from ssmbuild.books
  where bookID = #{bookID}
复制代码

<!--查询全部Book-->
<select id="queryAllBook" resultType="Books">
  SELECT * from ssmbuild.books
复制代码

private org.ymx.Dao.booksMapper booksMapper;
public void setBooksMapper(org.ymx.Dao.booksMapper booksMapper) {
    this.booksMapper = booksMapper;
}
public int addBook(Books book) {
    return booksMapper.addBook(book);
}
public int deleteBookById(int id) {
    return booksMapper.deleteBookById(id);
}
public int updateBook(Books books) {
    return booksMapper.updateBook(books);
}
public Books queryBookById(int id) {
    return booksMapper.queryBookById(id);
}
public List<Books> queryAllBook() {
    return booksMapper.queryAllBook();
}
复制代码

@Autowired
    @Qualifier("booksServiceImpl")
    private org.ymx.Service.booksService booksService;
    @RequestMapping("/allBook")
    public String list(Model model) {
        List<Books> list = booksService.queryAllBook();
        model.addAttribute("list", list);
        return "allBook";
    }
复制代码