📄 change_del_record.java
字号:
package record_manager;
import javax.swing.*;
import java.sql.*;
import java.awt.Color;
import java.awt.TextField;
import java.awt.event.*;
import javax.swing.JFrame;
public class change_del_record extends JFrame implements ActionListener
{
private static final long serialVersionUID = 1L;
JPanel cp;
ImageIcon icon=new ImageIcon("picture/12.jpg");
JLabel tp=new JLabel(icon,JLabel.CENTER);
JLabel j1=new JLabel("编号:");
JLabel j2=new JLabel("姓名:");
JLabel j3=new JLabel("性别:");
JLabel j4=new JLabel("项目:");
JLabel j5=new JLabel("学院:");
JLabel j6=new JLabel("成绩: ");
JLabel j7=new JLabel("名次:");
JLabel j8=new JLabel("日期:");
JLabel j9=new JLabel("纪录:");
JLabel j10=new JLabel("编号范围100～950");
JLabel j0=new JLabel("日期格式2008.10.1");
JButton b1=new JButton("查 询");
JButton b2=new JButton("修 改");
JButton b3=new JButton("删 除");
JButton b4=new JButton("取 消");
JComboBox cbx1=new JComboBox();
JComboBox cbx2=new JComboBox();
JComboBox cbx3=new JComboBox();
JComboBox cbx4=new JComboBox();
TextField t1=new TextField(3);
TextField t2=new TextField(20);
TextField t3=new TextField(20);
TextField t4=new TextField(20);
TextField t5=new TextField(20);
public change_del_record()
{try{
Init();
}catch(Exception err){err.printStackTrace();}}
private void Init() throws Exception{
cp=(JPanel) this.getContentPane();
cp.setLayout(null);
this.setTitle("运动员成绩修改/删除");
this.setResizable(false);
this.setSize(720,520);
j1.setBounds(40,40,60,20);
j1.setFont(new java.awt.Font("Dialog",0,20));
j1.setForeground(new Color(250,0,0));
t1.setBounds(100,40,130,20);
t1.setFont(new java.awt.Font("Dialog",0,14));
j2.setBounds(260,40,60,20);
j2.setFont(new java.awt.Font("Dialog",0,20));
j2.setForeground(new Color(250,0,0));
t2.setBounds(320,40,130,20);
t2.setFont(new java.awt.Font("Dialog",0,14));
t2.setEnabled(false);
j3.setBounds(480,40,60,20);
j3.setFont(new java.awt.Font("Dialog",0,20));
j3.setForeground(new Color(250,0,0));
cbx1.setBounds(540,40,130,20);
cbx1.setFont(new java.awt.Font("Dialog",0,12));
cbx1.addItem("");
cbx1.addItem("男");
cbx1.addItem("女");
cbx1.setEnabled(false);
j6.setBounds(40,120,60,20);
j6.setFont(new java.awt.Font("Dialog",0,20));
j6.setForeground(new Color(250,0,0));
t3.setBounds(100,120,130,20);
t3.setFont(new java.awt.Font("Dialog",0,14));
t3.setEnabled(false);
j7.setBounds(260,120,60,20);
j7.setFont(new java.awt.Font("Dialog",0,20));
j7.setForeground(new Color(250,0,0));
t4.setBounds(320,120,130,20);
t4.setFont(new java.awt.Font("Dialog",0,14));
t4.setEnabled(false);
j8.setBounds(480,120,60,20);
j8.setFont(new java.awt.Font("Dialog",0,20));
j8.setForeground(new Color(250,0,0));
t5.setBounds(540,120,130,20);
t5.setFont(new java.awt.Font("Dialog",0,14));
t5.setEnabled(false);
j4.setBounds(40,200,60,20);
j4.setFont(new java.awt.Font("Dialog",0,20));
j4.setForeground(new Color(250,0,0));
cbx2.setBounds(100,200,130,20);
cbx2.setFont(new java.awt.Font("Dialog",0,12));
cbx2.addItem("");
j5.setBounds(260,200,60,20);
j5.setFont(new java.awt.Font("Dialog",0,20));
j5.setForeground(new Color(250,0,0));
cbx3.setBounds(320,200,130,20);
cbx3.setFont(new java.awt.Font("Dialog",0,12));
cbx3.addItem("");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
Statement ps=con.createStatement();
ResultSet rs1=null;
rs1=ps.executeQuery("select * from 学院名称表");
while(rs1.next()){cbx3.addItem(rs1.getString(1));}
ResultSet rs2=null;
rs2=ps.executeQuery("select * from 项目表");
while(rs2.next()){cbx2.addItem(rs2.getString(1));}
}
catch(Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！");}
j9.setBounds(480,200,60,20);
j9.setFont(new java.awt.Font("Dialog",0,20));
j9.setForeground(new Color(250,0,0));
cbx4.setBounds(540,200,130,20);
cbx4.setFont(new java.awt.Font("Dialog",0,12));
cbx4.addItem("");
cbx4.addItem("破");
cbx4.addItem("平");
cbx4.addItem("否");
cbx4.setEnabled(false);
cbx3.setEnabled(false);
j10.setBounds(100,70,190,20);
j10.setFont(new java.awt.Font("Dialog",0,15));
j10.setForeground(new Color(20,250,20));
j0.setBounds(540,150,190,20);
j0.setFont(new java.awt.Font("Dialog",0,15));
j0.setForeground(new Color(20,250,20));
b1.setBounds(110,400,90,30);
b1.setFont(new java.awt.Font("Dialog",0,20));
b1.addActionListener(this);
b2.setBounds(240,400,90,30);
b2.setFont(new java.awt.Font("Dialog",0,20));
b2.addActionListener(this);
b3.setBounds(370,400,90,30);
b3.setFont(new java.awt.Font("Dialog",0,20));
b3.addActionListener(this);
b4.setBounds(510,400,90,30);
b4.setFont(new java.awt.Font("Dialog",0,20));
b4.addActionListener(this);
tp.setText("");
tp.setSize(720,480);
cp.add(j1,null);
cp.add(j2,null);
cp.add(j3,null);
cp.add(j4,null);
cp.add(j5,null);
cp.add(j6,null);
cp.add(j7,null);
cp.add(j8,null);
cp.add(j9,null);
cp.add(j10,null);
cp.add(j0,null);
cp.add(t1,null);
cp.add(t2,null);
cp.add(t3,null);
cp.add(t4,null);
cp.add(t5,null);
cp.add(cbx1);
cp.add(cbx2);
cp.add(cbx3);
cp.add(cbx4);
cp.add(b1,null);
cp.add(b2,null);
cp.add(b3,null);
cp.add(b4,null);
cp.add(tp,null);
this.setVisible(true);
this.setLocationRelativeTo(null);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b4){this.dispose();}
else if(e.getSource()==b1){
if(t1.getText().equals("")){JOptionPane.showMessageDialog(null, "编号不能为空！");t1.requestFocus();}
else if(cbx2.getSelectedItem().equals("")){JOptionPane.showMessageDialog(null, "项目不能为空！");cbx2.requestFocus();}
else
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
Statement ps=con.createStatement();
ResultSet rs4=null;
rs4=ps.executeQuery("select * from 表一 where 运动员编号='"+t1.getText().trim()+"'and 项目='"+cbx2.getSelectedItem().toString()+"'");
if(rs4.next())
{
t2.setText(rs4.getString(2));
cbx1.setSelectedItem(rs4.getString(3));
cbx3.setSelectedItem(rs4.getString(5));
t3.setText(rs4.getString(7));
t4.setText(rs4.getString(8));
t5.setText(rs4.getString(9));
cbx4.setSelectedItem(rs4.getString(10));
t2.setEnabled(true);cbx1.setEnabled(true);cbx3.setEnabled(true);cbx4.setEnabled(true);t3.setEnabled(true);
t4.setEnabled(true);t5.setEnabled(true);
}else{JOptionPane.showMessageDialog(null, "没有此记录！");}
}
catch (Exception err) { err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！"); }
}
else if(t1.getText().equals("")){JOptionPane.showMessageDialog(null, "编号不能为空！");t1.requestFocus();}
else if(t2.getText().equals("")){JOptionPane.showMessageDialog(null, "姓名不能为空！");t2.requestFocus();}
else if(cbx1.getSelectedItem().equals("")){JOptionPane.showMessageDialog(null, "性别不能为空！");cbx1.requestFocus();}
else if(t3.getText().equals("")){JOptionPane.showMessageDialog(null, "成绩不能为空！");t3.requestFocus();}
else if(t4.getText().equals("")){JOptionPane.showMessageDialog(null, "名次不能为空！");t4.requestFocus();}
else if(t5.getText().equals("")){JOptionPane.showMessageDialog(null, "日期不能为空！");t5.requestFocus();}
else if(cbx2.getSelectedItem().equals("")){JOptionPane.showMessageDialog(null, "项目不能为空！");cbx2.requestFocus();}
else if(cbx3.getSelectedItem().equals("")){JOptionPane.showMessageDialog(null, "学院不能为空！");cbx3.requestFocus();}
else if(cbx4.getSelectedItem().equals("")){JOptionPane.showMessageDialog(null, "纪录不能为空！");cbx4.requestFocus();}
else try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
Statement ps=con.createStatement();
ResultSet rs0=null;
ResultSet rs2=null;
ResultSet rs3=null;
rs0=ps.executeQuery("select * from 表一 where 运动员编号='"+t1.getText().trim()+"'");
String ss=new String();
if(rs0.next())
{ ss=rs0.getString(2);}
if(!ss.equals(t2.getText())&&!ss.equals(""))
{JOptionPane.showMessageDialog(null, "姓名与编号不一致！\n编号："+t1.getText()+" 姓名:"+ss);}
else
{
int num1=0,num2=0,num3=0;String s1=new String();String s2=new String();
String s3=new String();String s4=new String();
num1=Integer.valueOf(t1.getText().trim());
rs2=ps.executeQuery("select * from 运动员编号范围 where 学院='"+cbx3.getSelectedItem().toString()+"'");
if(rs2.next())
{
s1=rs2.getString(1);
s2=rs2.getString(2);
s3=rs2.getString(3);
s4=rs2.getString(4);
}
num2=Integer.valueOf(s3);num3=Integer.valueOf(s4);
if(num1<num2||num1>num3){JOptionPane.showMessageDialog(null, "编号与学院不一致"+"\n"+s1+"的编号范围是："+s2);}
else if(e.getSource()==b2)
{int v=JOptionPane.showConfirmDialog(this, "确定修改吗？","修改确认",JOptionPane.OK_CANCEL_OPTION);
if(v==JOptionPane.OK_OPTION)
{
rs3=ps.executeQuery("select * from 项目表 where 项目='"+cbx2.getSelectedItem().toString()+"'");
if(rs3.next())
{
ps.executeUpdate("update 表一 set 姓名='"+t2.getText().trim()+"',性别='"+cbx1.getSelectedItem().toString()+
"',学院='"+cbx3.getSelectedItem().toString()+
"',名次='"+t4.getText().trim()+"',日期='"+t5.getText().trim()+"',成绩='"+t3.getText().trim()+
"',类别='"+rs3.getString(2)+"',纪录='"+cbx4.getSelectedItem().toString()+"' where 运动员编号='"+t1.getText().trim()+"'and 项目='"+cbx2.getSelectedItem().toString()+"'");
JOptionPane.showMessageDialog(null, "修改成功！");this.dispose();
}
}
}
else
{int v=JOptionPane.showConfirmDialog(this, "确定删除这条记录吗？","删除确认",JOptionPane.OK_CANCEL_OPTION);
if(v==JOptionPane.OK_OPTION)
{
rs3=ps.executeQuery("select * from 项目表 where 项目='"+cbx2.getSelectedItem().toString()+"'");
if(rs3.next())
{
ps.executeUpdate("delete from 表一 where 运动员编号='"+t1.getText().trim()+"'and 项目='"+cbx2.getSelectedItem().toString()+"'");
JOptionPane.showMessageDialog(null, "删除成功！");this.dispose();
}
}
}
}
}
catch (Exception err) { err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！"); }
}
public static void main(String args[])
{new change_del_record(); }
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -