newsexcelframe.java

培训时做的学生管理系统.基于J2SE平台开发

package cn.com.studentsystem.excel;

import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import cn.com.studentsystem.classnews.ClassNews;

public class NewsExcelFrame  {
	JFrame jf;
	JButton jb1;
	JButton jb2 ;
	JTextField jt1 ;
	public NewsExcelFrame(){
		init();
		
	}
	
	public void init(){
	    jf = new JFrame();
		jf.setTitle("导出报表");
		jf.setSize(250, 150);
		jf.setLocationRelativeTo(null);
		
		
		JPanel jp = new JPanel();
		jp.setLayout(new FlowLayout(FlowLayout.CENTER,20,20));
		jb1 = new JButton("导出");
	    jb2 = new JButton("取消");
		
		JLabel jl1 = new JLabel("请输入表名");
	    jt1 = new JTextField(10);
		
	    jp.add(jl1);
	    jp.add(jt1);
	    jp.add(jb1);
	    jp.add(jb2);
	    
	    jf.add(jp);
	    jf.setVisible(true);
		
		class ExcelAction implements ActionListener{

			public void actionPerformed(ActionEvent arg0) {
				
				if(arg0.getActionCommand().equals("导出")){
                 String filename = "f:\\"+jt1.getText()+".xls";
                 int row_count = ClassNews.jt1.getRowCount();
                 Vector vector = new Vector();
					for(int i=0;i<row_count;i++){
						vector.add(ClassNews.dtm.getValueAt(i, 0));
						vector.add(ClassNews.dtm.getValueAt(i, 1));
						vector.add(ClassNews.dtm.getValueAt(i, 2));
					}
//					System.out.println(vector.get(3));
					WritableWorkbook workbook = NewsPutOutExcel.buildWorkBook(filename);
					WritableSheet sheet = NewsPutOutExcel.setExcel(workbook, row_count,vector);
						
//					try {
////						workbook.write();
////					    workbook.close();
//						} catch (WriteException e) {
//							// TODO Auto-generated catch block
//							e.printStackTrace();
//						}
//					catch (IOException e) {
//						// TODO Auto-generated catch block
//						e.printStackTrace();
//					}
					JOptionPane.showMessageDialog(null, "消息表已导出,存放在"+filename);
				    jf.dispose();
				}else if(arg0.getActionCommand().equals("取消")){
					jf.dispose();
				}
				
				
			}
			
		}
		ExcelAction excel_action = new   ExcelAction();
		jb1.addActionListener(excel_action);
		jb2.addActionListener(excel_action);
		
	}

}