java注解实践(测试用例)

java注解实践
  需求:
  1.给定一张user表,字段包括userId,...
  2.方便的对没个字段或字段的组合条件进行检索,并打印sql
package javaAnnotation;

/**
 * Created with IntelliJ IDEA.
 * User: bobo
 * Date: 2019/9/12
 * Description: No Description
 */
@Table("user")
public class Filter {

    @Colume("id")
    private int id;
    @Colume("user_name")
    private String userName;
    @Colume("nick_name")
    private String nickName;
    @Colume("age")
    private int age;
    @Colume("city")
    private String city;
    @Colume("email")
    private String email;
    @Colume("phone_num")
    private int phoneNum;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getNickName() {
        return nickName;
    }

    public void setNickName(String nickName) {
        this.nickName = nickName;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public int getPhoneNum() {
        return phoneNum;
    }

    public void setPhoneNum(int phoneNum) {
        this.phoneNum = phoneNum;
    }
}
package javaAnnotation;

import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;

/**
 * Created with IntelliJ IDEA.
 * User: bobo
 * Date: 2019/9/12
 * Description: No Description
 */
@Target(ElementType.TYPE)
@Retention(RetentionPolicy.RUNTIME)
public @interface Table {

    String value();
}
package javaAnnotation;

import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;

/**
 * Created with IntelliJ IDEA.
 * User: bobo
 * Date: 2019/9/12
 * Description: No Description
 */
@Target(ElementType.FIELD)
@Retention(RetentionPolicy.RUNTIME)
public @interface Colume {
    String value();
}
package javaAnnotation;

import java.lang.reflect.Field;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;

/**
 * Created with IntelliJ IDEA.
 * User: bobo
 * Date: 2019/9/12
 * Description: No Description
 */
public class FilterTest {

    public static String query(Filter filter){
        StringBuilder sb = new StringBuilder();
        Class<? extends Filter> clazz = filter.getClass();
        boolean annotationPresent = clazz.isAnnotationPresent(Table.class);
        if (!annotationPresent) {
            return null;
        }
        Table table = clazz.getAnnotation(Table.class);
        sb.append("select * from ").append(table.value());
        sb.append(" where 1=1");
        //遍历所有field
        Field[] fields = clazz.getDeclaredFields();
        for (Field field:fields){
            boolean isExist = field.isAnnotationPresent(Colume.class);
            if (!isExist) {
                continue;
            }
            Colume columeAnnotation = field.getAnnotation(Colume.class);
            //boolean类型需要特殊处理
            String methodName = "get"+field.getName().substring(0,1).toUpperCase()+field.getName().substring(1);
            Method method = getMethod(clazz, methodName);
            Object invoke = null;
            if (method!=null) {
                try {
                    invoke = method.invoke(filter);
                } catch (IllegalAccessException e) {
                    e.printStackTrace();
                } catch (InvocationTargetException e) {
                    e.printStackTrace();
                }

                if (invoke==null || invoke.equals("") ||(invoke instanceof Integer && (int)invoke ==0)) {
                    continue;
                }
                sb.append(" and "+columeAnnotation.value());
                sb.append(" = ");
                sb.append("" + invoke);
            }
        }
        return sb.toString();
    }

    public static Method getMethod(Class clazz,String method){
        Method[] methods = clazz.getMethods();
        for (Method m : methods){
            if (m.getName().equals(method)){
                return m;
            }
        }
        return null;
    }

    public static void main(String[] args) {
        Filter filter = new Filter();
        filter.setId(1);
        filter.setAge(111);
        filter.setCity("beijing");
        filter.setUserName("bobo");
        String query = query(filter);
        System.out.println("query = " + query);
    }
}

测试结果:

标题

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值