segment of test code

最新推荐文章于 2024-03-04 15:20:12 发布

最新推荐文章于 2024-03-04 15:20:12 发布 · 98 阅读

本文介绍了使用Java进行数据库操作的方法，包括字段匹配验证、正则表达式使用、获取数据库元数据等关键技术点，并展示了如何通过反射机制设置对象属性。

{

{
            if (fieldName == null || fieldName.trim().equalsIgnoreCase(""))
                return true;
            con = getConnection();
            st = con.createStatement();
            rs = st.executeQuery("SELECT * FROM " + to.getSchemaName() + "."
                    + to.getTableName() + " ");
            rsmd = rs.getMetaData();
            for (int i = 1; i < rsmd.getColumnCount() + 1; i++) {
                if (rsmd.getColumnName(i).equalsIgnoreCase(fieldName)) {
                    exist = true;
                }
            }
        }

        Pattern p = Pattern.compile("[a-zA-Z0-9]*");
        Matcher m = p.matcher("xx");
        boolean b = m.matches();
        System.out.println(""+b);

        String aa="喊";
        String bb="x";
        System.out.println("喊="+aa.getBytes().length);
        System.out.println("x="+bb.getBytes().length);

        String str="x2x收拾";

        String regEx="[a-zA-Z0-9]*";
        Pattern p=Pattern.compile(regEx);

Matcher m=p.matcher(str);

        boolean rs=m.find();
        System.out.println(""+rs);
        String StrTemp = "";
        for (int i = 0; i < StrTemp.length(); i++) {

if ((StrTemp.charAt(i) > '9' || StrTemp.charAt(i) < '0')

&& (StrTemp.charAt(i) > 'a' || StrTemp.charAt(i) < 'z')
&& (StrTemp.charAt(i) > 'A' || StrTemp.charAt(i) < 'Z')) {

}
}

   try {
    TableProfilePOJO pojo = new TableProfilePOJO();
    Class classType = pojo.getClass();
    Field[] fields = classType.getDeclaredFields();
    for (int i = 0; i < fields.length; i++) {

     Field field = fields[i];
     String fieldName = field.getName();
     //System.out.println("fieldName["+i+"]"+fieldName);
     String setMethodName = "set" + StringUtil.capitalize(fieldName);
     Method setMethod = classType.getMethod(setMethodName,
       new Class[] { field.getType() });
     //System.out.println("setMethod["+i+"]"+setMethod);

     setMethod.invoke(pojo, new Object[] { "setin" });
     System.out.println("pojo.getSchemaName()="+pojo.getSchemaName());
     pojo.getSchemaName();
    }
   } catch (Exception e) {
    e.printStackTrace();
   }

   try {
    TableProfilePOJO aab = new TableProfilePOJO();
    PropertyUtils.setProperty(aab, "idNo", "12");
    log.warn(PropertyUtils.getProperty(aab, "idNo"));
   } catch (Exception e) {
    e.printStackTrace();
   }

ArrayList list=new ArrayList();

   list.add("1");
   list.add("2");
   list.add("3");
   list.add("4");
   list.add("5");

for(int i=0;i<list.size();i++){

log.warn(list.get(i));

}