SQLQuery JavaClass Converter

This VSCode extension can convert SQL query syntax into Java data class to store query results, reducing the manual process of creating classes.

Features

• Connection list (Needs to pre-configuration in Extension Settings)
• Default template type/package name/class name (Needs to turn on in Extension Settings)
• Automatically save the last converted template type/package name/class name (Needs to turn on in Extension Settings)

You can bind custom shortcuts to SQLQuery JavaClass Converter: Convert command to enhance conversion efficiency.

Requirements

• Java 8+
• MySQL 8+
• Oracle 10g+
• SQL Server 2014+
• SQLite 3+

You need to install Java on your system and be able to execute java -jar command correctly.

Extension Settings

• sqlquery-javaclass-converter.connections: The connection list of this extension.
• sqlquery-javaclass-converter.connections.connectionName: Connection name. (required)
• sqlquery-javaclass-converter.connections.connectionDesc: Connection description.
• sqlquery-javaclass-converter.connections.jdbcUrl: Connection's JDBC url. (required)
• sqlquery-javaclass-converter.connections.userId: Connection's user id. (required)
• sqlquery-javaclass-converter.connections.password: Connection's password.
• sqlquery-javaclass-converter.connections.useSavedPassword: Set to true to use saved password, set to false to prompt for a password for every connection.
• sqlquery-javaclass-converter.defaultTemplateType: Default template type for conversion.
• sqlquery-javaclass-converter.useLastTemplateType: Set to true to save the last input template type as Default template type for next conversion.
• sqlquery-javaclass-converter.defaultPackageName: Default package name for conversion.
• sqlquery-javaclass-converter.useLastPackageName: Set to true to save the last input package name as Default package name for next conversion.
• sqlquery-javaclass-converter.defaultClassName: Default class name for conversion.
• sqlquery-javaclass-converter.useLastClassName: Set to true to save the last input class name as Default class name for next conversion.
• sqlquery-javaclass-converter.settingTarget: Set to User to save current setting to Global settings, set to Workspace to save current setting to current Workspace settings.

Instructions for use

Step1: The SQL query syntax has been written and now we will use this VSCode extension to create Java data class to load the query results.

Step2: Selecting the entire SQL query syntax (parameters can also be included).

Step3: Command Center -> Show and Run Commands -> Clicking on SQLQuery JavaClass Converter: Convert.

Step4: Input JDBC url for database connection.

Step5: Input User id.

Step6: Input Password.

Step7: Select a template to create Java data class.

Step8: Input Package name.

Step9: Input Class name.

Step10: Wait for the conversion (approximately 3-5 seconds).

Step11: Save the Java data class file when conversion finished.

Step12: Input the Java data class as mappedClass of RowMapper.

---

Enjoy!