All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.beetl.sql.ext.JoinFunction Maven / Gradle / Ivy

There is a newer version: 3.30.14-RELEASE
Show newest version
package org.beetl.sql.ext;

import org.beetl.core.Context;
import org.beetl.core.Function;
import org.beetl.core.GeneralLoopStatus;
import org.beetl.core.ILoopStatus;
import org.beetl.sql.clazz.kit.BeanKit;
import org.beetl.sql.core.ExecuteContext;
import org.beetl.sql.core.db.DBStyle;
import org.beetl.sql.core.engine.SQLParameter;

import java.util.LinkedList;
import java.util.List;

/**
 *
 * @author "Sean-[重庆]" [email protected]; xiandafu 
 *
 */
public class JoinFunction implements Function {

	private static String join(ILoopStatus it, List dbParas,DBStyle dbStyle ) {

		StringBuilder buf = new StringBuilder();
		while (it.hasNext()) {
			Object o = it.next();
			if (!it.isFirst()) {
				buf.append(',');
			}
			if(!dbStyle.preparedStatementSupport()){
				buf.append(dbStyle.wrapStatementValue(o));

			}else{
				buf.append('?');
			}
			dbParas.add(new SQLParameter(null, o));

		}
		return buf.toString();
	}

	public static void main(String[] args) {
		int[] a = {1, 2};
		Object obj = a;
		Class c = obj.getClass();
		if (c.isArray()) {
			Object[] cs = (Object[]) obj;
			System.out.println(cs.length);
		}
	}

	@Override
	public Object call(Object[] paras, Context ctx) {
		Object temp = paras[0];
		if (temp == null) {
			throw new NullPointerException("join 参数为null");
		}

		ILoopStatus it = GeneralLoopStatus.getIteratorStatus(temp);
		if (it == null) {
			throw new NullPointerException("join 参数为必须为集合,数组,Iterator");
		}
		if (paras.length == 2) {
			//获取对象属性join(objs,"name");
			it = getValue(it, (String) paras[1]);
		}

		List dbParas = (List) ctx.getGlobal("_paras");
		ExecuteContext executeContext = (ExecuteContext)ctx.getGlobal("_executeContext");
		DBStyle dbStyle = executeContext.sqlManager.getDbStyle();
		try {
			ctx.byteWriter.writeString(join(it, dbParas,dbStyle));
		} catch (Exception e) {
			// IO错误这里不抛出
		}
		return null;
	}

	private ILoopStatus getValue(ILoopStatus it, String attrName) {
		LinkedList list = new LinkedList();
		while (it.hasNext()) {
			list.add(BeanKit.getBeanProperty(it.next(), attrName));
		}

		return GeneralLoopStatus.getIteratorStatus(list);
	}
}




© 2015 - 2025 Weber Informatics LLC | Privacy Policy