ITeye博客

自动生成set和get方法

java_frog · 2008-09-11 15:40 · source code · Markdown

import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement;

import oracle.jdbc.*;

import crm.selltask.util.DBUtil;

public class Main { public static void main(String args) throws Exception {

	String strTablename ="Product";
	Connection con=DBUtil.getConnection();
	Statement stmt =con.createStatement();
	ResultSet rs =stmt.executeQuery("SELECT * FROM "+strTablename);
	StringBuffer buffer =new StringBuffer();
	buffer.append("public class "+strTablename+"\n{\n");
	OracleResultSetMetaData oracleMetadata=(OracleResultSetMetaData)rs.getMetaData();
	
	for(int i=1;i<=oracleMetadata.getColumnCount();i++)
	{
		String strTypeName =oracleMetadata.getColumnTypeName(i);
		String strColName =oracleMetadata.getColumnName(i);
		strTypeName =TypeConvertor.convert(strTypeName);
		strColName=strColName.toLowerCase();
		//如果嫌set和get后大小写转换麻烦,那么 
		buffer.append("\n\t private "+strTypeName+" "+strColName+";\n");
		buffer.append("\t public "+strTypeName+" get"+strColName.replace(strColName.substring(0, 1), strColName.substring(0, 1).toUpperCase())+"()\n");
		buffer.append("\t{\n");
		buffer.append("\t return this."+strColName+";\n");
		buffer.append("\t}\n");

		buffer.append("\t public void "+"set"+strColName.replace(strColName.substring(0, 1), strColName.substring(0, 1).toUpperCase())+"("+strTypeName+" "+strColName+")\n\t{\n");
		buffer.append("\t this."+strColName+"="+strColName+";\n\t}\n");
	}
	buffer.append("\n}\n");
	System.out.println(buffer);
}

}

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。