我也来玩玩反射(reflect of java)

不说P话,直接上码:

 

  package com.hzmagix.utils; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.lang.reflect.Constructor; import java.lang.reflect.InvocationTargetException; import java.text.DateFormat; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.util.Date; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFDateUtil; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import com.hzmagix.model.Flight; public class ExcelParsetUtils { public static SimpleDateFormat format = new SimpleDateFormat( "yyyy-MM-dd HH:mm:ss"); // TODO private static File exlfile = new File("F://flight_example.xls"); private static int celllenth = 11; private static Object parset(Object clazz, String vars) { System.out.println(vars); Class clz = clazz.getClass(); String strs[] = vars.split(","); Constructor ctor[] = clz.getDeclaredConstructors(); try { for (Constructor c : ctor) { Class cx[] = c.getParameterTypes(); if (cx.length == 0) { System.out.println(format.format(new Date()) + " DEBUG:无法解析无参构造函数!!!"); continue; } if (cx.length != strs.length + 1) { // 不构造ID System.out.println(format.format(new Date()) + " ERROR:参数传入错误!!!"); continue; } Object args[] = new Object[cx.length]; for (int i = 1; i < cx.length; i++) {// 忽略ID if (cx[i].isInstance(new Long(321))) { args[i] = new Long(strs[i]); } else if (cx[i].isInstance(new String("STRING TEST"))) { args[i] = new String(strs[i]); } else if (cx[i].isInstance(new Date())) { args[i] = new Date();// 暂不维护 } } Object obj = Class.forName(clazz.getClass().getName()) .getConstructor(cx).newInstance(args); System.out.println(obj); return obj; } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (IllegalArgumentException e) { e.printStackTrace(); } catch (SecurityException e) { e.printStackTrace(); } catch (InstantiationException e) { e.printStackTrace(); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (InvocationTargetException e) { e.printStackTrace(); } catch (NoSuchMethodException e) { e.printStackTrace(); } return null; } public static void parset(File exlfile, Object clazz, int cellength) { try { FileInputStream in = new FileInputStream(exlfile.getPath()); HSSFWorkbook workbook = new HSSFWorkbook(in); HSSFSheet sheet = workbook.getSheetAt(0); int rows = sheet.getPhysicalNumberOfRows(); DecimalFormat df = new DecimalFormat("#"); DateFormat format = new SimpleDateFormat("yyyy-MM-dd"); for (int i = 1; i < rows; i++) {// 第一行为标题 // Traffic wt = new Traffic(); HSSFRow row = sheet.getRow(i); if (row != null) { // 开始取行下的列 StringBuffer sb = new StringBuffer(); for (short j = 0; j < cellength; j++) { HSSFCell cell = row.getCell(j); Date date = new Date(); String stringValue = new String(); if (cell != null) { // 判断是什么类型的数据 switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_NUMERIC: stringValue = df.format(cell .getNumericCellValue()); if (HSSFDateUtil.isCellDateFormatted(cell)) { double d = cell.getNumericCellValue(); date = HSSFDateUtil.getJavaDate(d); } break; case HSSFCell.CELL_TYPE_STRING: stringValue = cell.getStringCellValue(); break; } } sb.append(stringValue); sb.append(","); } String s = sb.substring(0, sb.toString().length() - 1); // TODO FFF parset(clazz, s); } } // for (Traffic wt : trafficList) { // trafficManager.save(wt);// 保存 // } } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } // toexl(); System.out.println("end!!!"); } public static void main(String[] args) { Flight tr = new Flight(); parset(exlfile, tr, celllenth); } } 

 

 

  其实要实现的功能很简单,把excel表单以批量形式写入到数据库,可是每次根据不同的BEAN写一样的代码,真是件效率低下而且很让电脑浪费资源,最后令程序员后期非常难以维护的一件事($_$废话!),以前就有用过反射,可以根据给定的类然后生成一个实例,拿到实例后,调用Hibernate saveOrupdate来维护到持久层.(具体保存方法因人因时而宜.)所以我花了一下午的时间把这个写好了.不知道有没有用,反正好用!