📄 managesystem.java
字号:
else{
sql=" select * from grade 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 delete1 extends JFrame implements ActionListener
{
DBManage db=new DBManage(); //定义数据库操作对象
// flag2 flag1=new flag2();
ResultSet rs; //定义结果集
String SQL;
// if(flag1.flag==0)
// JFrame f=new JFrame("删除成绩");
// else
JFrame f=new JFrame("删除学生信息");
Container cp=f.getContentPane();
JPanel pa=new JPanel(new GridLayout(2,2,5,5));
JLabel lb1=new JLabel("请输入学号");
JTextField tf1=new JTextField(10);
JButton bt1=new JButton("确定");
JButton bt2=new JButton("取消");
public delete1()
{
cp.add(pa);
pa.add(lb1);
pa.add(tf1);
tf1.setText(null);
pa.add(bt1);
pa.add(bt2);
bt1.addActionListener(this);
bt2.addActionListener(this);
f.pack();
f.setVisible(true);
f.setSize(230,120);
//f.setBackground(Color.cyan); //设置背景颜色
f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==bt1)
{
if(tf1.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(f,"请输入学号!");
return;
}
else
{
// if(flag1.flag==0)
// SQL="select * from grade where 学号='" +tf1.getText().trim()+ "' ";
// else
SQL="select * from student where 学号='" +tf1.getText().trim()+ "' ";
rs=db.query(SQL); //执行数据库的查询
try{
if(!rs.next()) //判断该学号在表grade中是否存在
{
JOptionPane.showMessageDialog(f,"该学号不存在!");
return;
}
else{
SQL=" delete from student where 学号='" +tf1.getText().trim()+ "' ";
}
if(db.executeSQL(SQL))
JOptionPane.showMessageDialog(f,"成功删除信息!");
else
JOptionPane.showMessageDialog(f,"删除信息失败!");
}
catch(SQLException ep)
{ System.out.println("SQLException:"+ep.getMessage()); }
}
}
if(e.getSource()==bt2)
{
f.dispose();
}
}
}
class delete extends JFrame implements ActionListener
{
DBManage db=new DBManage(); //定义数据库操作对象
// flag2 flag1=new flag2();
ResultSet rs; //定义结果集
String SQL;
// if(flag1.flag==0)
JFrame f=new JFrame("删除成绩");
// else
// JFrame f=new JFrame("删除学生信息");
Container cp=f.getContentPane();
JPanel pa=new JPanel(new GridLayout(2,2,5,5));
JLabel lb1=new JLabel("请输入学号");
JTextField tf1=new JTextField(10);
JButton bt1=new JButton("确定");
JButton bt2=new JButton("取消");
public delete()
{
cp.add(pa);
pa.add(lb1);
pa.add(tf1);
tf1.setText(null);
pa.add(bt1);
pa.add(bt2);
bt1.addActionListener(this);
bt2.addActionListener(this);
f.pack();
f.setVisible(true);
f.setSize(230,120);
//f.setBackground(Color.cyan); //设置背景颜色
f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==bt1)
{
if(tf1.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(f,"请输入学号!");
return;
}
else
{
// if(flag1.flag==0)
SQL="select * from grade where 学号='" +tf1.getText().trim()+ "' ";
// else
// SQL="select * from student where 学号='" +tf1.getText().trim()+ "' ";
rs=db.query(SQL); //执行数据库的查询
try{
if(!rs.next()) //判断该学号在表grade中是否存在
{
JOptionPane.showMessageDialog(f,"该学号不存在!");
return;
}
else{
SQL=" delete from grade where 学号='" +tf1.getText().trim()+ "' ";
}
if(db.executeSQL(SQL))
JOptionPane.showMessageDialog(f,"成功删除信息!");
else
JOptionPane.showMessageDialog(f,"删除信息失败!");
}
catch(SQLException ep)
{ System.out.println("SQLException:"+ep.getMessage()); }
}
}
if(e.getSource()==bt2)
{
f.dispose();
}
}
}
class add1 extends JFrame implements ActionListener//添加学生信息
{
DBManage db=new DBManage(); //定义数据库操作对象
ResultSet rs;
String Sql; //定义字符串对象，代表sql语句
JFrame f=new JFrame("添加学生");
Container cp=f.getContentPane();
JPanel pa1=new JPanel(new GridLayout(6,2,5,5)); //创建面板pa1并设置布局为6行2列
JPanel pa2=new JPanel(new GridLayout(1,4,5,5)); //创建面板pa2并设置布局为1行4列
//创建标签对象
JLabel lb1=new JLabel("学号");
JLabel lb2=new JLabel("姓名");
JLabel lb3=new JLabel("性别");
JLabel lb4=new JLabel("籍贯");
JLabel lb5=new JLabel("出生年月");
JLabel lb6=new JLabel("所在学院");
//创建文本框对象
JTextField tfNum=new JTextField(10);
JTextField tfName=new JTextField(10);
JTextField tfSex=new JTextField(10);
JTextField tfPlace=new JTextField(10);
JTextField tfBirthday=new JTextField(10);
JTextField tfDepartment=new JTextField(10);
//创建按钮对象
JButton btAdd=new JButton("添加");
JButton btSave=new JButton("保存");
JButton btReset=new JButton("重置");
JButton btQuit=new JButton("退出");
Dimension dim=new Dimension(60,20);
public add1()
{
cp.setLayout(new GridLayout(2,1,5,5));
cp.add(pa1); //将pa1面板放入容器中
pa1.add(lb1);
pa1.add(tfNum);
pa1.add(lb2);
pa1.add(tfName);
pa1.add(lb3);
pa1.add(tfSex);
pa1.add(lb4);
pa1.add(tfPlace);
pa1.add(lb5);
pa1.add(tfBirthday);
pa1.add(lb6);
pa1.add(tfDepartment);
cp.add(pa2); //添加面板pa2
btAdd.setMaximumSize(dim);
btAdd.setMinimumSize(dim);
btAdd.setPreferredSize(dim);
pa2.add(btAdd);
btSave.setMaximumSize(dim);
btSave.setMinimumSize(dim);
btSave.setPreferredSize(dim);
pa2.add(btSave);
btReset.setMaximumSize(dim);
btReset.setMinimumSize(dim);
btReset.setPreferredSize(dim);
pa2.add(btReset);
btQuit.setMaximumSize(dim);
btQuit.setMinimumSize(dim);
btQuit.setPreferredSize(dim);
pa2.add(btQuit);
//注册监听者对象
btAdd.addActionListener(this);
btSave.addActionListener(this);
btReset.addActionListener(this);
btQuit.addActionListener(this);
f.pack();
f.setVisible(true);
f.setSize(400,400);
//f.setBackground(Color.cyan); //设置背景颜色
f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
//初始化时设置按钮的可用性
setButton(true,false,false,true);
//初始化时设置文本框不可编辑
setTextField(false,false,false,false,false,false);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==btAdd)
{
setNull();
setTextField(true,true,true,true,true,true);
setButton(false,true,true,true);
}
if(e.getSource()==btSave)
{
//判断学号是否为空
if(tfNum.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(f,"学号不可为空!");
return;
}
//判断姓名是否为空
if(tfName.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(f,"姓名不可为空!");
return;
}
Sql="select * from student where 学号='"+tfNum.getText().trim() +"' ";
//首先查询新增的学号在student表中是否存在
try{
rs=db.query(Sql);
Sql=" select * from student where 学号='"+tfNum.getText().trim() +"' ";
rs=db.query(Sql);
//查询当前学号，若不为空，说明grade表中此学号已存在
if(rs.next())
{
JOptionPane.showMessageDialog(f,"该学生的成绩已经存在，请重新输入!");
return;
}
else{
Sql=" insert into student values(";
Sql=Sql+ " '" +tfNum.getText().trim()+ "', "; Sql=Sql+ " '" +tfName.getText().trim()+ "', ";
Sql=Sql+ " '" +tfSex.getText().trim()+ "', ";
Sql=Sql+ " '" +tfPlace.getText().trim()+ "', ";
Sql=Sql+ " '" +tfBirthday.getText().trim()+ "', ";
Sql=Sql+ " '" +tfDepartment.getText().trim()+ "' ) ";
if(db.executeSQL(Sql))
{
JOptionPane.showMessageDialog(f,"添加成功!");
setNull();
setButton(true,false,false,true);
}
else
{
JOptionPane.showMessageDialog(f,"添加失败，请重新操作!");
}
}
//}
}
catch(SQLException sqle)
{ System.out.println("SQLException异常:"+sqle.getMessage()); }
}
if(e.getSource()==btReset)
{
setNull();
}
if(e.getSource()==btQuit)
{
f.dispose();
}
}
//设置文本框的可编辑性
private void setTextField(boolean num,boolean name,boolean Chinese,boolean Math,boolean English,boolean Total)
{
tfNum.setEditable(num);
tfName.setEditable(name);
tfSex.setEditable(Chinese);
tfPlace.setEditable(Math);
tfBirthday.setEditable(English);
tfDepartment.setEditable(Total);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -