BeanGenerator_3
/** * Step 1:根据beanExcelPath路径，导入所有Bean到beans */private void importBeans() {Bean bean = null;//获取页签个数，从第二个页签开始，每个页签为一个beanint sum = this.hssfWorkbook.getNumberOfSheets();for (int excelBeanIndex = 1; excelBeanIndex < sum; excelBeanIndex++) {//将页签内容解析生成beanbean = importBean(excelBeanIndex);beans.add(bean);}}private Bean importBean(int excelBeanIndex) {Bean bean = null;String beanName = null;String beanNote = null;String since = null;String version = null;String author = null;List<Parameter> parameters = new ArrayList<Parameter>();Parameter parameter = null;String parameterName = null;String parameterNote = null;String parameterClazz = null;int beginParameter = 1;hssfSheet=hssfWorkbook.getSheetAt(excelBeanIndex);beanName = hssfWorkbook.getSheetName(excelBeanIndex);beanNote = cellValue(0, 1);since = Util.date2String(new Date(), "yyyy/MM/dd");version = cellValue(0, 3);author = cellValue(0, 4);while (true) {parameterName = cellValue(beginParameter+1, 0);if (Util.isNullOrEmpty(parameterName))break;parameterNote = cellValue(beginParameter+1, 4);// TODO 数据库字段类型转换成java基本类型parameterClazz = cellValue(beginParameter+1, 1);parameter = new Parameter(parameterName, parameterNote,parameterClazz);parameters.add(parameter);beginParameter++;}bean = new Bean(beanName, beanNote, since, version, author, parameters);return bean;}/** * Step 2:根据模板地址，返回模板的字符串 * @param templatePath 某一个模板地址 * @return 读出模板的所有字符 */private String importTemplate(String templatePath, Bean bean) {String s, temp = new String(), result = new String();try {bufferedReader = new BufferedReader(new FileReader(templatePath));while ((s = bufferedReader.readLine()) != null) {if (s.indexOf(PARAMETER_FOR_BEGIN) > 0) {while (true) {s = bufferedReader.readLine();if (s == null || s.indexOf(PARAMETER_FOR_END) > 0)break;temp += s + "\n";}result += convertBean(temp, bean);temp = "";} else {result += convert(s, bean) + "\n";}}} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}return result;}private String convertBean(String s, Bean bean) {String result = "";String temp;List<Parameter> parameters = bean.getParameters();for (Parameter parameter : parameters) {temp = s;result += converParameter(temp, parameter);}return result;}?