eos java调用命名sql_普元 EOS Platform 7.6 开发命名SQL缓存示例

【解答】

示例代码及EMPLOYEE建表语句见 命名SQL缓存demo.zip

1、在Mysql5.5.29上创建命名SQL需要查询的表EMPLOYEE，新增两条数据

DROP TABLE EMPLOYEE;

CREATE TABLE EMPLOYEE

(EMP_ID NUMBER(10,0) NOT NULL primary key,

EMP_NAME VARCHAR(64),

BIRTHDAY DATE,

ADDRESS VARCHAR(128)

);

INSERT INTO "EMPLOYEE" ("EMPID", "EMPNAME", "BIRTHDAY", "ADDRESS") VALUES (1, 'zhangsan', , '陕西西安');

INSERT INTO "EMPLOYEE" ("EMPID", "EMPNAME", "BIRTHDAY", "ADDRESS") VALUES (2, 'lisi', , '陕西宝鸡');

2、表创建完成后，创建数据集test，生成持久化数据实体Employee

3、开发查询用的命名SQL：id="employeeSelectMap"为查询单条数据的sql，id="emplo