全球参数APN工具代码集成

ApnToolView.java 主类，负责导入Excel表格然后解析

package com.hq.lipeng;

import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;

import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.filechooser.FileNameExtensionFilter;

public class ApnToolView extends JFrame {

 private JLabel jl1, jl2, jl3, jl4;
 private JPanel jp0, jp1, jp2, jp3, jp4, jp5, jp6, jp7, jp8, jp9;
 private JTextField jtf1, jtf2, jtf3, jtf4;
 private JButton jb1, jb2, jb3, jb4, jb5, jb6, jb7;
 private JCheckBox jcb1, jcb2, jcb3;
 private JTextArea jta1, jta2, jta3;
 private boolean mark1 = false, mark2 = false;
 private String excelpath = "";
 String currentpath = System.getProperty("user.dir");
 String eccwithsim = "", eccwithoutsim = "", apnxml = "", voicemailxml = "";


 public static void main(String[] args) {
  new ApnToolView();
 }

 public ApnToolView() {
  jp1= new JPanel();
  jp2=new JPanel();
  jtf1 = new JTextField(15);
  jb1 = new JButton("ChooseExcel");
  jb2 = new JButton("CreateTheXML");
  jp1.add(jtf1);
  jp1.add(jb1);
  jp2.add(jb2);
  this.add(jp1);
  this.add(jp2);
  super.setTitle("xml生成及比对工具");
  this.setLayout(new GridLayout(2, 2, 0, 0));
  Dimension d = Toolkit.getDefaultToolkit().getScreenSize();
  this.setBounds((d.width - 300) / 2, (d.height - 300) / 2, 310, 150);
  this.setResizable(true);
  this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  this.setVisible(true);
  jb1.addActionListener(new ActionListener() {

   public void actionPerformed(ActionEvent e) {
    JFileChooser chooser = new JFileChooser(new File(""));
    FileNameExtensionFilter filter = new FileNameExtensionFilter(
      "excel(*.xls)", "xls");
    chooser.setFileFilter(filter);
    int returnVal = chooser.showOpenDialog(null);
    if (returnVal == JFileChooser.APPROVE_OPTION) {
     try {

      excelpath = chooser.getSelectedFile().getAbsolutePath();
      String str = "XML文件已在当前目录生成生成";
      jtf1.setText(excelpath);

     } catch (Exception ex) {
     }
    }

   }

  });
  jb2.addActionListener(new ActionListener() {

   @Override
   public void actionPerformed(ActionEvent e) {
    CustomType apne2x = new CustomType();
    apne2x.getExcel(excelpath);
    if(apne2x.mark){
     JOptionPane.showMessageDialog(rootPane, "apn-conf.xml文件已生成");
    }else{
     JOptionPane.showMessageDialog(rootPane, "生成程序有错",
       "WARMING", JOptionPane.WARNING_MESSAGE);
    }
   }});
 }

}

CystomType.java 解析类，将excel表格里面内容转化为xml格式

package com.hq.lipeng;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apac