# maven

**Repository Path**: myprofile/maven

## Basic Information

- **Project Name**: maven
- **Description**: 我得maven私服
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-05-03
- **Last Updated**: 2025-05-03

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## maven仓库
```xml
<repository>
    <id>lhstack</id>
    <url>https://gitee.com/myprofile/maven/raw/master</url>
    <snapshots>
        <enabled>true</enabled>
<!--        <checksumPolicy>ignore</checksumPolicy>-->
    </snapshots>
    <releases>
        <enabled>true</enabled>
<!--        <checksumPolicy>ignore</checksumPolicy>-->
    </releases>
</repository>
```

## mybatis-plus-helper 依赖
```xml

<dependencies>
    <!--  shadow版本,不存在依赖版本冲突  -->
    <dependency>
        <groupId>com.lhstack</groupId>
        <artifactId>mybatis-plus-helper</artifactId>
        <version>1.0.0-shadow</version>
    </dependency>
    
    <!--  shadow版本,可能依赖版本冲突  -->
    <dependency>
        <groupId>com.lhstack</groupId>
        <artifactId>mybatis-plus-helper</artifactId>
        <version>1.0.0</version>
    </dependency>
</dependencies>

```
## mybatis-plus-helper demo
```xml
<?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>com.lhstack</groupId>
    <artifactId>test</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>11</maven.compiler.source>
        <maven.compiler.target>11</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <dependency>
            <groupId>com.lhstack</groupId>
            <artifactId>mybatis-plus-helper</artifactId>
            <version>1.0-shadow-SNAPSHOT</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-api -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.7.36</version>
        </dependency>

        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.2.3</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/com.zaxxer/HikariCP -->
        <dependency>
            <groupId>com.zaxxer</groupId>
            <artifactId>HikariCP</artifactId>
            <version>4.0.3</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc -->
        <dependency>
            <groupId>org.xerial</groupId>
            <artifactId>sqlite-jdbc</artifactId>
            <version>3.49.1.0</version>
        </dependency>
    </dependencies>

    <repositories>
        <repository>
            <id>lhstack</id>
            <url>https://gitee.com/myprofile/maven/raw/master</url>
            <snapshots>
                <enabled>true</enabled>
                <!--        <checksumPolicy>ignore</checksumPolicy>-->
            </snapshots>
            <releases>
                <enabled>true</enabled>
                <!--        <checksumPolicy>ignore</checksumPolicy>-->
            </releases>
        </repository>
    </repositories>
</project>
```
```java
import com.lhstack.mybatisplus.SqlSessionFactoryCreator;
import com.lhstack.mybatisplus.SqlSessionHelper;
import com.lhstack.org.apache.ibatis.logging.slf4j.Slf4jImpl;
import com.lhstack.org.apache.ibatis.reflection.MetaObject;
import com.lhstack.org.apache.ibatis.session.SqlSessionFactory;
import com.lhstack.shade.com.baomidou.mybatisplus.annotation.*;
import com.lhstack.shade.com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.lhstack.shade.com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import com.lhstack.shade.com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lhstack.shade.com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import com.lhstack.shade.com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lhstack.shade.com.baomidou.mybatisplus.extension.service.IService;
import com.lhstack.shade.com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;


public class SqlSessionFactoryCreatorTest {

    public interface PersonMapper extends BaseMapper<Person> {

        void createTable();
    }


    public interface IPersonService extends IService<Person> {
        void createTable();
    }

    public static class PersonServiceImpl extends ServiceImpl<PersonMapper, Person> implements IPersonService {

        @Override
        public void createTable() {
            this.baseMapper.createTable();
        }
    }

    @TableName(value = "t_person")
    public static class Person {

        @TableId(type = IdType.AUTO)
        private Integer id;

        private String name;

        private Integer age;

        @TableField(fill = FieldFill.INSERT)
        private Long created;

        @TableField(fill = FieldFill.INSERT_UPDATE)
        private Long updated;

        public Integer getId() {
            return id;
        }

        public void setId(Integer id) {
            this.id = id;
        }

        public String getName() {
            return name;
        }

        public void setName(String name) {
            this.name = name;
        }

        public Integer getAge() {
            return age;
        }

        public void setAge(Integer age) {
            this.age = age;
        }

        public Long getCreated() {
            return created;
        }

        public void setCreated(Long created) {
            this.created = created;
        }

        public Long getUpdated() {
            return updated;
        }

        public void setUpdated(Long updated) {
            this.updated = updated;
        }

        @Override
        public String toString() {
            return "Person{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", age=" + age +
                    ", created=" + created +
                    ", updated=" + updated +
                    '}';
        }
    }

    public static void main(String[] args) {

        HikariConfig config = new HikariConfig();
        config.setDriverClassName("org.sqlite.JDBC");
        config.setJdbcUrl("jdbc:sqlite:" + System.getProperty("user.dir") + "\\test.db");
        config.setMaximumPoolSize(5);
        config.setMinimumIdle(1);
        config.setAutoCommit(true);
        config.setConnectionTimeout(60000);
        config.setIdleTimeout(60000);
        config.setMaxLifetime(1800000);
        try (HikariDataSource dataSource = new HikariDataSource(config)) {
            SqlSessionFactory sqlSessionFactory = SqlSessionFactoryCreator.create(dataSource)
                    .withInterceptor(new PaginationInnerInterceptor())
                    .withXmlFileContents("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" +
                            "<!DOCTYPE mapper PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\" \"http://mybatis.org/dtd/mybatis-3-mapper.dtd\">\n" +
                            "<mapper namespace=\"SqlSessionFactoryCreatorTest$PersonMapper\">\n" +
                            "\n" +
                            "    <update id=\"createTable\">\n" +
                            "        CREATE TABLE IF NOT EXISTS t_person (\n" +
                            "            id INTEGER PRIMARY KEY AUTOINCREMENT,\n" +
                            "            name TEXT,\n" +
                            "            age INTEGER,\n" +
                            "            created INTEGER,\n" +
                            "            updated INTEGER\n" +
                            "        )\n" +
                            "    </update>\n" +
                            "</mapper>")
                    .configureConfiguration(mybatisConfiguration -> {
                        mybatisConfiguration.addMapper(PersonMapper.class);
                        mybatisConfiguration.setLogImpl(Slf4jImpl.class);
                    })
                    .withMetaObjectHandler(new MetaObjectHandler() {
                        @Override
                        public void insertFill(MetaObject metaObject) {
                            setFieldValByName("created", System.currentTimeMillis(), metaObject);
                            setFieldValByName("updated", System.currentTimeMillis(), metaObject);
                        }

                        @Override
                        public void updateFill(MetaObject metaObject) {
                            setFieldValByName("updated", System.currentTimeMillis(), metaObject);
                        }
                    })
                    .build();
            SqlSessionHelper sqlSessionHelper = new SqlSessionHelper(sqlSessionFactory);

            sqlSessionHelper.getService(PersonServiceImpl.class, PersonMapper.class, PersonServiceImpl::createTable);
            sqlSessionHelper.getMapper(PersonMapper.class, mapper -> {
                Person person = mapper.selectOne(new LambdaQueryWrapper<Person>().eq(Person::getName, "test"));
                if (person == null) {
                    person = new Person();
                    person.setAge(25);
                    person.setName("test");
                    mapper.insert(person);
                }
            });
            sqlSessionHelper.getService(PersonServiceImpl.class, PersonMapper.class, service -> {
                System.out.println(service.getById(1));
                System.out.println(service.page(new Page<>(1, 10)).getRecords());
            });
        }

    }
}
```