gFramework

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'mc_wx';
desc T_OO_EVENT;

 

	public static void createInsertSql() throws Exception
	{
		String sql="SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'mc_wx';";
		JSONArray jsons=gDbUtils.ExecuteSelect(sql, null);
		for(int i=0;i<jsons.size();i++)
		{
			String parms="Object[] parm = {";
			JSONObject json=jsons.getJSONObject(i);
			String str=json.getString("TABLE_NAME");
			sql="desc "+str;
			String newSql="INSERT INTO ";
			String endSql="(";
			newSql+=str +"(";
			JSONArray jsonsDesc=gDbUtils.ExecuteSelect(sql, null);
			for(int k=0;k<jsonsDesc.size();k++)
			{
				JSONObjec