Getting Started

Example for MySQL

Usage

Maven central: kite-spring-boot-starter

1. Add the following dependencies to your project:

• Maven

<dependency>
   <groupId>io.github.tangllty</groupId>
   <artifactId>kite-spring-boot-starter</artifactId>
   <version>${kite.version}</version>
</dependency>

• Gradle

implementation("io.github.tangllty:kite-spring-boot-starter:${kite.version}")

2. Create a table in your database

create table account (
  id          bigint not null auto_increment,
  username    varchar(32)     default '',
  password    varchar(32)     default '',
  balance     decimal(10,2)   default '0.00',
  create_time date            default null,
  update_time date            default null,
  primary key (`id`)
);

3. Configure your database connection information in the application.yml file

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/kite-test
    username: root
    password: password

4. Extend the BaseMapper interface to create a Mapper interface

import com.tang.kite.mapper.BaseMapper;

public interface AccountMapper extends BaseMapper<Account> {
}

5. Test the Mapper interface

import com.tang.kite.io.Resources;
import com.tang.kite.session.factory.SqlSessionFactoryBuilder;
import com.tang.kite.session.mapper.AccountMapper;
import org.junit.jupiter.api.Test;

public class KiteTest {

    @Test
    public void test() {
        var resource = Resources.getResourceAsStream("kite-config.yml");
        var sqlSessionFactory = new SqlSessionFactoryBuilder().build(resource);
        var sqlSession = sqlSessionFactory.openSession();
        var accountMapper = sqlSession.getMapper(AccountMapper.class);
        var list = accountMapper.select();
        list.forEach(System.out::println);
        sqlSession.close();
    }

}