word.java

电子词典源代码

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

import java.awt.event.*;

class WordWindow extends JFrame implements ActionListener
{
	JMenuBar m_bar=new JMenuBar();
	JMenu m_file=new JMenu("文件"),m_edit=new JMenu("编辑"),m_help=new JMenu("帮助");
	JMenuItem m_insert=new JMenuItem("添加"),m_delect=new JMenuItem("删除"),
	m_update=new JMenuItem("修改"),m_select=new JMenuItem("查询"),m_exit=new JMenuItem("退出"),
	m_link=new JMenuItem("联系我们");
	Connection con=null;
	Statement stm=null;
	
	String conURL="jdbc:mysql://localhost/WordDataBase?user=root&password=root";
	
	
	
	WordWindow()
	{
		super("电子字典1.0");
		link_database();
		
		m_file.add(m_insert);m_insert.setEnabled(true);
		m_file.add(m_delect);m_delect.setEnabled(true);
		m_file.addSeparator();
		m_file.add(m_exit);m_exit.setEnabled(true);
		
		m_edit.add(m_update);m_update.setEnabled(true);
		m_edit.add(m_select);m_select.setEnabled(true);
		
		m_help.add(m_link);m_link.setEnabled(true);
		
		m_edit.addActionListener(this);
		m_insert.addActionListener(this);
		m_delect.addActionListener(this);
		m_update.addActionListener(this);
		m_select.addActionListener(this);
		m_link.addActionListener(this);
		m_exit.addActionListener(this);
		
		
		m_bar.add(m_file);
		m_bar.add(m_edit);
		m_bar.add(m_help);
		setJMenuBar(m_bar);
		
		setBounds(150,150,400,250);
		setVisible(true);
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e)
			{
				try{
					stm.close();
					con.close();
					
				}
				catch(SQLException e1)
				{
					e1.printStackTrace();
				}
				System.exit(0);
			}
		});
		
		}
	public void actionPerformed(ActionEvent ee)
	{
		if(ee.getSource()==m_exit)
		{
			try{
				stm.close();
				con.close();
				
			}
			catch(SQLException e)
			{
				e.printStackTrace();
			}
			
			System.exit(0);
		}
		else if(ee.getSource()==m_insert)
		{
			
			new InsertListener().Lanuch();
			
		}
		else if(ee.getSource()==m_delect)
		{
			new DelectListener().Lanuch();
		}
		else if(ee.getSource()==m_update)
		{
			new UpdateListener().Lanuch();
		}
		else if(ee.getSource()==m_select)
		{
		
			new SelectListener().Lanuch();
		}
		else if(ee.getSource()==m_link)
		{
			
			JInternalFrame intf;
			JLabel lb;
			JTextField tf;
			JTextArea ta;
			JButton bt;
			intf=new JInternalFrame("欢迎你使用我们的产品！",true,true,true,true);
			intf.setSize(50,50);
			intf.setVisible(true);
			ta=new JTextArea(10,40);
			intf.add(ta);
			add(intf);
			ta.setText("感谢大家，感谢广大人民群众！哈哈！" +
					"\n"+"~~~~~~~_~~~~~~~");
		}
		
	}
	
	
	private class InsertListener implements ActionListener
	{
		JInternalFrame intf;
		JLabel lb1,lb2;
		JTextField tf1,tf2;
		JTextArea ta;
		JButton bt1;
		
		public void Lanuch()
		{
			
			intf=new JInternalFrame("添加",true,true,true,true);
			intf.setSize(50,50);
			intf.setVisible(true);
			JPanel p=new JPanel();
			JPanel p2=new JPanel();
			JPanel p3=new JPanel();
			lb1=new JLabel("输入新的单词：");
			lb2=new JLabel("输入单词解释:");
			tf2=new JTextField(40);
			tf1=new JTextField(40);
			ta=new JTextArea(10,40);
			tf1.setText("");
			tf2.setText("");
			ta.setText("提示：");
			bt1=new JButton("添加");
			JPanel p1=new JPanel();
			p1.setLayout(new GridLayout(1,2));
			p1.add(lb1);p1.add(tf1);
			p2.setLayout(new GridLayout(1,2));
			p2.add(lb2);p2.add(tf2);
			p.setLayout(new GridLayout(2,1));
			
			p.add(p1);p.add(p2);
			p3.setLayout(new GridLayout(1,2));
			p3.add(p);p3.add(bt1);
			intf.setLayout(new BorderLayout());
			intf.add(p3,"North");
			intf.add(ta,"Center");
			add(intf);
			bt1.addActionListener(this);
		}
		public void actionPerformed(ActionEvent e)
		{
			
			raise();
			tf1.setText("");
			tf2.setText("");
			
		}
		public void raise()
		{
			String str1=tf1.getText().trim();
			String str2=tf2.getText().trim();
			if((str1.equals(""))||(str2.equals("")))
			{
				ta.setText("提示：单词和解释都不能为空！");
				
			}
			else
			{
				String temp="insert into wordtest values('"+str1+"','"+str2+"')";
				
			
			  try{
				  con=DriverManager.getConnection(conURL);
				  stm.executeUpdate(temp);
				  ta.setText("提示:添加成功");
				
			  }
			   catch(SQLException e1)
			   {
				e1.printStackTrace();
			   }
			}
		}
	}
	private class DelectListener implements ActionListener
	{
		JInternalFrame intf;
		JLabel lb;
		JTextField tf;
		JTextArea ta;
		JButton bt1;
		public void Lanuch()
		{
		
			intf=new JInternalFrame("删除",true,true,true,true);
			intf.setSize(50,50);
			intf.setVisible(true);
			JPanel p=new JPanel();
			lb=new JLabel("输入删除的单词：");
			tf=new JTextField(40);
			
			ta=new JTextArea(10,40);
			bt1=new JButton("删除");
			JPanel p1=new JPanel();
			p1.setLayout(new GridLayout(1,3));
			p1.add(lb);p1.add(tf);p1.add(bt1);
			
			p.setLayout(new BorderLayout());
			p.add(p1,"North");
			p.add(ta,"Center");
			intf.setLayout(new BorderLayout());
			intf.add(ta,"Center");
			intf.add(p,"North");
			add(intf);
			bt1.addActionListener(this);
		}
		public void actionPerformed(ActionEvent e)
		{
			
				Delect();
				tf.setText("");
				
		}
		public void Delect()
		{
			String str=tf.getText().trim();
			try{
				con=DriverManager.getConnection(conURL);
				ResultSet rs=stm.executeQuery("select * from wordtest");
				while(rs.next())
				{
					String ename=rs.getString("english");
					if(ename.equals(str))
					{
						PreparedStatement ps=con.prepareStatement("delete from wordtest where english=?");
						ps.setString(1,""+str+"");
						ps.executeUpdate();
						ta.setText("删除成功");
						break;
					}
					else
					{
						ta.setText("提示：需要删除的单词不存在!请注意单词是否书写正确。");
					}
				
				}
				
			}
			catch(SQLException e1)
			{
				e1.printStackTrace();
			}
		}
	}
	private class UpdateListener implements ActionListener
	{
		JInternalFrame intf;
		JLabel lb1,lb2;
		JTextField tf1,tf2;
		JTextArea ta;
		JButton bt1;
		
		public void Lanuch()
		{
			
			intf=new JInternalFrame("修改",true,true,true,true);
			intf.setSize(50,50);
			intf.setVisible(true);
			JPanel p=new JPanel();
			JPanel p2=new JPanel();
			JPanel p3=new JPanel();
			lb1=new JLabel("输入修改单词：");
			lb2=new JLabel("输入修改解释:");
			tf2=new JTextField(40);
			tf1=new JTextField(40);
			ta=new JTextArea(10,40);
			ta.setText("");
			bt1=new JButton("修改");
			JPanel p1=new JPanel();
			p1.setLayout(new GridLayout(1,2));
			p1.add(lb1);p1.add(tf1);
			p2.setLayout(new GridLayout(1,2));
			p2.add(lb2);p2.add(tf2);
			p.setLayout(new GridLayout(2,1));
			
			p.add(p1);p.add(p2);
			p3.setLayout(new GridLayout(1,2));
			p3.add(p);p3.add(bt1);
			intf.setLayout(new BorderLayout());
			intf.add(p3,"North");
			intf.add(ta,"Center");
			add(intf);
			bt1.addActionListener(this);
		}
		public void actionPerformed(ActionEvent e)
		{
			Update();
			tf1.setText("");
			tf2.setText("");
		}
		public void Update()
		{
			String str1=tf1.getText().trim();
			String str2=tf2.getText().trim();
			
			try{
				con=DriverManager.getConnection(conURL);
				ResultSet rs=stm.executeQuery("select * from wordtest");
				
			
				while(rs.next())
				{
					String ename=rs.getString("english");
					if(ename.equals(str1))
				
					{
				    
						PreparedStatement ps=con.prepareStatement("update wordtest set chinese=? where english=?");
				     
						ps.setString(1, ""+str2+"");
						ps.setString(2, ""+str1+"");
				     
						ps.executeUpdate();
				     
						ta.setText("修改成功");
				     
						break;
				
					}
				
					else
				
					{
					    ta.setText("提示:需要修改的单词不存在，请注意单词是否书写正确.");
				
					}
				
				}
			
			}
			catch(SQLException e1)
			{
				e1.printStackTrace();
			}
		}
	}
	private class SelectListener implements ActionListener
	{
		JInternalFrame intf;
		JLabel lb;
		JTextField tf;
		JTextArea ta;
		JButton bt1;
		public void Lanuch()
		{
			
			intf=new JInternalFrame("查询",true,true,true,true);
			intf.setSize(50,50);
			intf.setVisible(true);
			JPanel p=new JPanel();
			lb=new JLabel("输入需要查询的词：");
			tf=new JTextField(40);
			tf.setText("");
			ta=new JTextArea(10,40);
			ta.setText("");
			bt1=new JButton("查询");
			JPanel p1=new JPanel();
			p1.setLayout(new GridLayout(1,3));
			p1.add(lb);p1.add(tf);p1.add(bt1);
			
			p.setLayout(new BorderLayout());
			p.add(p1,"North");
			p.add(ta,"Center");
			intf.add(p);
			add(intf);
			bt1.addActionListener(this);
		}
		public void actionPerformed(ActionEvent e)
		{
			Select();
			tf.setText("");
		}
		public void Select()
		{
			String ename,cname;
			String str=tf.getText().trim();
			

			try{
				con=DriverManager.getConnection(conURL);
				ResultSet rs=stm.executeQuery("select * from wordtest");
				while(rs.next())
				{
					ename=rs.getString("english");
					cname=rs.getString("chinese");
					if(ename.equals(str))
					{
						ta.setText(ename+" "+cname);
						break;
					}
					else
					{
						ta.setText("该单词不存在或者没有添加，如果有请注意添加！");
					}
				}
				
			}
			catch(SQLException e1)
			{
				e1.printStackTrace();
			}
		}
			
		
	}
	public void link_database()
	{
		try{
			Class.forName("com.mysql.jdbc.Driver");
			con=DriverManager.getConnection(conURL);
			stm=con.createStatement();
			
		}
		catch(ClassNotFoundException e)
		{
			System.out.println("Not Found DataBase:"+e.getMessage());
		}
		catch(SQLException e)
		{
			System.out.println("SQLException :"+e.getMessage());
		}
	}

}
public class Word {

	public static void main(String[] args)
	{
		WordWindow window=new WordWindow();
		window.validate();
	}

}