Java程序设计 6 btnQuery.addActionListener(this); btnModify.addActionListener(this); btnCancel.addActionListener(this); btnModify.setEnabled(false); txtDate.setEditable(false); txtScore.setEditable(false); setVisible(true);
txtName.requestFocus(); }
public void actionPerformed(ActionEvent ae){ if(ae.getSource()==btnCancel){ dispose();
} else if(ae.getSource()==btnQuery){ try{
Class.forName(\ catch(ClassNotFoundException e){ }
try{con=DriverManager.getConnection(\ sql=con.createStatement();
rs=sql.executeQuery(\成绩表 where 姓名='\ if(rs.next()){
txtName.setText(rs.getString(\姓名\
txtScore.setText(new Integer(rs.getInt(\成绩\
txtDate.setText(rs.getDate(\出生日期\ btnModify.setEnabled(true); txtDate.setEditable(true); txtScore.setEditable(true); }else{
System.out.println(\不存在该记录! \ btnModify.setEnabled(false); txtName.setText(\ txtScore.setText(\ txtDate.setText(\
txtDate.setEditable(false); txtScore.setEditable(false); }
}catch(SQLException e){ }
}else if(ae.getSource()==btnModify){ try{
System.out.println(\成绩表 set 出生日期='\成绩=\姓名
Java程序设计 ='\
sql.executeUpdate(\成绩表 set 出生日期='\成绩=\姓名='\
System.out.println(\记录修改完毕！\ btnModify.setEnabled(false); txtName.setText(\ txtScore.setText(\ txtDate.setText(\
txtDate.setEditable(false); txtScore.setEditable(false); con.close();
}catch(SQLException e){ } } }
public static void main(String[] args) { new ModifyForm(); } }
7 3.2.2 运行效果：
Java程序设计 8 3.3.1 删除数据：
/*删除数据*/
import javax.swing.*; import java.awt.*;
import java.awt.event.*; import java.sql.*;
public class DeleteForm extends JFrame implements ActionListener {
JLabel labName=new JLabel(\姓名：\ JLabel labDate=new JLabel(\出生日期：\ JLabel labScore=new JLabel(\成绩：\ JTextField txtName=new JTextField(20); JTextField txtDate=new JTextField(18); JTextField txtScore=new JTextField(20); JButton btnDelete=new JButton(\删除\ JButton btnCancel=new JButton(\取消\ JButton btnQuery=new JButton(\查询\ JPanel pan=new JPanel(); JPanel pan1=new JPanel(); JPanel pan2=new JPanel(); JPanel pan3=new JPanel(); JPanel pan4=new JPanel(); Connection con; Statement sql; ResultSet rs; DeleteForm() {
super(\删除数据\ setSize(400,300); pan1.add(labName); pan1.add(txtName); pan2.add(labDate); pan2.add(txtDate); pan3.add(labScore); pan3.add(txtScore); pan4.add(btnQuery); pan4.add(btnDelete); pan4.add(btnCancel);
pan.setLayout(new GridLayout(3,1)); pan.add(pan1); pan.add(pan2); pan.add(pan3);
getContentPane().add(pan,\ getContentPane().add(pan4,\ btnQuery.addActionListener(this); btnDelete.addActionListener(this);
Java程序设计 btnCancel.addActionListener(this);
btnDelete.setEnabled(false);//取消删除按钮的功能 txtDate.setEditable(false); txtScore.setEditable(false); setVisible(true);
txtName.requestFocus(); }
public void actionPerformed(ActionEvent ae) {
if(ae.getSource()==btnCancel) {
dispose(); }
else if(ae.getSource()==btnQuery){ //实现查询功能 try {
Class.forName(\ catch(ClassNotFoundException e){ }
try{con=DriverManager.getConnection(\ sql=con.createStatement();
rs=sql.executeQuery(\* from 成绩表 where ='\ if(rs.next()) {
txtName.setText(rs.getString(\姓名\ txtScore.setText(new Integer(rs.getInt(\成\
txtDate.setText(rs.getDate(\出生日期\ btnDelete.setEnabled(true);//使删除按钮功能实现 txtDate.setEditable(true); txtScore.setEditable(true); }else{
System.out.println(\不存在该记录！\ btnDelete.setEnabled(false); txtName.setText(\ txtScore.setText(\ txtDate.setText(\
txtDate.setEditable(false); txtScore.setEditable(false); }
}catch(SQLException e){ } }
else if(ae.getSource()==btnDelete) //实现删除功能
9 姓名绩Java程序设计 10 {
try {
System.out.println(\ 成绩表 set 出生日期='\成绩=\where 姓名='\
sql.executeUpdate(\FROM 成绩表 where 姓名='\
System.out.println(\记录删除完毕！\ btnDelete.setEnabled(false); txtName.setText(\ txtScore.setText(\ txtDate.setText(\
txtDate.setEditable(false); txtScore.setEditable(false); con.close(); }
catch(SQLException e){ } } }
public static void main(String[] args) {
new DeleteForm(); } }
3.3.2 运行效果：