📄 checkwindow.java
字号:
else if(s.equals("后方一致"))x="'";
else if(s.equals("前方一致"))x="%'";
else if(s.equals("等于"))x="'";
return x;
}
public void actionPerformed(ActionEvent e){
if(e.getActionCommand().equals("退出"))
{
ConfirmWindow x=new ConfirmWindow();
x.setVisible(true);
}
else if(e.getActionCommand().equals("搜索"))
{
String s1=f.getText().trim();
String s2=f2.getText().trim();
String s3=f3.getText().trim();
String s4=f4.getText().trim();
v2.addElement(string1);
if(s1.trim().equals("")&&s2.trim().equals("")
&&s3.trim().equals("")&&s4.trim().equals(""))
{
JOptionPane.showMessageDialog(null, "请先输入您要查询的内容");
}
else
{
DataBase_Sever d=new DataBase_Sever();;Vector v;
String st1="",st2="",st3="",st4="";
if(!s1.trim().equals("")){
if(!((String)combo1.getSelectedItem()).equals("关键字")){
if(s2.trim().equals("")
&&s3.trim().equals("")&&s4.trim().equals("")){
st1=getCommand((String)combo1.getSelectedItem())+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem());
}
else
st1=getCommand((String)combo1.getSelectedItem())+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" and ";
}
else{
if(s2.trim().equals("")
&&s3.trim().equals("")&&s4.trim().equals("")){
st1="BookName"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" or "+
"Author"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" or "+
"BookID"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" or "+
"Publisher"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" or "+
"Class"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem());
}
else{
st1="BookName"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" or "+
"Author"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" or "+
"BookID"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" or "+
"Publisher"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" or "+
"Class"+getFrontCommand((String)combo3.getSelectedItem())+s1+getBackCommand((String)combo3.getSelectedItem())+" and ";
}
}
}
if(!s2.trim().equals("")){
if(!((String)combo12.getSelectedItem()).equals("关键字")){
if(s3.trim().equals("")&&s4.trim().equals("")){
st2=getCommand((String)combo12.getSelectedItem())+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem());
}
else
st2=getCommand((String)combo12.getSelectedItem())+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" and ";
}
else{
if(s3.trim().equals("")&&s4.trim().equals("")){
st2="BookName"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" or "+
"Author"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" or "+
"BookID"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" or "+
"Publisher"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" or "+
"Class"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem());
}
else{
st2="BookName"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" or "+
"Author"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" or "+
"BookID"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" or "+
"Publisher"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" or "+
"Class"+getFrontCommand((String)combo32.getSelectedItem())+s2+getBackCommand((String)combo32.getSelectedItem())+" and ";
}
}
}
if(!s3.trim().equals("")){
if(!((String)combo13.getSelectedItem()).equals("关键字")){
if(s4.trim().equals("")){
st3=getCommand((String)combo13.getSelectedItem())+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem());}
else
st3=getCommand((String)combo13.getSelectedItem())+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" and ";
}
else{
if(s4.trim().equals("")){
st3="BookName"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" or "+
"Author"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" or "+
"BookID"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" or "+
"Publisher"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" or "+
"Class"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem());
}
else{
st3="BookName"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" or "+
"Author"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" or "+
"BookID"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" or "+
"Publisher"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" or "+
"Class"+getFrontCommand((String)combo33.getSelectedItem())+s3+getBackCommand((String)combo33.getSelectedItem())+" and ";
}
}
}
if(!s4.trim().equals("")){
if(!((String)combo14.getSelectedItem()).equals("关键字")){
st4=getCommand((String)combo14.getSelectedItem())+getFrontCommand((String)combo34.getSelectedItem())+s4+getBackCommand((String)combo34.getSelectedItem());
}
else{
st4="BookName"+getFrontCommand((String)combo34.getSelectedItem())+s4+getBackCommand((String)combo34.getSelectedItem())+" or "+
"Author"+getFrontCommand((String)combo34.getSelectedItem())+s4+getBackCommand((String)combo34.getSelectedItem())+" or "+
"BookID"+getFrontCommand((String)combo34.getSelectedItem())+s4+getBackCommand((String)combo34.getSelectedItem())+" or "+
"Publisher"+getFrontCommand((String)combo34.getSelectedItem())+s4+getBackCommand((String)combo34.getSelectedItem())+" or "+
"Class"+getFrontCommand((String)combo34.getSelectedItem())+s4+getBackCommand((String)combo34.getSelectedItem());
}
}
d.select("book", "where "+st1+st2+st3+st4);
v=d.getData(d.rs);
try{
d.rs.close();
}catch(SQLException ex1){}
d.closeDB();
if(v.size()<2)
{
JOptionPane.showMessageDialog(null, "查询内容不存在");
v2.removeAllElements();
}
else
{
for (int n=1;n<v.size();n++){
v2.addElement(v.elementAt(n));
}
BookWindow x=new BookWindow(v2);
x.setVisible(true);
dispose();
}
}
}
else if(e.getActionCommand().equals("确定"))
{
if(t1.getText().trim().equals("")&&t2.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null, "请先输入您要查询的内容");
}
else {
String s1=t1.getText().trim();
String s2=t2.getText().trim();
v2.addElement(string2);
DataBase_Sever d=new DataBase_Sever();
if(s1.equals("")){
s=" where Name='"+s2+"'";
}
else if(s2.equals("")){
s=" where ReaderID='"+s1+"'";
}
else {
s=" where ReaderID='"+s1+"' and Name='"+s2+"'";
}
d.select("reader", s);
Vector v=d.getData(d.rs);
try{
d.rs.close();
}catch(SQLException ex1){}
d.closeDB();
if(v.size()<2)
{
JOptionPane.showMessageDialog(null, "不存在此读者");
v2.removeAllElements();
t1.setText("");
t2.setText("");
}
else{
for (int n=1;n<v.size();n++){
v2.addElement(v.elementAt(n));
}
BookWindow x=new BookWindow(v2);
x.setVisible(true);
dispose();
}
}
}
else if(e.getActionCommand().equals("清除"))
{
f.setText("");
f2.setText("");
f3.setText("");
f4.setText("");
}
else if(e.getActionCommand().equals("返回主界面"))
{MainWindow x=new MainWindow();
x.setVisible(true);
dispose();
}
else
System.out.println("Error!");
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -