Springboot整合mysql 5.7 实现增删改查

妖狐艹你老母 2024-03-25 20:59 17阅读 0赞

出现 Cannot resolve class or package ‘mysql’处理方法  
https://blog.csdn.net/zhouhan\_0509/article/details/127319458

这个是因为连接mysql的版本的关系，cj是8.0的

Failed to obtain JDBC Connection； nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsExc

https://blog.csdn.net/RavenWE/article/details/121482923

useSSL=false和true的区别  
https://blog.csdn.net/sungancd/article/details/119183605

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>org.example</groupId>
        <artifactId>kafka</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.3.2.RELEASE</version>
            <relativePath/>
        </parent>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>1.2.71</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.38</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.5.1</version>
            </dependency>
    
        </dependencies>
    
        <properties>
            <maven.compiler.source>8</maven.compiler.source>
            <maven.compiler.target>8</maven.compiler.target>
        </properties>
    
    </project>

[SpringBoot中Server层以及Mapper层常用注解][SpringBoot_Server_Mapper]

[SpringBoot项目连接MySQL数据库][SpringBoot_MySQL]

[IDEA创建Mapper.xml文件][IDEA_Mapper.xml]

mapper层  
![在这里插入图片描述][b9b3ae9904e14b30874f2cd9e0c8e84e.png]

![在这里插入图片描述][35b823f51c06471e96b5b8987ecc9b03.png]

![在这里插入图片描述][67d8827376aa49ac865cb1a77c5b65e9.png]  
![在这里插入图片描述][27054ae91ed045969377247072f3c701.png]  
批量修改或者新增  
![在这里插入图片描述][8107b5a287534f828c2ac58ab6ed1f17.png]

@Controller
    @RequestMapping("/hello")
    public class Test1Controller {
        
    
        @Autowired
        private OrderServiceImpl orderServiceImpl;
    
        @RequestMapping("/h")
        public void test(){
        
           // System.out.println(orderService.findById());
    
            /*Order order = new Order();
            order.setOrderName("圣女果");
            order.setOrderId(4L);
            order.setFeature("贵且好吃");
            System.out.println(order);
            //orderService.updateById(order);
            System.out.println(orderServiceImpl.saveOrUpdate(order));*/
    
            List <Order> orderList = new ArrayList<>();
            orderList.add(new Order().setOrderId(1L).setOrderName("批量修改"));
            orderList.add(new Order().setOrderId(5L).setOrderName("新增水果").setNumber("100005").setFeature("批量新增或者修改测试"));
            System.out.println(orderServiceImpl.saveOrUpdateBatch(orderList));
        }

[SpringBoot_Server_Mapper]: https://blog.csdn.net/m0_73311735/article/details/127570498?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522167911261116782425128928%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=167911261116782425128928&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-1-127570498-null-null.142%5Ev74%5Einsert_down38,201%5Ev4%5Eadd_ask,239%5Ev2%5Einsert_chatgpt&utm_term=mapper%E5%B1%82%E7%9A%84%E6%B3%A8%E8%A7%A3&spm=1018.2226.3001.4187
[SpringBoot_MySQL]: https://blog.csdn.net/The_girl_wait_me/article/details/124688884?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522167910724316800213079074%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=167910724316800213079074&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~top_positive~default-1-124688884-null-null.142%5Ev74%5Einsert_down38,201%5Ev4%5Eadd_ask,239%5Ev2%5Einsert_chatgpt&utm_term=springboot%E8%BF%9E%E6%8E%A5mysql%E6%95%B0%E6%8D%AE%E5%BA%93&spm=1018.2226.3001.4187
[IDEA_Mapper.xml]: https://blog.csdn.net/qq_41135254/article/details/96102670?utm_medium=distribute.pc_relevant.none-task-blog-2~default~baidujs_baidulandingword~default-1-96102670-blog-128575208.pc_relevant_3mothn_strategy_recovery&spm=1001.2101.3001.4242.2&utm_relevant_index=4
[b9b3ae9904e14b30874f2cd9e0c8e84e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/eebeac22c83a427dabc4a98b767f51f0.png
[35b823f51c06471e96b5b8987ecc9b03.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/0d89f58d865541018183720c8dee077f.png
[67d8827376aa49ac865cb1a77c5b65e9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/15a0f9e1f33e43189c642fb27dc7a580.png
[27054ae91ed045969377247072f3c701.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/0998e8cc6e1e4e09b52176baee60fc95.png
[8107b5a287534f828c2ac58ab6ed1f17.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/09b5293500114c8dbcf81b17e972f160.png