📄 guest.java
字号:
{clewLabel.setText("删除失败");} }
if (rrr1==1){String delQuery="delete from gradeTab where 学号='"+text21.getText()+"'";
int result=delstmt.executeUpdate(delQuery);
if(result==1)
{clewLabel.setText("删除成功");
text21.setText("");text22.setText("");
planComboBox.removeAllItems();planComboBox.addItem("");
planComboBox.addItem("大一");planComboBox.addItem("大二");
planComboBox.addItem("大三");planComboBox.addItem("大四");
text24.setText("");text25.setText("");
collegeBox.removeAllItems();collegeBox.addItem("");
collegeBox.addItem("计科系");collegeBox.addItem("成教学院");
text27.setText("");text28.setText("");
text29.setText("");text30.setText("");
text31.setText(""); }
else
{clewLabel.setText("删除失败");}
delstmt.close();}
}
catch(SQLException e2)
{e2.printStackTrace();}
}
if(source==previousButton) //上一条按钮previousButton点击事件
{String message="JDBC1没有提供previous()方法.\n 此功能暂未实现\n希望在改用数据库后用JDBC2实现";
if (rs==null) {JOptionPane.showMessageDialog(this,"只有这些记录","请检查,有个小错误",
JOptionPane.WARNING_MESSAGE);return;}
else JOptionPane.showMessageDialog(this,message,"I'm sorry",JOptionPane.WARNING_MESSAGE);
}
if(source==cleanButton)
{{ if(rrr0==1){
text1.setText("");text2.setText("");
sexComboBox.removeAllItems();
sexComboBox.addItem("");
sexComboBox.addItem("男");
sexComboBox.addItem("女");
text4.setText("");
text5.setText("");
collegeComboBox.removeAllItems();collegeComboBox.addItem("");
collegeComboBox.addItem("计科系");collegeComboBox.addItem("成教学院");
visageComboBox.removeAllItems(); visageComboBox.addItem("");
visageComboBox.addItem("党员");visageComboBox.addItem("团员");
text8.setText("");
text9.setText("");text10.setText("");
text11.setText("");text12.setText("");}
if(rrr1==1){
text21.setText("");text22.setText("");
planComboBox.removeAllItems();planComboBox.addItem("");
planComboBox.addItem("大一");planComboBox.addItem("大二");
planComboBox.addItem("大三");planComboBox.addItem("大四");
text24.setText("");text25.setText("");
collegeBox.removeAllItems();collegeBox.addItem("");
collegeBox.addItem("计科系");collegeBox.addItem("成教学院");
text27.setText("");text28.setText("");
text29.setText("");text30.setText("");
text31.setText(""); }
}
}
if(source==addButton) //添加按钮addButton点击事件
{try
{ if(rrr0==1)
{ PreparedStatement pstmt=con.prepareStatement(
"insert into dataTab values(?,?,?,?,?,?,?,?,?,?,?,?)");
String s1=text1.getText();String s2=text2.getText();
String s3=(String)sexComboBox.getSelectedItem();String s4=text4.getText();
String s5=text5.getText();
String s6=(String)collegeComboBox.getSelectedItem();
String s7=(String)visageComboBox.getSelectedItem();String s8=text8.getText();
String s9=text9.getText();String s10=text10.getText();
String s11=text11.getText();String s12=text12.getText();
pstmt.setString(1,s1);pstmt.setString(2,s2);
pstmt.setString(3,s3);pstmt.setString(4,s4);
pstmt.setString(5,s5);pstmt.setString(6,s6);
pstmt.setString(7,s7);pstmt.setString(8,s8);
pstmt.setString(9,s9);pstmt.setString(10,s10);
pstmt.setString(11,s11);pstmt.setString(12,s12);
pstmt.executeUpdate();
pstmt.close();
text1.setText("");text2.setText("");
sexComboBox.removeAllItems();
sexComboBox.addItem(""); sexComboBox.addItem("男");
sexComboBox.addItem("女");
text4.setText("");
text5.setText("");
collegeComboBox.removeAllItems();collegeComboBox.addItem("");
collegeComboBox.addItem("计科系");collegeComboBox.addItem("成教学院");
visageComboBox.removeAllItems();visageComboBox.addItem("");
visageComboBox.addItem("党员");visageComboBox.addItem("团员");
text8.setText("");
text9.setText("");text10.setText("");
text11.setText("");text12.setText("");}
if(rrr1==1)
{ PreparedStatement pstmt=con.prepareStatement(
"insert into gradeTab values(?,?,?,?,?,?,?,?,?,?,?)");
String s21=text21.getText();String s22=text22.getText();
String s23=(String)planComboBox.getSelectedItem();
String s24=text24.getText();String s25=text25.getText();
String s26=(String)collegeBox.getSelectedItem();
String s27=text27.getText();String s28=text28.getText();
String s29=text29.getText();String s30=text30.getText();
String s31=text31.getText();
pstmt.setString(1,s21);pstmt.setString(2,s22);
pstmt.setString(3,s23);pstmt.setString(4,s24);
pstmt.setString(5,s25);pstmt.setString(6,s26);
pstmt.setString(7,s27);pstmt.setString(8,s28);
pstmt.setString(9,s29);pstmt.setString(10,s30);
pstmt.setString(11,s31);
pstmt.executeUpdate();
pstmt.close();
text21.setText("");text22.setText("");
planComboBox.removeAllItems();planComboBox.addItem("");
planComboBox.addItem("大一");planComboBox.addItem("大二");
planComboBox.addItem("大三");planComboBox.addItem("大四");
text24.setText(""); text25.setText("");
collegeBox.removeAllItems();collegeBox.addItem("");
collegeBox.addItem("计科系");collegeBox.addItem("成教学院");
text27.setText("");text28.setText("");
text29.setText("");text30.setText("");
text31.setText(""); }
}
catch(SQLException ex)
{System.out.println("SQLException:"+ex.getMessage());}
}
if(source==loginButton)
{clewLabel.setText("");
// tabbedPane.addTab("成绩表格" , icon, tablePane);
//tabbedPane.setSelectedIndex(tabbedPane.getTabCount()-1);
}
if(source==updateButton) //更新按钮updateButton点击事件
{try
{ if(!text1.getText().equals("")&&(rrr0==1))
{ Statement updatestmt=con.createStatement();
PreparedStatement pstmt=con.prepareStatement(
"UPDATE dataTab SET 姓名=?,性别=?,班级=?,专业=?,所在院系=?,政治面貌=?,宿舍=?,联系电话=?,通讯地址=?,邮政编码=?,个人特长及简介=?WHERE 学号=?");
String s1=text1.getText();String s2=text2.getText();
String s3=(String)sexComboBox.getSelectedItem();String s4=text4.getText();
String s5=text5.getText();
String s6=(String)collegeComboBox.getSelectedItem();
String s7=(String)visageComboBox.getSelectedItem();String s8=text8.getText();
String s9=text9.getText();String s10=text10.getText();
String s11=text11.getText();String s12=text12.getText();
pstmt.setString(1,s2);pstmt.setString(2,s3);
pstmt.setString(3,s4);pstmt.setString(4,s5);
pstmt.setString(5,s6);pstmt.setString(6,s7);
pstmt.setString(7,s8);pstmt.setString(8,s9);
pstmt.setString(9,s10);pstmt.setString(10,s11);
pstmt.setString(11,s12);pstmt.setString(12,s1);
pstmt.executeUpdate();
pstmt.close();}
if(!text21.getText().equals("")&&(rrr1==1))
{Statement updatestmt=con.createStatement();
PreparedStatement pstmt2=con.prepareStatement(
"UPDATE gradeTab SET 姓名=?,课程安排=?,班级=?,专业=?,所在院系=?,课程编号=?,课程名称=?,指导老师=?,考试成绩=?,课程简介=?WHERE 学号=?");
String s1=text21.getText();String s2=text22.getText();
String s3=(String)planComboBox.getSelectedItem();
String s4=text24.getText();String s5=text25.getText();
String s6=(String)collegeBox.getSelectedItem();
String s7=text27.getText();String s8=text28.getText();
String s9=text29.getText();String s10=text30.getText();
String s11=text31.getText();
pstmt2.setString(1,s2);pstmt2.setString(2,s3);
pstmt2.setString(3,s4);pstmt2.setString(4,s5);
pstmt2.setString(5,s6);pstmt2.setString(6,s7);
pstmt2.setString(7,s8);pstmt2.setString(8,s9);
pstmt2.setString(9,s10);pstmt2.setString(10,s11);
pstmt2.setString(11,s1);
pstmt2.executeUpdate();
pstmt2.close();}
else JOptionPane.showMessageDialog(this,"请检查需要更新的值","请检查,有个小错误",
JOptionPane.WARNING_MESSAGE);
}
catch(SQLException e2)
{e2.printStackTrace();
clewLabel.setText(e2.toString());}
}
}
public void itemStateChanged(ItemEvent evt)
{ Object source=evt.getSource();
if (source==ra1Button)
{ tabbedPane.setSelectedIndex(DATA);
ra1=1;ra2=0;
rrr1=0;rrr0=1;
}
if (source==ra2Button)
{ tabbedPane.setSelectedIndex(GRADE);
ra2=1;ra1=0;
rrr1=1;rrr0=0;
//tabbedPane.removeTabAt(tabbedPane.getTabCount()-1);
//tabbedPane.setSelectedIndex(tabbedPane.getTabCount()-1);
}
if (source==ra3Button)
{ra3=1;ra4=0;
}
if(source==ra4Button)
{ra4=1;ra3=0;
}
}
public void stateChanged(ChangeEvent event)
{switch(tabbedPane.getSelectedIndex())
{
case DATA:
{rrr0=1;rrr1=0;
rrr2=0;rrr3=0;
simplenessSelectPane.remove(queryGradeComboBox);
simplenessSelectPane.remove(dataComboBox);
simplenessSelectPane.remove(gradeComboBox);
simplenessSelectPane.remove(selectLabel);
sSelectGbc.gridx=4;sSelectGbc.gridwidth=1;
sSelectGbc.gridy=2;sSelectGbc.gridheight=1;
sSelectGbc.anchor=GridBagConstraints.WEST;
simplenessSelectPane.add(queryDataComboBox,sSelectGbc);
queryText.setText("");
queryDataComboBox.setSelectedIndex(0);
sSelectGbc.gridx=2;sSelectGbc.gridwidth=1;
sSelectGbc.gridy=28;sSelectGbc.gridheight=2;
sSelectGbc.anchor=GridBagConstraints.WEST;
simplenessSelectPane.add(previousButton,sSelectGbc);
sSelectGbc.gridx=4;sSelectGbc.gridwidth=1;
sSelectGbc.gridy=28;sSelectGbc.gridheight=2;
sSelectGbc.anchor=GridBagConstraints.EAST;
simplenessSelectPane.add(nextButton,sSelectGbc);
simplenessSelectPane.repaint();
}
break;
case GRADE:
{rrr0=0;rrr1=1;
rrr2=0;rrr3=0;
simplenessSelectPane.remove(queryDataComboBox);
simplenessSelectPane.remove(dataComboBox);
simplenessSelectPane.remove(gradeComboBox);
simplenessSelectPane.remove(selectLabel);
sSelectGbc.gridx=4;sSelectGbc.gridwidth=1;
sSelectGbc.gridy=2;sSelectGbc.gridheight=1;
sSelectGbc.anchor=GridBagConstraints.WEST;
simplenessSelectPane.add(queryGradeComboBox,sSelectGbc);
queryText.setText("");
queryGradeComboBox.setSelectedIndex(0);
sSelectGbc.gridx=2;sSelectGbc.gridwidth=1;
sSelectGbc.gridy=28;sSelectGbc.gridheight=2;
sSelectGbc.anchor=GridBagConstraints.WEST;
simplenessSelectPane.add(previousButton,sSelectGbc);
sSelectGbc.gridx=4;sSelectGbc.gridwidth=1;
sSelectGbc.gridy=28;sSelectGbc.gridheight=2;
sSelectGbc.anchor=GridBagConstraints.EAST;
simplenessSelectPane.add(nextButton,sSelectGbc);
simplenessSelectPane.repaint();
}
break;
case DATATABLE:
{rrr0=0;rrr1=0;
rrr2=1;rrr3=0;
simplenessSelectPane.remove(queryGradeComboBox);
sSelectGbc.gridx=4;sSelectGbc.gridwidth=1;
sSelectGbc.gridy=2;sSelectGbc.gridheight=1;
sSelectGbc.anchor=GridBagConstraints.WEST;
simplenessSelectPane.add(queryDataComboBox,sSelectGbc);
queryText.setText("");
queryDataComboBox.setSelectedIndex(0);
/*sSelectGbc.gridx=2;sSelectGbc.gridwidth=1;
sSelectGbc.gridy=18;sSelectGbc.gridheight=2;
sSelectGbc.anchor=GridBagConstraints.EAST;
simplenessSelectPane.add(selectLabel,sSelectGbc);
sSelectGbc.gridx=4;sSelectGbc.gridwidth=1;
sSelectGbc.gridy=18;sSelectGbc.gridheight=2;
sSelectGbc.anchor=GridBagConstraints.WEST;
simplenessSelectPane.add(dataComboBox,sSelectGbc);*/
simplenessSelectPane.remove(gradeComboBox);
simplenessSelectPane.repaint();
}
break;
case GRADETABLE:
{rrr0=0;rrr1=0;
rrr2=0;rrr3=1;
simple⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -