package com.easyjf.web.tools;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.velocity.context.Context;
import com.easyjf.dbo.EasyJDBEngine;

public class BeanTemplateProcess implements ITemplateProcess {
	private String tableName;
	public BeanTemplateProcess()
	{
		
	}
	public BeanTemplateProcess(String tableName)
	{
		this.tableName=tableName;
	}
	public void process(Context context) {
		// TODO Auto-generated method stub
		Connection conn = EasyJDBEngine.getInstance().getConnection();
		try {
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("select * from " + tableName);
			ResultSetMetaData meta = rs.getMetaData();
			int count = meta.getColumnCount();
			List list = new ArrayList(count);
			for (int i = 1; i <= count; i++) {
				Map map = new HashMap();				
				String name= meta.getColumnName(i);
				map.put("name",name);
				map.put("type", jdbcType2Java(meta.getColumnClassName(i)));
				map.put("method",name.substring(0,1).toUpperCase()+name.substring(1));				
				map.put("lable", meta.getColumnLabel(i));
				map.put("size", new Integer(meta.getColumnDisplaySize(i)));
				list.add(map);
			}
			rs.close();
			stmt.close();
			context.put("fieldList",list);
			context.put("tableKeyFiled","cid");
			context.put("TabelIdGenerator","com.easyjf.dbo.RandomIdGenerator");
		} catch (Exception e) {

		}
		context.put("tableName",tableName);
	}

	private String jdbcType2Java(String sqlType)
	{
		String ret=sqlType.replaceAll("java\\.lang\\.","");
		if(ret.equals("java.sql.Timestamp"))ret="java.util.Date";
	    /**
	     * 以此類推，進(jìn)行更多的轉(zhuǎn)換操作
	     */
		return ret;
	}
	public String getTableName() {
		return tableName;
	}
	public void setTableName(String tableName) {
		this.tableName = tableName;
	}
	

}