📄 managesystem.java
字号:
catch(SQLException ce)
{ System.out.println("SQLException异常:"+ce.getMessage()); }
setAbled(false,false,true); //设置TNum和TName文本框不可编辑
setButton(false,true,true,true); //设置确定按钮不可用
}
if(e.getSource()==BSave)
{
sql=" update grade set 语文='" +TChinese.getText().trim()+ "',";
sql=sql+ "数学='" +TMath.getText().trim()+ "',";
sql=sql+ "英语='" +TEnglish.getText().trim()+ "',";
sql=sql+ "总分='" +TTotal.getText().trim()+ "'";
sql=sql+ "where 学号='" +TNum.getText().trim()+ "' or 姓名='" +TName.getText().trim()+ "' ";
if(db.executeSQL(sql))
{ JOptionPane.showMessageDialog(f,"修改成功!"); }
else
{ JOptionPane.showMessageDialog(f,"修改失败，请重新操作!"); }
setNull();
setAbled(true,false,false);
setButton(true,false,false,true);
}
if(e.getSource()==BReset)
{
setNull();
}
if(e.getSource()==BQuit)
{
f.dispose();
}
}
}
class search1 extends JFrame implements ActionListener,ItemListener//学生信息查询
{
DBManage db=new DBManage(); //定义数据库操作对象
ResultSet rs; //定义结果集
String sql;
boolean select=false; //表示哪个单选按钮被选中，若为true，则r1被选中，否则r2被选中
JFrame f=new JFrame();
Container cp=f.getContentPane();
JPanel pa1=new JPanel(new FlowLayout());
JPanel pa2=new JPanel(new GridLayout(2,2));
JPanel pa3=new JPanel(new FlowLayout());
JPanel pa4=new JPanel(new GridLayout(3,4));
JRadioButton r1=new JRadioButton("按学号查询",false);
JRadioButton r2=new JRadioButton("按姓名查询",false);
ButtonGroup bg=new ButtonGroup(); //创建按纽组对象，实现单选按纽的多选一功能
JLabel lb1=new JLabel("请输入学号：");
JLabel lb2=new JLabel("请输入姓名：");
JTextField tf1=new JTextField(10);
JTextField tf2=new JTextField(10);
JButton bt1=new JButton("确定");
JButton bt2=new JButton("取消");
JLabel lbNum=new JLabel("学号");
JLabel lbName=new JLabel("姓名");
JLabel lbChinese=new JLabel("性别");
JLabel lbMath=new JLabel("籍贯");
JLabel lbEnglish=new JLabel("出生年月");
JLabel lbTotal=new JLabel("所在学院");
JTextField tfNum=new JTextField(10);
JTextField tfName=new JTextField(10);
JTextField tfChinese=new JTextField(10);
JTextField tfMath=new JTextField(10);
JTextField tfEnglish=new JTextField(10);
JTextField tfTotal=new JTextField(10);
public search1()
{
cp.setLayout(new GridLayout(4,1));
//向面版pa1中添加控件
pa1.add(r1);
pa1.add(r2);
bg.add(r1); //加载按纽到按纽组
bg.add(r2);
cp.add(pa1);
//向面版pa2中添加控件
pa2.add(lb1);
pa2.add(tf1);
pa2.add(lb2);
pa2.add(tf2);
cp.add(pa2);
//向面版pa3中添加控件
pa3.add(bt1);
pa3.add(bt2);
cp.add(pa3);
//向面版pa4中添加控件
pa4.add(lbNum);pa4.add(tfNum);
pa4.add(lbName);pa4.add(tfName);
pa4.add(lbChinese);pa4.add(tfChinese);
pa4.add(lbMath);pa4.add(tfMath);
pa4.add(lbEnglish);pa4.add(tfEnglish);
pa4.add(lbTotal);pa4.add(tfTotal);
cp.add(pa4);
//添加控件的监听对象
r1.addItemListener(this);
r2.addItemListener(this);
bt1.addActionListener(this);
bt2.addActionListener(this);
f.pack();
f.setVisible(true);
f.setSize(500,300);
f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setAbled(false,false,false,false,false,false); //设置文本框不可编辑
}
public void itemStateChanged(ItemEvent e)
{
if(e.getSource()==r1)
{
if(e.getStateChange()==e.SELECTED)
{
tf1.setEditable(true);
tf2.setText(null);
tf2.setEditable(false);
select=true;
}
}
if(e.getSource()==r2)
{
if(e.getStateChange()==e.SELECTED)
{
tf1.setText(null);
tf1.setEditable(false);
tf2.setEditable(true);
select=false;
}
}
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==bt1)
{
//如果按学号查询
if(select)
{
if(tf1.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(f,"学号不能为空，请重新输入!");
return;
}
else{
sql=" select * from student where 学号='" +tf1.getText().trim()+ "' ";
rs=db.query(sql);
try{
if(!rs.next())
{
JOptionPane.showMessageDialog(f,"该学号不存在，请确认!");
return;
}
else{
tfNum.setText(rs.getString("学号"));
tfName.setText(rs.getString("姓名"));
tfChinese.setText(rs.getString("性别"));
tfMath.setText(rs.getString("籍贯"));
tfEnglish.setText(rs.getString("出生年月"));
tfTotal.setText(rs.getString("所在学院"));
}
}
catch(SQLException ep)
{ System.out.println("SQLException:"+ep.getMessage()); }
}
}
else
{
if(tf2.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(f,"姓名不能为空，请重新输入!");
return;
}
else{
sql=" select * from student where 姓名='" +tf2.getText().trim()+ "' ";
rs=db.query(sql);
try{
if(!rs.next())
{
JOptionPane.showMessageDialog(f,"该姓名不存在，请确认!");
return;
}
else{
tfNum.setText(rs.getString("学号"));
tfName.setText(rs.getString("姓名"));
tfChinese.setText(rs.getString("性别"));
tfMath.setText(rs.getString("籍贯"));
tfEnglish.setText(rs.getString("出生年月"));
tfTotal.setText(rs.getString("所在学院"));
}
}
catch(SQLException sqle)
{ System.out.println("SQLException异常:"+sqle.getMessage()); }
}
}
}
if(e.getSource()==bt2)
{
f.dispose();
}
}
//设置文本框是否可编辑，该函数有两个参数，为布尔型变量，若为true，则设置文本框可编辑，若为false，则不可编辑
void setAbled(boolean num,boolean name,boolean chinese,boolean math,boolean english,boolean total)
{
tfNum.setEditable(num);
tfName.setEditable(name);
tfChinese.setEditable(chinese);
tfMath.setEditable(math);
tfEnglish.setEditable(english);
tfTotal.setEditable(total);
}
}
class search extends JFrame implements ActionListener,ItemListener//成绩查询
{
DBManage db=new DBManage(); //定义数据库操作对象
ResultSet rs; //定义结果集
String sql;
boolean select=false; //表示哪个单选按钮被选中，若为true，则r1被选中，否则r2被选中
JFrame f=new JFrame();
Container cp=f.getContentPane();
JPanel pa1=new JPanel(new FlowLayout());
JPanel pa2=new JPanel(new GridLayout(2,2));
JPanel pa3=new JPanel(new FlowLayout());
JPanel pa4=new JPanel(new GridLayout(3,4));
JRadioButton r1=new JRadioButton("按学号查询",false);
JRadioButton r2=new JRadioButton("按姓名查询",false);
ButtonGroup bg=new ButtonGroup(); //创建按纽组对象，实现单选按纽的多选一功能
JLabel lb1=new JLabel("请输入学号：");
JLabel lb2=new JLabel("请输入姓名：");
JTextField tf1=new JTextField(10);
JTextField tf2=new JTextField(10);
JButton bt1=new JButton("确定");
JButton bt2=new JButton("取消");
JLabel lbNum=new JLabel("学号");
JLabel lbName=new JLabel("姓名");
JLabel lbChinese=new JLabel("语文");
JLabel lbMath=new JLabel("数学");
JLabel lbEnglish=new JLabel("英语");
JLabel lbTotal=new JLabel("总分");
JTextField tfNum=new JTextField(10);
JTextField tfName=new JTextField(10);
JTextField tfChinese=new JTextField(10);
JTextField tfMath=new JTextField(10);
JTextField tfEnglish=new JTextField(10);
JTextField tfTotal=new JTextField(10);
public search()
{
cp.setLayout(new GridLayout(4,1));
//向面版pa1中添加控件
pa1.add(r1);
pa1.add(r2);
bg.add(r1); //加载按纽到按纽组
bg.add(r2);
cp.add(pa1);
//向面版pa2中添加控件
pa2.add(lb1);
pa2.add(tf1);
pa2.add(lb2);
pa2.add(tf2);
cp.add(pa2);
//向面版pa3中添加控件
pa3.add(bt1);
pa3.add(bt2);
cp.add(pa3);
//向面版pa4中添加控件
pa4.add(lbNum);pa4.add(tfNum);
pa4.add(lbName);pa4.add(tfName);
pa4.add(lbChinese);pa4.add(tfChinese);
pa4.add(lbMath);pa4.add(tfMath);
pa4.add(lbEnglish);pa4.add(tfEnglish);
pa4.add(lbTotal);pa4.add(tfTotal);
cp.add(pa4);
//添加控件的监听对象
r1.addItemListener(this);
r2.addItemListener(this);
bt1.addActionListener(this);
bt2.addActionListener(this);
f.pack();
f.setVisible(true);
f.setSize(500,300);
f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setAbled(false,false,false,false,false,false); //设置文本框不可编辑
}
public void itemStateChanged(ItemEvent e)
{
if(e.getSource()==r1)
{
if(e.getStateChange()==e.SELECTED)
{
tf1.setEditable(true);
tf2.setText(null);
tf2.setEditable(false);
select=true;
}
}
if(e.getSource()==r2)
{
if(e.getStateChange()==e.SELECTED)
{
tf1.setText(null);
tf1.setEditable(false);
tf2.setEditable(true);
select=false;
}
}
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==bt1)
{
//如果按学号查询
if(select)
{
if(tf1.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(f,"学号不能为空，请重新输入!");
return;
}
else{
sql=" select * from grade where 学号='" +tf1.getText().trim()+ "' ";
rs=db.query(sql);
try{
if(!rs.next())
{
JOptionPane.showMessageDialog(f,"该学号不存在，请确认!");
return;
}
else{
tfNum.setText(rs.getString("学号"));
tfName.setText(rs.getString("姓名"));
tfChinese.setText(rs.getString("语文"));
tfMath.setText(rs.getString("数学"));
tfEnglish.setText(rs.getString("英语"));
tfTotal.setText(rs.getString("总分"));
}
}
catch(SQLException ep)
{ System.out.println("SQLException:"+ep.getMessage()); }
}
}
else
{
if(tf2.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(f,"姓名不能为空，请重新输入!");
return;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -