1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
| package cn.stylefeng.roses.kernel.dsctn.persist.sqladapter;
|
| import cn.stylefeng.roses.kernel.db.api.sqladapter.AbstractSql;
| import lombok.Getter;
|
| /**
| * 添加数据源的sql
| *
| * @author fengshuonan
| * @date 2019-07-16-13:06
| */
| @Getter
| public class AddDatabaseInfoSql extends AbstractSql {
|
| @Override
| protected String mysql() {
| return "INSERT INTO `sys_database_info`(`db_id`, `db_name`, `jdbc_driver`, `jdbc_url`, `username`, `password`, `remarks`, `create_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
| }
|
| @Override
| protected String sqlServer() {
| return "INSERT INTO [sys_database_info] ([db_id], [db_name], [jdbc_driver], [jdbc_url], [username], [password], [remarks], [create_time]) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
| }
|
| @Override
| protected String pgSql() {
| return "INSERT INTO sys_database_info(db_id, db_name, jdbc_driver, jdbc_url, username, password, remarks, create_time) VALUES (?, ?, ?, ?, ?, ?, ?, to_timestamp(?,'YYYY-MM-DD HH24:MI:SS'))";
| }
|
| @Override
| protected String oracle() {
| return "INSERT INTO sys_database_info(db_id, db_name, jdbc_driver, jdbc_url, username, password, remarks, create_time) VALUES (?, ?, ?, ?, ?, ?, ?, to_date(?, 'yyyy-mm-dd hh24:mi:ss'))";
| }
| }
|
|
