segment of test code

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

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

本文介绍了一个使用Java进行数据库操作的例子，并演示了如何通过正则表达式来验证字符串。文中涉及了数据库连接、SQL语句执行、字段名检查及正则表达式的编译与匹配过程。

{

{
??????????? 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++){< p="">

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

?? }

??? }