赞
踩

①Spring
SpringConfig
- package com.cacb.config;
-
- import org.springframework.context.annotation.ComponentScan;
- import org.springframework.context.annotation.Configuration;
- import org.springframework.context.annotation.Import;
- import org.springframework.context.annotation.PropertySource;
-
- @Configuration
- @ComponentScan("com.cacb.service")
- @PropertySource("jdbc.properties")
- @Import({JdbcConfig.class,MybatisConfig.class})
- public class SpringConfig {
- }
MybatisConfig
- package com.cacb.config;
-
- import org.mybatis.spring.SqlSessionFactoryBean;
- import org.mybatis.spring.mapper.MapperScannerConfigurer;
- import org.springframework.context.annotation.Bean;
-
- import javax.sql.DataSource;
-
- public class MybatisConfig {
-
- @Bean
- public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource){
- SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
- factoryBean.setDataSource(dataSource);
- factoryBean.setTypeAliasesPackage("com.cacb.domain");
- return factoryBean;
- }
-
-
- @Bean
- public MapperScannerConfigurer mapperScannerConfigurer(){
- MapperScannerConfigurer msc = new MapperScannerConfigurer();
- msc.setBasePackage("com.cacb.dao");
- return msc;
- }
- }

JdbcConfig
- package com.cacb.config;
-
- import com.alibaba.druid.pool.DruidDataSource;
- import org.springframework.beans.factory.annotation.Value;
- import org.springframework.context.annotation.Bean;
-
- import javax.sql.DataSource;
-
-
- 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;
-
- @Bean
- public DataSource dataSource(){
- DruidDataSource dataSource = new DruidDataSource();
- dataSource.setDriverClassName(driver);
- dataSource.setUrl(url);
- dataSource.setUsername(username);
- dataSource.setPassword(password);
- return dataSource;
- }
- }

jbdc.properties
- jdbc.driver=com.mysql.jdbc.Driver
- jdbc.url=jdbc:mysql:"//localhost:3306/cary_cacb
- jdbc.username=
- jdbc.password=
③SpringMVC
ServletConfig
- package com.cacb.config;
-
- import org.springframework.web.servlet.support.AbstractAnnotationConfigDispatcherServletInitializer;
-
- public class ServletConfig extends AbstractAnnotationConfigDispatcherServletInitializer {
- @Override
- protected Class<?>[] getRootConfigClasses() {
- return new Class[]{SpringConfig.class};
- }
-
- @Override
- protected Class<?>[] getServletConfigClasses() {
- return new Class[]{SpringMvcConfig.class};
- }
-
- @Override
- protected String[] getServletMappings() {
- return new String[]{"/"};
- }
- }

SpringMvcConfig
- package com.cacb.config;
-
- import org.springframework.context.annotation.ComponentScan;
- import org.springframework.context.annotation.Configuration;
- import org.springframework.web.servlet.config.annotation.EnableWebMvc;
-
- @Configuration
- @ComponentScan("com.cacb.controller")
- @EnableWebMvc
- public class SpringMvcConfig {
- }

- package com.cacb.domain;
-
- 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 + '\'' +
- '}';
- }
- }

- package com.cacb.dao;
-
- import com.cacb.domain.Book;
- import org.apache.ibatis.annotations.Delete;
- import org.apache.ibatis.annotations.Insert;
- import org.apache.ibatis.annotations.Select;
- import org.apache.ibatis.annotations.Update;
-
- import java.util.List;
-
- public interface BookDao {
- @Insert("insert into tbl_book values(null,#{type},#{name},#{description})")
- public void save(Book book);
-
- @Update("update tbl_boook 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();
- }

- package com.cacb.service;
-
- import com.cacb.domain.Book;
-
- import java.util.List;
-
- public interface BookService {
-
- public boolean save(Book book);
-
- public boolean update(Book book);
-
- public boolean delete(Integer id);
-
- public Book getById(Integer id);
-
- public List<Book> getAll();
- }

- package com.cacb.service.impl;
-
-
- import com.cacb.dao.BookDao;
- import com.cacb.domain.Book;
- import com.cacb.service.BookService;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Service;
-
- import java.util.List;
-
-
- @Service
- public class BookServiceImpl implements BookService {
- @Autowired
- private BookDao bookDao;
-
- @Override
- public boolean save(Book book) {
- bookDao.save(book);
- return true;
- }
-
- @Override
- public boolean update(Book book) {
- bookDao.update(book);
- return true;
- }
-
- @Override
- public boolean delete(Integer id) {
- bookDao.delete(id);
- return true;
- }
-
- @Override
- public Book getById(Integer id) {
- bookDao.getById(id);
- return null;
- }
-
- @Override
- public List<Book> getAll() {
- bookDao.getAll();
- return null;
- }
- }

- package com.cacb.service;
-
- import com.cacb.config.SpringConfig;
- import com.cacb.domain.Book;
- 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(classes = SpringConfig.class)
- public class BookServiceTest {
-
- @Autowired
- private BookService bookService;
-
- @Test
- public void testGetById(){
- Book book = bookService.getById(1);
- System.out.println(book);
- }
- }

- package com.cacb.controller;
-
- import com.cacb.domain.Book;
- import com.cacb.service.BookService;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.web.bind.annotation.*;
-
- import java.util.List;
-
- @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();
- }
- }

Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。