📄 insert.java
字号:
课程名.setEditable(false);
分数=new JTextField(10);
分数.setEditable(true);
////////////////////////////////////////
label=new JLabel("学生选课成绩维护",JLabel.CENTER);
label.setFont(new Font("TimesRoman",Font.BOLD,20));
label.setForeground(Color.BLUE);
////////////////////////////////////////
Box box0=Box.createHorizontalBox();
box0.add(label);
Box box1=Box.createHorizontalBox();
box1.add(new JLabel("学 号 : ",JLabel.CENTER));
box1.add(学号);
Box box2=Box.createHorizontalBox();
box2.add(new JLabel("课程号 : ",JLabel.CENTER));
box2.add(课程号);
Box box3=Box.createHorizontalBox();
box3.add(new JLabel("课程名 : ",JLabel.CENTER));
box3.add(课程名);
Box box4=Box.createHorizontalBox();
box4.add(new JLabel("分 数: ",JLabel.CENTER));
box4.add(分数);
boxH=Box.createVerticalBox();
boxH.add(Box.createVerticalStrut(8));
boxH.add(box0);
boxH.add(Box.createVerticalStrut(8));
boxH.add(box1);
boxH.add(Box.createVerticalStrut(8));
boxH.add(box2);
boxH.add(Box.createVerticalStrut(8));
boxH.add(box3);
boxH.add(Box.createVerticalStrut(8));
boxH.add(box4);
}
/*---------------------布局-------------------------*/
boxH.add(Box.createVerticalGlue());
JPanel pCenter=new JPanel();
pCenter.add(boxH);
setLayout(new BorderLayout());
add(pCenter,BorderLayout.CENTER);
JPanel pSouth=new JPanel();
if(select==51)
{
pSouth.add(查询);
}
pSouth.add(录入);
pSouth.add(重置);
add(pSouth,BorderLayout.SOUTH);
validate();
}
/*---------------------界面布局结束-------------------------*/
//////////////////////////////////////////////////////
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==录入)
{
if(select==10)
try
{
String sex=null;
if(男.isSelected())
{
sex=男.getText();
}
else
{
sex=女.getText();
}
if(学号.getText().equals( "" )||姓名.getText().equals( "" )||
专业.getText().equals( "" )||出生.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好学生资料" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 学生基本信息表 WHERE 学号 = '"+学号.getText()+"'";
String InsertInput = "INSERT INTO 学生基本信息表 VALUES('"
+ 学号.getText()+"','"+姓名.getText()+"','"
+sex+"','"+专业.getText()+"','"
+出生.getText()+"',"+身高.getText()+",'"+学号.getText()+"')";
this.InsertQuery=InsertQuery;
this.InsertInput=InsertInput;
inputStudent();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*------------------------修改学生基本信息--------------------------*/
if(select==11)
try
{
String sex=null;
if(男.isSelected())
{
sex=男.getText();
}
else
{
sex=女.getText();
}
if(学号.getText().equals( "" )||姓名.getText().equals( "" )||
专业.getText().equals( "" )||出生.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好学生资料" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 学生基本信息表 WHERE 学号 = '"+学号.getText()+"'";
String InsertInput = "UPDATE 学生基本信息表 SET 姓名='"+姓名.getText()+"',性别='"+sex
+"',专业='"+专业.getText()+"',生日='"+出生.getText()+"',身高="+身高.getText()
+",密码='"+密码.getText()+"' WHERE 学号='"+学号.getText()+"'";
this.InsertQuery=InsertQuery;
this.InsertInput=InsertInput;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*------------------------删除学生基本信息--------------------------*/
if(select==12)
{
try
{
if(学号.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好要删除学生的学号！" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 学生基本信息表 WHERE 学号 = '"+学号.getText()+"'";
String InsertInput = "DELETE FROM 学生基本信息表 WHERE 学号='"+学号.getText()+"'";
this.InsertQuery=InsertQuery;
this.InsertInput=InsertInput;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
}
/*------------------------查询学生基本信息--------------------------*/
if(select==13)
try
{
if(学号.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好学生学号" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 学生基本信息表 WHERE 学号 = '"+学号.getText()+"'";
this.InsertQuery=InsertQuery;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*--------------------------------录入课程信息------------------------------------*/
if(select==20)
try
{
if(课程号.getText().equals( "" )||学时.getText().equals( "" )||
学分.getText().equals( "" )||学期.getText().equals( "" )||
教师.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好课程资料" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 课程信息表 WHERE 课程号 = '"+课程号.getText()+"'";
String InsertInput = "INSERT INTO 课程信息表 VALUES('"+ 课程号.getText()+"'";
if(!课程名.getText().equals( "" ))
{
InsertInput=InsertInput+",'"+课程名.getText()+"'";
}
InsertInput = InsertInput+","+学时.getText()+","+学分.getText()+",'"+
学期.getText()+"','"+教师.getText()+"')";
this.InsertQuery=InsertQuery;
this.InsertInput=InsertInput;
inputStudent();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*----------------------------------修改课程信息----------------------------------*/
if(select==21)
try
{
if(课程号.getText().equals( "" )||学时.getText().equals( "" )||
学分.getText().equals( "" )||学期.getText().equals( "" )||
教师.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好课程资料" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 课程信息表 WHERE 课程号 = '"+课程号.getText()+"'";
String InsertInput = "UPDATE 课程信息表 SET ";
if(!课程名.getText().equals( "" ))
{
InsertInput = InsertInput+"课程名='"+ 课程名.getText()+"',";
}
InsertInput = InsertInput+"学时="+学时.getText()+",学分="+学分.getText()+",学期='"+
学期.getText()+"',教师='"+教师.getText()
+"' WHERE 课程号 = '"+课程号.getText()+"'";
this.InsertQuery=InsertQuery;
this.InsertInput=InsertInput;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*----------------------------------删除课程信息----------------------------------*/
if(select==22)
try
{
if(课程号.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好要删除课程的课程号！" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 课程信息表 WHERE 课程号 = '"+课程号.getText()+"'";
String InsertInput = "DELETE FROM 课程信息表 WHERE 课程号 = '"+课程号.getText()+"'";
this.InsertQuery=InsertQuery;
this.InsertInput=InsertInput;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*----------------------------------查询课程信息----------------------------------*/
if(select==23)
try
{
if(课程号.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好课程号" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 课程信息表 WHERE 课程号 = '"+课程号.getText()+"'";
this.InsertQuery=InsertQuery;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*------------------------------添加、修改学生选课成绩-----------------------------*/
if(select==30)//添加、修改的前提是学生已经选上了该课程
try
{
if(学号.getText().equals( "" )||课程号.getText().equals( "" )||
分数.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好成绩记录" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT 学号,课程号 FROM 成绩表 WHERE 学号 = '"+
学号.getText()+"' AND 课程号='"+课程号.getText()+"'";
String InsertInput = "UPDATE 成绩表 SET 分数="+分数.getText()+" WHERE 学号='"+学号.getText()+
"' AND 课程号='"+课程号.getText()+"'";
this.InsertQuery=InsertQuery;
this.InsertInput=InsertInput;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*------------------------------删除学生选课成绩-----------------------------*/
if(select==31)
try
{
if(学号.getText().equals( "" )||课程号.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填写完整学号和课程号！" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT 学号,课程号 FROM 成绩表 WHERE 学号 = '"+
学号.getText()+"' AND 课程号='"+课程号.getText()+"'";
String InsertInput = "DELETE FROM 成绩表 WHERE 学号='"+学号.getText()+
"' AND 课程号='"+课程号.getText()+"'";
this.InsertQuery=InsertQuery;
this.InsertInput=InsertInput;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*------------------------------查询学生选课成绩-----------------------------*/
if(select==32)
try
{
if(学号.getText().equals( "" )||课程号.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填写完整学号和课程号！" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT 分数 FROM 成绩表 WHERE 学号 = '"+
学号.getText()+"' AND 课程号='"+课程号.getText()+"'";
this.InsertQuery=InsertQuery;
inputGrade();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*----------------------------添加教师信息-------------------------------------*/
if(select==40)
try
{
if( 登陆帐号.getText().equals( "" )||教师姓名.getText().equals( "" )||
院系.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好教师资料" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 教师表 WHERE 登陆帐号='"+登陆帐号.getText()+"'";
String InsertInput = "INSERT INTO 教师表 VALUES('"+登陆帐号.getText()+"','"+
教师姓名.getText()+"','"+登陆帐号.getText()+"','"+院系.getText()+"')";
this.InsertQuery=InsertQuery;
this.InsertInput=InsertInput;
inputStudent();
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog ( this ,ee ,
"学生选课管理系统",JOptionPane.WARNING_MESSAGE );
}
/*-----------------------------修改教师信息-----------------------------------*/
if(select==41)
try
{
if( 登陆帐号.getText().equals( "" )||教师姓名.getText().equals( "" )||
院系.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"请填好教师资料" );
//setTitle( "无记录显示" );
return;
}
String InsertQuery = "SELECT * FROM 教师表 WHERE 登陆帐号='"+登陆帐号.getText()+"'";
String InsertInput = "UPDATE 教师表 SET 教师='"+教师姓名.getText()+"',院系='"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -