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;
}
public int[] findValue(String value) {
for (int i = 0; i < myTable.getColumnCount(); i++) {
for (int j = 0; j < myTable.getRowCount(); j++) {
if (value.compareToIgnoreCase(getValueAt(i, j)) == 0) return new int[] {i, j};
}
}
return new int[] {-1, -1};
}
/**
* 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);
}
}
}
}
private void saveColumnSpecification() {
final TableColumnModel columnModel = table.getColumnModel();
final int numColumns = table.getColumnCount();
final List<String> columns = new ArrayList<String>(numColumns);
final List<Integer> columnWidths = new ArrayList<Integer>(numColumns);
for (int i = 0; i < numColumns; i++) {
final String columnName = table.getColumnName(i);
columns.add(columnName);
final TableColumn column = columnModel.getColumn(i);
final int columnWidth = column.getWidth();
columnWidths.add(Integer.valueOf(columnWidth));
}
tableSpecification.setColumnOrder(columns);
tableSpecification.setColumnWidths(columnWidths);
MetricsProfileRepository.getInstance().persistCurrentProfile();
}
public void actionPerformed(final ActionEvent e) {
if (e.getSource() instanceof JButton) {
final JButton button = (JButton) e.getSource();
if (button.getText().equals("Save")) {
AccountManager.getAccounts().clear();
String[] data = new String[4];
for (int i = 0; i < table.getRowCount(); i++) {
for (int x = 0; x < table.getColumnCount(); x++) {
data[x] = (String) table.getValueAt(i, x);
}
AccountManager.getAccounts().add(new Account(data[0], data[1], data[2], data[3]));
}
AccountManager.saveAccounts();
dispose();
} else if (button.getToolTipText().equals("Add")) {
final String str =
JOptionPane.showInputDialog(
getParent(),
"Enter the account username:"******"New Account",
JOptionPane.QUESTION_MESSAGE);
if (str == null || str.isEmpty()) {
return;
}
final int row = table.getRowCount();
((DefaultTableModel) table.getModel()).addRow(new Object[] {str, null, null, null});
((DefaultTableModel) table.getModel()).fireTableRowsInserted(row, row);
} else if (button.getToolTipText().equals("Remove")) {
final int row = table.getSelectedRow();
final String user = (String) table.getModel().getValueAt(table.getSelectedRow(), 0);
if (user != null) {
for (int i = 0; i < AccountManager.getAccounts().size(); i++) {
if (AccountManager.getAccounts().get(i).getUsername().equals(user)) {
AccountManager.getAccounts().remove(i);
}
}
((DefaultTableModel) table.getModel()).fireTableRowsDeleted(row, row);
}
}
}
}
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);
}
}