📄 managerpanel.java
字号:
{
stuNumTextField.setText(null);
stuNameTextField.setText(null);
majorTextField.setText(null);
birthTextField.setText(null);
heightTextField.setText(null);
}
}
//修改学生信息界面监听//修改学生信息界面监听//修改学生信息界面监听
if(selected == 3)
{
if(e.getSource() == changeButton) //修改按钮
{
try
{
String sex = (String)sexComboBox.getSelectedItem();
if(stuNumTextField.getText().equals( "" )||stuNameTextField.getText().equals( "" )||
majorTextField.getText().equals( "" )||birthTextField.getText().equals( "" ))
{
JOptionPane.showMessageDialog(ManagerPanel.this,"请填好学生资料" );
//setTitle( "无记录显示" );
return;
}
insertQuery = "SELECT * FROM 学生基本信息表 WHERE 学号 = '"+stuNumTextField.getText()+"'";
insertUpdate = "UPDATE 学生基本信息表 SET 姓名='"+stuNameTextField.getText()+"',性别='" + sex
+"',专业='"+majorTextField.getText()+"',生日='"+birthTextField.getText()+"',身高=" + heightTextField.getText()
+",密码='"+passwordTextField.getText()+"' WHERE 学号='"+stuNumTextField.getText()+"'";
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog (ManagerPanel.this,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
if(e.getSource() == resetButton) // 继续按钮
{
stuNumTextField.setText(null);
stuNameTextField.setText(null);
majorTextField.setText(null);
birthTextField.setText(null);
heightTextField.setText(null);
}
}
//查询学生信息界面监听 查询学生信息界面监听 查询学生信息界面监听 查询学生信息界面监听
if(selected == 4)
{
if(e.getSource() == queryButton) //查询按钮
{
try
{
if(stuNumTextField.getText().equals( "" ))
{
JOptionPane.showMessageDialog(ManagerPanel.this, "请填好学生学号" );
//setTitle( "无记录显示" );
return;
}
insertQuery = "SELECT * FROM 学生基本信息表 WHERE 学号 = '"+stuNumTextField.getText()+"'";
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog (ManagerPanel.this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
if(e.getSource() == resetButton) // 继续按钮
{
stuNumTextField.setText(null);
stuNameTextField.setText(null);
sexTextField.setText(null);
majorTextField.setText(null);
birthTextField.setText(null);
heightTextField.setText(null);
passwordTextField.setText(null);
}
}
//删除学生信息界面监听 删除学生信息界面监听 删除学生信息界面监听
if(selected == 5)
{
if(e.getSource() == delButton)
{
try
{
if(stuNumTextField.getText().equals( "" ))
{
JOptionPane.showMessageDialog( ManagerPanel.this, "请填好要删除学生的学号！" );
//setTitle( "无记录显示" );
return;
}
insertQuery = "SELECT * FROM 学生基本信息表 WHERE 学号 = '" + stuNumTextField.getText()+"'";
insertUpdate = "DELETE FROM 学生基本信息表 WHERE 学号='" + stuNumTextField.getText()+"'";
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog (ManagerPanel.this, ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
if(e.getSource() == resetButton)
{
stuNumTextField.setText(null);
}
}
//录入教师信息界面监听 录入教师信息界面监听 录入教师信息界面监听
if(selected == 6)
{
if(e.getSource() == insertButton) //修改按钮
{
try
{
if(teaNumTextField.getText().equals( "" ) || teaNameTextField.getText().equals( "" )
|| titleTextField.getText().equals( "" ) || collegeTextField.getText().equals( "" )
|| ageTextField.getText().equals( "" ))
{
JOptionPane.showMessageDialog(ManagerPanel.this, "请填好教师资料" );
//setTitle( "无记录显示" );
return;
}
String sex = (String)sexComboBox.getSelectedItem();
insertQuery = "SELECT * FROM 教师表 WHERE 登陆帐号='" + teaNumTextField.getText()+"'";
insertUpdate = "INSERT INTO 教师表 VALUES('"
+ teaNumTextField.getText()+"','" + teaNameTextField.getText()+"','"
+ teaNumTextField.getText() +"','" + collegeTextField.getText() + "','"
+ sex +"'," + ageTextField.getText()+",'"
+ titleTextField.getText()+"')";
inputStudent();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog (ManagerPanel.this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
if(e.getSource() == resetButton) //继续按钮
{
teaNumTextField.setText(null);
teaNameTextField.setText(null);
collegeTextField.setText(null);
ageTextField.setText(null);
titleTextField.setText(null);
}
}
//修改教师信息界面监听 修改教师信息界面监听 修改教师信息界面监听
if(selected == 7)
{
if(e.getSource() == changeButton) //修改按钮
{
try
{
if(teaNumTextField.getText().equals( "" ) || teaNameTextField.getText().equals( "" )
|| titleTextField.getText().equals( "" ) || collegeTextField.getText().equals( "" )
|| ageTextField.getText().equals( "" ))
{
JOptionPane.showMessageDialog(ManagerPanel.this,"请填好教师资料" );
//setTitle( "无记录显示" );
return;
}
String sex = (String)sexComboBox.getSelectedItem();
insertQuery = "SELECT * FROM 教师表 WHERE 登陆帐号='"+teaNumTextField.getText()+"'";
insertUpdate = "UPDATE 教师表 SET 教师='" + teaNameTextField.getText()
+"',性别='" + sex
+"',年龄='" + ageTextField.getText()
+"',登陆密码='"+ passwordTextField.getText()
+"',职称='" + titleTextField.getText()
+"',院系='" + collegeTextField.getText()
+"' WHERE 登陆帐号='" + teaNumTextField.getText()+"'";
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog (ManagerPanel.this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
if(e.getSource() == resetButton) //继续按钮
{
teaNumTextField.setText(null);
teaNameTextField.setText(null);
collegeTextField.setText(null);
ageTextField.setText(null);
titleTextField.setText(null);
passwordTextField.setText(null);
}
}
//查询教师信息界面监听 查询教师信息界面监听 查询教师信息界面监听
if(selected == 8)
{
if(e.getSource() == queryButton) //查询按钮
{
try
{
if(teaNumTextField.getText().equals( "" ))
{
JOptionPane.showMessageDialog(ManagerPanel.this,"请填好教师帐号" );
//setTitle( "无记录显示" );
return;
}
insertQuery = "SELECT * FROM 教师表 WHERE 登陆帐号 = '"+teaNumTextField.getText()+"'";
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog (ManagerPanel.this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
if(e.getSource() == resetButton) // 继续按钮
{
teaNumTextField.setText(null);
teaNameTextField.setText(null);
sexTextField.setText(null);
titleTextField.setText(null);
collegeTextField.setText(null);
ageTextField.setText(null);
passwordTextField.setText(null);
}
}
//删除教师信息界面监听 删除教师信息界面监听 删除教师信息界面监听
if(selected == 9)
{
if(e.getSource() == delButton)
{
try
{
if(teaNumTextField.getText().equals( "" ))
{
JOptionPane.showMessageDialog( ManagerPanel.this, "请填好要删除教师的帐户！" );
//setTitle( "无记录显示" );
return;
}
insertQuery = "SELECT * FROM 教师表 WHERE 登陆帐号= '" + teaNumTextField.getText()+"'";
insertUpdate = "DELETE FROM 教师表 WHERE 登陆帐号='" + teaNumTextField.getText()+"'";
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog (ManagerPanel.this, ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
if(e.getSource() == resetButton)
{
teaNumTextField.setText(null);
}
}
//录入课程信息界面监听 //录入课程信息界面监听 //录入课程信息界面监听
if(selected == 10)
{
if(e.getSource() == insertButton) //录入按钮
{
try
{
if(courseNumTextField.getText().equals( "" )
|| periodTextField.getText().equals( "" )
|| creditHourTextField.getText().equals( "" )
|| termTextField.getText().equals( "" )
|| teaTextField.getText().equals( "" )
|| courseNumTextField.getText().equals(""))
{
JOptionPane.showMessageDialog(ManagerPanel.this,"请填好课程资料" );
//setTitle( "无记录显示" );
return;
}
insertQuery = "SELECT * FROM 课程信息表 WHERE 课程号 = '"
+ courseNumTextField.getText() + "'";
insertUpdate = "INSERT INTO 课程信息表 VALUES('"
+ courseNumTextField.getText()
+"','" + courseNameTextField.getText()
+"','" + periodTextField.getText()
+"','" + creditHourTextField.getText()
+"','" + termTextField.getText()
+"','" + teaTextField.getText()+"')";
inputStudent();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog (ManagerPanel.this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
if(e.getSource() == resetButton) //继续按钮
{
courseNumTextField.setText(null);
courseNameTextField.setText(null);
periodTextField.setText(null);
creditHourTextField.setText(null);
termTextField.setText(null);
teaTextField.setText(null);
}
}
//修改课程信息界面监听 //修改课程信息界面监听 //修改课程信息界面监听
if(selected == 11)
{
if(e.getSource() == changeButton) //修改按钮
{
try
{
if(courseNumTextField.getText().equals( "" )
|| periodTextField.getText().equals( "" )
|| creditHourTextField.getText().equals( "" )
|| termTextField.getText().equals( "" )
|| teaTextField.getText().equals( "" )
|| courseNumTextField.getText().equals(""))
{
JOptionPane.showMessageDialog(ManagerPanel.this,"请填好课程资料" );
//setTitle( "无记录显示" );
return;
}
insertQuery = "SELECT * FROM 课程信息表 WHERE 课程号 = '"
+ courseNumTextField.getText()+"'";
insertUpdate = "UPDATE 课程信息表 SET 学时='" + periodTextField.getText()
+ "',课程名='"+ courseNameTextField.getText()
+ "',学分='" + creditHourTextField.getText()
+ "',学期='" + termTextField.getText()
+ "',教师='" + teaTextField.getText()
+ "' WHERE 课程号 = '" + courseNumTextField.getText()+"'";;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog (ManagerPanel.this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
if(e.getSource() == resetButton) //继续按钮
{
courseNumTextField.setText(null);
courseNameTextField.setText(null);
periodTextField.setText(null);
creditHourTextField.setText(null);
termTextField.setText(null);
teaTextField.setText(null);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -