-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathJava238_Jdbc.java
More file actions
97 lines (73 loc) · 2.04 KB
/
Copy pathJava238_Jdbc.java
File metadata and controls
97 lines (73 loc) · 2.04 KB
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
package java0929_jdbc;
import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.List;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
class DesignTest extends JFrame implements ActionListener {
JTextField inputTxt;
JButton searchBtn;
JTable table;
DefaultTableModel model;
public DesignTest() {
inputTxt = new JTextField(20);
searchBtn = new JButton("검색");
JPanel jp = new JPanel();
jp.add(inputTxt);
jp.add(searchBtn);
// 테이블 헤드
Object[] obj = { "사원번호", "사원명", "연봉", "입사일" };
model = new DefaultTableModel(obj, 0) {
// 셀 편집 불가능
@Override
public boolean isCellEditable(int row, int column) {
return false;
}
};
table = new JTable(model);
// 컬럼이동 불가능
table.getTableHeader().setReorderingAllowed(false);
// 라인의 높이
table.setRowHeight(20);
add(jp, BorderLayout.NORTH);
add(new JScrollPane(table), BorderLayout.CENTER);
searchBtn.addActionListener(this);
setSize(500, 400);
setVisible(true);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
@Override
public void actionPerformed(ActionEvent e) {
String data = inputTxt.getText();
inputTxt.requestFocus();
inputTxt.select(0, data.length());
// 테이블 초기화
model.setRowCount(0);
EmpDAO dao = EmpDAO.getInstance();
List<EmpDTO> aList = dao.searchMethod(data);
if (aList.size() == 0) {
JOptionPane.showMessageDialog(this, "검색데이터가 없습니다");
return;
}
for (EmpDTO dto : aList) {
Object[] line = new Object[4];
line[0] = dto.getEmployee_id();
line[1] = dto.getFirst_name();
line[2] = dto.getSalary();
line[3] = dto.getHire_date();
model.addRow(line);
}
}
}
public class Java238_Jdbc {
public static void main(String[] args) {
new DesignTest();
}
}