indexpane.java

是mysql数据库数据导入程序是从excel中提取数据导入到mysql数据库中

package com.main;

import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;

import javax.swing.JButton;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
import javax.swing.JList;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextField;

import excel.read.Medium;
import excel.read.SetJListDate;

public class IndexPane extends JFrame implements MouseListener 
{

	private JButton jb1 = new JButton("浏览");
	private JButton jb2 = new JButton("读取");
	private JTextField jtf = new JTextField(30);
	public static JList jl = new JList();	
	private JFileChooser jfc = new JFileChooser();
	
	//显示界面
	public void read()
	{
		JPanel jp = new JPanel();
		jp.add(jtf);
		String[] str = {"请选择你的Excel表"};
		jl.setListData(str);
		jl.setVisibleRowCount(1);
		JScrollPane jsp = new JScrollPane(jl);
		jp.add(jsp);
		jp.add(jb1);
		jp.add(jb2);
		this.add(jp);
		this.pack();
		this.setVisible(true);
		
		jb1.addMouseListener(this);
		jb2.addMouseListener(this);
	}

	public void mouseClicked(MouseEvent e) 
	{
	
		/*
		 * 找到要导入的excel文件
		 */
		if(e.getSource() == jb1)
		{
			jfc.setToolTipText("打开");
			int r = jfc.showOpenDialog(this);
			String path = null;
			if (r == JFileChooser.APPROVE_OPTION) 
			{
				path = jfc.getSelectedFile().getAbsolutePath();//得到文件的路
				jtf.setText(path);
				new SetJListDate().fuzhi(path);
			}
		}
		
		/*
		 * 对excel操作
		 */
		if(e.getSource() == jb2)
		{
			new Medium().caseing(jtf.getText());
		}
	}

	public void mouseEntered(MouseEvent e) {
		// TODO Auto-generated method stub
		
	}

	public void mouseExited(MouseEvent e) {
		// TODO Auto-generated method stub
		
	}

	public void mousePressed(MouseEvent e) {
		// TODO Auto-generated method stub
		
	}

	public void mouseReleased(MouseEvent e) {
		// TODO Auto-generated method stub
		
	}
	
}