SSM增删改查

SSM增删改查

1.配置

jdk1.8

mysql 8.0.21

Tomcat 8.5.45

Maven：

<dependencies> 
  <dependency> 
    <groupId>org.projectlombok</groupId>  
    <artifactId>lombok</artifactId>  
    <version>1.18.30</version> 
  </dependency>  
  <!-- Spring相关依赖-->  
  <dependency> 
    <groupId>org.springframework</groupId>  
    <artifactId>spring-context</artifactId>  
    <version>5.3.16</version> 
  </dependency>  
  <!--Spring事务管理-->  
  <dependency> 
    <groupId>org.springframework</groupId>  
    <artifactId>spring-tx</artifactId>  
    <version>5.3.16</version> 
  </dependency>  
  <dependency> 
    <groupId>org.springframework</groupId>  
    <artifactId>spring-jdbc</artifactId>  
    <version>5.3.16</version> 
  </dependency>  
  <dependency> 
    <groupId>org.springframework</groupId>  
    <artifactId>spring-test</artifactId>  
    <version>5.3.16</version> 
  </dependency>  
  <!--Spring MVC的相关依赖-->  
  <dependency> 
    <groupId>org.springframework</groupId>  
    <artifactId>spring-webmvc</artifactId>  
    <version>5.3.16</version> 
  </dependency>  
  <!--MyBatis相关依赖-->  
  <dependency> 
    <groupId>org.mybatis</groupId>  
    <artifactId>mybatis</artifactId>  
    <version>3.5.15</version> 
  </dependency>  
  <!--MyBatis与Spring整合相关依赖-->  
  <dependency> 
    <groupId>org.mybatis</groupId>  
    <artifactId>mybatis-spring</artifactId>  
    <version>2.0.6</version> 
  </dependency>  
  <!--数据源-->  
  <dependency> 
    <groupId>com.alibaba</groupId>  
    <artifactId>druid</artifactId>  
    <version>1.2.22</version> 
  </dependency>  
  <!--ServletAPI：引入servlet的功能-->  
  <dependency> 
    <groupId>javax.servlet</groupId>  
    <artifactId>javax.servlet-api</artifactId>  
    <version>3.1.0</version>  
    <scope>provided</scope> 
  </dependency>  
  <!-- 数据库驱动相关依赖-->  
  <dependency> 
    <groupId>mysql</groupId>  
    <artifactId>mysql-connector-java</artifactId>  
    <version>8.0.25</version> 
  </dependency>  
  <dependency> 
    <groupId>javax.servlet</groupId>  
    <artifactId>jstl</artifactId>  
    <version>1.2</version> 
  </dependency>  
  <dependency> 
    <groupId>com.fasterxml.jackson.core</groupId>  
    <artifactId>jackson-core</artifactId>  
    <version>2.9.9</version> 
  </dependency>  
  <!-- json解析 -->  
  <dependency> 
    <groupId>com.fasterxml.jackson.core</groupId>  
    <artifactId>jackson-databind</artifactId>  
    <version>2.9.9.3</version>
  </dependency> 
</dependencies> 

2.配置Config

在本地resource配置jdbc.properties配置文件

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/User?serverTimezone=UTC
jdbc.username=root
jdbc.password=123456

配置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;

    @Bean
    public DruidDataSource dataSource(){
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setDriverClassName(driver);
        druidDataSource.setUrl(url);
        druidDataSource.setUsername(username);
        druidDataSource.setPassword(password);
        return druidDataSource;
    }
}

配置MybatisConfig

public class MybatisConfig {
    @Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource){
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setDataSource(dataSource);
        factoryBean.setTypeAliasesPackage("com.spring.pojo");
        return factoryBean;
    }

    @Bean
    public MapperScannerConfigurer mapperScannerConfigurer(){
        MapperScannerConfigurer configurer = new MapperScannerConfigurer();
        configurer.setBasePackage("com.spring.mapper");
        return configurer;
    }
}

配置ServletConfig

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[]{"/"};
    }
}

配置SpringConfig

@Configuration
@ComponentScan("com.spring.mapper")
@PropertySource("classpath:jdbc.properties")
@Import({JdbcConfig.class, MybatisConfig.class})
//@EnableTransactionManagement
public class SpringConfig {
}

配置SpringMvcConfig

@Configuration
@ComponentScan("com.spring.controller")
@EnableWebMvc
public class SpringMvcConfig {
}

3.配置Controller

package com.spring.controller;

@RestController
@RequestMapping("/user")
public class Controller {

   @Autowired
   private UserMapper mapper;

   @GetMapping
   public List<User> getAll(){
      return mapper.getAll();
   }

   @PostMapping
   public int insert (@RequestBody User user){
      return mapper.insert(user);
   }

   @PutMapping
   public int update(@RequestBody User user){
      return mapper.update(user);
   }

   @DeleteMapping
   public int delete(Integer id){
      return mapper.delete(id);
   }
}

4.配置Mapper

@Mapper
public interface UserMapper {
    @Select("select * from user")
    List<User> getAll();
    @Insert("insert into user(id,name,age) values(#{id},#{name},#{age})")
    int insert(User user);
    @Update("update user set name = #{name}, age = #{age} where id = #{id}")
    int update(User user);
    @Delete("delete from user where id = #{id}")
    int delete(Integer id);
}

5.配置实体类Customer

@Data
public class User {
    private Integer id;
    private String name;
    private Integer age;
}

6.在插件中下载JBLJavaToWeb

下载后右键项目，选择JBLJavaToWeb，自动生成webapp

打开Tomcat，配置工件，选择war explorded

7.运行就完了

查询

增加

修改（更新）

删除