lu.java

Java实现的通讯录系统

package lu;
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class Lu 
{
	public static void main(String args[])
	{
		new Login();		
	}
}
class Login extends Frame
{
	Label lno,lpass,lwelcome;
        TextField tno,tpass;
	Button blogin,bexit; 
	Login()
	{
		super("登录窗口");
		setLayout(new FlowLayout());
                Font fb = new Font("Helvetica", Font.BOLD, 40);                
                lwelcome=new Label("欢迎来到通讯录管理系统");
                lwelcome.setForeground(new Color(120,12,89));
                lwelcome.setFont(fb);
		lno=new Label("学号");
		lpass=new Label("密码");
		tno=new TextField(12);
		tpass=new TextField(12);
		blogin=new Button("登录");
		bexit=new Button("退出");
		tpass.setEchoChar('*');
		blogin.addActionListener(
				                 new ActionListener()
				                  {
				                	  public void actionPerformed(ActionEvent e)
				                	  {
				                		  
				                		  new MainWindow().setVisible(true);
                                                                  setVisible(false);
				                	  }
				                  }
		                         );
		bexit.addActionListener(
				                 new ActionListener()
				                 {
				                	 public void actionPerformed(ActionEvent e)
				                	 {
				                		 System.exit(0);
				                	 }
				                 }
		                        );
                 add(lwelcome);
                 add(lno);                       
		add(tno);
		add(lpass);
		add(tpass);
		add(blogin);
		add(bexit);
		setBounds(120,120,500,380);
		setVisible(true);
	}
}

class MainWindow extends JFrame implements ActionListener//主界面
{
	JMenuBar jmenubar;
	JMenu madd,mdelete,mupdate,msearch,mexit;
	JMenuItem add,delete,update,search,exit;
	MainWindow()
	{
		super("通讯录管理系统");
		setLayout(new FlowLayout());
		jmenubar=new JMenuBar();
		madd=new JMenu("添加");
		mdelete=new JMenu("删除");
		mupdate=new JMenu("更新");
		msearch=new JMenu("查询");
		mexit=new JMenu("退出");
		add=new JMenuItem("添加记录");
		delete=new JMenuItem("删除记录");
		update=new JMenuItem("更新记录");
		search=new JMenuItem("查询记录");
		exit=new JMenuItem("退出系统");
		add.addActionListener(this);
		delete.addActionListener(this);
		update.addActionListener(this);
		search.addActionListener(this);
		exit.addActionListener(this);
		madd.add(add);
		mdelete.add(delete);
		mupdate.add(update);
		msearch.add(search);
		mexit.add(exit);
		jmenubar.add(madd);
		jmenubar.add(mdelete);
		jmenubar.add(mupdate);
		jmenubar.add(msearch);
        jmenubar.add(mexit);
        setJMenuBar(jmenubar);
        setBounds(100,100,600,360);
        setVisible(true);
        validate();		
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==add)
		{
			new AddWindow().setVisible(true);
		}
		else if(e.getSource()==delete)
		{
			new DeleteWindow().setVisible(true);
		}
		else if(e.getSource()==update)
		{
			new UpdateWindow().setVisible(true);
		}
		else if(e.getSource()==search)
		{
			new Search().setVisible(true);
		}
		else if(e.getSource()==exit)
		{
			System.exit(0);
		}
	}
}

class AddWindow extends JFrame implements ActionListener//增加窗口
{
	JLabel jname,jsex,jbirth,jphone,jaddress;
	JTextField tname,tsex,tbirth,tphone,taddress;
	JButton benter,bclear,bgoto,bexit;
	AddWindow()
	{
		super("增加窗口");
		setLayout(new FlowLayout());
		jname=new JLabel("姓名：");
		jsex=new JLabel("性别：");
		jbirth=new JLabel("生日：");
		jphone=new JLabel("电话：");
		jaddress=new JLabel("住址：");
		tname=new JTextField(12);
		tsex=new JTextField(12);
		tbirth=new JTextField(12);
		tphone=new JTextField(12);
		taddress=new JTextField(12);
		benter=new JButton("确定");
		bclear=new JButton("清空");
                bgoto=new JButton("返回");
		bexit=new JButton("退出");
		benter.addActionListener(this);
		bclear.addActionListener(this);
		bexit.addActionListener(this);
                bgoto.addActionListener(this);
		add(jname);
		add(tname);
		add(jsex);
		add(tsex);
		add(jbirth);
		add(tbirth);
		add(jphone);
		add(tphone);
		add(jaddress);
		add(taddress);
		add(benter);
		add(bclear);
		add(bexit);
                add(bgoto);
		setBounds(120,120,400,370);
		setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==benter)
		{
				Connection con;
				PreparedStatement sql;
				try
				{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
			    catch(ClassNotFoundException ee){}
			    try
			    {
			    	con=DriverManager.getConnection("jdbc:odbc:sun","","");
			    	sql=con.prepareStatement("INSERT INTO book VALUES(?,?,?,?,?)");
			    	sql.setString(1,tname.getText());
			    	sql.setString(2,tsex.getText());
			    	sql.setString(3,tbirth.getText());
			    	sql.setString(4, tphone.getText());
			    	sql.setString(5,taddress.getText());
			    	sql.executeQuery();
			    	JOptionPane.showMessageDialog(benter, "添加成功！");
			    	con.close();
			    }
			    catch(SQLException eee)
			    {
			    	System.out.println(""+eee);
			    }
			
		}
		else if(e.getSource()==bclear)
		{
			tname.setText(null);
			tsex.setText(null);
			tbirth.setText(null);
			tphone.setText(null);
			taddress.setText(null);
			
		}
                else if(e.getSource()==bgoto)
		{
			new MainWindow().setVisible(true);
                        setVisible(false);
		} 
		else if(e.getSource()==bexit)
		{
			System.exit(0);
		}
	}
}
class DeleteWindow extends JFrame implements ActionListener//删除窗口
{
	JLabel jname;
	JTextField tname;
	JButton bdelete,bexit,bgoto;
	DeleteWindow()
	{
		super("删除窗口");
		setLayout(new FlowLayout());
		jname=new JLabel("姓名");
		tname=new JTextField(12);
		bdelete=new JButton("删除");
                bgoto=new JButton("返回");
		bexit=new JButton("退出");
		bdelete.addActionListener(this);
		bexit.addActionListener(this);
                bgoto.addActionListener(this);
               
		add(jname);
		add(tname);
		add(bdelete);
		add(bexit);
                add(bgoto);
		setBounds(120,120,400,370);
		setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==bdelete)
		{
			Connection con;
			PreparedStatement sql;
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}
		    catch(ClassNotFoundException ee){}
		    try
		    {
		    	con=DriverManager.getConnection("jdbc:odbc:sun","","");
		    	sql=con.prepareStatement("DELETE FROM book WHERE name=?");
		    	sql.setString(1,tname.getText());
		    	sql.executeUpdate();
		    	JOptionPane.showMessageDialog(bdelete, "删除成功！");
		    	con.close();
		    }
		    catch(SQLException eee)
		    {
		    	System.out.println(""+eee);
		    }
			
		}
                 else if(e.getSource()==bgoto)
		{
			new MainWindow().setVisible(true);
                        setVisible(false);
		} 
		else if(e.getSource()==bexit)
		{
			System.exit(0);
		}
	}	
}
class UpdateWindow extends JFrame implements ActionListener//更新窗口
{
	JLabel jname,jsex,jbirth,jphone,jaddress;
	JTextField tname,tsex,tbirth,tphone,taddress;
	JButton benter,bclear,bgoto,bexit;
	UpdateWindow()
	{
		super("更新窗口");
		setLayout(new FlowLayout());
		jname=new JLabel("姓名：");
		jsex=new JLabel("性别：");
		jbirth=new JLabel("生日：");
		jphone=new JLabel("电话：");
		jaddress=new JLabel("住址：");
		tname=new JTextField(12);
		tsex=new JTextField(12);
		tbirth=new JTextField(12);
		tphone=new JTextField(12);
		taddress=new JTextField(12);
		benter=new JButton("更新");
		bclear=new JButton("清空");
                bgoto=new JButton("返回");
		bexit=new JButton("退出");               
		add(jname);
		add(tname);
		add(jsex);
		add(tsex);
		add(jbirth);
		add(tbirth);
		add(jphone);
		add(tphone);
		add(jaddress);
		add(taddress);
		add(benter);
		add(bclear);
                add(bgoto);
		add(bexit);
                benter.addActionListener(this);
                bclear.addActionListener(this);
                bgoto.addActionListener(this);
                bexit.addActionListener(this);
                setBounds(120,120,400,370);
		setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==benter)
		{
				Connection con;
				PreparedStatement sql;
				ResultSet rs;
				try
				{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
			    catch(ClassNotFoundException ee){}
			    try
			    {
			    	con=DriverManager.getConnection("jdbc:odbc:sun","","");
			    	sql=con.prepareStatement("UPDATE book SET name=?,sex=?,birth=?,phone=?,address=?");
			    	sql.setString(1,tname.getText());
			    	sql.setString(2,tsex.getText());
			    	sql.setString(3,tbirth.getText());
			    	sql.setString(4, tphone.getText());
			    	sql.setString(5,taddress.getText());
			    	sql.executeQuery();
			    	JOptionPane.showMessageDialog(benter,"更新成功!");
			    	con.close();
			    }
			    catch(SQLException eee)
			    {
			    	System.out.println(""+eee);
			    }
			
		}
		else if(e.getSource()==bclear)
		{
			tname.setText(null);
			tsex.setText(null);
			tbirth.setText(null);
			tphone.setText(null);
			taddress.setText(null);
			
		}
                 else if(e.getSource()==bgoto)
		{
			new MainWindow().setVisible(true);
                        setVisible(false);
		}
		else if(e.getSource()==bexit)
		{
			System.exit(0);
		}
	}
	
}
class Search extends JFrame implements ActionListener//查询窗口
{
	JLabel jname;
	JTextField tname;
	JButton bsearch,bexit,bgoto;
	JTextArea show;
	Search()
	{
		super("查询窗口");
		setLayout(new FlowLayout());
		jname=new JLabel("姓名");
		tname=new JTextField(12);
		bsearch=new JButton("查询");
		bexit=new JButton("退出");
                bgoto=new JButton("返回");
		show=new JTextArea(60,30);
		bsearch.addActionListener(this);
		bexit.addActionListener(this);
                bgoto.addActionListener(this);
		add(jname);
		add(tname);
		add(bsearch);
		add(bexit);
                add(bgoto);
		add(show);
		setBounds(120,120,400,370);
		setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==bsearch)
		{
			Connection con;
			PreparedStatement sql;
			ResultSet rs;
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}
		    catch(ClassNotFoundException ee){}
		    try
		    {
		    	con=DriverManager.getConnection("jdbc:odbc:sun","","");
		    	sql=con.prepareStatement("SELECT* FROM book WHERE name=?");
		    	sql.setString(1,tname.getText());
		        rs=sql.executeQuery();
		        while(rs.next())
    			{	
    				show.append("学号："+rs.getString(1)+"\n");
    			    show.append("姓名："+rs.getString(2)+"\n");
    			    show.append("性别："+rs.getString(3)+"\n");
    			    show.append("系别："+rs.getString(4)+"\n");
    			    show.append("住址："+rs.getString(5)+"\n");
    		    }
		    	con.close();
		    }
		    catch(SQLException eee)
		    {
		    	System.out.println(""+eee);
		    }
			
		}
                else if(e.getSource()==bgoto)
		{
			new MainWindow().setVisible(true);
                        setVisible(false);
		}
		else if(e.getSource()==bexit)
		{
			System.exit(0);
		}
	}
}