modifywin.java

电子词典

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


class ModifyWin extends JFrame implements ActionListener
{
	JTextField 修改英语单词_文本条,修改汉语解释_文本条;
	
	JButton modifybtn,cancelbtn;
	
	Connection Con=null;
	
	Statement Stmt=null;
	
	ModifyWin()	
	{
		super("修改");
				
		this.setBounds(250,250,250,200);
		
		this.setVisible(true);
		
		JPanel p=new JPanel();
		
		p.add(new Label("输入英语单词:"));
		
		修改英语单词_文本条=new JTextField(20);
		
		p.add(修改英语单词_文本条);
		
		p.add(new Label("输入该单词修改的汉语解释:"));
		
		修改汉语解释_文本条=new JTextField(20);
		
		p.add(修改汉语解释_文本条);
		
		modifybtn=new JButton("提交");
		
		cancelbtn = new JButton("取消");
		
		p.add(modifybtn);p.add(cancelbtn);
		
		modifybtn.addActionListener(this);
		
		cancelbtn.addActionListener(this);
		
		this.add(p);
		
		this.validate();
				
	}
	
	
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==modifybtn)
		{
			
			if(修改英语单词_文本条.getText().equals("")||
			   
			   修改汉语解释_文本条.getText().equals(""))
			   
			{
				JOptionPane.showMessageDialog(this,"修改的单词或解释不能为空！","警告",
				
                    JOptionPane.WARNING_MESSAGE);

			}
			
			// 判断输入框不能为空
		else
		{				
			try{
				修改();
									
			   }
		
			catch(SQLException ee){}
		}
		
	  }
	  
	  else if(e.getSource()==cancelbtn)
	  {
	  	dispose();
	  }
	
	}
	
	
	public void 修改() throws SQLException   //实现修改功能
	{
		String cname,ename;
		
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		
		catch(ClassNotFoundException e){}
		
		Con = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=english\\english.mdb","","");
					
		Stmt=Con.createStatement();
		
		ResultSet rs=Stmt.executeQuery("SELECT * FROM 表1");
		
		boolean boo=false;
		
		while((boo=rs.next())==true)
		{
			ename=rs.getString("单词");
			
			cname=rs.getString("解释");
			
			if(ename.equals(修改英语单词_文本条.getText()))
			{
				String s1="'"+修改英语单词_文本条.getText().trim()+"'",s2="'"+修改汉语解释_文本条.getText().trim()+"'";
		
				String temp="UPDATE 表1 SET 解释="+s2+" WHERE 单词 = "+s1;
								
				Stmt.executeUpdate(temp);
					
				JOptionPane.showMessageDialog(this,"记录修改成功！","恭喜",
				
				JOptionPane.WARNING_MESSAGE);
				
				dispose();
				
				break;
			}
		}
		Con.close();	
		
		if(boo==false)
		{
			JOptionPane.showMessageDialog(this,"不存在此单词！","警告",
			
			JOptionPane.WARNING_MESSAGE);
		}
		
	}
}