最终项目结构:
1.创建工程
1.新建一个maven项目,使用webapp框架
maven项目骨架archetype加载慢的问题<Maven>新建maven项目时,archetype项目骨架加载慢的问题的解决方法_骨架加载不出来_小李子还挺酸的博客-CSDN博客
解决方法:
1.下载archetype-catalog.xml
2.把它放入C:\Users\xie\.m2\repository\org\apache\maven\archetype\archetype-catalog\3.2.1目录下(因人而异)
3.修改settings,注意这里要修改默认settings而不是current file的settings。
这样就可以从本地资源加载骨架,从而加速项目结构的建立。
2.完善项目骨架
将language-level改成8,
1.创建资源文件java和test文件的java。
2.创建springMVC的基本项目结构
包含config、domain、dao、service、controller
3.导入必要的坐标
在pom文件中导入坐标
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.10.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.10.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.2.10.RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.16</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.0</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.1</version>
<configuration>
<port>80</port>
<path>/</path>
</configuration>
</plugin>
</plugins>
</build>
2.SSM整合
通过配置整合SSM
1.Spring
1. SpringConfig
@Configuration
@ComponentScan({"com.xhh.service"})
@PropertySource("jdbc.properties")
@Import({JdbcConfig.class,MybatisConfig.class})
public class SpringConfig {
}
2.MyBatis
1. MybatisConfig
public class MybatisConfig {
//参数dataSource是Spring容器根据类型自动装配的
@Bean
public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource){
SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
factoryBean.setDataSource(dataSource);
factoryBean.setTypeAliasesPackage("com.xhh.domain");
return factoryBean;
}
@Bean
public MapperScannerConfigurer mapperScannerConfigurer(){
MapperScannerConfigurer msc = new MapperScannerConfigurer();
msc.setBasePackage("com.xhh.dao");
return msc;
}
}
2. JdbcConfig
public class JdbcConfig {
@Value("${jdbc.driver}")
private String driver;
@Value("${jdbc.url}")
private String url;
@Value("${jdbc.username}")
private String username;
@Value("${jdbc.password}")
private String password;
//造datasource
@Bean
public DataSource dataSource(){
DruidDataSource dataSource = new DruidDataSource();
dataSource.setDriverClassName(driver);
dataSource.setUrl(url);
dataSource.setUsername(username);
dataSource.setPassword(password);
return dataSource;
}
}
3. jdbc.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm_db
jdbc.username=root
jdbc.password=123456
3.SpringMVC
1. ServletConfig
public class ServletConfig extends AbstractAnnotationConfigDispatcherServletInitializer {
protected Class<?>[] getRootConfigClasses() {
return new Class[]{SpringConfig.class};
}
protected Class<?>[] getServletConfigClasses() {
return new Class[]{SpringMvcConfig.class};
}
protected String[] getServletMappings() {
return new String[]{"/"};
}
}
2. SpringMvcConfig
@Configuration
@ComponentScan("com.xhh.controller")
@EnableWebMvc
public class SpringMvcConfig {
}
3.功能模块
1.表与实体类domain
创建tbl_book表:
实体类Book
public class Book {
private Integer id;
private String type;
private String name;
private String description;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
@Override
public String toString() {
return "Book{" +
"id=" + id +
", type='" + type + '\'' +
", name='" + name + '\'' +
", description='" + description + '\'' +
'}';
}
2.dao(接口+自动代理)
public interface BookDao {
@Insert("insert into tbl_book values(null, #{type}, #{name}, #{description})")
public void save(Book book);
@Update("update tbl_book set type = #{type}, name = #{name}, description = #{description} where id = #{id}")
public void update(Book book);
@Delete("delete from tbl_book where id = #{id}")
public void delete(Integer id);
@Select("select from tbl_book where id = #{id}")
public Book getByID(Integer id);
@Select("select * from tbl_book")
public List<Book> getAll();
}
3.service(接口+实现类)
接口:
//提供业务层接口
public interface BookService {
/**
*
* @param book
* @return
*/
public boolean save(Book book);
public boolean update(Book book);
public boolean delete(Integer id);
public Book getByID(Integer id);
public List<Book> getAll();
}
实现类:
@Service
public class BookServiceImpl implements BookService {
//调用dao接口,需要先注入
//自动装配
@Autowired
private BookDao bookDao;
public boolean save(Book book) {
bookDao.save(book);
return true;
}
public boolean update(Book book) {
bookDao.update(book);
return true;
}
public boolean delete(Integer id) {
bookDao.delete(id);
return true;
}
public Book getByID(Integer id) {
return bookDao.getByID(id);
}
public List<Book> getAll() {
return bookDao.getAll();
}
业务层接口测试(整合JUnit)
创建测试类
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(classes = SpringConfig.class)
public class BookServiceTest {
@Autowired
private BookService bookService;
@Test
public void testGetById(){
Book book = bookService.getByID(1);
System.out.println(book);
}
@Test
public void testGetAll(){
List<Book> bookList = bookService.getAll();
System.out.println(bookList);
}
}
4.controller
@RestController
@RequestMapping("/books")
public class BookController {
@Autowired
private BookService bookService;
@PostMapping
public boolean save(@RequestBody Book book) {
return bookService.save(book);
}
@PutMapping
public boolean update(@RequestBody Book book) {
return bookService.update(book);
}
@DeleteMapping("/{id}")
public boolean delete(@PathVariable Integer id) {
return bookService.delete(id);
}
@GetMapping("/{id}")
public Book getByID(@PathVariable Integer id) {
return bookService.getByID(id);
}
@GetMapping
public List<Book> getAll() {
return bookService.getAll();
}
表现层接口测试
Postman