LibraryManager/ReaderQuery.java at master · uboger/LibraryManager · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
 //ReaderQuery.java
import java.awt.*;
import java.awt.event.*;
import java.sql.SQLException;
import java.sql.ResultSet;
import javax.swing.*;
public class ReaderQuery extends JFrame{
	Label namelb=new Label("读者姓名"),typelb=new Label("读者类型");
	TextField nametxt=new TextField(),typetxt=new TextField();
	Button querybtn=new Button("查询"),closebtn=new Button("退出");
	JTable table;
	JScrollPane scrollpane;
	String[] heads={"读者编号","读者姓名","读者类型","读者性别","可借数量","可借天数"};
	Object[][] readertable=new Object[30][heads.length];
	public ReaderQuery(){
		setTitle("ReaderQuery");
		setSize(700,400);
		setLayout(null);
		setResizable(false);

		namelb.setBounds(150,30,50,20);
		nametxt.setBounds(210,30,100,20);
		typelb.setBounds(330,30,50,20);
		typetxt.setBounds(390,30,100,20);
		querybtn.setBounds(220,80,50,20);
		closebtn.setBounds(410,80,50,20);
		add(namelb);add(nametxt);add(typelb);add(typetxt);add(querybtn);add(closebtn);
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				DbOp.close();
				dispose();
			}
		});
		querybtn.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				 queryActionPerformed(e);
			}
		});
		closebtn.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			  	DbOp.close();
				dispose();
			}
		});

		setLocationRelativeTo(null);
		setVisible(true);
	}
	private void queryActionPerformed(ActionEvent e){
		readertable=new Object[30][heads.length];
		String readername=nametxt.getText(),readertype=typetxt.getText();
		String sql,sql1,sql2,sql3;
		if(readername.equals("")){
			sql1="";
		}else{
			sql1="readername like'"+readername+"%'";
		}
		if(readertype.equals("")){
			sql2="";
		}else{
			sql2="readertype like '"+readertype+"%'";
		}
		if(!readername.equals("")&&!readertype.equals("")){
			sql2="and "+sql2;
		}
		sql="select * from reader where ";
		sql3=sql1+sql2;
		if(!sql3.equals("")){
			sql=sql+sql3;
		}else{
			JOptionPane.showMessageDialog(null,"请输入你要查询的信息");
			return;
		}
		try{
			ResultSet rs=DbOp.executeQuery(sql);
			String[] alloptions={"id","readername","readertype","sex","max_num","days_num"};
			int i=0;
			boolean rsnext=false;
			while(rs.next()){
				for(int j=0;j<alloptions.length;j++){
					readertable[i][j]=rs.getString(alloptions[j]);
				}
				i++;
				rsnext=true;
			}
			if(rsnext){
				table=new JTable(readertable,heads);
				scrollpane=new JScrollPane(table);
				scrollpane.setBounds(50,120,600,240);
				add(scrollpane);


			}else{
				JOptionPane.showMessageDialog(null,"没有查询到任何相关联的信息");
			}
		}catch(SQLException se){
			JOptionPane.showMessageDialog(null,"找不到你要查询的信息");

		}

	}
	public static void main(String[] args){
		new ReaderQuery();
	}
}