tables.java

mysql 根据你的配置 程序会自动生成sql语句 然后就可以把这些sql语句执行了

package com.cql.user;

import java.util.Iterator;
import java.util.List;

public class Tables {
	private List<Duan> duans;
	private String name;
	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public List<Duan> getDuans() {
		return duans;
	}

	public void setDuans(List<Duan> duans) {
		this.duans = duans;
	}

	public String getCreateSQL()
	{
		String str= "";
		Iterator tab = duans.iterator();
		str += "create table ";
		str += this.name;
		str += "(";
		String dou="";
		int i = 0;
		while(tab.hasNext())
		{	i++;
		    if(i<=1) dou="";
		    else dou=" ,";
			Duan duan = (Duan)tab.next();
			str += dou;
			str += duan.getCreateSQL();
			
		}
		str +=");";
		return str;
	}
	


}