addinf.java

我们学完java后的一个综合作业

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

class addinf implements ActionListener{
	JDialog dialog;
	JTextField tF1=new JTextField();
	JTextField tF2=new JTextField();
	JTextField tF3=new JTextField();
	JTextField tF4=new JTextField();
	addinf(JFrame f)
	{
		dialog=new JDialog(f,"添加联糸人",true);
		Container dialogPane=dialog.getContentPane();
		dialogPane.setLayout(new GridLayout(5,2));
		dialogPane.add(new JLabel("姓名:",SwingConstants.CENTER));
		dialogPane.add(tF1);
		dialogPane.add(new JLabel("地址:",SwingConstants.CENTER));
		dialogPane.add(tF2);
		dialogPane.add(new JLabel("电话:",SwingConstants.CENTER));
		dialogPane.add(tF3);
		dialogPane.add(new JLabel("电子邮箱:",SwingConstants.CENTER));
		dialogPane.add(tF4);
		JButton b1=new JButton("确定");
		dialogPane.add(b1);
		JButton b2=new JButton("取消");
		dialogPane.add(b2);
		b1.addActionListener(this);
		b2.addActionListener(this);
		dialog.setBounds(200,150,400,130);
		dialog.getRootPane().setDefaultButton(b1);
		dialog.setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{
		String cmd=e.getActionCommand();
		if(cmd.equals("确定"))
		{
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=
				DriverManager.getConnection("jdbc:odbc:notebook","zxp","121");
			Statement stmt=con.createStatement();
			String name=tF1.getText();
			String add=tF2.getText();
			String phone=tF3.getText();
			String mail=tF4.getText();
			String SQLOrder="INSERT INTO phone VALUES('"
				+name+"','"+add+"','"+phone+"','"+mail+"')";
			dialog.dispose();
			JOptionPane.showMessageDialog(dialog,"添加成功");
			stmt.executeUpdate(SQLOrder);
			stmt.close();
			con.close();
		}catch(Exception ex){System.exit(0);}
		}
		else if(cmd.equals("取消")){
			dialog.dispose();
		}
	}
}