?? delwin.java
字號:
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
class DelWin extends JFrame implements ActionListener {
JTextField 刪除單詞_文本條;
JButton delbtn,cancelbtn;
Connection Con = null;
Statement Stmt = null;
DelWin()
{
super("刪除單詞");
this.setBounds(250,250,250,200);
this.setVisible(true);
JPanel p1 = new JPanel();
p1.add(new Label("輸入要刪除的單詞:"));
刪除單詞_文本條 = new JTextField(20);
p1.add(刪除單詞_文本條);
delbtn = new JButton("刪除");
cancelbtn = new JButton("取消");
p1.add(delbtn);p1.add(cancelbtn);
this.add(p1);
delbtn.addActionListener(this);
cancelbtn.addActionListener(this);
this.validate();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==delbtn)
{
if(刪除單詞_文本條.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()+"'";
String temp="DELETE FROM 表1 WHERE 單詞="+s1;
Stmt.executeUpdate(temp);
JOptionPane.showMessageDialog(this,"成功刪除記錄!","恭喜",
JOptionPane.WARNING_MESSAGE);
dispose();
break;
}
}
Con.close();
if(boo==false)
{
JOptionPane.showMessageDialog(this,"不存在此單詞!","警告",
JOptionPane.WARNING_MESSAGE);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -