目录
项目的结构
创建Maven项目,项目结构如下:
一、先建立数据库ssm,创建表tb_book
创建数据库ssm,以及创建表tb_book的代码入下。
-- ----------------------------
-- Table structure for tb_book
-- ----------------------------
CREATE DATABASE ssm;
USE SSM;
CREATE TABLE `tb_book` (
`id` int(11),
`name` varchar(32) ,
`press` varchar(32) ,
`author` varchar(32)
) ;
-- ----------------------------
-- Records of tb_book
-- ----------------------------
INSERT INTO `tb_book` VALUES ('1', '应用开发教程', 'XX出版社', 'yqd');
创建表tb_book后,如下图所示。
二、编辑pom.xml
需要的注意的是,依赖会因为版本不一样报错。以及最后项目名称不同报错,因为我的项目名称是chapter14xml,读者需要注意!
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<!--Spring事务管理-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<!--Spring MVC的相关依赖-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<!--MyBatis相关依赖-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency>
<!--MyBatis与Spring整合相关依赖-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.1</version>
</dependency>
<!--数据源:阿里公司的德鲁伊-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.20</version>
</dependency>
<!--单元测试相关的依赖-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- 相关的依赖-->
<!--ServletAPI:引入servlet的功能-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!--ServletAPI: jsp页面的功能包 -->
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
<scope>provided</scope>
</dependency>
<!-- 数据库驱动相关依赖-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>compile</scope>
</dependency>
</dependencies>
<build>
<finalName>chapter14xml</finalName>
<pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
<plugins>
<plugin>
<artifactId>maven-clean-plugin</artifactId>
<version>3.1.0</version>
</plugin>
<!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.22.1</version>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.2</version>
</plugin>
<plugin>
<artifactId>maven-install-plugin</artifactId>
<version>2.5.2</version>
</plugin>
<plugin>
<artifactId>maven-deploy-plugin</artifactId>
<version>2.8.2</version>
</plugin>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<configuration>
<port>8080</port>
<path>/chapter14xml</path>
</configuration>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>
三、配置jdbc.properties
右键resources,选择File,然后创建jdbc.properties即可。需要注意username和password会不一样。具体代码如下:
jdbc.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm?useUnicode=true\
&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
jdbc.username=root
jdbc.password=123456
四、创建实体类
在com.yqd.domain下创建实体类Book。具体代码如下:
package com.yqd.domain;
public class Book {
private Integer id; //图书id
private String name; //图书名称
private String press; //出版社
private String author; //作者
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPress() {
return press;
}
public void setPress(String press) {
this.press = press;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
}
五、创建dao层
在com.yqd.dao下创建接口类BookMapper。
package com.yqd.dao;
import com.yqd.domain.Book;
public interface BookMapper {
public Book findBookById(Integer id);
}
在resources下,创建目录com.yqd.dao。接着创建映射文件BookMapper.xml。具体代码如下:
<?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.yqd.dao.BookMapper">
<!--根据id查询图书信息 -->
<select id="findBookById" parameterType="int"
resultType="com.yqd.domain.Book">
select * from tb_book where id = #{id}
</select>
</mapper>
接着在resource下,创建application-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
http://www.springframework.org/schema/context/spring-context.xsd
">
<!--引入属性文件-->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!--数据源-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!--创建SqlSessionFactory对象-->
<bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<!--数据源-->
<property name="dataSource" ref="dataSource"/>
</bean>
<!--扫描Dao包,创建动态代理对象, 会自动存储到spring IOC容器中-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--指定要扫描的dao的包-->
<property name="basePackage" value="com.yqd.dao"/>
</bean>
</beans>
六、创建service层
在com.yqd.service包下创建接口类BookService。具体代码入下:
package com.yqd.service;
import com.yqd.domain.Book;
public interface BookService {
public Book findBookById(Integer id);
}
在com.yqd.service.impl包下创建接口实现类BookServiceImpl。具体代码入下:
package com.yqd.service.impl;
import com.yqd.dao.BookMapper;
import com.yqd.domain.Book;
import com.yqd.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class BookServiceImpl implements BookService {
@Autowired
private BookMapper bookMapper;
public Book findBookById(Integer id) {
return bookMapper.findBookById(id);
}
}
接着在resource下,创建application-service.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
http://www.springframework.org/schema/context/spring-context.xsd
">
<!--开启注解扫描, 扫描包-->
<context:component-scan base-package="com.yqd.service"/>
</beans>
七、创建controller层
在com.yqd.controller包下创建控制类BookController类。具体代码如下:
package com.yqd.controller;
import com.yqd.domain.Book;
import com.yqd.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
@Controller
public class BookController {
@Autowired
private BookService bookService;
@RequestMapping("/book")
public ModelAndView findBookById(Integer id) {
Book book = bookService.findBookById(id);
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("book.jsp");
modelAndView.addObject("book", book);
return modelAndView;
}
}
接着在resource下,创建spring-mvc文件。相关代码入下:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
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
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!-- 配置要扫描的包 -->
<context:component-scan base-package="com.yqd.controller"/>
<!-- 配置注解驱动 -->
<mvc:annotation-driven/>
</beans>
八、编写测试类
在com.yqd.test包下新建BookServiceTest类,主要看能不能拿到数据。具体代码如下:
package com.yqd.test;
import com.yqd.domain.Book;
import com.yqd.service.BookService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath:application-service.xml",
"classpath:application-dao.xml"})
public class BookServiceTest {
@Autowired
private BookService bookService;
@Test
public void findBookById() {
Book book = bookService.findBookById(1);
System.out.println("图书id:" + book.getId());
System.out.println("图书名称:" + book.getName());
System.out.println("作者:" + book.getAuthor());
System.out.println("出版社:" + book.getPress());
}
}
九、编写jsp文件
在webapp下创建index.jsp。具体代码如下:
<html>
<body>
<h2>Hello SSM!</h2>
</body>
</html>
在webapp下创建book.jsp。具体代码如下:
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<html>
<head><title>图书信息查询</title></head>
<body>
<table border="1">
<tr>
<th>图书id</th>
<th>图书名称</th>
<th>出版社</th>
<th>作者</th>
</tr>
<tr>
<td>${book.id}</td>
<td>${book.name}</td>
<td>${book.press}</td>
<td>${book.author}</td>
</tr>
</table>
</body>
</html>
十、相关配置
在ProjectStructure(项目结构)里,Facets里Web需要注意Deployment Descriptiors(部署说明)需要选择正确的web.xml文件位置。以及(Web Resource Direction(web资源路径)需要选择正确的路径,因为这样才能访问得到你的jsp文件,选到webapp那一层就行。
选择到Artifacts,点击+号,选中Web Application Exploded,然后From Modules,选中项目即可。点击应用Apply即可。
选择到Artifacts,点击+号,选中Web Application Archive,然后选For '项目名称':war exploded',然后选择Apply应用即可。
选择编辑配置Edit Configurations。
点击+号, 选择Tomcat Server接着选中local。
选择你汤姆猫放的位置。
选择Fix一键修复。
把这两个都选择上。然后应用Apply即可。
十一、运行结果
BookServiceTest运行结果如下:
运行Tomcat之后的页面如下:
在地址栏里输入localhost:8080/chapter14xml_war/book,回车之后就会出现以下结果,这是因为还没有传入参数。所以这个表里是空数据。
在地址栏里输入localhost:8080/chapter14xml_war/book?id=1,回车之后就会出现以下结果,这是传入参数之后的结果,这样就把数据库里id=1的数据就查找出来并显示出来了。