📄 membermanagepanel.java
字号:
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'35' and Age<='45' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'35' and Age<='45' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'35' and Age<='45' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'35' and Age<='45' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 5) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'45' and Age<='55' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'45' and Age<='55' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'45' and Age<='55' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'45' and Age<='55' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'45' and Age<='55' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'45' and Age<='55' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 6) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'55' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'55' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'55' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'55' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'55' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'55' and Score>=10000 order by Score");
}
}
} else if (combxSex.getSelectedIndex() == 1) {
if (combAge.getSelectedIndex() == 0) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 1) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age<'18' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age<'18' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age<'18' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age<'18' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age<'18' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age<'18' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 2) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>='18' and Age<='25' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>=18 and Age<='25' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>='18' and Age<='25' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>='18' and Age<='25' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>='18' and Age<='25' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>='18' and Age<='25' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 3) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'25' and Age<='35' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'25' and Age<='35' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'25' and Age<='35' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'25' and Age<='35' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'25' and Age<='35' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'25' and Age<='35' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 4) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'35' and Age<='45' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'35' and Age<='45' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'35' and Age<='45' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'35' and Age<='45' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'35' and Age<='45' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'35' and Age<='45' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 5) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'45' and Age<='55' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'45' and Age<='55' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'45' and Age<='55' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'45' and Age<='55' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'45' and Age<='55' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'45' and Age<='55' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 6) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'55' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'55 and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'55 and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'55 and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='男' and Age>'55 and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='男' and Age>'55 and Score>=10000 order by Score");
}
}
} else if (combxSex.getSelectedIndex() == 2) {
if (combAge.getSelectedIndex() == 0) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 1) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age<'18' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age<'18' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age<'18' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age<'18' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age<'18' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age<'18' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 2) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age>='18' and Age<='25' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age>='18' and Age<='25' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='女' and Age>='18' and Age<='25' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='女' and Age>='18' and Age<='25' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Sex='女' and Age>='18' and Age<='25' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age>='18' and Age<='25' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 3) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age>'25' and Age<='35' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Sex='女' and Age>'25' and Age<='35' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.Ge⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -