Title: [咨询] 字段映射问题 · Issue #842 · APIJSON/APIJSON · GitHub
Open Graph Title: [咨询] 字段映射问题 · Issue #842 · APIJSON/APIJSON
X Title: [咨询] 字段映射问题 · Issue #842 · APIJSON/APIJSON
Description: Description 我使用字段映射功能,重写了setColumn和getKey方法,在初始化时正常输入内容,但是当我调用查询时,ColumnUtil.VERSIONED_KEY_COLUMN_MAP为空了 代码内容 public class TunnelSqlConfig extends APIJSONSQLConfig { /** * 默认构造函数 */ public TunnelSqlConfig() { super(); } /** * 带参数构造函数 * *...
Open Graph Description: Description 我使用字段映射功能,重写了setColumn和getKey方法,在初始化时正常输入内容,但是当我调用查询时,ColumnUtil.VERSIONED_KEY_COLUMN_MAP为空了 代码内容 public class TunnelSqlConfig extends APIJSONSQLConfig { /** * 默认构造函数 */ public TunnelSq...
X Description: Description 我使用字段映射功能,重写了setColumn和getKey方法,在初始化时正常输入内容,但是当我调用查询时,ColumnUtil.VERSIONED_KEY_COLUMN_MAP为空了 代码内容 public class TunnelSqlConfig extends APIJSONSQLConfig { /** * 默认构造函数 */ public TunnelSq...
Opengraph URL: https://github.com/APIJSON/APIJSON/issues/842
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[咨询] 字段映射问题","articleBody":"### Description \n\n我使用字段映射功能,重写了setColumn和getKey方法,在初始化时正常输入内容,但是当我调用查询时,ColumnUtil.VERSIONED_KEY_COLUMN_MAP为空了\n\n\n代码内容\npublic class TunnelSqlConfig extends APIJSONSQLConfig\u003cString> {\n\n\n /**\n * 默认构造函数\n */\n public TunnelSqlConfig() {\n super();\n }\n\n /**\n * 带参数构造函数\n *\n * @param method 请求方法\n * @param table 表名\n */\n public TunnelSqlConfig(RequestMethod method, String table) {\n super(method, table);\n }\n\n static {\n // 设置逻辑删除字段\n KEY_DELETED_KEY = \"del_flag\";\n KEY_DELETED_VALUE = \"1\";\n KEY_NOT_DELETED_VALUE = \"0\";\n // 设置默认数据库类型和模式\n DEFAULT_DATABASE = DATABASE_MYSQL;\n DEFAULT_SCHEMA = SystemProperties.Database.getDefaultSchema();\n\n // 配置SQL配置回调\n SIMPLE_CALLBACK = new SimpleCallback\u003cString>() {\n\n /**\n * 获取SQL配置实例\n *\n * @param method 请求方法\n * @param database 数据库名\n * @param schema 模式名\n * @param datasource 数据源名\n * @param table 表名\n * @return SQL配置实例\n */\n @Override\n public AbstractSQLConfig\u003cString> getSQLConfig(RequestMethod method, String database, String schema, String datasource, String table) {\n return new TunnelSqlConfig(method, table);\n }\n\n /**\n * 获取用户ID字段名\n *\n * @param database 数据库名\n * @param schema 模式名\n * @param datasource 数据源名\n * @param table 表名\n * @return 用户ID字段名\n */\n @Override\n public String getUserIdKey(String database, String schema, String datasource, String table) {\n return USER_.equals(table) || PRIVACY_.equals(table) ? ID : USER_ID;\n }\n };\n\n Map\u003cString, Map\u003cString, String>> tableKeyColumnMap = new HashMap\u003c>();\n Map\u003cString, String> ballastlessLedgerColumnMap = new HashMap\u003c>();\n ballastlessLedgerColumnMap.put(\"id\", \"id\");\n ballastlessLedgerColumnMap.put(\"lineName\", \"line_name\");\n ballastlessLedgerColumnMap.put(\"lineLevel\", \"line_level\");\n ballastlessLedgerColumnMap.put(\"bureauName\", \"bureau_name\");\n ballastlessLedgerColumnMap.put(\"divisionName\", \"division_name\");\n ballastlessLedgerColumnMap.put(\"sectionName\", \"section_name\");\n ballastlessLedgerColumnMap.put(\"direction\", \"direction\");\n ballastlessLedgerColumnMap.put(\"locationType\", \"location_type\");\n ballastlessLedgerColumnMap.put(\"locationName\", \"location_name\");\n ballastlessLedgerColumnMap.put(\"sectionNumber\", \"section_number\");\n ballastlessLedgerColumnMap.put(\"equipmentCode\", \"equipment_code\");\n ballastlessLedgerColumnMap.put(\"startMileage\", \"start_mileage\");\n ballastlessLedgerColumnMap.put(\"endMileage\", \"end_mileage\");\n ballastlessLedgerColumnMap.put(\"centerMileage\", \"center_mileage\");\n ballastlessLedgerColumnMap.put(\"overallLength\", \"overall_length\");\n ballastlessLedgerColumnMap.put(\"trackType\", \"track_type\");\n ballastlessLedgerColumnMap.put(\"componentType\", \"component_type\");\n ballastlessLedgerColumnMap.put(\"status\", \"status\");\n ballastlessLedgerColumnMap.put(\"delFlag\", \"del_flag\");\n ballastlessLedgerColumnMap.put(\"createBy\", \"create_by\");\n ballastlessLedgerColumnMap.put(\"createTime\", \"create_time\");\n ballastlessLedgerColumnMap.put(\"updateBy\", \"update_by\");\n ballastlessLedgerColumnMap.put(\"updateTime\", \"update_time\");\n tableKeyColumnMap.put(\"BallastlessLedger\", ballastlessLedgerColumnMap);\n\n ColumnUtil.VERSIONED_KEY_COLUMN_MAP.put(1, tableKeyColumnMap);\n\n // 初始化列工具\n ColumnUtil.init();\n\n // 调试:检查初始化结果\n System.out.println(\"映射配置初始化完成\");\n System.out.println(\"表映射: \" + ColumnUtil.VERSIONED_KEY_COLUMN_MAP.get(1).keySet());\n\n }\n \n @Override\n public AbstractSQLConfig\u003cString> setColumn(List\u003cString> column) {\n System.out.println(ColumnUtil.VERSIONED_KEY_COLUMN_MAP);\n List\u003cString> list = ColumnUtil.compatInputColumn(column, getTable(), getMethod(), 1, false);\n return super.setColumn(list);\n }\n\n @Override\n public String getKey(String key) {\n System.out.println(ColumnUtil.VERSIONED_KEY_COLUMN_MAP);\n String inputKey = ColumnUtil.compatInputKey(key, getTable(), getMethod(),1,false);\n String string = super.getKey(inputKey);\n return string;\n }\n\n}\n\n\n\n\n日志内容\n\n\u003cimg width=\"1305\" height=\"754\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/525cc404-be55-4483-bd1f-884a78b4fed7\" />\n\n\u003cimg width=\"1308\" height=\"798\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/92805682-f9bc-4b01-9ac9-35a8ae0dd18c\" />\n\n\n查询条件\n\n{\n \"BallastlessLedger[]\": {\n \"count\": 20,\n \"page\": 0,\n \"BallastlessLedger\": {\n \"delFlag\": \"0\",\n \"@order\": \"createTime-\"\n },\n \"query\": 2\n },\n \"total@\": \"/BallastlessLedger[]/total\"\n}\n\n\n异常日志\n\nCaused by: java.sql.SQLSyntaxErrorException: (conn=3221599286) Unknown column 'delFlag' in 'where clause'\nIf column exists but type cannot be identified (example 'select ? `field1` from dual'). Use CAST function to solve this problem (example 'select CAST(? as integer) `field1` from dual')\n\tat com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110)\n\tat com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202)\n\tat com.oceanbase.jdbc.OceanBaseStatement.executeExceptionEpilogue(OceanBaseStatement.java:331)\n\tat com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:258)\n\tat com.oceanbase.jdbc.JDBC4PreparedStatement.execute(JDBC4PreparedStatement.java:172)\n\tat com.oceanbase.jdbc.JDBC4PreparedStatement.executeQuery(JDBC4PreparedStatement.java:186)\n\tat apijson.orm.AbstractSQLExecutor.executeQuery(AbstractSQLExecutor.java:1386)\n\tat apijson.orm.SQLExecutor.executeQuery(SQLExecutor.java:70)\n","author":{"url":"https://github.com/hany5725","@type":"Person","name":"hany5725"},"datePublished":"2025-09-14T02:56:19Z","url":"https://github.com/APIJSON/APIJSON/issues/842"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:b2a84a64-a9d2-23cb-d6f9-963932d81b04 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A764:1C79DB:187FB0:21AF18:6AFCA9B4 |
| html-safe-nonce | 21ae5cb3462d8978ad788dfd2419ac551d36b991157ffe44992aacd65b21890e |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNzY0OjFDNzlEQjoxODdGQjA6MjFBRjE4OjZBRkNBOUI0IiwidmlzaXRvcl9pZCI6IjQ5MzcwMDM0MTMyMDUxOTkyODQiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 7e4cb7604d3ee783e7c0bd8ebe6693d5bc1504a6d49a7e32e0d08f5a1e8ddd4c |
| hovercard-subject-tag | issue:3414487128 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/APIJSON/APIJSON/842/issue_layout |
| twitter:image | https://opengraph.githubassets.com/5685cc97f10ea9e9d482a20d13230bc23b9e3458e3ae4ca161c859b868c1c958/APIJSON/APIJSON/issues/842 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/5685cc97f10ea9e9d482a20d13230bc23b9e3458e3ae4ca161c859b868c1c958/APIJSON/APIJSON/issues/842 |
| og:image:alt | Description 我使用字段映射功能,重写了setColumn和getKey方法,在初始化时正常输入内容,但是当我调用查询时,ColumnUtil.VERSIONED_KEY_COLUMN_MAP为空了 代码内容 public class TunnelSqlConfig extends APIJSONSQLConfig { /** * 默认构造函数 */ public TunnelSq... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | hany5725 |
| hostname | github.com |
| expected-hostname | github.com |
| None | e3084aead77cbcb4f4904fba53851fa1a0546b0dec3619bd250815e72588dc6d |
| turbo-cache-control | no-preview |
| go-import | github.com/APIJSON/APIJSON git https://github.com/APIJSON/APIJSON.git |
| octolytics-dimension-user_id | 41146037 |
| octolytics-dimension-user_login | APIJSON |
| octolytics-dimension-repository_id | 74359442 |
| octolytics-dimension-repository_nwo | APIJSON/APIJSON |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 74359442 |
| octolytics-dimension-repository_network_root_nwo | APIJSON/APIJSON |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5410e4bebd3e45b138c853ecef3992279d86d5af |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width