insertemployee.java

没有什么难的

package UI;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.util.*;
import java.sql.*;
import DB.*;

class InsertEmployee extends JFrame implements ActionListener
{
	JLabel lID = new JLabel("ID");
	JLabel lName = new JLabel("姓名");
	JLabel lDept = new JLabel("部门");
	JLabel lEmail = new JLabel("邮箱");
	JLabel lTel = new JLabel("电话");

	JTextField tID = new JTextField();
	JTextField tName = new JTextField();
	JTextField tDept = new JTextField();
	JTextField tEmail = new JTextField();
	JTextField tTel = new JTextField();

	JButton btSave = new JButton("保存");
	
	String sID = null;
	String sName = null;
	String sDeptName = null;
	String sEmail = null;
	String sTel = null;
	DB db;
	JList list = new JList();
	int index = 0;
	public InsertEmployee(JList list,int index)
	{
		db = new DB();
		this.list = list;
		this.index = index;
		
		this.setLayout(null);
		lID.setBounds(50,50,90,35);
		lName.setBounds(50,100,90,35);
		lDept.setBounds(50,150,90,35);
		lEmail.setBounds(50,200,90,35);
		lTel.setBounds(50, 250, 90, 35);

		tID.setBounds(150,50,200,35);
		tName.setBounds(150,100,200,35);
		tDept.setBounds(150,150,200,35);
		tEmail.setBounds(150,200,200,35);
		tTel.setBounds(150, 250, 200, 35);

		btSave.setBounds(100,300,70,35);
		btSave.addActionListener(this);

		this.add(lID);this.add(lName);this.add(lDept);this.add(lEmail);this.add(lTel);
		this.add(tID);this.add(tName);this.add(tDept);this.add(tEmail);this.add(tTel);
		this.add(btSave);
		
		this.setSize(500,400);
		this.setVisible(true);
		

	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource() == btSave)
		{
			sID = tID.getText();
			sName = tName.getText();
			sDeptName = tDept.getText();
			sEmail = tEmail.getText();
			sTel = tTel.getText();
			String sqlInsert = "insert into employee(id,name,deptName,email,tel)" +
			"values('"+sID+ "','"+sName+"','"+sDeptName+"','"+sEmail+"','"+sTel+"')";
			db.update(sqlInsert);
			db.close();
			this.dispose();
			
			((DefaultListModel)list.getModel()).addElement(sName);			
			list.setSelectedIndex(index);
            list.ensureIndexIsVisible(index);
		}	
	}
	public static void main(String args[])
	{
		JFrame f = new InsertEmployee(new JList(),0);
		//f.add(new InsertEmployee());
		f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		f.setSize(500,400);
		f.setVisible(true);
	}
}