Code & Data Utilities

DB2Code (DB Column Code Converter)

Instantly convert table definitions and DB column lists into CamelCase, Java VO, TypeScript Interface, MyBatis ResultMap, and SQL statements.

Fast and secure data transformation directly in your browser.

💡 Tip: Second column separated by Tab is auto-mapped to Javadoc comment in VO mode and Type in TS mode.

Input Column List (Paste from Table Definition/Excel)

USER_ID	사용자 식별자 ID
USER_NAME	사용자명
EMAIL_ADDR	이메일 주소
PHONE_NO	휴대전화번호
DEPT_CODE	부서 코드
USER_STATUS	계정 상태(ACTIVE/INACTIVE)
LOGIN_FAIL_CNT	로그인 실패 횟수
LAST_LOGIN_AT	최종 로그인 일시
CREATED_AT	등록 일시
UPDATED_AT	수정 일시

글자수/Chars:202줄수/Lines:10

Generated Code Output

userId
userName
emailAddr
phoneNo
deptCode
userStatus
loginFailCnt
lastLoginAt
createdAt
updatedAt

글자수/Chars:98줄수/Lines:10

DB Column Code Converter Guide & Tips

Copy column list (names, descriptions/types) from Excel or schema doc and paste into input.
Select your target conversion tab (Basic Camel, Java VO, TypeScript, MyBatis, SQL, etc.).
Adjust options (Table Name, Modifier, WHERE Key vs All) and copy the generated snippet.

Tab Delimiter (\t): Second column separated by tab is mapped to Javadoc comments in VO mode and field types in TS mode.
WHERE Safety Switch: Defaults to key-only WHERE condition using the first column to prevent accidental full-column conditions.

Characteristics: Pure text-based quick snippet generator. Does not connect to live databases or execute DDL statements.

Privacy & Safety: All transformations run securely inside your browser client. No schema data is ever transmitted to servers.