dic.java

实现英汉,汉英单词查询,添加,修改,删除功能,界面友好!

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import sun.audio.*;
import javax.swing.JOptionPane;


 class DataWindow extends JFrame implements ActionListener
{
	JFrame topFrame;
	JDesktopPane desktop;
	JTextField englishtext;
	JTextArea chinesetext;
	JButton b1,b2,b3,b4,b5;
	JLabel label;
	JMenuBar mbar;
	public JMenu mfile,medit,mhelp,mlogin,mfun;
	public JMenuItem edic,cdic,back_data,quit,addedit,modedit,deledit,hhelp,about,login,change,zhuxiao,story;
	
     
	DataWindow()
	{
		super("                                                                        " +
				"    英汉小词典                                                                        ");
		this.setBounds(250,250,600,400);
		this.setVisible(true);
	
	    getContentPane().add(new JScrollPane(chinesetext));
		mbar = new JMenuBar();
		setJMenuBar(mbar);
		mbar.setOpaque(true);
		mfile = new JMenu("文件");
		medit = new JMenu("编辑");
		mhelp = new JMenu("帮助");
		mlogin=new JMenu("登陆");
		mfun=new JMenu("娱乐一下");
		mbar.add(mfile);mbar.add(medit);mbar.add(mhelp);mbar.add(mlogin);mbar.add(mfun);
		story=new JMenuItem("听故事");
		mfun.add(story);
		edic = new JMenuItem("英汉词典");
		cdic = new JMenuItem("汉英词典");
		quit = new JMenuItem("  退出");//文件菜单
		addedit = new JMenuItem("添加词汇");
		modedit = new JMenuItem("修改词汇");
		deledit = new JMenuItem("删除词汇");//编辑菜单
		hhelp = new JMenuItem("帮助");
		about = new JMenuItem("关于...");//帮助菜单
		login=new JMenuItem("创建用户");
		change=new JMenuItem("修改密码");
		zhuxiao=new JMenuItem("用户注销");//登陆菜单
		mlogin.add(login);
		mlogin.add(change);
		mlogin.add(zhuxiao);
		mfile.add(edic);
		mfile.add(cdic);
		mfile.addSeparator();
		mfile.add(quit);  //mfile
		medit.add(addedit);
		medit.add(modedit);
		medit.add(deledit);
		//medit.setEnabled(false);//medit
		mhelp.add(hhelp);
		mhelp.add(about);   //mhelp
		story.addActionListener(this);
		login.addActionListener(this);
		change.addActionListener(this);
		zhuxiao.addActionListener(this);
		edic.addActionListener(this);
		cdic.addActionListener(this);
		quit.addActionListener(this);
		addedit.addActionListener(this);
		modedit.addActionListener(this);
		deledit.addActionListener(this);
		hhelp.addActionListener(this);
		about.addActionListener(this);
		englishtext = new JTextField(16);
		englishtext.setFont(new Font("",15,15));
		chinesetext = new JTextArea(8,15);
		chinesetext.setEditable(false);
		chinesetext.setFont(new Font("",25,25));
		chinesetext.setBackground(new Color(175,238,238));
		b1 = new JButton("查询");
		b2 = new JButton("添加");
		b3 = new JButton("修改");
		b4 = new JButton("刪除");
		b5 = new JButton("发音");
		JPanel p1 = new JPanel(),p2 = new JPanel();//添加面板
		mbar.setBackground(new Color(175,238,238));
		p1.setBackground(new Color(175,238,238));
		p2.setBackground(new Color(175,238,238));
		englishtext.setBackground(new Color( 248,248,255));
		b1.setBackground(new Color( 175,238,238));
		b2.setBackground(new Color( 175,238,238));
		b3.setBackground(new Color( 175,238,238));
		b4.setBackground(new Color( 175,238,238));
		b5.setBackground(new Color( 175,238,238));
		label = new JLabel("输入要查询的英语单词:");
		label.setFont(new Font("隶书",20,20));
		p1.add(label);
		p1.add(englishtext);p1.add(b1);p1.add(b5);
		p2.add(b2);p2.add(b3);p2.add(b4);
		//b2.setEnabled(false);b3.setEnabled(false);b4.setEnabled(false);
		this.add(p1,"North");
		this.add(p2,"South");
		this.add(new JScrollPane(chinesetext),"Center");
		b1.addActionListener(this);
		b2.addActionListener(this);
		b3.addActionListener(this);
		b4.addActionListener(this);
		b5.addActionListener(this);
		englishtext.addActionListener(this);
	}




	public void actionPerformed(ActionEvent e) //实现按钮监听
	{				
		if(e.getSource()==b1||e.getSource()==englishtext)
		{
			chinesetext.setText("");
			
			if(englishtext.getText().equals(""))
			{
				JOptionPane.showMessageDialog(this,"请输入单词！","SORRY",
				
				JOptionPane.WARNING_MESSAGE);
			}
			
		else{
			
			try{	Listwords();	}
			catch(SQLException ee){  }
		    }
		} 
		else if(e.getSource()==b2||e.getSource()==addedit)
		{
		 AddWin add = new AddWin();    //AddWin是添加窗口的类
			
		}
		else if(e.getSource()==b3||e.getSource()==modedit)
		{
		 ModifyWin modi = new ModifyWin(); //ModifyWin是修改窗口的类
		}
		else if(e.getSource()==b4||e.getSource()==deledit)
		{
		 DelWin del = new DelWin();   //DelWin是删除窗口的类
		}
		else if(e.getSource()==b5)//发音
		{
			JOptionPane.showMessageDialog(this,"还没实现该功能！","SORRY",
					JOptionPane.WARNING_MESSAGE);
		}
		else if(e.getSource()==edic) //英汉
		{
			label.setText("输入要查询的英语单词:");
			englishtext.setText("");
			chinesetext.setText("");
		}
		else if(e.getSource()==cdic) //汉英
		{
			label.setText("输入要查询的汉语意思:");
			englishtext.setText("");
			chinesetext.setText("");
		}
		
		
		else if(e.getSource()==quit) //退出
		{
			System.exit(0);
		}
		
		else if(e.getSource()==about)  //关于
		{
			final String AboutMsg = "一个小小的电子词典\n \n"
			+"实现了简单的查询,增添功能,希望你用得愉快\n \n"
			+"感谢使用\n \n"
			+"毕业设计:made by lvfei";
			JOptionPane.showMessageDialog(topFrame,AboutMsg);
		}
		
		else if(e.getSource()==hhelp)  //帮助
		{
			HelpFrame help = new HelpFrame();
			help.setVisible(true);
		}
		else if(e.getSource()==login)
		{
			new Creat();
			
		}
		else if(e.getSource()==change)
		{
			new Password();
		}
		else if(e.getSource()==zhuxiao)
		{
			new Login();
			dispose();
			
		}
		else if(e.getSource()==story)
		{
			JOptionPane.showMessageDialog(this, "从前有坐山", "上当啦", JOptionPane.WARNING_MESSAGE);
		}

	}
	
	public void Listwords() throws SQLException  //实现查询功能
	{
		String cname,ename;
		String conURL="jdbc:odbc:test2";
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){}
		//建立桥接器
		Connection Ex1Con = DriverManager.getConnection(conURL);
		Statement Ex1Stmt = Ex1Con.createStatement();
		if(label.getText().equals("输入要查询的英语单词:"))
		{
			ResultSet rs = Ex1Stmt.executeQuery("SELECT * FROM 表1");
			while( rs.next())
			{
				ename = rs.getString("单词");
				cname = rs.getString("解释");
				if(ename.equals(englishtext.getText()))
				{
					chinesetext.append(cname+'\n');
				}
			}
			Ex1Con.close();  //关闭数据库
			if(chinesetext.getText().equals(""))
			{
				JOptionPane.showMessageDialog(this,"查无此单词！","SORRY",
				JOptionPane.WARNING_MESSAGE);
			}
		}
		else if(label.getText().equals("输入要查询的汉语意思:"))
		{
			ResultSet rs=Ex1Stmt.executeQuery("SELECT * FROM 表1 WHERE 解释 LIKE '%"+englishtext.getText()+"%'");
			while(rs.next())
			{
				ename = rs.getString("单词");
				cname = rs.getString("解释");
				chinesetext.append(ename+'\n');
			}
			Ex1Con.close();  //关闭数据库
			if(chinesetext.getText().equals(""))
			{
				JOptionPane.showMessageDialog(this,"查无此单词！","SORRY",
				JOptionPane.WARNING_MESSAGE);
			}
		}
		
	}   
}
public class Dic
{
	public static void main(String args[])
	{  
		JFrame.setDefaultLookAndFeelDecorated(true);
		DataWindow dw=new DataWindow();
		dw.validate();
	}
	 
}