SqlServer表转JavaBean

解释权：

• 谢彬

• 2018-10-17

• 使用说明：将@tb改成对应的表执行sql后即可自动生成javaBean

USE MsInvoiceDB
GO
DECLARE @tb nvarchar(100)SET @tb = 'InvoiceEASTicket'
SELECT 'private ' + CASE 
		WHEN st.name = 'decimal' THEN 'double'
		WHEN st.name = 'int' THEN 'int'
		WHEN st.name = 'float' THEN 'double'
		ELSE 'String'
	END + ' '
	, LOWER(substring(col.name, 1, 1)) + substring(col.name, 2, len(col.name)) + ';'
FROM syscolumns col
	INNER JOIN systypes st ON st.xusertype = col.xtype
WHERE ID = OBJECT_ID(@tb)
UNION ALL
SELECT 'public ' + CASE 
		WHEN st.name = 'decimal' THEN 'double'
		WHEN st.name = 'int' THEN 'int'
		WHEN st.name = 'float' THEN 'double'
		ELSE 'String'
	END + ' get' + UPPER(substring(col.name, 1, 1)) + substring(col.name, 2, len(col.name) - 1) + '() { return ' + LOWER(substring(col.name, 1, 1)) + substring(col.name, 2, len(col.name)) + '; }'
	, 'public void set' + UPPER(substring(col.name, 1, 1)) + substring(col.name, 2, len(col.name) - 1) + '(' + CASE 
		WHEN st.name = 'decimal' THEN 'double'
		WHEN st.name = 'int' THEN 'int'
		WHEN st.name = 'float' THEN 'double'
		ELSE 'String'
	END + ' ' + LOWER(substring(col.name, 1, 1)) + substring(col.name, 2, len(col.name)) + ') { this.' + LOWER(substring(col.name, 1, 1)) + substring(col.name, 2, len(col.name)) + ' = ' + LOWER(substring(col.name, 1, 1)) + substring(col.name, 2, len(col.name)) + '; }'
FROM syscolumns col
	INNER JOIN systypes st ON st.xusertype = col.xtype
WHERE ID = OBJECT_ID(@tb);