📄 guest.java
字号:
f2.show();
}
if(source==sButton) //高级查询
{if (rrr2==1 )
getItemString5=(String)dataComboBox.getSelectedItem();
if (rrr3==1)
{getItemString6=(String)gradeComboBox.getSelectedItem();
try {
if(queryText.getText().equals(""))
{ Statement stmt = con.createStatement();
if((rrr3==1)&&(getItemString6.equals("学号")))
{query="SELECT 学号 FROM gradeTab ";}
else if((rrr3==1)&&(getItemString6.equals("姓名")))
{ query="SELECT 姓名 FROM gradeTab ";}
else if((rrr3==1)&&(getItemString6.equals("课程安排")))
{ query="SELECT 课程安排 FROM gradeTab ";}
else if((rrr3==1)&&(getItemString6.equals("班级")))
{ query="SELECT 班级 FROM gradeTab";}
else if((rrr3==1)&&(getItemString6.equals("所在院系")))
{ query="SELECT 所在院系 FROM gradeTab ";}
else if((rrr3==1)&&(getItemString6.equals("专业")))
{ query="SELECT 专业 FROM gradeTab ";}
else if((rrr3==1)&&(getItemString6.equals("课程编号")))
{ query="SELECT 课程编号 FROM gradeTab ";}
else if((rrr3==1)&&(getItemString6.equals("课程名称")))
{ query="SELECT 课程名称 FROM gradeTab";}
else if((rrr3==1)&&(getItemString6.equals("指导老师")))
{ query="SELECT 指导老师 FROM gradeTab ";}
else if((rrr3==1)&&(getItemString6.equals("考试成绩")))
{ query="SELECT 考试成绩 FROM gradeTab ";}
rs = stmt.executeQuery(query);
model = new CachingResultSetTableModel(rs);
JTable table = new JTable(model);
scrollGradeTablePane = new JScrollPane(table);
gradeTablePane.add(scrollGradeTablePane, "Center");
scrollGradeTablePane.doLayout();}
}
catch(SQLException e)
{ System.out.println("Error " + e);}
}
}
if(source==selectButton) //查询按钮selectButton点击事件
{clewLabel.setText("请确认你的操作是否正确？");
rs=null;
if (rrr0==1 )
getItemString1=(String)queryDataComboBox.getSelectedItem();
if (rrr1==1)
getItemString2=(String)queryGradeComboBox.getSelectedItem();
if (rrr2==1 )
{getItemString3=(String)queryDataComboBox.getSelectedItem();
getItemString5=(String)dataComboBox.getSelectedItem();}
if (rrr3==1)
{getItemString4=(String)queryGradeComboBox.getSelectedItem();
getItemString6=(String)gradeComboBox.getSelectedItem();}
{try
{
Statement stmt = con.createStatement();
if(!queryText.getText().equals(""))
{ if((rrr0==1)&&(getItemString1.equals("学号")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 学号 =?";}
else if((rrr0==1)&&(getItemString1.equals("姓名")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 姓名=?";}
else if((rrr0==1)&&(getItemString1.equals("性别")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 性别 =?";}
else if((rrr0==1)&&(getItemString1.equals("班级")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 班级 =?";}
else if((rrr0==1)&&(getItemString1.equals("所在院系")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 所在院系 =?";}
else if((rrr0==1)&&(getItemString1.equals("专业")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 专业 =?";}
else if((rrr0==1)&&(getItemString1.equals("政治面貌")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 政治面貌 =?";}
else if((rrr0==1)&&(getItemString1.equals("宿舍")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 宿舍 =?";}
else if((rrr0==1)&&(getItemString1.equals("联系电话")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 联系电话 =?";}
else if((rrr0==1)&&(getItemString1.equals("通讯地址")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 通讯地址 =?";}
else if((rrr0==1)&&(getItemString1.equals("邮政编码")))
{ dataQueryString="SELECT * "+"FROM dataTab "+"WHERE 邮政编码 =?";}
else if((rrr1==1)&&(getItemString2.equals("学号")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 学号 =?";}
else if((rrr1==1)&&(getItemString2.equals("姓名")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 姓名 =?";}
else if((rrr1==1)&&(getItemString2.equals("课程安排")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 课程安排 =?";}
else if((rrr1==1)&&(getItemString2.equals("班级")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 班级 =?";}
else if((rrr1==1)&&(getItemString2.equals("所在院系")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 所在院系 =?";}
else if((rrr1==1)&&(getItemString2.equals("专业")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 专业 =?";}
else if((rrr1==1)&&(getItemString2.equals("课程编号")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 课程编号 =?";}
else if((rrr1==1)&&(getItemString2.equals("课程名称")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 课程名称 =?";}
else if((rrr1==1)&&(getItemString2.equals("指导老师")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 指导老师 =?";}
else if((rrr1==1)&&(getItemString2.equals("考试成绩")))
{ dataQueryString="SELECT * "+"FROM gradeTab "+"WHERE 考试成绩 =?";}
//else { JOptionPane.showMessageDialog(this,"jjjjj");}
dataQuerystmt=con.prepareStatement(dataQueryString);
//dataQuerystmt.setString(1,"dataTab");
// dataQuerystmt.setString(1,"姓名");
dataQuerystmt.setString(1,text);
rs=dataQuerystmt.executeQuery();
//if (ra1==1 && ra4==1) { }
// query="select * from dataTab where '"+getItemString1+"'='"+text+"' ";
//else if(ra1==1 && ra3==1) {query="select * from gradeTab where 学号='"+text+"' ";}
//else if(ra2==1 && ra3==1) {query="select * from dataTab where 学号='"+text+"' ";}
//else if(ra2==1 && ra4==1) {query="select * from gradeTab where 姓名='"+text+"' ";}
// rs = stmt.executeQuery(query);
if (rs.next())
{ if(rrr0==1){
text1.setText(rs.getString(1));text2.setText(rs.getString(2));
sexComboBox.removeAllItems();sexComboBox.addItem(rs.getString(3));
text4.setText(rs.getString(4));
text5.setText(rs.getString(5));
collegeComboBox.removeAllItems();collegeComboBox.addItem(rs.getString(6));
visageComboBox.removeAllItems();visageComboBox.addItem(rs.getString(7));
text8.setText(rs.getString(8));
text9.setText(rs.getString(9));text10.setText(rs.getString(10));
text11.setText(rs.getString(11));text12.setText(rs.getString(12));}
if(rrr1==1){
text21.setText(rs.getString(1));text22.setText(rs.getString(2));
planComboBox.removeAllItems();planComboBox.addItem(rs.getString(3));
text24.setText(rs.getString(4));
text25.setText(rs.getString(5));
collegeBox.removeAllItems();collegeBox.addItem(rs.getString(6));
text27.setText(rs.getString(7));text28.setText(rs.getString(8));
text29.setText(rs.getString(9));text30.setText(rs.getString(10));
text31.setText(rs.getString(11)); }
}
else JOptionPane.showMessageDialog(this,"没有合乎要求的记录.","请检查,输入有错误",JOptionPane.WARNING_MESSAGE);
}
else {clewLabel.setText("没有合乎要求的记录.");
JOptionPane.showMessageDialog(this,"请输入需要查询的字段名及其值","请检查,有个小错误",
JOptionPane.WARNING_MESSAGE);}
//dataQuerystmt.close();
stmt.close();
//System.out.println(getItemString);
}
catch (SQLException ex)
{clewLabel.setText(ex.getMessage());
//System.err.println("SQLException: " + ex.getMessage());
}
}
if (rrr2==1)
{if ( scrollTablePane!=null) dataTablePane.remove(scrollTablePane);
try {
if(!queryText.getText().equals(""))
{stmt = con.createStatement();
if((rrr2==1)&&(getItemString3.equals("学号")))
{dataquery="SELECT * FROM dataTab where 学号='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("姓名")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 姓名='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("性别")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 性别 ='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("班级")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 班级 ='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("所在院系")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 所在院系 ='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("专业")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 专业 ='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("政治面貌")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 政治面貌 ='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("宿舍")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 宿舍 ='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("联系电话")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 联系电话 ='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("通讯地址")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 通讯地址 ='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("邮政编码")))
{ dataquery="SELECT * "+"FROM dataTab "+"WHERE 邮政编码 ='"+text+"'";}
else if((rrr2==1)&&(getItemString3.equals("所有")))
{ dataquery="SELECT * "+"FROM dataTab ";}
rs = stmt.executeQuery(dataquery);
model = new CachingResultSetTableModel(rs);
JTable datatable = new JTable(model);
scrollTablePane = new JScrollPane(datatable);
dataTablePane.add(scrollTablePane, "Center");
scrollTablePane.doLayout();}
else if(queryText.getText().equals(""))
{System.out.println("hf");}
}
catch(SQLException e)
{ System.out.println("Error " + e);
}
}
if (rrr3==1)
{if ( scrollGradeTablePane!=null) gradeTablePane.remove(scrollGradeTablePane);
try {
if(!queryText.getText().equals(""))
{stmt = con.createStatement();
if((rrr3==1)&&(getItemString4.equals("学号")))
{gradequery="SELECT * FROM gradeTab where 学号='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("姓名")))
{ gradequery="SELECT * "+"FROM gradeTab "+"WHERE 姓名='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("课程安排")))
{ gradequery="SELECT * "+"FROM gradeTab "+"WHERE 课程安排 ='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("班级")))
{ gradequery="SELECT * "+"FROM gradeTab "+"WHERE 班级 ='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("所在院系")))
{ gradequery="SELECT * "+"FROM gradeTab "+"WHERE 所在院系 ='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("专业")))
{ gradequery="SELECT * "+"FROM gradeTab "+"WHERE 专业 ='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("课程编号")))
{ gradequery="SELECT * "+"FROM gradeTab "+"WHERE 课程编号 ='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("课程名称")))
{ gradequery="SELECT * "+"FROM gradeTab "+"WHERE 课程名称 ='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("指导老师")))
{ gradequery="SELECT * "+"FROM gradeTab "+"WHERE 指导老师 ='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("考试成绩")))
{ gradequery="SELECT * "+"FROM gradeTab "+"WHERE 考试成绩 ='"+text+"'";}
else if((rrr3==1)&&(getItemString4.equals("所有")))
{ gradequery="SELECT * "+"FROM gradeTab ";}
rs = stmt.executeQuery(gradequery);
model = new CachingResultSetTableModel(rs);
JTable table = new JTable(model);
scrollGradeTablePane = new JScrollPane(table);
gradeTablePane.add(scrollGradeTablePane, "Center");
scrollGradeTablePane.doLayout();}
}
catch(SQLException e)
{ System.out.println("Error " + e);}
}
}
if(source==nextButton) //下一条按钮nextButton点击事件
{ if (rs==null) {JOptionPane.showMessageDialog(this,"只有这些记录","请检查,有个小错误",
JOptionPane.WARNING_MESSAGE);return;}
{ try
{if (rs.next())
{ if(rrr0==1){
text1.setText(rs.getString(1));text2.setText(rs.getString(2));
sexComboBox.removeAllItems();sexComboBox.addItem(rs.getString(3));
text4.setText(rs.getString(4));
text5.setText(rs.getString(5));
collegeComboBox.removeAllItems();collegeComboBox.addItem(rs.getString(7));
visageComboBox.removeAllItems();visageComboBox.addItem(rs.getString(7));
text8.setText(rs.getString(8));
text9.setText(rs.getString(9));text10.setText(rs.getString(10));
text11.setText(rs.getString(11));text12.setText(rs.getString(12));}
if(rrr1==1){
text21.setText(rs.getString(1));text22.setText(rs.getString(2));
planComboBox.removeAllItems();planComboBox.addItem(rs.getString(3));
text24.setText(rs.getString(4));
text25.setText(rs.getString(5));
collegeBox.removeAllItems();collegeBox.addItem(rs.getString(6));
text27.setText(rs.getString(7));text28.setText(rs.getString(8));
text29.setText(rs.getString(9));text30.setText(rs.getString(10));
text31.setText(rs.getString(11)); }
}
else {rs.close();rs=null;}
}
catch(Exception e)
{System.out.println("error"+e);}
}}
if(source==exitButton)
{System.exit(0);
}
if(source==delButton) //删除按钮delButton点击事件
{ try
{
Statement delstmt=con.createStatement();
if (rrr0==1){String delQuery="delete from dataTab where 学号='"+text1.getText()+"'";
int result=delstmt.executeUpdate(delQuery);
if(result==1)
{clewLabel.setText("删除成功");
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("");}
else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -