luckysheet/luckysheet-mysql

mysql版本 >= 8

数据库初始化

创建数据库

CREATE DATABASE luckysheetdb

创建表 id采用雪花算法

CREATE TABLE `luckysheet` (
  `id` bigint(30) NOT NULL,
  `block_id` varchar(200) NOT NULL,
  `row_col` varchar(50) DEFAULT NULL,
  `index` varchar(200) NOT NULL,
  `list_id` varchar(200) NOT NULL,
  `status` int(1) DEFAULT NULL,
  `json_data` json DEFAULT NULL,
  `order` int(3) DEFAULT NULL,
  `is_delete` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lib` (`list_id`,`index`,`block_id`),
  KEY ```order``` (`order`),
  KEY ```status``` (`status`),
  KEY ```is_delete``` (`is_delete`)
) ENGINE=InnoDB DEFAULT CHARSET=armscii8

插入初始化语句

INSERT INTO luckysheet VALUES (139400313311449087, 'fblock', '', '1', '1079500#-8803#7c45f52b7d01486d88bc53cb17dcd2c3', 1, '{"row":84,"name":"Sheet1","chart":[],"color":"","index":"1","order":0,"column":60,"config":{},"status":0,"celldata":[],"ch_width":4748,"rowsplit":[],"rh_height":1790,"scrollTop":0,"scrollLeft":0,"visibledatarow":[],"visibledatacolumn":[],"jfgird_select_save":[],"jfgrid_selection_range":{}}', 0, 0);
INSERT INTO luckysheet VALUES (139400313311449088, 'fblock', '', '2', '1079500#-8803#7c45f52b7d01486d88bc53cb17dcd2c3', 0, '{"row":84,"name":"Sheet2","chart":[],"color":"","index":"2","order":1,"column":60,"config":{},"status":0,"celldata":[],"ch_width":4748,"rowsplit":[],"rh_height":1790,"scrollTop":0,"scrollLeft":0,"visibledatarow":[],"visibledatacolumn":[],"jfgird_select_save":[],"jfgrid_selection_range":{}}', 1, 0);
INSERT INTO luckysheet VALUES (139400313311449089, 'fblock', '', '3', '1079500#-8803#7c45f52b7d01486d88bc53cb17dcd2c3', 0, '{"row":84,"name":"Sheet3","chart":[],"color":"","index":"3","order":2,"column":60,"config":{},"status":0,"celldata":[],"ch_width":4748,"rowsplit":[],"rh_height":1790,"scrollTop":0,"scrollLeft":0,"visibledatarow":[],"visibledatacolumn":[],"jfgird_select_save":[],"jfgrid_selection_range":{}}', 2, 0);

注意： 表中 index、order 是关键字

项目中使用

1、luckysheet中的pom.xml 注释postgre，引入mysql

        <!-- 数据库接口以及实现 -->
        <dependency>
            <groupId>com.xc</groupId>
            <artifactId>luckysheet-db</artifactId>
            <version>${project.version}</version>
        </dependency>
        <dependency>
            <groupId>com.xc</groupId>
            <artifactId>luckysheet-mysql</artifactId>
            <version>${project.version}</version>
        </dependency>
        <!--<dependency>-->
            <!--<groupId>com.xc</groupId>-->
            <!--<artifactId>luckysheet-postgre</artifactId>-->
            <!--<version>${project.version}</version>-->
        <!--</dependency>-->

2、com.xc.luckysheet.db.server 文件夹中 JfGridFileGetService类 JfGridUpdateService类

mysql实现

@Resource(name = "mysqlRecordDataInsertHandle")
private IRecordDataInsertHandle recordDataInsertHandle;

@Resource(name = "mysqlRecordDataUpdataHandle")
private IRecordDataUpdataHandle recordDataUpdataHandle;

@Resource(name = "mysqlRecordDelHandle")
private IRecordDelHandle recordDelHandle;

@Resource(name = "mysqlRecordSelectHandle")
private IRecordSelectHandle recordSelectHandle;

postgres实现

@Resource(name = "postgresRecordDataInsertHandle")
private IRecordDataInsertHandle recordDataInsertHandle;

@Resource(name = "postgresRecordDataUpdataHandle")
private IRecordDataUpdataHandle recordDataUpdataHandle;

@Resource(name = "postgresRecordDelHandle")
private IRecordDelHandle recordDelHandle;

@Resource(name = "postgresRecordSelectHandle")
private IRecordSelectHandle recordSelectHandle;