private Vector<String> getColumnNames() {
Vector<String> columnNames = new Vector<String>();
for (int i = 0; i < jTable1.getColumnCount(); i++) columnNames.add(jTable1.getColumnName(i));
return columnNames;
}
private Component table() {
String[] titles = {
"Year",
"Starting Balance",
"Starting Principal",
"Withdrawals",
"Appreciation",
"Deposits",
"Ending Balance"
};
tableModel = new DefaultTableModel(titles, 0);
for (int i = 0; i < 12800; i++) {
tableModel.addRow(
new Integer[] {1900 + i, 10000 + i, 8000 + i, 50 + i, 905 + i, 2000 + i, 12000 + i});
}
JTable table = new CustomTable(tableModel);
int preferredWidth = 0;
for (int i = 0; i < table.getColumnCount(); i++) {
int width = packColumn(table, i, 2);
preferredWidth += width;
}
Dimension preferredSize = new Dimension(preferredWidth, 400);
table.setPreferredScrollableViewportSize(preferredSize);
this.setMinimumSize(preferredSize);
JScrollPane scrollPane = new JScrollPane(table);
return scrollPane;
}
/**
* This method is activated on the Keystrokes we are listening to in this implementation. Here it
* listens for Copy and Paste ActionCommands. Selections comprising non-adjacent cells result in
* invalid selection and then copy action cannot be performed. Paste is done by aligning the upper
* left corner of the selection with the 1st element in the current selection of the JTable.
*/
public void actionPerformed(ActionEvent e) {
if (e.getActionCommand().compareTo("Copy") == 0) {
StringBuffer sbf = new StringBuffer();
// Check to ensure we have selected only a contiguous block of
// cells
int numcols = jTable1.getSelectedColumnCount();
int numrows = jTable1.getSelectedRowCount();
int[] rowsselected = jTable1.getSelectedRows();
int[] colsselected = jTable1.getSelectedColumns();
if (!((numrows - 1 == rowsselected[rowsselected.length - 1] - rowsselected[0]
&& numrows == rowsselected.length)
&& (numcols - 1 == colsselected[colsselected.length - 1] - colsselected[0]
&& numcols == colsselected.length))) {
JOptionPane.showMessageDialog(
null, "Invalid Copy Selection", "Invalid Copy Selection", JOptionPane.ERROR_MESSAGE);
return;
}
for (int i = 0; i < numrows; i++) {
for (int j = 0; j < numcols; j++) {
sbf.append(jTable1.getValueAt(rowsselected[i], colsselected[j]));
if (j < numcols - 1) sbf.append("\t");
}
sbf.append("\n");
}
stsel = new StringSelection(sbf.toString());
system = Toolkit.getDefaultToolkit().getSystemClipboard();
system.setContents(stsel, stsel);
}
if (e.getActionCommand().compareTo("Paste") == 0) {
System.out.println("Trying to Paste");
int startRow = (jTable1.getSelectedRows())[0];
int startCol = (jTable1.getSelectedColumns())[0];
try {
String trstring =
(String) (system.getContents(this).getTransferData(DataFlavor.stringFlavor));
System.out.println("String is:" + trstring);
StringTokenizer st1 = new StringTokenizer(trstring, "\n");
for (int i = 0; st1.hasMoreTokens(); i++) {
rowstring = st1.nextToken();
StringTokenizer st2 = new StringTokenizer(rowstring, "\t");
for (int j = 0; st2.hasMoreTokens(); j++) {
value = (String) st2.nextToken();
if (startRow + i < jTable1.getRowCount() && startCol + j < jTable1.getColumnCount())
jTable1.setValueAt(value, startRow + i, startCol + j);
System.out.println(
"Putting " + value + "at row = " + startRow + i + "column = " + startCol + j);
}
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
// Determines the width of each column in the table.
protected void determineColumnWidth() {
if (segmentTable.getColumnCount() == 2) {
TableColumn column = null;
for (int i = 0; i < 2; i++) {
column = segmentTable.getColumnModel().getColumn(i);
if (i == 0) {
column.setPreferredWidth(30);
} else {
column.setPreferredWidth(100);
}
}
}
}
void tableInitialise(JTable table) {
JScrollPane scroll;
TableColumn column = null;
int colunms = table.getColumnCount();
for (int y = 0; y < colunms; y++) {
column = table.getColumnModel().getColumn(y);
/*将每一列的默认宽度设置为100*/
column.setPreferredWidth(100);
}
/*
* 设置JTable自动调整列表的状态，此处设置为关闭
*/
table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
table.setFont(new Font("Menu.font", Font.PLAIN, 14));
table.getTableHeader().setFont(new Font("Menu.font", Font.BOLD, 15));
/*用JScrollPane装载JTable，这样超出范围的列就可以通过滚动条来查看*/
scroll = new JScrollPane(table);
TablePanel.removeAll();
TablePanel.setLayout(new BoxLayout(TablePanel, BoxLayout.Y_AXIS));
TablePanel.add(scroll);
TablePanel.revalidate();
table.setRowSelectionAllowed(true); // 设置JTable可被选择
table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); // 设置JTable为单行选择
table.getTableHeader().setBackground(new Color(206, 231, 255)); // 设置JTable表头颜色
table.getTableHeader().setReorderingAllowed(false); // 设置JTable每个字段的顺序不可以改变
table.getTableHeader().setResizingAllowed(false); // 设置JTable每个表头的大小不可以改变
makeFace(table); // 设置JTable 颜色
table.setVisible(true);
}
public static void makeFace(JTable table) {
try {
DefaultTableCellRenderer tcr =
new DefaultTableCellRenderer() {
public Component getTableCellRendererComponent(
JTable table,
Object value,
boolean isSelected,
boolean hasFocus,
int row,
int column) {
if (row % 2 == 0) setBackground(Color.white); // 设置奇数行底色
else if (row % 2 == 1) setBackground(new Color(206, 231, 255)); // 设置偶数行底色
return super.getTableCellRendererComponent(
table, value, isSelected, hasFocus, row, column);
}
};
for (int i = 0; i < table.getColumnCount(); i++) {
table.getColumn(table.getColumnName(i)).setCellRenderer(tcr);
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
// Method to update Table and related components
private void update() {
Database db = new Database();
String column[] = {
"ID",
"NAME",
"GENDER",
"GUARDIAN_ROLE",
"GUARDIAN_NAME",
"PRESENT_ADDRESS",
"PRESENT_CITY",
"PRESENT_PHONE"
};
try {
// Update table
if (searchcombobox.getSelectedIndex() == 0 && allfieldcheckbox.isSelected()) {
mytablemodel = new MyTableModel(db.getAllStudent(), db.getColumnNameFromStudent());
} else if (searchcombobox.getSelectedIndex() == 0 && !allfieldcheckbox.isSelected()) {
mytablemodel = new MyTableModel(db.getSomeFieldsFromStudent(), column);
} else if (searchcombobox.getSelectedIndex() == 1 && allfieldcheckbox.isSelected()) {
String query =
"SELECT * FROM Student WHERE NAME = \'" + searchtextfield.getText().trim() + "\'";
mytablemodel = new MyTableModel(db.getData(query), db.getColumnNameFromStudent());
} else if (searchcombobox.getSelectedIndex() == 1 && !allfieldcheckbox.isSelected()) {
String query =
"SELECT ID, NAME, GENDER, GUARDIAN_ROLE, GUARDIAN_NAME, PRESENT_ADDRESS, PRESENT_CITY, PRESENT_PHONE FROM Student WHERE NAME = \'"
+ searchtextfield.getText().trim()
+ "\'";
mytablemodel = new MyTableModel(db.getData(query), column);
} else if (searchcombobox.getSelectedIndex() == 2 && allfieldcheckbox.isSelected()) {
String query =
"SELECT * FROM Student WHERE GUARDIAN_NAME = \'"
+ searchtextfield.getText().trim()
+ "\'";
mytablemodel = new MyTableModel(db.getData(query), db.getColumnNameFromStudent());
} else if (searchcombobox.getSelectedIndex() == 2 && !allfieldcheckbox.isSelected()) {
String query =
"SELECT ID, NAME, GENDER, GUARDIAN_ROLE, GUARDIAN_NAME, PRESENT_ADDRESS, PRESENT_CITY, PRESENT_PHONE FROM Student WHERE GUARDIAN_NAME = \'"
+ searchtextfield.getText().trim()
+ "\'";
mytablemodel = new MyTableModel(db.getData(query), column);
} else if (searchcombobox.getSelectedIndex() == 3 && allfieldcheckbox.isSelected()) {
String query =
"SELECT * FROM Student WHERE ID = ANY(SELECT SID FROM Fee WHERE CID = ANY(SELECT ID FROM CourseInfo WHERE NAME = \'"
+ searchtextfield.getText().trim()
+ "\'))";
mytablemodel = new MyTableModel(db.getData(query), db.getColumnNameFromStudent());
} else if (searchcombobox.getSelectedIndex() == 3 && !allfieldcheckbox.isSelected()) {
String query =
"SELECT ID, NAME, GENDER, GUARDIAN_ROLE, GUARDIAN_NAME, PRESENT_ADDRESS, PRESENT_CITY, PRESENT_PHONE FROM Student WHERE ID = ANY(SELECT SID FROM Fee WHERE CID = ANY(SELECT ID FROM CourseInfo WHERE NAME = \'"
+ searchtextfield.getText().trim()
+ "\'))";
mytablemodel = new MyTableModel(db.getData(query), column);
} else if (searchcombobox.getSelectedIndex() == 4 && allfieldcheckbox.isSelected()) {
String query =
"SELECT * FROM Student WHERE ID = ANY(SELECT SID FROM Fee WHERE TOTAL_FEES - FEES_PAYED >= 0)";
mytablemodel = new MyTableModel(db.getData(query), db.getColumnNameFromStudent());
} else {
String query =
"SELECT ID, NAME, GENDER, GUARDIAN_ROLE, GUARDIAN_NAME, PRESENT_ADDRESS, PRESENT_CITY, PRESENT_PHONE FROM Student WHERE ID = ANY(SELECT SID FROM Fee WHERE TOTAL_FEES - FEES_PAYED >= 0)";
mytablemodel = new MyTableModel(db.getData(query), column);
}
table = new JTable(mytablemodel);
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
// Add list selection listener to table
table.getSelectionModel().addListSelectionListener(this);
TableColumn col = null;
for (int i = 3; i < table.getColumnCount(); i++) {
col = table.getColumnModel().getColumn(i);
col.setPreferredWidth(200);
}
scrollpane = new JScrollPane(table);
panel_3.removeAll();
panel_3.add(scrollpane);
// Update total student label
int total = db.getTotalStudent();
totalstudentlabel.setText("Total Student = " + total);
// Clear search combo box
searchtextfield.setText("");
this.revalidate();
} catch (Exception e) {
JOptionPane.showMessageDialog(this, e.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);
}
}
