📄 wmstupsycomdialog.java
字号:
}
if(studyOrPsy.equals("心理"))
{
String sql = "";
iniPsyTable(sql);
}
}
//4按照学号/姓名查询
else if(yearTerm.equals("全部")&&weekOrMonth.equals("全部")&&studyOrPsy.equals("全部")&&!stuCondition.equals("全部"))
{
if(stuCondition.equals("学号"))
{
if(flag == false)
{
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！！");
}
else{
String sql =" where studentid ='"+getQStuId()+"'";
initialTable(sql);
}
}
else{
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！！");
}
else{
String sql =" where studentid like '%"+getQStuId()+"%'";
initialTable(sql);
}
}
}
else if(stuCondition.equals("姓名"))
{
if(flag == false){
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where stuname = '"+getInput()+"'";
initialTable(sql);
}
}
else
{
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where stuname like '%"+getInput()+"%'";
initialTable(sql);
}
}
}
}
// 2-1 复合查询
else if(!yearTerm.equals("全部")&&!weekOrMonth.equals("全部")&&studyOrPsy.equals("全部")&&stuCondition.equals("全部"))
{
String sql = " where yearterm ='"+yearTerm+"'"+" and weekormon = '"+weekOrMonth+"'";
System.out.println(sql);
initialTable(sql);
}
//2-2复合查询
else if(!yearTerm.equals("全部")&&weekOrMonth.equals("全部")&&!studyOrPsy.equals("全部")&&stuCondition.equals("全部"))
{
System.out.println("dd"+studyOrPsy);
if(studyOrPsy.equals("学习"))
{
String sql =" where yearterm = '"+yearTerm+"'";
iniStuTable(sql);
}
if(studyOrPsy.equals("心理"))
{
String sql =" where yearterm = '"+yearTerm+"'";
iniPsyTable(sql);
}
}
//2-3复合查询
else if(!yearTerm.equals("全部")&&weekOrMonth.equals("全部")&&studyOrPsy.equals("全部")&&!stuCondition.equals("全部"))
{
if(stuCondition.equals("学号"))
{
if(flag ==false)
{
if(id==0)
{
JOptionPane.showMessageDialog(this,"学号输入错误");
}
else
{
String sql = " where yearterm = '"+yearTerm+"'"+" and studentid = '"+id+"'";
initialTable(sql);
}
}else
{
if(id==0)
{
JOptionPane.showMessageDialog(this,"学号输入错误");
}
else
{
String sql = " where yearterm = '"+yearTerm+"'"+" and studentid like '%"+id+"%'";
initialTable(sql);
}
}
}
else if(stuCondition.equals("姓名"))
{
if(flag ==false){
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this, "姓名不能为空！");
}
else
{
String sql =" where yearterm = '"+yearTerm+"'"+" and stuname = '"+name+"'";
initialTable(sql);
}
}
else
{
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this, "姓名不能为空！");
}
else
{
String sql =" where yearterm = '"+yearTerm+"'"+" and stuname like '%"+name+"%'";
initialTable(sql);
}
}
}
}
//2-4 复合查询
else if(yearTerm.equals("全部")&&!weekOrMonth.equals("全部")&&!studyOrPsy.equals("全部")&&stuCondition.equals("全部"))
{
if(studyOrPsy.equals("学习"))
{
String sql =" where weekormon = '"+weekOrMonth+"'";
iniStuTable(sql);
}
if(studyOrPsy.equals("心理"))
{
String sql =" where weekormon = '"+weekOrMonth+"'";
iniPsyTable(sql);
}
}
//2-5复合查询
else if(yearTerm.equals("全部")&&!weekOrMonth.equals("全部")&&studyOrPsy.equals("全部")&&!stuCondition.equals("全部"))
{
if(stuCondition.equals("学号"))
{
if(flag ==false)
{
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！");
}
else
{
String sql = " where weekormon = '"+weekOrMonth+"'"+" and studentid = "+id;
System.out.println(sql);
initialTable(sql);
}
}
else
{
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！");
}
else
{
String sql = " where weekormon = '"+weekOrMonth+"'"+" and studentid like '%"+id+"%'";
System.out.println(sql);
initialTable(sql);
}
}
}
else if(stuCondition.equals("姓名"))
{
if(flag ==false)
{
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where weekormon = '"+weekOrMonth+"'"+" and stuname = '"+getInput()+"'";
initialTable(sql);
}
}
else
{
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where weekormon = '"+weekOrMonth+"'"+" and stuname like '%"+getInput()+"%'";
initialTable(sql);
}
}
}
}
//2-6复合查询
else if(yearTerm.equals("全部")&&weekOrMonth.equals("全部")&&!studyOrPsy.equals("全部")&&!stuCondition.equals("全部"))
{
if(studyOrPsy.equals("学习"))
{
if(stuCondition.equals("学号"))
{
if(flag == false)
{
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！");
}
else
{
String sql = " where studentid = "+id;
iniStuTable(sql);
}
}
else
{
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！");
}
else
{
String sql = " where studentid like '%"+id+"%'";
iniStuTable(sql);
}
}
}
else if(stuCondition.equals("姓名"))
{
if(flag == false){
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where stuname = '"+name+"'";
iniStuTable(sql);
}
}
else{
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where stuname like '%"+name+"%'";
iniStuTable(sql);
}
}
}
}
if(studyOrPsy.equals("心理"))
{
if(stuCondition.equals("学号"))
{
if(flag ==false){
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！");
}
else
{
String sql = " where studentid = "+id;
iniPsyTable(sql);
}
}
else{
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！");
}
else
{
String sql = " where studentid like '%"+id+"%'";
iniPsyTable(sql);
}
}
}
else if(stuCondition.equals("姓名"))
{
if(flag==false){
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where stuname = '"+name+"'";
iniPsyTable(sql);
}}
else
{
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where stuname like '%"+name+"%'";
iniPsyTable(sql);
}
}
}
}
}
//复合查询
else if(!yearTerm.equals("全部")&&!weekOrMonth.equals("全部")&&!studyOrPsy.equals("全部")&&stuCondition.equals("全部"))
{
if(studyOrPsy.equals("学习"))
{
String sql =" where yearterm = '"+yearTerm+"' and weekormon = '"+weekOrMonth+"'";
iniStuTable(sql);
}
if(studyOrPsy.equals("心理"))
{
String sql =" where yearterm = '"+yearTerm+"' and weekormon = '"+weekOrMonth+"'";
System.out.print(sql);
iniPsyTable(sql);
}
}
//复合查询
else if(!yearTerm.equals("全部")&&!weekOrMonth.equals("全部")&&studyOrPsy.equals("全部")&&!stuCondition.equals("全部"))
{
if(stuCondition.equals("学号"))
{
if(flag ==false){
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！");
}
else
{
String sql = " where yearTerm = '"+ yearTerm+"' and weekormon = '"+weekOrMonth+"'"+" and studentid = "+id;
System.out.println(sql);
initialTable(sql);
}}
else
{
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！");
}
else
{
String sql = " where yearTerm = '"+ yearTerm+"' and weekormon = '"+weekOrMonth+"'"+" and studentid like '%"+id+"%'";
System.out.println(sql);
initialTable(sql);
}
}
}
else if(stuCondition.equals("姓名"))
{
if(flag == false){
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where yearTerm = '"+ yearTerm+"' and weekormon = '"+weekOrMonth+"'"+" and stuname = '"+getInput()+"'";
initialTable(sql);
}
}
else
{
if(name.equals("null"))
{
JOptionPane.showMessageDialog(this,"姓名不能为空！");
}
else
{
String sql =" where yearTerm = '"+ yearTerm+"' and weekormon = '"+weekOrMonth+"'"+" and stuname like '%"+getInput()+"%'";
initialTable(sql);
}
}
}
}
//复合查询
else if(!yearTerm.equals("全部")&&weekOrMonth.equals("全部")&&!studyOrPsy.equals("全部")&&!stuCondition.equals("全部"))
{
if(studyOrPsy.equals("学习"))
{
if(stuCondition.equals("学号"))
{
if(flag ==false){
if(id==0)
{
JOptionPane.showMessageDialog(this, "学号输入错误！");
}
else
{
String sql = " where yearTerm = '"+ yearTerm+"' and studentid = "+id;
iniStuTable(sql);
}}
else{
if(id==0)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -