{"id":2334,"date":"2023-06-27T15:33:03","date_gmt":"2023-06-27T07:33:03","guid":{"rendered":"https:\/\/xinchewhd.com.cn\/?p=2334"},"modified":"2023-06-27T15:33:03","modified_gmt":"2023-06-27T07:33:03","slug":"spring-boot-mybatis-plus-clickhouse-%e8%bd%bb%e6%9d%be%e5%ae%9e%e7%8e%b0%e5%a2%9e%e5%88%a0%e6%94%b9%e6%9f%a5%ef%bc%8c%e7%9c%8b%e4%ba%86%e5%bf%85%e6%87%82%ef%bc%81","status":"publish","type":"post","link":"https:\/\/xinchewhd.com.cn\/index.php\/mysql\/spring-boot-mybatis-plus-clickhouse-%e8%bd%bb%e6%9d%be%e5%ae%9e%e7%8e%b0%e5%a2%9e%e5%88%a0%e6%94%b9%e6%9f%a5%ef%bc%8c%e7%9c%8b%e4%ba%86%e5%bf%85%e6%87%82%ef%bc%81\/","title":{"rendered":"Spring Boot + Mybatis Plus + ClickHouse \u8f7b\u677e\u5b9e\u73b0\u589e\u5220\u6539\u67e5\uff0c\u770b\u4e86\u5fc5\u61c2\uff01"},"content":{"rendered":"
\n

\u9879\u76ee\u573a\u666f\uff1a<\/h2>\n<\/p>\n

ClickHouse \u64cd\u4f5c\u57fa\u4e8e Mybatis-puls\u6e90\u7801\u6269\u5c55\u5f00\u53d1\u3002\u89e3\u51b3ClickHouse\u7684\u4fee\u6539\u548c\u5220\u9664 SQL\u64cd\u4f5c\u4e0eMysql\u4e0d\u76f8\u540c\u3002<\/p>\n

\u57fa\u4e8e Mybatis-puls\uff1a<\/h2>\n

update \u3001updateById \u3001 delete  \u51fd\u6570<\/p>\n

1\u3001SqlMethodDiv.java<\/code> \u6587\u4ef6\u679a\u4e3e\u7c7b\uff0c\u5bf9sql\u811a\u672c\u5b9a\u4e49<\/span><\/a><\/p>\n

<\/span>package com.demo.test;
 
import com.demo.DemoClickHouse;
import com.demo.domain.dataobject.User;
import com.demo.domain.service.UserService;
import com.demo.infrastructure.util.page.PageResult;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
 
@RunWith(SpringRunner.class)
@SpringBootTest(classes = DemoClickHouse.class)
public class UserMapperTest {
 
    @Autowired
    UserService userService;
 
 
    @Test
    public void findById_Test<\/span><\/span>() {
        User byId = userService.findById(1);
        System.out.println(\"\u67e5\u8be2\u7528\u6237ID=1\u4fe1\u606f\uff1a\"<\/span> + byId);
    }
 
    @Test
    public void page_Test<\/span><\/span>() {
        User user = new User();
        Integer page = 1;
        Integer limit<\/span> = 2;
        PageResult<User> userList = userService.page(user, page, limit<\/span>);
        System.out.println(\"\u67e5\u8be2\u7528\u6237\u4fe1\u606f\u5206\u9875\uff1a\"<\/span> + userList);
    }
 
    @Test
    public void create_Test<\/span><\/span>() {
        User user = new User();
        user.setUserName(\"\u5f20\u4e09\"<\/span>);
        user.setPassWord(\"123\"<\/span>);
        user.setPhone(\"12312222\"<\/span>);
        user.setEmail(\"326427540@qq.com\"<\/span>);
        userService.create(user);
        System.out.println(\"\u521b\u5efa\uff1a\"<\/span> + user);
    }
 
    @Test
    public void update_Test<\/span><\/span>() {
        User user = new User();
        user.setId(1395347901827317761l);
        user.setUserName(\"\u5c0f\u674e\u98de\u5200\"<\/span>);
        user.setPassWord(\"123\"<\/span>);
        user.setPhone(\"12312222\"<\/span>);
        user.setEmail(\"326427540@qq.com\"<\/span>);
        userService.update(user);
        System.out.println(\"\u521b\u5efa\uff1a\"<\/span> + user);
    }
 
 
    @Test
    public void delete_Test<\/span><\/span>() {
        userService.delete(1l);
        System.out.println(\"\u5220\u9664\uff1a\"<\/span> + 1l);
    }
 
}
<\/code><\/pre>\n