根据实体生成条件语句

最新推荐文章于 2024-05-10 14:31:45 发布

原创最新推荐文章于 2024-05-10 14:31:45 发布 · 127 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Bean #Java


import java.lang.reflect.Field;

/**
 * 根据实体生成条件语句
 * @author RuiLin.Xie - xKF24276
 *
 */
public class Main
{

	public static void main(String[] args) throws IllegalArgumentException, IllegalAccessException
	{

		Bean bean = new Bean();
		bean.setUid(12345);
		bean.setUName("xie");
//		bean.setUpwd("**##**987");

		beanMakeWhere(bean);
	}

	public static void beanMakeWhere(Bean bean) throws IllegalArgumentException, IllegalAccessException
	{
		Field[] fields = bean.getClass().getDeclaredFields();

		StringBuffer where = new StringBuffer();

		String tj = " like ";

		for(int i = 0; i < fields.length; i++)
		{

			String fName = fields[i].getName();
			fields[i].setAccessible(true);
			Object value = fields[i].get(bean);
			if(value == null)
			{
				continue;
			}

			if(value instanceof Number)
			{
				if( Integer.parseInt(value.toString()) == 0)
				{
					continue;
				}
				if(where.length() > 0)
				{
					where.append(" AND ");
				}
				where.append(fName + "=" + value + "");
			}
			else
			{
				if(where.length() > 0)
				{
					where.append(" AND ");
				}
				where.append(fName + " like '%" + value + "%'");
			}


		}

		System.out.println(where.toString());
	}

}