public MediaTable() {
super();
setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);
table =
new JTable() {
private static final long serialVersionUID = 20100125;
public boolean isCellEditable(int x, int y) {
return false;
}
};
DefaultTableModel model = new DefaultTableModel();
model.addColumn("Artist");
model.addColumn("Title");
model.addColumn("Album");
model.addColumn("Length");
String string[] = {"This", "feature", "is not implemented", "yet"};
model.addRow(string);
table.setBackground(Color.WHITE);
table.setModel(model);
table.getTableHeader().setReorderingAllowed(false);
add(table);
setViewportView(table);
}
public void unGreyTable() {
sitesTable.setSelectionBackground(oldSelectionBackground);
sitesTable.setSelectionForeground(oldSelectionForeground);
sitesTable.setForeground(Color.BLACK);
sitesTable.setBackground(Color.WHITE);
sitesTable.setEnabled(true);
}
/**
* Constructor de la clase, crea la tabla y de da todas las propiedades para mostrarla en la
* aplicacion.
*/
public PanelHojaCalculo() {
modelo = new ModeloTabla();
columnasTabla = new ModeloColumnasTabla();
tabla = new JTable(modelo, columnasTabla);
tablaAux = new JTable(modelo, filasTabla);
tabla.createDefaultColumnsFromModel();
tablaAux.createDefaultColumnsFromModel();
tabla.setColumnSelectionAllowed(true);
tabla.setRowSelectionAllowed(true);
tablaAux.setSelectionModel(tabla.getSelectionModel());
tablaAux.setMaximumSize(new Dimension(40, 10000));
tablaAux.setBackground(new Color(238, 238, 238));
// Se puede pasar a true si se quiere seleccionar las filas
tablaAux.setEnabled(false);
tablaAux.setColumnSelectionAllowed(false);
tablaAux.setCellSelectionEnabled(false);
viewPort = new JViewport();
viewPort.setView(tablaAux);
viewPort.setPreferredSize(tablaAux.getMaximumSize());
tabla.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
tablaAux.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
scrollPane = new JScrollPane(tabla);
scrollPane.setRowHeader(viewPort);
scrollPane.setPreferredSize(new Dimension(790, 500));
add(scrollPane);
}
public ViewTelaEscolhaAtividade() {
setTitle("Check In/ Check Out");
setBounds(100, 100, 735, 466);
JPanel panel = new JPanel();
panel.setBackground(new Color(255, 255, 255));
getContentPane().add(panel, BorderLayout.CENTER);
panel.setLayout(null);
textField_PesquisarAtividade = new JTextField();
textField_PesquisarAtividade.setBounds(85, 28, 487, 19);
panel.add(textField_PesquisarAtividade);
textField_PesquisarAtividade.setColumns(10);
btnPesquisar = new JButton("Pesquisar");
btnPesquisar.setBounds(584, 25, 117, 25);
panel.add(btnPesquisar);
table_AtividadeParticipante = new JTable();
table_AtividadeParticipante.setBackground(new Color(50, 205, 50));
table_AtividadeParticipante.setBounds(12, 59, 564, 351);
table_AtividadeParticipante.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
table_AtividadeParticipante =
new JTable() {
@Override
public boolean isCellEditable(int row, int column) {
return false;
}
};
btnCheckIn = new JButton("Check In");
btnCheckIn.setBounds(584, 62, 117, 25);
panel.add(btnCheckIn);
btnCheckIn.setEnabled(false);
btnCheckOut = new JButton("Check Out");
btnCheckOut.setBounds(584, 99, 117, 25);
panel.add(btnCheckOut);
btnCheckOut.setEnabled(false);
btnVoltar = new JButton("Voltar");
btnVoltar.setBounds(596, 385, 117, 25);
panel.add(btnVoltar);
lblAtividade = new JLabel("Atividade:");
lblAtividade.setBounds(12, 30, 87, 15);
panel.add(lblAtividade);
JScrollPane scrollPane = new JScrollPane(table_AtividadeParticipante);
scrollPane.setBounds(12, 60, 560, 350);
panel.add(scrollPane);
this.setVisible(true);
}
private void setDataTebleLockState(boolean b) {
passwd.setText("");
unlock.setEnabled(b);
lock.setEnabled(!b);
if (b) {
table.setEnabled(false);
table.setBackground(Color.white);
} else {
table.setEnabled(true);
table.setBackground(Color.yellow);
JOptionPane.showMessageDialog(
null,
"Administration Mode Unlocked",
"Administration Mode",
JOptionPane.INFORMATION_MESSAGE);
}
}
private void init_table_bg() {
Color ivory = new Color(255, 255, 255);
tbl_chats.setOpaque(true);
jScrollPane1.setBorder(
javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 237, 237)));
tbl_chats.setFillsViewportHeight(true);
tbl_chats.setBackground(ivory);
}
public hostelStatus() {
setTitle("Hostel");
connect();
updateRecord();
JFrame fr = new JFrame();
Toolkit tkt = fr.getToolkit();
Dimension frsize = tkt.getScreenSize();
setBounds(frsize.width / 4, frsize.height / 12, frsize.width / 2, frsize.height / 8);
setLayout(null);
cn = getContentPane();
cn.setBackground(new Color(190, 180, 170));
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
tl = new JLabel("Current Hostels Status");
tl.setFont(new Font("Engravers MT", 1, 25));
tl.setForeground(new Color(247, 251, 249));
p1 = new JPanel();
p1.setBounds(0, 0, 600, 50);
p1.add(tl);
p1.setBackground(new Color(31, 88, 166));
cn.add(p1);
b1 = new JButton("LOAD");
b1.setMnemonic('L');
b1.addActionListener(new dispListener());
b1.setBounds(230, 320, 120, 30);
b2 = new JButton("EXIT");
b2.setMnemonic('X');
b2.addActionListener(new exitListener());
b2.setBounds(350, 320, 100, 30);
cn.add(b1);
cn.add(b2);
table = new JTable(data, col);
table.setFont(new Font("Serif", Font.BOLD, 16));
table.setBackground(new Color(250, 250, 250));
table.setEnabled(false);
JScrollPane jsp = new JScrollPane(table);
jsp.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_NEVER);
jsp.setBounds(5, 100, 590, 200);
cn.add(jsp);
screensize = Toolkit.getDefaultToolkit().getScreenSize();
setSize(600, 400);
setVisible(true);
setVisible(true);
setResizable(true);
connect();
}
void greyOutTable() {
sitesTable.setEnabled(false);
oldSelectionBackground = sitesTable.getSelectionBackground();
oldSelectionForeground = sitesTable.getSelectionForeground();
sitesTable.setSelectionBackground(Color.GRAY);
sitesTable.setSelectionForeground(Color.DARK_GRAY);
sitesTable.setForeground(Color.GRAY);
sitesTable.setBackground(null);
}
public static void main(String[] args) {
/*
构造函数有很多下面先介绍几个:
JTable()
JTable(int numRows, int numColumns)
JTable(Object[][] rowData, Object[] columnNames)
*/
JTable example1 = new JTable(); // 看不到但存在
JTable example2 = new JTable(8, 6);
final Object[] columnNames = {
"姓名", "性别", "家庭地址", // 列名最好用final修饰
"电话号码", "生日", "工作", "收入", "婚姻状况", "恋爱状况"
};
Object[][] rowData = {
{"ddd", "男", "江苏南京", "1378313210", "03/24/1985", "学生", "寄生中", "未婚", "没"},
{"eee", "女", "江苏南京", "13645181705", "xx/xx/1985", "家教", "未知", "未婚", "好象没"},
{"fff", "男", "江苏南京", "13585331486", "12/08/1985", "汽车推销员", "不确定", "未婚", "有"},
{"ggg", "女", "江苏南京", "81513779", "xx/xx/1986", "宾馆服务员", "确定但未知", "未婚", "有"},
{"hhh", "男", "江苏南京", "13651545936", "xx/xx/1985", "学生", "流放中", "未婚", "无数次分手后没有"}
};
JTable friends = new JTable(rowData, columnNames);
friends.setPreferredScrollableViewportSize(new Dimension(600, 100)); // 设置表格的大小
friends.setRowHeight(30); // 设置每行的高度为20
friends.setRowHeight(0, 20); // 设置第1行的高度为15
friends.setRowMargin(5); // 设置相邻两行单元格的距离
friends.setRowSelectionAllowed(true); // 设置可否被选择.默认为false
friends.setSelectionBackground(Color.white); // 设置所选择行的背景色
friends.setSelectionForeground(Color.red); // 设置所选择行的前景色
friends.setGridColor(Color.black); // 设置网格线的颜色
friends.selectAll(); // 选择所有行
friends.setRowSelectionInterval(0, 2); // 设置初始的选择行,这里是1到3行都处于选择状态
friends.clearSelection(); // 取消选择
friends.setDragEnabled(false); // 不懂这个
friends.setShowGrid(false); // 是否显示网格线
friends.setShowHorizontalLines(false); // 是否显示水平的网格线
friends.setShowVerticalLines(true); // 是否显示垂直的网格线
friends.setValueAt("tt", 0, 0); // 设置某个单元格的值,这个值是一个对象
friends.doLayout();
friends.setBackground(Color.lightGray);
JScrollPane pane1 = new JScrollPane(example1); // JTable最好加在JScrollPane上
JScrollPane pane2 = new JScrollPane(example2);
JScrollPane pane3 = new JScrollPane(friends);
JPanel panel = new JPanel(new GridLayout(0, 1));
panel.setPreferredSize(new Dimension(600, 400));
panel.setBackground(Color.black);
panel.add(pane1);
panel.add(pane2);
panel.add(pane3);
JFrame frame = new JFrame("JTableDemo");
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setContentPane(panel);
frame.pack();
frame.show();
}
/**
* This method initializes compareTable
*
* @return javax.swing.JTable
*/
private JTable getCompareTable() {
if (compareTable == null) {
compareTable = new JTable();
compareTable.setBackground(java.awt.Color.white);
compareTable.setFont(new Font("DialogInput", Font.PLAIN, 12));
compareTable.setSelectionMode(javax.swing.ListSelectionModel.SINGLE_SELECTION);
compareTable.setModel(getDefaultTableModel(false));
setTableProps();
}
return compareTable;
}
private void buildWin() {
jpbLoading = new JProgressBar(0, 100);
jfcBrowse = new JFileChooser(Initial.DB_CONFIG_PATH);
jlConfigPath = new JLabel("配置文件路径:");
jlStatus = new JLabel("未操作");
jlConfigPath.setFont(SwingContainerFactory.getFont());
jlStatus.setFont(SwingContainerFactory.getFont());
jlStatus.setForeground(Color.RED);
jpOperatingDbInfo = new JPanel();
jpStatusBar = new JPanel(new BorderLayout());
jpDisplay = new JPanel(new BorderLayout());
jbAddDbInfo = new JButton("添加");
jbDelDbInfo = new JButton("删除");
jbSaveDbInfo = new JButton("保存");
jbBrowse = new JButton("浏览...");
jbLoadDbInfo = new JButton("加载");
jbClearDbInfo = new JButton("清空");
jtfConfigPath = new JTextField(20);
jbAddDbInfo.setFont(SwingContainerFactory.getFont());
jbDelDbInfo.setFont(SwingContainerFactory.getFont());
jbSaveDbInfo.setFont(SwingContainerFactory.getFont());
jbBrowse.setFont(SwingContainerFactory.getFont());
jbLoadDbInfo.setFont(SwingContainerFactory.getFont());
jbClearDbInfo.setFont(SwingContainerFactory.getFont());
jpOperatingDbInfo.add(jbAddDbInfo);
jpOperatingDbInfo.add(jbDelDbInfo);
jpOperatingDbInfo.add(jbClearDbInfo);
jpOperatingDbInfo.add(jbSaveDbInfo);
jpOperatingDbInfo.add(jlConfigPath);
jpOperatingDbInfo.add(jtfConfigPath);
jpOperatingDbInfo.add(jbBrowse);
jpOperatingDbInfo.add(jbLoadDbInfo);
jpStatusBar.add(jpbLoading, BorderLayout.CENTER);
jpStatusBar.add(jlStatus, BorderLayout.WEST);
tmDbInfo = new Table();
jtDbinfo = new JTable(tmDbInfo);
jtDbinfo.setRowHeight(20);
jtDbinfo.setBackground(Color.white);
jtDbinfo.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
TableColumnModel tcm = jtDbinfo.getColumnModel();
for (int i = 0; i < tcm.getColumnCount(); i++) {
tcm.getColumn(i).setPreferredWidth(80);
}
tcm.getColumn(10).setPreferredWidth(150);
tcm.getColumn(11).setPreferredWidth(300);
tcm.getColumn(3).setCellEditor(new DefaultCellEditor(new JComboBox<DBType>(DBType.values())));
jspDbInfo = new JScrollPane(jtDbinfo);
jpDisplay.add(jspDbInfo, BorderLayout.CENTER);
jpDisplay.add(jpOperatingDbInfo, BorderLayout.NORTH);
this.add(jpDisplay, BorderLayout.CENTER);
this.add(jpStatusBar, BorderLayout.SOUTH);
}
private void jbInit() throws Exception {
setTitle("DIARIO CONTADO");
frmDatosVenta = new FrmDatosVenta(engine);
frmDatosVenta.setLocationRelativeTo(this);
getContentPane().setLayout(borderLayout1);
jLabel1.setFont(new java.awt.Font("Arial", Font.PLAIN, 18));
jLabel1.setToolTipText("");
jLabel1.setText("DIARIO DE ENTRADAS");
pnlCentro.setLayout(borderLayout2);
cmdCerrar.setText("CERRAR");
cmdCerrar.addActionListener(new FrmDiarioDeEntradas_cmdCerrar_actionAdapter(this));
cmdImprimir.setText("IMPRIMIR");
tblDiario.setBackground(new Color(255, 240, 255));
tblDiario.setFont(new java.awt.Font("Arial", Font.PLAIN, 12));
tblDiario.setModel(modelDiarioVentasDeContado1);
tblDiario.addMouseListener(new FrmDiarioDeEntradas_tblDiario_mouseAdapter(this));
this.addWindowListener(new FrmDiarioDeEntradas_this_windowAdapter(this));
jLabel2.setFont(new java.awt.Font("Arial", Font.BOLD, 20));
jLabel2.setText("Total:");
lblTotal.setFont(new java.awt.Font("Arial", Font.BOLD, 20));
lblTotal.setText("");
this.getContentPane().setBackground(Color.white);
this.addKeyListener(new FrmDiarioDeEntradas_this_keyAdapter(this));
pnlCentro.setBackground(Color.white);
pnlNorte.setBackground(Color.white);
pnlNorte.setLayout(borderLayout4);
scrollDiario.getViewport().setBackground(Color.white);
scrollDiario.setPreferredSize(new Dimension(800, 600));
lblFecha.setFont(new java.awt.Font("Arial", Font.BOLD, 16));
lblFecha.setText("");
jPanel1.setLayout(borderLayout3);
pnlSur.setMaximumSize(new Dimension(4000, 200));
jPanel1.setBackground(Color.white);
jPanel2.setBackground(Color.white);
this.getContentPane().add(pnlCentro, java.awt.BorderLayout.CENTER);
pnlCentro.add(pnlNorte, java.awt.BorderLayout.CENTER);
pnlCentro.add(scrollDiario, java.awt.BorderLayout.NORTH);
scrollDiario.getViewport().add(tblDiario);
this.getContentPane().add(pnlSur, java.awt.BorderLayout.SOUTH);
pnlSur.add(cmdImprimir);
pnlSur.add(cmdCerrar);
this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
jPanel1.add(lblFecha, java.awt.BorderLayout.EAST);
jPanel1.add(jLabel1, java.awt.BorderLayout.WEST);
pnlNorte.add(jPanel2, java.awt.BorderLayout.EAST);
jPanel2.add(jLabel2);
jPanel2.add(lblTotal);
this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
}
@SuppressWarnings("unused")
private void jbInit() throws Exception {
for (int i = 0; i < 4; i++) for (int j = 0; j < 4; j++) data[i][j] = new Integer(i * 10 + j);
System.out.println("Header length=" + header[1]);
jTable1 = new JTable(data, header);
jTable1.setCellSelectionEnabled(true);
this.setTitle("Excel Lent JTABLE");
jTable1.setBackground(Color.pink);
this.setLayout(borderLayout1);
this.setSize(new Dimension(400, 300));
this.setBackground(Color.white);
JScrollPane scrollPane = new JScrollPane(jTable1);
this.add(scrollPane, BorderLayout.CENTER);
// This is the line that does all the magic!
ExcelAdapter myAd = new ExcelAdapter(jTable1);
}
public DependencyPanel() {
dataControl = new AnalyseUIController();
this.indirectFilterBox = new JCheckBox(dataControl.translate("ShowIndirectDependencies"));
this.indirectFilterBox.addActionListener(this);
createLayout();
dependencyTable = new JTable();
tableModel = new DependencyTableModel(new ArrayList<DependencyDTO>(), dataControl);
dependencyTable.setModel(tableModel);
dependencyScrollPane.setViewportView(dependencyTable);
dependencyTable.setBackground(UIManager.getColor("Panel.background"));
dependencyTable.setAutoCreateRowSorter(true);
initialiseTrees();
setLayout(theLayout);
}
public void makePartTable() throws SQLiteException, PartException {
PartTableModel model = new PartTableModel();
model.addColumn("Id");
model.addColumn("Name");
model.addColumn("Material");
model.addColumn("Projekt Nr.");
model.addColumn("Erstellt am");
sqLite.dbConnect();
datensatz = new PartList(sqLite);
List<IPart> list = datensatz.getDataListSort();
for (int i = 0; i < list.size(); i++) {
IPart d = list.get(i);
model.addRow(
new Object[] {
d.getId(),
d.getName(),
d.getMaterialId(),
d.getProjektNr(),
PartUtil.erstellDatumFormatieren(d.getErstellDatum())
});
}
sqLite.close();
partTable = new JTable(model);
partTable.setSelectionMode(javax.swing.ListSelectionModel.SINGLE_SELECTION);
partTable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
partTable.getColumnModel().getColumn(0).setPreferredWidth(20);
partTable.getColumnModel().getColumn(1).setPreferredWidth(400);
partTable.getColumnModel().getColumn(2).setPreferredWidth(150);
partTable.getColumnModel().getColumn(3).setPreferredWidth(200);
partTable.getColumnModel().getColumn(4).setPreferredWidth(120);
partTable.setBackground(Format.BGCOLOR);
JTableHeader header = partTable.getTableHeader();
header.setBackground(Color.LIGHT_GRAY);
header.setForeground(Color.black);
}
public prueba() {
setBorder(new LineBorder(new Color(0, 0, 0), 2, true));
setBounds(0, 0, 800, 600);
setOpaque(false);
setLayout(null);
JScrollPane scrollPane_1 = new JScrollPane();
scrollPane_1.setBounds(new Rectangle(500, 0, 250, 400));
scrollPane_1.setBounds(50, 50, 650, 450);
add(scrollPane_1);
leftTable = new JTable(new SimpleColorTableModel());
leftTable.setBackground(new Color(153, 204, 255));
scrollPane_1.setViewportView(leftTable);
setupTable(leftTable);
populate((SimpleColorTableModel) leftTable.getModel());
setSize(800, 600);
}
public GoodsInfoDialog(Frame f, String title, boolean model, GoodsBean gb) {
super(f, title, model);
getContentPane().setBackground(new Color(175, 238, 238));
this.gb = gb;
lblGoods = new JLabel("输入相关商品信息进行查询(商品编号、名称)：");
btnAdd = new JButton("增加");
btnAdd.setBackground(new Color(176, 224, 230));
btnUpdate = new JButton("修改");
btnUpdate.setBackground(new Color(176, 224, 230));
btnDel = new JButton("删除");
btnDel.setBackground(new Color(176, 224, 230));
btnExit = new JButton("退出");
btnExit.setBackground(new Color(176, 224, 230));
textGoods = new JTextField();
table = new JTable();
table.setBackground(new Color(176, 224, 230));
GoodsDAO = new GoodsDAOImpl();
init();
// JCheckBox chckbxNewCheckBox = new JCheckBox("显示禁用商品");
// chckbxNewCheckBox.setBounds(676, 65, 103, 23);
// getContentPane().add(chckbxNewCheckBox);
}
public void initTableVente() {
// Desactivation de l'edition d'un cellule lors d'un double click
tableVente =
new JTable() {
public boolean isCellEditable(int row, int column) {
boolean temp = false;
if (column == 4) {
temp = true;
}
return temp;
}
};
tableVente.setName("tableVente");
tableVente.setBackground(new Color(201, 241, 253));
tableVente.setShowGrid(false);
MAJTableVente();
// ajout d'une scrollbare au tableau
JScrollPane scrollPane = new JScrollPane(tableVente);
scrollPane.getViewport().setBackground(new Color(201, 241, 253));
paneVente.add(scrollPane, BorderLayout.CENTER);
}
private void createTicker() {
setBackground(ColorAndFontConstants.BACKGROUND_COLOR);
setLayout(new GridBagLayout());
setOpaque(false);
setFocusable(false);
setToolTipText(
HelpContentsPanel.createMultilineTooltipText(
new String[] {
controller.getLocaliser().getString("tickerTablePanel.tooltip"),
"\n ",
controller.getLocaliser().getString("tickerTablePanel.tooltip.clickToConfigure")
}));
// on mouse click - view the exchanges tab
MouseListener viewPreferencesMouseListener =
new MouseAdapter() {
@Override
public void mouseReleased(MouseEvent arg0) {
controller.displayView(View.PREFERENCES_VIEW);
}
};
String tickerTooltipText =
HelpContentsPanel.createMultilineTooltipText(
new String[] {
controller.getLocaliser().getString("tickerTablePanel.tooltip"),
"\n ",
controller.getLocaliser().getString("tickerTablePanel.tooltip.clickToConfigure")
});
addMouseListener(viewPreferencesMouseListener);
GridBagConstraints constraints = new GridBagConstraints();
tickerTableModel = new TickerTableModel(this.exchangeController);
table = new JTable(tickerTableModel);
table.setOpaque(true);
table.setShowGrid(true);
table.setGridColor(Color.lightGray);
table.setBackground(ColorAndFontConstants.BACKGROUND_COLOR);
table.setBorder(BorderFactory.createMatteBorder(1, 1, 1, 1, SystemColor.windowBorder));
table.setComponentOrientation(
ComponentOrientation.getOrientation(controller.getLocaliser().getLocale()));
table.setRowHeight(getFontMetrics(FontSizer.INSTANCE.getAdjustedDefaultFont()).getHeight());
table.setSelectionMode(javax.swing.ListSelectionModel.SINGLE_SELECTION);
table.setRowSelectionAllowed(false);
table.setColumnSelectionAllowed(false);
table.getTableHeader().setReorderingAllowed(false);
table.setToolTipText(tickerTooltipText);
table.addMouseListener(viewPreferencesMouseListener);
table.getTableHeader().addMouseListener(viewPreferencesMouseListener);
table.getTableHeader().setToolTipText(tickerTooltipText);
table.getTableHeader().setFont(FontSizer.INSTANCE.getAdjustedDefaultFontWithDelta(-1));
int tableHeaderHeight =
fontMetrics.getHeight()
+ table.getTableHeader().getInsets().top
+ table.getTableHeader().getInsets().bottom;
// Windows 8 has slightly taller headers so add a tweak for that.
if (System.getProperty("os.name", "unknown").startsWith("Win")) {
tableHeaderHeight = tableHeaderHeight + WINDOWS_TABLE_HEADER_HEIGHT_TWEAK;
}
int tickerWidth = setupColumnWidths();
setupTableHeaders();
idealHeight =
(fontMetrics.getHeight() + table.getRowMargin()) * tickerTableModel.getRowCount()
+ tableHeaderHeight
+ tickerTableModel.getRowCount()
+ 10;
setPreferredSize(new Dimension(tickerWidth, idealHeight));
scrollPane =
new JScrollPane(
table,
JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_NEVER);
scrollPane.setComponentOrientation(
ComponentOrientation.getOrientation(controller.getLocaliser().getLocale()));
scrollPane.setBorder(BorderFactory.createEmptyBorder());
scrollPane.setViewportBorder(BorderFactory.createEmptyBorder());
scrollPane.addMouseListener(viewPreferencesMouseListener);
setupScrollPane(tickerWidth);
constraints.fill = GridBagConstraints.HORIZONTAL;
constraints.gridx = 0;
constraints.gridy = 0;
constraints.gridwidth = 1;
constraints.weightx = 1;
constraints.weighty = 1;
constraints.anchor = GridBagConstraints.CENTER;
add(scrollPane, constraints);
}
public pnl_wheels_view(int width, int height) {
setBackground(Color.WHITE);
setSize(width, height - 30);
window_width = this.getWidth();
window_height = this.getHeight();
setLayout(null);
tbl_service_details =
new JTable() {
private static final long serialVersionUID = 1L;
protected JTableHeader createDefaultTableHeader() {
return new JTableHeader(columnModel) {
private static final long serialVersionUID = 1L;
public String getToolTipText(MouseEvent e) {
String tip = null;
java.awt.Point p = e.getPoint();
int index = columnModel.getColumnIndexAtX(p.x);
if (index == 8) {
tip = "Enable checkbox if Free checkup is Completed";
}
return tip;
}
};
}
@Override
public Component prepareRenderer(TableCellRenderer renderer, int row, int col) {
Component comp = super.prepareRenderer(renderer, row, col);
int index = (int) getModel().getValueAt(row, 0);
int due_date = fcd_completed_due_date.get(index - 1);
if (col == 8) {
if (due_date == 0) {
comp.setBackground(Color.LIGHT_GRAY);
}
}
return comp;
}
};
tbl_service_details.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
tbl_service_details.setRowSelectionAllowed(false);
mdl_service_details =
new DefaultTableModel() {
private static final long serialVersionUID = 1L;
public boolean isCellEditable(int row, int col) {
if (col == 9) return true;
else if (col == 8 && fcd_completed_due_date.get((int) getValueAt(row, 0) - 1) != 0)
return true;
else return false;
}
public Class<?> getColumnClass(int c) {
if (this.getRowCount() >= 1) {
return getValueAt(0, c).getClass();
} else {
return new String().getClass();
}
}
};
String[] columns = {
"S.NO",
"Customer Name",
"Mobile No",
"Vehicle No",
"Bill Date",
"Remarks",
"Particulars",
"Total",
"FCD",
"Info"
};
mdl_service_details.setColumnIdentifiers(columns);
load_all_sbd();
tbl_service_details.setModel(mdl_service_details);
tbl_service_details.setFont(new Font("Arial", Font.PLAIN, 14));
tbl_service_details.setForeground(Color.DARK_GRAY);
tbl_service_details.setGridColor(Color.BLUE);
tbl_service_details.setBackground(Color.WHITE);
tbl_service_details.setRowMargin(5);
tbl_service_details.setRowHeight(50);
tbl_service_details.getColumn("Particulars").setCellRenderer(new SubTableRenderer());
tbl_service_details.getColumn("Customer Name").setCellRenderer(new WrapCellRenderer());
tbl_service_details.getColumn("Mobile No").setCellRenderer(new WrapCellRenderer());
tbl_service_details.getColumn("Vehicle No").setCellRenderer(new WrapCellRenderer());
tbl_service_details.getColumn("Bill Date").setCellRenderer(new WrapCellRenderer());
tbl_service_details.getColumn("Remarks").setCellRenderer(new WrapCellRenderer());
Action update_fcd =
new AbstractAction() {
private static final long serialVersionUID = 1L;
@Override
public void actionPerformed(ActionEvent e) {
int row = Integer.valueOf(e.getActionCommand());
int completed_date = fcd_completed_date.get(row);
int due_date = fcd_completed_due_date.get(row);
if (due_date > 0) {
String msg = "";
if (completed_date > 0) {
msg =
"<html><Table>"
+ "<tr>"
+ "<td><font color='green'> FreeCheckup Status </font></td>"
+ "<td> : </td>"
+ "<td><font color='green'> Completed </font></td>"
+ "</tr>"
+ "<tr>"
+ "<td><font color='green'> Completed Date </font></td>"
+ "<td> : </td>"
+ "<td><font color='green'>"
+ Time.get_date(completed_date, "dd/MM/yyyy hh:mm:ss a")
+ " </font></td>"
+ "</tr>"
+ "</Table></html>";
} else if (completed_date == 0) {
msg =
"<html><Table>"
+ "<tr>"
+ "<td><font color='red'> FreeCheckup Status </font></td>"
+ "<td> : </td>"
+ "<td><font color='red'> Not Completed </font></td>"
+ "</tr>"
+ "<tr>"
+ "<td><font color='red'> Due Date </font></td>"
+ "<td> : </td>"
+ "<td><font color='red'>"
+ Time.get_date(due_date)
+ " </font></td>"
+ "</tr>"
+ "</Table></html>";
}
JOptionPane.showMessageDialog(tbl_service_details, msg);
} else {
JOptionPane.showMessageDialog(
tbl_service_details, " This bill don't have any service which has Free Checkup");
}
}
};
@SuppressWarnings("unused")
ButtonColumn buttonColumn = new ButtonColumn(tbl_service_details, update_fcd, 9);
tbl_service_details.addMouseListener(
new java.awt.event.MouseAdapter() {
@Override
public void mouseClicked(java.awt.event.MouseEvent evt) {
int col = tbl_service_details.columnAtPoint(evt.getPoint());
int row = tbl_service_details.rowAtPoint(evt.getPoint());
ServiceBill obj_service_bill = null;
int index = (int) tbl_service_details.getValueAt(row, 0) - 1;
boolean is_fcd_update =
(col == 8 && fcd_completed_due_date.get(index) > 0) ? true : false;
if (col == 0 || is_fcd_update) {
String date_str = tbl_service_details.getValueAt(row, 4).toString();
obj_service_bill = dbh.get_service_bill(vehicle_id.get(index), date_str);
}
if ((col == 0 || is_fcd_update) && obj_service_bill == null) {
JOptionPane.showMessageDialog(
tbl_service_details, "Error while getting service bill object");
Logger.log.severe(
"Error while getting service bill object for service bill id " + index);
} else if (col == 0) {
wheel_bill_print obj_wbp = new wheel_bill_print(obj_service_bill.getId());
obj_wbp.setVisible(true);
} else if (is_fcd_update) {
int epoch = (boolean) tbl_service_details.getValueAt(row, col) ? Time.now() : 0;
fcd_completed_date.set(index, epoch);
obj_service_bill.setFree_checkup_completed(epoch);
dbh.update(obj_service_bill);
}
}
});
JTableHeader obj_jtable_header = tbl_service_details.getTableHeader();
obj_jtable_header.setBackground(Color.BLUE);
obj_jtable_header.setForeground(Color.WHITE);
obj_jtable_header.setFont(new Font("Dialog", Font.BOLD | Font.ITALIC, 12));
JScrollPane jsp_service_details = new JScrollPane(tbl_service_details);
jsp_service_details.setForeground(new Color(102, 153, 255));
jsp_service_details.setBorder(new MatteBorder(3, 3, 3, 3, (Color) new Color(204, 51, 102)));
jsp_service_details.setBackground(new Color(204, 102, 153));
jsp_service_details.setBounds(20, 120, window_width - 40, window_height - 220);
add(jsp_service_details);
int tbl_width = jsp_service_details.getWidth();
tbl_service_details.getColumn("S.NO").setMaxWidth((tbl_width / 100) * 4);
tbl_service_details.getColumn("Customer Name").setPreferredWidth((tbl_width / 100) * 9);
tbl_service_details.getColumn("Mobile No").setWidth((tbl_width / 100) * 9);
tbl_service_details.getColumn("Vehicle No").setWidth((tbl_width / 100) * 7);
tbl_service_details.getColumn("Bill Date").setWidth((tbl_width / 100) * 10);
tbl_service_details.getColumn("Remarks").setPreferredWidth((tbl_width / 100) * 8);
tbl_service_details.getColumn("Total").setMaxWidth((tbl_width / 100) * 8);
tbl_service_details.getColumn("FCD").setMaxWidth((tbl_width / 100) * 10);
tbl_service_details.getColumn("Info").setMaxWidth((tbl_width / 100) * 8);
tbl_service_details.getColumn("Particulars").setPreferredWidth((tbl_width / 100) * 28);
rowSorter = new TableRowSorter<>(tbl_service_details.getModel());
tbl_service_details.setRowSorter(rowSorter);
JPanel pnl_search = new JPanel();
pnl_search.setBackground(new Color(204, 51, 153));
pnl_search.setBorder(new MatteBorder(3, 3, 3, 3, (Color) new Color(204, 51, 153)));
pnl_search.setBounds(20, 95, tbl_width, 30);
add(pnl_search);
pnl_search.setLayout(new BoxLayout(pnl_search, BoxLayout.X_AXIS));
JLabel lbl_search_word = new JLabel("Search Text ");
lbl_search_word.setBackground(new Color(204, 153, 0));
lbl_search_word.setAlignmentX(Component.CENTER_ALIGNMENT);
pnl_search.add(lbl_search_word);
lbl_search_word.setForeground(new Color(255, 255, 153));
lbl_search_word.setFont(new Font("Bitstream Charter", Font.BOLD | Font.ITALIC, 18));
txt_search_word = new JTextField();
txt_search_word.setBackground(new Color(255, 255, 255));
pnl_search.add(txt_search_word);
txt_search_word.setColumns(10);
txt_search_word
.getDocument()
.addDocumentListener(
new DocumentListener() {
@Override
public void insertUpdate(DocumentEvent e) {
String text = txt_search_word.getText();
if (text.trim().length() == 0) {
rowSorter.setRowFilter(null);
} else {
rowSorter.setRowFilter(RowFilter.regexFilter("(?i)" + text));
}
calculate_total();
}
@Override
public void removeUpdate(DocumentEvent e) {
String text = txt_search_word.getText();
if (text.trim().length() == 0) {
rowSorter.setRowFilter(null);
} else {
rowSorter.setRowFilter(RowFilter.regexFilter("(?i)" + text));
}
calculate_total();
}
@Override
public void changedUpdate(DocumentEvent e) {
throw new UnsupportedOperationException(
"Not supported yet."); // To change body of generated methods, choose Tools |
// Templates.
}
});
JPanel pnl_total = new JPanel();
pnl_total.setBackground(Color.WHITE);
pnl_total.setBorder(new MatteBorder(3, 3, 3, 3, (Color) new Color(204, 51, 153)));
pnl_total.setBounds(20, window_height - 105, tbl_width, 40);
add(pnl_total);
pnl_total.setLayout(new BoxLayout(pnl_total, BoxLayout.X_AXIS));
pnl_total.add(Box.createHorizontalGlue());
lbl_total = new JLabel("Total ");
lbl_total.setBackground(new Color(204, 153, 0));
lbl_total.setAlignmentX(Component.CENTER_ALIGNMENT);
pnl_total.add(lbl_total);
lbl_total.setForeground(Color.BLUE);
lbl_total.setVisible(false);
lbl_total.setFont(new Font("Bitstream Charter", Font.BOLD | Font.ITALIC, 18));
btn_toggle_total = new JButton("Show Total");
btn_toggle_total.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
String btn_text = btn_toggle_total.getText();
if (btn_text.equals("Show Total")) {
lbl_total.setVisible(true);
btn_toggle_total.setText("Hide Total");
} else {
lbl_total.setVisible(false);
btn_toggle_total.setText("Show Total");
}
}
});
pnl_total.add(btn_toggle_total);
cmb_search_catagory = new JComboBox<String>();
cmb_search_catagory.setBounds((window_width / 2) - 245, 45, 225, 24);
cmb_search_catagory.addItem("Vehicle Number");
cmb_search_catagory.addItem("Customer Name");
cmb_search_catagory.addItem("Date Period");
cmb_search_catagory.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (cmb_search_catagory.getSelectedIndex() != 2) {
load_all_sbd();
calculate_total();
jdp_from.setVisible(false);
jdp_to.setVisible(false);
txt_search_text.setVisible(true);
} else {
jdp_from.setVisible(true);
jdp_to.setVisible(true);
txt_search_text.setVisible(false);
}
}
});
add(cmb_search_catagory);
jdp_from = new JXDatePicker();
jdp_from.setDate(Calendar.getInstance().getTime());
jdp_from.setFormats(new SimpleDateFormat("dd.MM.yyyy"));
jdp_from.setBounds((window_width / 2), 28, 225, 24);
jdp_from.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
load_sbd_bw_date_range();
}
});
add(jdp_from);
jdp_from.setVisible(false);
jdp_to = new JXDatePicker();
jdp_to.setDate(Calendar.getInstance().getTime());
jdp_to.setFormats(new SimpleDateFormat("dd.MM.yyyy"));
jdp_to.setBounds((window_width / 2), 58, 225, 24);
jdp_to.setVisible(false);
jdp_to.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
jdp_from.getMonthView().setUpperBound(jdp_to.getDate());
load_sbd_bw_date_range();
}
});
add(jdp_to);
txt_search_text = new JTextField();
txt_search_text.setBorder(new LineBorder(new Color(0, 0, 0)));
txt_search_text.setBounds((window_width / 2), 45, 225, 24);
add(txt_search_text);
txt_search_text
.getDocument()
.addDocumentListener(
new DocumentListener() {
@Override
public void insertUpdate(DocumentEvent e) {
update_filter();
calculate_total();
}
@Override
public void removeUpdate(DocumentEvent e) {
update_filter();
calculate_total();
}
@Override
public void changedUpdate(DocumentEvent e) {
update_filter();
calculate_total();
}
});
calculate_total();
txt_search_word.setText(Time.get_current_date_time());
}
public void setTagInfos(TagInfo tagInfo) {
this.tagInfo = tagInfo;
infoTable.setBackground(Color.WHITE);
infoTable.setModel(new InfoTableModel("general"));
}
@SuppressWarnings({"unchecked", "rawtypes"})
public InterfaceTrans() {
setTitle("Pantalla Principal");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setSize(1280, 720); // Tamaño
setLocationRelativeTo(null); // Centrar ventana
// donde se ejecute el programa
setResizable(true);
setVisible(true);
// Quito la visibilidad de los elementos del padre que no necesito
super.contentPane.setVisible(false); // para que se vea mi Panel en vez
// del gris heredado
super.menu2.setVisible(false);
super.tb1.setVisible(false);
// Añado a la barra los elementos que si necesito
abrir = new JMenuItem("Abrir... Alt+B");
abrir.setMnemonic('B');
abrir.setIcon(new ImageIcon(InterfaceTrans.class.getResource(""))); // ""
// para
// colocar
// un
// icono
abrir.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent ae) {
try {
InterfaceTrans.archivotrans();
} catch (Throwable e) {
e.printStackTrace();
}
}
});
super.menu1.add(abrir);
// -------------- Tabla ----------------------------------------------
// -------------------------------------------------------------------
tabla = new JTable();
// ARRAY QUE CAPTURA EL CONTENIDO
contenido = new Object[Tablas.transporte.size()][6];
int contador = 0;
for (Entry<Integer, Transporte> entrada : Tablas.transporte.entrySet()) {
contenido[contador][0] = entrada.getValue().getId();
contenido[contador][1] = entrada.getValue().getIdCliente();
contenido[contador][2] = entrada.getValue().getIdProducto();
contenido[contador][3] = entrada.getValue().isTipoViaje();
contenido[contador][4] = entrada.getValue().getFechaEntrega();
contenido[contador][5] = entrada.getValue().getFechaRecogida();
contador++;
}
ModeloTablaTrans =
new DefaultTableModel(contenido, columnas) {
private static final long serialVersionUID = 1L;
public boolean isCellEditable(int rowIndex, int columnIndex) {
return false;
}
};
// -----
// COJEMO EL MODELO DE LA TABLA
tabla = new JTable(ModeloTablaTrans);
tabla.setShowVerticalLines(true);
tabla.setShowHorizontalLines(true);
tabla.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); // SELECCION SENCILLA
tabla.setVisible(true);
sp = new JScrollPane(tabla); // Necesita un Scroll para que se vean las columnas
sp.setBounds(608, 182, 616, 337);
// -------A partir de aqui el tabbedPaned-------------------
separador = new JTabbedPane();
panel1 = new JPanel();
panel1.setBackground(Color.LIGHT_GRAY); // asi le damos color al panel
panel1.setLayout(null);
lblId_Transporte = new JLabel("N\u00BA Transporte:");
lblId_Transporte.setFont(new Font("Arial", Font.BOLD, 13));
lblId_Cliente = new JLabel("ID Cliente:");
lblId_Cliente.setFont(new Font("Arial", Font.BOLD, 13));
lblId_Producto = new JLabel("ID Producto:");
lblId_Producto.setFont(new Font("Arial", Font.BOLD, 13));
lblTipo_Viaje = new JLabel("Tipo Viaje:");
lblTipo_Viaje.setFont(new Font("Arial", Font.BOLD, 13));
lblFechaEnvio = new JLabel("Fecha Envio:");
lblFechaEnvio.setFont(new Font("Arial", Font.BOLD, 13));
lblFechaRecepcion = new JLabel("Fecha Rcogida:");
lblFechaRecepcion.setFont(new Font("Arial", Font.BOLD, 13));
// ----------cajas de texto ----------------
cajaId_Transporte = new JTextField();
cajaId_Transporte.setEnabled(false);
cajaId_Cliente = new JTextField();
cajaId_Producto = new JTextField();
cajaTipo_Viaje = new JTextField();
// --------botones-------------------
guardar = new JButton("Guardar");
guardar.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
Transporte t = new Transporte();
Disparador d = new Disparador("idTransporte");
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
if (t.insertar(
d.nextValue(),
Integer.parseInt(cajaId_Cliente.getText()),
Integer.parseInt(cajaId_Producto.getText()),
cajaTipo_Viaje.getText(),
sdf.format(dateEnvio.getCalendar().getTime()),
sdf.format(dateRecep.getCalendar().getTime()))
== true) {
JOptionPane.showMessageDialog(
null, "El registro " + d.insert() + " se ha insertado correctamente");
}
}
});
borrar = new JButton("LIMPIAR REGISTRO");
borrar.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) { // usado para dejar las vacías
cajaId_Transporte.setText(null);
cajaId_Cliente.setText(null);
cajaId_Producto.setText(null);
cajaTipo_Viaje.setText(null);
dateRecep.setCalendar(null); // vaciamos la caja del calendario
dateEnvio.setCalendar(null); // vaciamos la caja del calendario
}
});
lblId_Transporte.setBounds(73, 181, 187, 28);
lblId_Cliente.setBounds(73, 220, 187, 30);
lblId_Producto.setBounds(73, 261, 187, 30);
lblTipo_Viaje.setBounds(73, 302, 187, 30);
lblFechaEnvio.setBounds(73, 343, 187, 28);
lblFechaRecepcion.setBounds(73, 382, 187, 30);
// ----------Cajas-------------
cajaId_Transporte.setBounds(270, 179, 124, 30);
cajaId_Cliente.setBounds(270, 221, 250, 30);
cajaId_Producto.setBounds(270, 262, 250, 30);
cajaTipo_Viaje.setBounds(270, 302, 85, 30);
// ----------Botones-------------
guardar.setBounds(270, 423, 85, 30);
borrar.setBounds(384, 423, 136, 30);
dateRecep.setBounds(270, 382, 250, 30);
panel1.add(sp);
panel1.add(guardar);
panel1.add(borrar);
panel1.add(lblId_Transporte);
panel1.add(lblId_Cliente);
panel1.add(lblId_Producto);
panel1.add(lblTipo_Viaje);
panel1.add(lblFechaEnvio);
panel1.add(lblFechaRecepcion);
panel1.add(cajaId_Transporte);
panel1.add(cajaId_Cliente);
panel1.add(cajaId_Producto);
panel1.add(cajaTipo_Viaje);
separador.addTab("Gestion de Transporte", null, panel1, "Separador1"); // Añadimos
// el
// Panel1
// al
// separador
panel1.add(dateRecep);
dateEnvio = new JDateChooser();
dateEnvio.setBounds(270, 343, 250, 30);
panel1.add(dateEnvio);
btnOk = new JButton("OK");
btnOk.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
cajaTipo_Viaje.setText((String) comboBox.getSelectedItem());
}
});
btnOk.setBounds(473, 302, 47, 30);
panel1.add(btnOk);
comboBox = new JComboBox();
comboBox.setModel(
new DefaultComboBoxModel(new String[] {"Entrega", "Recogida", "Mixto", "Anulado"}));
comboBox.setBounds(365, 302, 98, 30);
panel1.add(comboBox);
btnNewButton = new JButton("Generar N\u00BA");
btnNewButton.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
cajaId_Transporte.setText(new Disparador("idTransporte").nextValue() + "");
}
});
btnNewButton.setBounds(404, 182, 116, 26);
panel1.add(btnNewButton);
lblModuloTransporte = new JLabel("MODULO TRANSPORTE");
lblModuloTransporte.setFont(new Font("Tahoma", Font.BOLD | Font.ITALIC, 30));
lblModuloTransporte.setBounds(101, 28, 362, 37);
panel1.add(lblModuloTransporte);
JSeparator separatortitulo = new JSeparator();
separatortitulo.setBackground(Color.BLACK);
separatortitulo.setBounds(46, 68, 417, 10);
panel1.add(separatortitulo);
label = new JLabel("");
label.setIcon(
new ImageIcon(InterfaceTrans.class.getResource("/FinalLaGestionTransport/truckmini.png")));
label.setBounds(47, 11, 62, 54);
panel1.add(label);
label_logo = new JLabel("");
label_logo.setIcon(
new ImageIcon(InterfaceTrans.class.getResource("/FinalLaGestionTransport/mini-logo.png")));
label_logo.setBounds(1058, 11, 207, 114);
panel1.add(label_logo);
getContentPane().add(separador); // sin esto no se veria nada, añadimos
// al JFrame el JTabbedPane
// ------------------------------------------------------------------------------------------------
// --------------------------A partir de aquí el panel 2
// ------------------------------------------
// ------------------------------------------------------------------------------------------------
panel2 = new JPanel();
panel2.setBackground(Color.LIGHT_GRAY); // asi le damos color al panel1
panel2.setLayout(null);
separador.addTab("Conductores", null, panel2, "Separador1");
btnAgregarCondutores = new JButton("MODIFICAR CONDUCTORES");
btnAgregarCondutores.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
// AddConductores verformulario2 = new AddConductores();
// verformulario2.setVisible(true);
try {
Runtime.getRuntime()
.exec("rundll32 url.dll,FileProtocolHandler C:\\LaGestion\\Conductores.xls");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
});
tabla2 = new JTable();
tabla21 = new DefaultTableModel();
tabla2.setModel(tabla21);
tabla2.setBorder(new BevelBorder(BevelBorder.LOWERED, null, null, null, null));
tabla2.setBackground(Color.LIGHT_GRAY);
tabla2.setBounds(601, 189, 648, 400);
// No queremos ver las lineas verticales
tabla2.setShowVerticalLines(true);
// No queremos ver las lineas verticales
tabla2.setShowHorizontalLines(true);
panel2.add(tabla2);
btnAgregarCondutores.setBounds(384, 216, 207, 103);
panel2.add(btnAgregarCondutores);
labelLogo = new JLabel("");
labelLogo.setIcon(
new ImageIcon(InterfaceTrans.class.getResource("/FinalLaGestionTransport/mini-logo.png")));
labelLogo.setBounds(1042, 11, 207, 114);
panel2.add(labelLogo);
labelConductor = new JLabel("LISTADO CONDUCTORES");
labelConductor.setFont(new Font("Tahoma", Font.BOLD | Font.ITALIC, 30));
labelConductor.setBounds(100, 33, 402, 37);
panel2.add(labelConductor);
label_2 = new JLabel("");
label_2.setIcon(
new ImageIcon(InterfaceTrans.class.getResource("/FinalLaGestionTransport/truckmini.png")));
label_2.setBounds(51, 16, 62, 54);
panel2.add(label_2);
separatorTitulo = new JSeparator();
separatorTitulo.setBackground(Color.BLACK);
separatorTitulo.setBounds(61, 72, 441, 10);
panel2.add(separatorTitulo);
// RELOJ
hilo = new Thread(this);
hilo.start();
lblReloj = new JLabel("");
lblReloj.setFont(new Font("Tahoma", Font.BOLD | Font.ITALIC, 22));
lblReloj.setBounds(61, 189, 312, 201);
panel2.add(lblReloj);
// Label Turno
lblTurno = new JLabel("HORARIO/TURNO");
lblTurno.setFont(new Font("Tahoma", Font.BOLD | Font.ITALIC, 18));
lblTurno.setBounds(61, 401, 186, 27);
panel2.add(lblTurno);
lblVerturno = new JLabel("");
lblVerturno.setFont(new Font("Tahoma", Font.BOLD | Font.ITALIC, 24));
lblVerturno.setForeground(Color.BLUE);
lblVerturno.setBounds(61, 446, 233, 66);
panel2.add(lblVerturno);
btnVerConductores = new JButton("VER CONDUCTORES");
btnVerConductores.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
String ruta = "C:\\LaGestion\\Conductores.xls";
JFileChooser excel = new JFileChooser();
excel.setSelectedFile(new File(ruta));
File archivoexcel = null;
archivoexcel = excel.getSelectedFile().getAbsoluteFile();
try {
Workbook leerEx = Workbook.getWorkbook(archivoexcel);
for (int hoja = 0; hoja < leerEx.getNumberOfSheets(); hoja++) {
Sheet hojap = leerEx.getSheet(hoja);
int colum2 = hojap.getColumns();
int filas1 = hojap.getRows();
Object data[] = new Object[colum2];
for (int fila = 0; fila < filas1; fila++) {
for (int colum1 = 0; colum1 < colum2; colum1++) {
if (fila == 0) {
tabla21.addColumn(hojap.getCell(colum1, fila).getContents());
}
// System.out.println(hojap.getCell(colum1, fila).getContents());
if (fila >= 1) data[colum1] = hojap.getCell(colum1, fila).getContents();
}
tabla21.addRow(data);
}
}
// opcional
tabla21.removeRow(0);
} catch (Exception e) {
}
// FIN DE LEER EXCEL
btnVerConductores.setEnabled(false);
}
});
btnVerConductores.setBounds(601, 141, 153, 37);
panel2.add(btnVerConductores);
// Separador
getContentPane().add(separador); // sin esto no se veria nada, añadimos
// al JFrame el JTabbedPane
}
public PathDialog(JFrame frame, ArrayList<Path> list, ArrayList<Edge> elist) {
super(frame, true);
setLocation(new Point(200, 100));
setSize(new Dimension(800, 521));
setTitle("Set Path");
pathsList = list;
edgesList = elist;
JPanel tablePanel = new JPanel();
tablePanel.setBorder(null);
JPanel buttonPanel = new JPanel();
JPanel bottomPanel = new JPanel();
JPanel dataEntryPanel = new JPanel();
GroupLayout groupLayout = new GroupLayout(getContentPane());
groupLayout.setHorizontalGroup(
groupLayout
.createParallelGroup(Alignment.TRAILING)
.addGroup(
groupLayout
.createSequentialGroup()
.addGroup(
groupLayout
.createParallelGroup(Alignment.LEADING)
.addGroup(
groupLayout
.createSequentialGroup()
.addGap(14)
.addComponent(
dataEntryPanel,
GroupLayout.DEFAULT_SIZE,
766,
Short.MAX_VALUE))
.addGroup(
groupLayout
.createSequentialGroup()
.addContainerGap()
.addGroup(
groupLayout
.createParallelGroup(Alignment.TRAILING)
.addGroup(
groupLayout
.createSequentialGroup()
.addComponent(
tablePanel,
GroupLayout.DEFAULT_SIZE,
657,
Short.MAX_VALUE)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(
buttonPanel,
GroupLayout.PREFERRED_SIZE,
GroupLayout.DEFAULT_SIZE,
GroupLayout.PREFERRED_SIZE))
.addComponent(
bottomPanel,
GroupLayout.DEFAULT_SIZE,
768,
Short.MAX_VALUE))))
.addContainerGap()));
groupLayout.setVerticalGroup(
groupLayout
.createParallelGroup(Alignment.LEADING)
.addGroup(
groupLayout
.createSequentialGroup()
.addContainerGap()
.addGroup(
groupLayout
.createParallelGroup(Alignment.LEADING)
.addComponent(
buttonPanel,
GroupLayout.PREFERRED_SIZE,
GroupLayout.DEFAULT_SIZE,
GroupLayout.PREFERRED_SIZE)
.addComponent(
tablePanel,
GroupLayout.PREFERRED_SIZE,
240,
GroupLayout.PREFERRED_SIZE))
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(
dataEntryPanel, GroupLayout.PREFERRED_SIZE, 172, GroupLayout.PREFERRED_SIZE)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(
bottomPanel, GroupLayout.PREFERRED_SIZE, 47, GroupLayout.PREFERRED_SIZE)
.addContainerGap()));
tablePanel.setLayout(new BoxLayout(tablePanel, BoxLayout.X_AXIS));
String columnNames[] = {"Name", "Edges", "Max Speed", "Vehicle/Min"};
model = new DefaultTableModel(columnNames, 0);
table = new JTable(model);
table.setGridColor(Color.LIGHT_GRAY);
table.setBackground(Color.WHITE);
table.setBorder(null);
table.setPreferredScrollableViewportSize(new Dimension(650, 170));
table.setFillsViewportHeight(true);
JScrollPane scrollPane = new JScrollPane(table);
scrollPane.setBorder(null);
tablePanel.add(scrollPane);
JLabel lblName = new JLabel("Name :");
JLabel lblEdges = new JLabel("Edges :");
JLabel lblMaxSpeed = new JLabel("Max Speed :");
JLabel lblVehiclemin = new JLabel("Vehicle/min :");
txtPathName = new JTextField();
txtPathName.setColumns(10);
txtMaxSpeed = new JTextField();
txtMaxSpeed.setColumns(10);
txtVehicleMin = new JTextField();
txtVehicleMin.setColumns(10);
txtEdges = new JTextField();
txtEdges.setColumns(10);
GroupLayout gl_dataEntryPanel = new GroupLayout(dataEntryPanel);
gl_dataEntryPanel.setHorizontalGroup(
gl_dataEntryPanel
.createParallelGroup(Alignment.LEADING)
.addGroup(
gl_dataEntryPanel
.createSequentialGroup()
.addContainerGap()
.addGroup(
gl_dataEntryPanel
.createParallelGroup(Alignment.LEADING)
.addComponent(lblName)
.addComponent(lblEdges)
.addComponent(lblMaxSpeed)
.addComponent(lblVehiclemin))
.addGap(49)
.addGroup(
gl_dataEntryPanel
.createParallelGroup(Alignment.LEADING)
.addComponent(
txtVehicleMin, GroupLayout.DEFAULT_SIZE, 502, Short.MAX_VALUE)
.addGroup(
gl_dataEntryPanel
.createParallelGroup(Alignment.TRAILING)
.addComponent(txtMaxSpeed)
.addComponent(txtEdges, Alignment.LEADING)
.addComponent(
txtPathName,
Alignment.LEADING,
GroupLayout.DEFAULT_SIZE,
502,
Short.MAX_VALUE)))
.addContainerGap(117, GroupLayout.PREFERRED_SIZE)));
gl_dataEntryPanel.setVerticalGroup(
gl_dataEntryPanel
.createParallelGroup(Alignment.LEADING)
.addGroup(
gl_dataEntryPanel
.createSequentialGroup()
.addContainerGap()
.addGroup(
gl_dataEntryPanel
.createParallelGroup(Alignment.BASELINE)
.addComponent(lblName)
.addComponent(
txtPathName,
GroupLayout.PREFERRED_SIZE,
GroupLayout.DEFAULT_SIZE,
GroupLayout.PREFERRED_SIZE))
.addPreferredGap(ComponentPlacement.RELATED)
.addGroup(
gl_dataEntryPanel
.createParallelGroup(Alignment.BASELINE)
.addComponent(lblEdges)
.addComponent(
txtEdges,
GroupLayout.PREFERRED_SIZE,
GroupLayout.DEFAULT_SIZE,
GroupLayout.PREFERRED_SIZE))
.addPreferredGap(ComponentPlacement.RELATED)
.addGroup(
gl_dataEntryPanel
.createParallelGroup(Alignment.BASELINE)
.addComponent(lblMaxSpeed)
.addComponent(
txtMaxSpeed,
GroupLayout.PREFERRED_SIZE,
GroupLayout.DEFAULT_SIZE,
GroupLayout.PREFERRED_SIZE))
.addPreferredGap(ComponentPlacement.RELATED)
.addGroup(
gl_dataEntryPanel
.createParallelGroup(Alignment.BASELINE)
.addComponent(
txtVehicleMin,
GroupLayout.PREFERRED_SIZE,
GroupLayout.DEFAULT_SIZE,
GroupLayout.PREFERRED_SIZE)
.addComponent(lblVehiclemin))
.addGap(40)));
dataEntryPanel.setLayout(gl_dataEntryPanel);
JButton btnAdd = new JButton("Add");
btnAdd.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
addValuesToTable();
txtPathName.setText("");
txtEdges.setText("");
txtMaxSpeed.setText("");
txtVehicleMin.setText("");
}
});
JButton btnRemove = new JButton("Delete");
btnRemove.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
removeRows(table.getSelectedRow());
txtPathName.setText("");
txtEdges.setText("");
txtMaxSpeed.setText("");
txtVehicleMin.setText("");
}
});
GroupLayout gl_buttonPanel = new GroupLayout(buttonPanel);
gl_buttonPanel.setHorizontalGroup(
gl_buttonPanel
.createParallelGroup(Alignment.LEADING)
.addGroup(
gl_buttonPanel
.createSequentialGroup()
.addContainerGap()
.addGroup(
gl_buttonPanel
.createParallelGroup(Alignment.LEADING)
.addComponent(btnRemove, Alignment.TRAILING)
.addComponent(
btnAdd,
Alignment.TRAILING,
GroupLayout.DEFAULT_SIZE,
GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE))
.addContainerGap()));
gl_buttonPanel.setVerticalGroup(
gl_buttonPanel
.createParallelGroup(Alignment.LEADING)
.addGroup(
gl_buttonPanel
.createSequentialGroup()
.addGap(49)
.addComponent(btnAdd)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(btnRemove)
.addContainerGap(55, Short.MAX_VALUE)));
buttonPanel.setLayout(gl_buttonPanel);
JButton btnApply = new JButton("Apply");
btnApply.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
getValuesFromTable();
setVisible(false);
}
});
JButton btnCancel = new JButton("Cancel");
btnCancel.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
setVisible(false);
}
});
GroupLayout gl_bottomPanel = new GroupLayout(bottomPanel);
gl_bottomPanel.setHorizontalGroup(
gl_bottomPanel
.createParallelGroup(Alignment.LEADING)
.addGroup(
Alignment.TRAILING,
gl_bottomPanel
.createSequentialGroup()
.addContainerGap(359, Short.MAX_VALUE)
.addComponent(btnCancel)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(btnApply)
.addContainerGap()));
gl_bottomPanel.setVerticalGroup(
gl_bottomPanel
.createParallelGroup(Alignment.LEADING)
.addGroup(
Alignment.TRAILING,
gl_bottomPanel
.createSequentialGroup()
.addContainerGap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(
gl_bottomPanel
.createParallelGroup(Alignment.BASELINE)
.addComponent(btnApply)
.addComponent(btnCancel))
.addContainerGap()));
bottomPanel.setLayout(gl_bottomPanel);
getContentPane().setLayout(groupLayout);
}
/**
* Create a JTable with data Model.
*
* @param columnsName : Titles of JTable columns.
*/
public SwingScilabVariableBrowser(String[] columnsName, int[] aligment) {
super(UiDataMessages.VARIABLE_BROWSER, VARBROWSERUUID);
setAssociatedXMLIDForHelp("browsevar");
buildMenuBar();
addMenuBar(menuBar);
ToolBar toolBar = ScilabToolBar.createToolBar();
toolBar.add(RefreshAction.createButton(UiDataMessages.REFRESH));
toolBar.addSeparator();
toolBar.add(ModifyAction.createButton(this, UiDataMessages.MODIFY));
toolBar.add(DeleteAction.createButton(this, UiDataMessages.DELETE));
toolBar.addSeparator();
toolBar.add(HelpAction.createButton(UiDataMessages.HELP));
filteringButton = ScilabVarFilteringButtonAction.createButton("Show/hide Scilab variable");
// toolBar.add(filteringButton);
addToolBar(toolBar);
dataModel = new SwingTableModel<Object>(columnsName);
table =
new JTable(dataModel) {
// Implement table cell tool tips.
public String getToolTipText(MouseEvent e) {
String tip = null;
TableModel model = ((JTable) e.getSource()).getModel();
java.awt.Point p = e.getPoint();
int rowIndex = rowAtPoint(p);
if (rowIndex >= 0) {
rowIndex = convertRowIndexToModel(rowIndex);
int colIndex = columnAtPoint(p);
if (colIndex == BrowseVar.TYPE_DESC_COLUMN_INDEX) {
/* Scilab type */
try {
tip =
Messages.gettext("Scilab type:")
+ " "
+ model.getValueAt(rowIndex, BrowseVar.TYPE_COLUMN_INDEX).toString();
} catch (IllegalArgumentException exception) {
/* If the type is not known/managed, don't crash */
}
} else {
if (colIndex == BrowseVar.SIZE_COLUMN_INDEX) {
/* Use the getModel() method because the
* column 5 has been removed from display
* but still exist in the model */
tip =
Messages.gettext("Bytes:")
+ " "
+ model.getValueAt(rowIndex, BrowseVar.BYTES_COLUMN_INDEX).toString();
}
}
}
return tip;
}
};
table.setFillsViewportHeight(true);
table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
table.setAutoCreateRowSorter(true);
/* Size of the icon column */
table.getColumnModel().getColumn(0).setPreferredWidth(30);
/* Hide the columns. But keep it in memory for the tooltip */
TableColumn column = table.getColumnModel().getColumn(BrowseVar.NB_COLS_INDEX);
table.removeColumn(column);
/* The order to removing does matter since it changes the positions */
column = table.getColumnModel().getColumn(BrowseVar.NB_ROWS_INDEX);
table.removeColumn(column);
column = table.getColumnModel().getColumn(BrowseVar.TYPE_COLUMN_INDEX);
table.removeColumn(column);
column = table.getColumnModel().getColumn(BrowseVar.FROM_SCILAB_COLUMN_INDEX);
table.removeColumn(column);
column = table.getColumnModel().getColumn(BrowseVar.BYTES_COLUMN_INDEX);
table.removeColumn(column);
table.addMouseListener(new BrowseVarMouseListener());
// Mouse selection mode
table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
table.setCellSelectionEnabled(true);
table.setBackground(Color.WHITE);
if (table.getGridColor().equals(Color.WHITE)) {
table.setGridColor(new Color(128, 128, 128));
}
table.setShowHorizontalLines(true);
table.setShowVerticalLines(true);
for (int i = 0; i < aligment.length; i++) {
align(table, columnsName[i], aligment[i]);
}
// Plug the shortcuts
ExportToCsvAction.registerAction(this, table);
JScrollPane scrollPane = new JScrollPane(table);
setContentPane(scrollPane);
WindowsConfigurationManager.restorationFinished(this);
}
/**
* Constructor initialises the table and a popup tool, as well as initialising the required GUI
* elements. It adds action listeners for the three main buttons, which include basic user input
* validation checking.
*/
public TableAttributeEditor(JFrame MyOwner) {
// As usual, it is insanely hard to get the swing components to display
// and work properly. If JTable is not displayed in a scroll pane no headers are
// displayed, and you have to do it manually. (If you *do* display it
// in a scrollbar, in this instance, it screws up sizing)
// The broken header mis-feature is only mentioned in the tutorial,
// not in the api doco - go figure.
super();
owner = MyOwner;
// final JPanel mainPanel = (JPanel)this;
tableData = new AttributeTableModel();
attributeTable = new JTable(tableData);
// attributeTable.setRowHeight(20); // This may be needed, depends on how fussy people get about
// the bottom of letters like 'y' getting cut off when the cell is selected - bug 3013.
popupTableTool = new SmartPopupTableTool(attributeTable, tableData, (JXplorerBrowser) owner);
// Set the renderer for the attribute type...
final AttributeTypeCellRenderer typeRenderer = new AttributeTypeCellRenderer();
attributeTable.setDefaultRenderer(AttributeNameAndType.class, typeRenderer);
// Set the renderer for the attribute value...
final AttributeValueCellRenderer valueRenderer = new AttributeValueCellRenderer();
attributeTable.setDefaultRenderer(AttributeValue.class, valueRenderer);
// Set the editor for the attribute value...
myEditor = new AttributeValueCellEditor(owner);
attributeTable.setDefaultEditor(AttributeValue.class, myEditor);
attributeTable.getTableHeader().setReorderingAllowed(false);
currentDN = null;
JPanel buttonPanel = new JPanel(new FlowLayout(FlowLayout.CENTER));
buttonPanel.add(
submit =
new CBButton(
CBIntText.get("Submit"), CBIntText.get("Submit your changes to the Directory.")));
buttonPanel.add(
reset =
new CBButton(
CBIntText.get("Reset"),
CBIntText.get("Reset this entry i.e. cancels any changes.")));
buttonPanel.add(
changeClass =
new CBButton(
CBIntText.get("Change Classes"),
CBIntText.get("Change the Object Class of this entry.")));
buttonPanel.add(
opAttrs =
new CBButton(
CBIntText.get("Properties"),
CBIntText.get("View the Operational Attributes of this entry.")));
// I don't really understand why we have to do this...
// but without it these buttons over ride the default
// button (Search Bar's search button), if they have
// been clicked and the user hits the enter key?
opAttrs.setDefaultCapable(false);
submit.setDefaultCapable(false);
reset.setDefaultCapable(false);
changeClass.setDefaultCapable(false);
setLayout(new BorderLayout(10, 10));
tableScroller = new JScrollPane();
attributeTable.setBackground(Color.white);
tableScroller.setPreferredSize(new Dimension(300, 285));
tableScroller.setViewportView(attributeTable);
add(tableScroller, BorderLayout.CENTER);
add(buttonPanel, BorderLayout.SOUTH);
if ("true".equals(JXConfig.getProperty("lock.read.only")))
title = CBIntText.get("Table Viewer");
else title = CBIntText.get("Table Editor");
setVisible(true);
// triggers adding operational attributes of the current entry.
opAttrs.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
displayOperationalAttributes();
}
});
reset.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
myEditor.stopCellEditing();
// tableData.reset();
displayEntry(originalEntry, dataSource, false);
}
});
submit.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
doSubmit();
}
});
// This allows the user to change the objectclass attribute.
// This is pretty tricky, because it changes what attributes are available.
changeClass.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
changeClass();
}
});
attributeTable.addMouseListener(
new MouseAdapter() {
public void mousePressed(MouseEvent e) {
if (!doPopupStuff(e)) super.mousePressed(e);
}
public void mouseReleased(MouseEvent e) {
if (!doPopupStuff(e)) super.mouseReleased(e);
}
// TODO need to have a way to call this from a keystroke...
public boolean doPopupStuff(MouseEvent e) {
if (e.isPopupTrigger() == false) return false;
int row = attributeTable.rowAtPoint(new Point(e.getX(), e.getY()));
attributeTable.clearSelection();
attributeTable.addRowSelectionInterval(row, row);
attributeTable.repaint();
popupTableTool.registerCurrentRow(
(AttributeNameAndType) attributeTable.getValueAt(row, 0),
(AttributeValue) attributeTable.getValueAt(row, 1),
row,
tableData.getRDN()); // active path also set by valueChanged
popupTableTool.show(attributeTable, e.getX(), e.getY());
popupTableTool.registerCellEditor(myEditor); // TE: for bug fix 3107.
return true;
}
});
}
public PantallaPuntaje() {
setBounds(100, 100, 590, 432);
this.setLocationRelativeTo(PantallaPrincipal.getInstance());
this.setResizable(false);
this.setDefaultCloseOperation(EXIT_ON_CLOSE);
getContentPane().setLayout(null);
JLabel label_1 = new JLabel(""); // Boton atras
label_1.addMouseListener(
new MouseAdapter() {
public void mouseClicked(MouseEvent e) {
PantallaPrincipal.getInstance().setLocationRelativeTo(PantallaPuntaje.this);
setVisible(false);
PantallaPrincipal.getInstance().setVisible(true);
}
});
Font font = null;
try {
font =
Font.createFont(
Font.TRUETYPE_FONT,
getClass().getResourceAsStream("/res/fuente/VCR_OSD_MONO_1.001.ttf"));
} catch (FontFormatException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
GraphicsEnvironment genv = GraphicsEnvironment.getLocalGraphicsEnvironment();
genv.registerFont(font);
font = font.deriveFont(12f);
label_1.setIcon(new ImageIcon(PantallaAyuda.class.getResource("/res/flecha_final.png")));
label_1.setBounds(16, 17, 52, 52);
getContentPane().add(label_1);
JScrollPane scrollPane = new JScrollPane();
scrollPane.setBorder(BorderFactory.createMatteBorder(2, 2, 2, 2, Color.BLACK));
scrollPane.setBounds(81, 82, 450, 231);
getContentPane().add(scrollPane);
Object[][] datos = new Object[MainJuego.getTopFive().size()][2];
for (int i = 0; i < MainJuego.getTopFive().size(); i++) {
datos[i][0] = MainJuego.getTopFive().get(i).getNombre();
datos[i][1] = MainJuego.getTopFive().get(i).getPuntos();
}
String[] columnas = {"NOMBRE", " PUNTAJE"};
DefaultTableCellRenderer Alinear = new DefaultTableCellRenderer();
Alinear.setHorizontalAlignment(SwingConstants.CENTER);
DefaultTableModel dtm = new DefaultTableModel(datos, columnas);
table = new JTable(dtm);
scrollPane.setViewportView(table);
scrollPane.setBackground(Color.black);
table.setBackground(Color.black);
table.getTableHeader().setFont(font.deriveFont(Font.PLAIN, 40f));
table.getTableHeader().setForeground(Color.YELLOW);
table.getTableHeader().setBackground(Color.BLACK);
table.setRowHeight(37);
table.setFont(font.deriveFont(Font.PLAIN, 23f));
table.setBorder(null);
table.setForeground(Color.WHITE);
table.setShowGrid(false);
table.getTableHeader().setReorderingAllowed(false);
table.getTableHeader().setResizingAllowed(false);
table.getColumnModel().getColumn(1).setCellRenderer(Alinear);
table.setFocusable(false);
table.setEnabled(false);
JLabel lblNewLabel = new JLabel("New label");
lblNewLabel.setIcon(new ImageIcon(PantallaPuntaje.class.getResource("/res/fondo puntaje.jpg")));
lblNewLabel.setBounds(0, 0, 590, 410);
getContentPane().add(lblNewLabel);
this.setResizable(false);
}
/** Create the frame. */
@SuppressWarnings({"unchecked", "rawtypes"})
public MembersManagement() {
connection = DBConnector.dbConnector();
setIconImage(
Toolkit.getDefaultToolkit()
.getImage(
MembersManagement.class.getResource(
"/Resources/Custo.Man.Christmas.Folder.Library.ico.png")));
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 1366, 768);
contentPane = new JPanel();
contentPane.setBackground(Color.DARK_GRAY);
contentPane.setBorder(new LineBorder(Color.BLUE, 1, true));
setContentPane(contentPane);
StartPosition.centerOnScreen(this);
String[] MemberType = new String[] {"Students", "Teachers"};
JButton button = new JButton("_");
button.setBounds(1234, 1, 44, 23);
button.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
MinFrame();
}
});
contentPane.setLayout(null);
button.setForeground(Color.WHITE);
button.setFocusable(false);
button.setBackground(Color.DARK_GRAY);
contentPane.add(button);
JButton button_1 = new JButton("");
button_1.setBounds(1277, 1, 44, 23);
button_1.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
MaxFrame();
}
});
button_1.setIcon(new ImageIcon(MembersManagement.class.getResource("/Resources/Maximize.png")));
button_1.setForeground(Color.WHITE);
button_1.setFocusable(false);
button_1.setBackground(Color.DARK_GRAY);
contentPane.add(button_1);
JButton button_2 = new JButton("X");
button_2.setBounds(1321, 1, 44, 23);
button_2.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
CloseFrame();
}
});
button_2.setForeground(Color.WHITE);
button_2.setFont(new Font("Ubuntu", Font.BOLD, 8));
button_2.setFocusable(false);
button_2.setBackground(Color.RED);
contentPane.add(button_2);
Border emptyBorder = BorderFactory.createEmptyBorder();
JLabel lblStudentsManagement = new JLabel("Members Management");
lblStudentsManagement.setBounds(403, 34, 543, 78);
lblStudentsManagement.setHorizontalAlignment(SwingConstants.CENTER);
lblStudentsManagement.setForeground(new Color(255, 255, 255));
lblStudentsManagement.setFont(new Font("Ubuntu", Font.BOLD, 36));
contentPane.add(lblStudentsManagement);
String[] searchCriteria = new String[] {"Name", "Registration Number"};
JPanel panel3 = new JPanel();
panel3.setBackground(Color.DARK_GRAY);
panel3.setBorder(new LineBorder(Color.BLUE));
panel3.setBounds(14, 187, 1340, 568);
contentPane.add(panel3);
panel3.setLayout(null);
panel3.setVisible(false);
JLabel lblSelectSearchCriteria = new JLabel("Select Search Criteria");
lblSelectSearchCriteria.setForeground(Color.WHITE);
lblSelectSearchCriteria.setFont(new Font("Ubuntu", Font.PLAIN, 13));
lblSelectSearchCriteria.setBounds(487, 39, 149, 21);
panel3.add(lblSelectSearchCriteria);
JScrollPane scrollPane_1 = new JScrollPane();
scrollPane_1.setBounds(10, 99, 1320, 402);
panel3.add(scrollPane_1);
table_1 = new JTable();
table_1.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));
table_1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
scrollPane_1.setViewportView(table_1);
JLabel lblCriteria = new JLabel("Name");
lblCriteria.setForeground(Color.WHITE);
lblCriteria.setFont(new Font("Ubuntu", Font.PLAIN, 13));
lblCriteria.setBounds(952, 39, 149, 21);
panel3.add(lblCriteria);
JComboBox cmbSearchCriteria = new JComboBox(searchCriteria);
cmbSearchCriteria.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
if (cmbSearchCriteria.getSelectedItem().toString() == "Name") {
lblCriteria.setText("Name");
txtSearch.setBounds(1001, 37, 160, 25);
} else if (cmbSearchCriteria.getSelectedItem().toString() == "Registration Number") {
lblCriteria.setText("Registration Number");
txtSearch.setBounds(1100, 37, 160, 25);
}
}
});
cmbSearchCriteria.setForeground(Color.WHITE);
cmbSearchCriteria.setFont(new Font("Ubuntu", Font.PLAIN, 13));
cmbSearchCriteria.setBorder(emptyBorder);
cmbSearchCriteria.setBackground(Color.DARK_GRAY);
cmbSearchCriteria.setBounds(646, 39, 160, 20);
panel3.add(cmbSearchCriteria);
JComboBox cmbType = new JComboBox(MemberType);
cmbType.setForeground(Color.WHITE);
cmbType.setFont(new Font("Ubuntu", Font.PLAIN, 13));
cmbType.setBackground(Color.DARK_GRAY);
cmbType.setBounds(246, 39, 160, 20);
panel3.add(cmbType);
JLabel lblSearchBy = new JLabel("Search By");
lblSearchBy.setForeground(Color.WHITE);
lblSearchBy.setFont(new Font("Ubuntu", Font.PLAIN, 13));
lblSearchBy.setBounds(885, 39, 75, 21);
panel3.add(lblSearchBy);
txtSearch = new JTextField();
txtSearch.addKeyListener(
new KeyAdapter() {
@Override
public void keyTyped(KeyEvent e) {
String type = cmbType.getSelectedItem().toString();
String sCriteria = cmbSearchCriteria.getSelectedItem().toString();
if (type == "Students") {
if (sCriteria == "Name") {
try {
LibMemberDM bDM = new LibMemberDM();
table_1.setModel(
DbUtils.resultSetToTableModel(bDM.searchByNameS(txtSearch.getText())));
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex.getMessage());
}
} else if (sCriteria == "Registration Number") {
try {
LibMemberDM bDM = new LibMemberDM();
table_1.setModel(
DbUtils.resultSetToTableModel(bDM.searchByRegNoS(txtSearch.getText())));
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex.getMessage());
}
}
} else if (type == "Teachers") {
if (sCriteria == "Name") {
try {
LibMemberDM bDM = new LibMemberDM();
table_1.setModel(
DbUtils.resultSetToTableModel(bDM.searchByNameT(txtSearch.getText())));
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex.getMessage());
}
} else if (sCriteria == "Registration Number") {
try {
LibMemberDM bDM = new LibMemberDM();
table_1.setModel(
DbUtils.resultSetToTableModel(bDM.searchByRegNoT(txtSearch.getText())));
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex.getMessage());
}
}
}
}
});
txtSearch.setForeground(Color.WHITE);
txtSearch.setFont(new Font("Ubuntu", Font.PLAIN, 13));
txtSearch.setBorder(emptyBorder);
txtSearch.setBackground(Color.GRAY);
txtSearch.setBounds(1001, 37, 200, 25);
panel3.add(txtSearch);
txtSearch.setColumns(10);
JButton btnUpdate = new JButton("Update");
btnUpdate.setFont(new Font("Ubuntu", Font.PLAIN, 12));
btnUpdate.setBackground(Color.DARK_GRAY);
btnUpdate.setForeground(Color.WHITE);
btnUpdate.setBounds(518, 523, 89, 23);
panel3.add(btnUpdate);
JButton btnRemove = new JButton("Remove");
btnRemove.setFont(new Font("Ubuntu", Font.PLAIN, 12));
btnRemove.setBackground(Color.DARK_GRAY);
btnRemove.setForeground(Color.WHITE);
btnRemove.setBounds(676, 523, 89, 23);
panel3.add(btnRemove);
JLabel lblSelectMemberType = new JLabel("Select Member Type");
lblSelectMemberType.setForeground(Color.WHITE);
lblSelectMemberType.setFont(new Font("Ubuntu", Font.PLAIN, 13));
lblSelectMemberType.setBounds(97, 39, 149, 21);
panel3.add(lblSelectMemberType);
JPanel panel1 = new JPanel();
panel1.setBorder(new LineBorder(Color.BLUE));
panel1.setBackground(Color.DARK_GRAY);
panel1.setBounds(14, 187, 1340, 568);
contentPane.add(panel1);
panel1.setVisible(true);
panel1.setLayout(null);
JComboBox cmbMemType = new JComboBox(MemberType);
cmbMemType.setForeground(Color.WHITE);
cmbMemType.setFont(new Font("Ubuntu", Font.PLAIN, 13));
cmbMemType.setBorder(emptyBorder);
cmbMemType.setBackground(Color.DARK_GRAY);
cmbMemType.setBounds(449, 39, 146, 25);
panel1.add(cmbMemType);
JButton btnView = new JButton("View Members");
btnView.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
String Type = cmbMemType.getSelectedItem().toString();
try {
if (Type == "Students") {
String Query =
"select t2.MemID, t1.FullName, t1.Address, t1.DOB, t1.NIC, t1.Sex, t1.ContactNo, t1.CurrentGrade, t1.CurrentClass from StudentsMF t1, LibMem t2 where t1.RegNo = t2.RegNoS";
PreparedStatement pst = connection.prepareStatement(Query);
ResultSet rs = pst.executeQuery();
table.setModel(DbUtils.resultSetToTableModel(rs));
rs.close();
pst.close();
} else if (Type == "Teachers") {
String Query =
"select t2.MemID, t1.Name, t1.Adress, t1.DOB, t1.NIC, t1.Sex, t1.ContactNo, t1.TGrade, t1.Type from TeachersMF t1, LibMem t2 where t1.RegNo = t2.RegNoT";
PreparedStatement pst = connection.prepareStatement(Query);
ResultSet rs = pst.executeQuery();
table.setModel(DbUtils.resultSetToTableModel(rs));
rs.close();
pst.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
});
btnView.setForeground(Color.WHITE);
btnView.setBackground(Color.DARK_GRAY);
btnView.setFont(new Font("Ubuntu", Font.PLAIN, 13));
btnView.setBounds(736, 36, 131, 30);
panel1.add(btnView);
JScrollPane scrollPane = new JScrollPane();
scrollPane.setBounds(10, 99, 1320, 458);
panel1.add(scrollPane);
table = new JTable();
table.setGridColor(Color.GRAY);
table.setFont(new Font("Ubuntu", Font.PLAIN, 11));
table.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));
table.setBackground(Color.WHITE);
table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
scrollPane.setViewportView(table);
JPanel panel2 = new JPanel();
panel2.setBorder(new LineBorder(Color.BLUE));
panel2.setBackground(Color.DARK_GRAY);
panel2.setBounds(14, 187, 1340, 568);
contentPane.add(panel2);
panel2.setLayout(null);
JLabel lblISBN = new JLabel("Registration Number");
lblISBN.setForeground(Color.WHITE);
lblISBN.setFont(new Font("Ubuntu", Font.PLAIN, 13));
lblISBN.setBounds(232, 183, 142, 22);
panel2.add(lblISBN);
txtRegNo = new JTextField();
txtRegNo.setCursor(Cursor.getPredefinedCursor(Cursor.TEXT_CURSOR));
txtRegNo.setBackground(Color.GRAY);
txtRegNo.setForeground(Color.WHITE);
txtRegNo.setFont(new Font("Ubuntu", Font.PLAIN, 13));
txtRegNo.setBounds(413, 182, 208, 24);
txtRegNo.setBorder(emptyBorder);
panel2.add(txtRegNo);
txtRegNo.setColumns(10);
txtPassword = new JTextField();
txtPassword.setCursor(Cursor.getPredefinedCursor(Cursor.TEXT_CURSOR));
txtPassword.setForeground(Color.WHITE);
txtPassword.setFont(new Font("Ubuntu", Font.PLAIN, 13));
txtPassword.setBorder(emptyBorder);
txtPassword.setColumns(10);
txtPassword.setBackground(Color.GRAY);
txtPassword.setBounds(413, 214, 208, 24);
panel2.add(txtPassword);
JLabel lblName = new JLabel("Password");
lblName.setForeground(Color.WHITE);
lblName.setFont(new Font("Ubuntu", Font.PLAIN, 13));
lblName.setBounds(232, 215, 142, 22);
panel2.add(lblName);
JLabel lblNicNumber = new JLabel("Re-Enter Password");
lblNicNumber.setForeground(Color.WHITE);
lblNicNumber.setFont(new Font("Ubuntu", Font.PLAIN, 13));
lblNicNumber.setBounds(232, 248, 142, 22);
panel2.add(lblNicNumber);
txtRPassword = new JTextField();
txtRPassword.setCursor(Cursor.getPredefinedCursor(Cursor.TEXT_CURSOR));
txtRPassword.setForeground(Color.WHITE);
txtRPassword.setFont(new Font("Ubuntu", Font.PLAIN, 13));
txtRPassword.setBorder(emptyBorder);
txtRPassword.setColumns(10);
txtRPassword.setBackground(Color.GRAY);
txtRPassword.setBounds(413, 247, 208, 24);
panel2.add(txtRPassword);
JButton btnClear = new JButton("Clear");
btnClear.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
clearFeilds();
}
});
btnClear.setForeground(Color.WHITE);
btnClear.setFont(new Font("Ubuntu", Font.PLAIN, 13));
btnClear.setBackground(Color.DARK_GRAY);
btnClear.setBounds(474, 344, 110, 32);
panel2.add(btnClear);
JButton btnAddMember = new JButton("Add Member");
btnAddMember.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (!txtRPassword.getText().equals("")
|| !txtPassword.getText().equals("")
|| !txtRegNo.getText().equals("")) {
if (txtPassword.getText().equals(txtRPassword.getText())) {
try {
LibMemberDM mDM = new LibMemberDM();
LibMember member = new LibMember();
member.setMemID(txtRegNo.getText());
member.setPassword(txtPassword.getText());
// checking whether RegNo exist in the database {
String query1 = "select RegNo from TeachersMF where RegNo=?";
String query2 = "select RegNo from StudentsMF where RegNo=?";
PreparedStatement pst1 = connection.prepareStatement(query1);
pst1.setString(1, member.getMemID());
PreparedStatement pst2 = connection.prepareStatement(query2);
pst2.setString(1, member.getMemID());
ResultSet rs1 = pst1.executeQuery();
ResultSet rs2 = pst2.executeQuery();
int count1 = 0, count2 = 0;
while (rs1.next()) count1++;
while (rs2.next()) count2++;
if (count1 == 0 && count2 == 0)
JOptionPane.showMessageDialog(
null,
"Registration Number does not exist!",
"Error",
JOptionPane.WARNING_MESSAGE);
else if (count1 == 1 && count2 == 0) {
String query3 =
"select MemID from LibMem where MemID='" + member.getMemID() + "'";
PreparedStatement pst3 = connection.prepareStatement(query3);
ResultSet rs3 = pst3.executeQuery();
int count3 = 0;
while (rs3.next()) count3++;
if (count3 != 0) JOptionPane.showMessageDialog(null, "User Already Exist!");
else if (count3 == 0) {
if (mDM.insertMemberT(member)) {
JOptionPane.showMessageDialog(null, "Successful");
clearFeilds();
} else JOptionPane.showMessageDialog(null, "Failed");
rs3.close();
pst3.close();
}
} else if (count1 == 0 && count2 == 1) {
String query6 = "select * from LibMem where MemID='" + member.getMemID() + "'";
PreparedStatement pst5 = connection.prepareStatement(query6);
ResultSet rs4 = pst5.executeQuery();
int count3 = 0;
while (rs4.next()) count3++;
if (count3 != 0) JOptionPane.showMessageDialog(null, "User Already Exist!");
else if (count3 == 0) {
if (mDM.insertMemberS(member)) {
JOptionPane.showMessageDialog(null, "Successful");
clearFeilds();
} else JOptionPane.showMessageDialog(null, "Failed");
rs4.close();
pst5.close();
}
}
rs1.close();
rs2.close();
pst1.close();
pst2.close();
} catch (Exception x) {
JOptionPane.showMessageDialog(null, x);
System.out.println(x);
}
} else JOptionPane.showMessageDialog(null, "Passwords do not Match");
} else JOptionPane.showMessageDialog(null, "Fill in All the Details");
}
});
btnAddMember.setFont(new Font("Ubuntu", Font.PLAIN, 13));
btnAddMember.setBackground(Color.DARK_GRAY);
btnAddMember.setForeground(Color.WHITE);
btnAddMember.setBounds(265, 344, 125, 32);
panel2.add(btnAddMember);
JLabel label = new JLabel("");
label.setIcon(
new ImageIcon(MembersManagement.class.getResource("/Resources/sign-up-icon.png")));
label.setBounds(856, 140, 256, 226);
panel2.add(label);
panel2.setVisible(false);
// Creating Tab Buttons of Tabs Pane
JButton btnEditStudentDetails = new JButton("Edit Member Details");
JButton btnAddStudents = new JButton("Add Members");
JButton btnViewStudents = new JButton("View Members");
btnViewStudents.setFont(new Font("Ubuntu", Font.PLAIN, 13));
btnViewStudents.setForeground(Color.WHITE);
btnViewStudents.setBackground(Color.BLUE);
btnViewStudents.setBounds(14, 164, 124, 23);
contentPane.add(btnViewStudents);
btnAddStudents.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (btnAddStudents.hasFocus()) {
btnAddStudents.setBackground(Color.BLUE);
btnAddStudents.setForeground(Color.WHITE);
btnViewStudents.setBackground(Color.DARK_GRAY);
btnViewStudents.setForeground(Color.WHITE);
btnEditStudentDetails.setBackground(Color.DARK_GRAY);
btnEditStudentDetails.setForeground(Color.WHITE);
}
if (panel2.isVisible() == false) {
panel2.setVisible(true);
panel1.setVisible(false);
panel3.setVisible(false);
}
}
});
btnAddStudents.setForeground(Color.WHITE);
btnAddStudents.setBorder(BorderFactory.createLineBorder(Color.BLUE));
btnAddStudents.setFont(new Font("Ubuntu", Font.PLAIN, 13));
btnAddStudents.setBackground(Color.DARK_GRAY);
btnAddStudents.setBounds(137, 164, 144, 23);
contentPane.add(btnAddStudents);
btnEditStudentDetails.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (btnEditStudentDetails.hasFocus()) {
btnEditStudentDetails.setBackground(Color.BLUE);
btnEditStudentDetails.setForeground(Color.WHITE);
btnAddStudents.setBackground(Color.DARK_GRAY);
btnAddStudents.setForeground(Color.WHITE);
btnViewStudents.setBackground(Color.DARK_GRAY);
btnViewStudents.setForeground(Color.WHITE);
}
if (panel3.isVisible() == false) {
panel3.setVisible(true);
panel1.setVisible(false);
panel2.setVisible(false);
}
}
});
btnEditStudentDetails.setForeground(Color.WHITE);
btnEditStudentDetails.setBorder(BorderFactory.createLineBorder(Color.BLUE));
btnEditStudentDetails.setFont(new Font("Ubuntu", Font.PLAIN, 13));
btnEditStudentDetails.setBackground(Color.DARK_GRAY);
btnEditStudentDetails.setBounds(280, 164, 169, 23);
contentPane.add(btnEditStudentDetails);
btnViewStudents.setBorder(BorderFactory.createLineBorder(Color.BLUE));
btnViewStudents.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (btnViewStudents.hasFocus()) {
btnViewStudents.setBackground(Color.BLUE);
btnViewStudents.setForeground(Color.WHITE);
btnAddStudents.setBackground(Color.DARK_GRAY);
btnAddStudents.setForeground(Color.WHITE);
btnEditStudentDetails.setBackground(Color.DARK_GRAY);
btnEditStudentDetails.setForeground(Color.WHITE);
}
if (panel1.isVisible() == false) {
panel1.setVisible(true);
panel2.setVisible(false);
panel3.setVisible(false);
}
}
});
}
private JPanel localVendListStockPanel() {
JPanel mainListPanel = new JPanel();
mainListPanel.setLayout(new BoxLayout(mainListPanel, BoxLayout.Y_AXIS));
JPanel headerPanel = new JPanel(new FlowLayout(FlowLayout.CENTER));
headerPanel.setPreferredSize(new Dimension(600, 60));
JLabel header = new JLabel("LIST STOCK");
header.setFont(new Font("Verdana", Font.BOLD, 25));
headerPanel.add(header);
mainListPanel.add(headerPanel);
for (int j = 0; j < numOfSelected.length; ++j) {
int ID = numOfSelected[j];
JPanel stockPanel = new JPanel();
BorderLayout listItemsLayout = new BorderLayout(0, 20);
stockPanel.setLayout(listItemsLayout);
Object[] columnHeading = {"Row", "Column", "Item Name", "Amount", "Price", "Total"};
try {
itemsArray = getStock(ID);
} catch (Exception e) {
e.printStackTrace();
System.out.println("Failed to populate itemsArray...");
System.out.println("Quitting the Marketing manager...");
System.exit(DISPOSE_ON_CLOSE);
}
DefaultTableModel tableModel =
new DefaultTableModel(itemsArray, columnHeading) {
/** */
private static final long serialVersionUID = 1L;
@Override
public boolean isCellEditable(int row, int column) {
// all cells false
return false;
}
};
// tableModel.setRowCount(itemsArray.length);
JTable stockTable = new JTable(tableModel);
stockTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
stockTable.setFont(new Font("Verdana", 20, 15));
stockTable.setRowHeight(40);
stockTable.getColumnModel().getColumn(0).setMaxWidth(50);
stockTable.getColumnModel().getColumn(0).setMinWidth(50);
stockTable.getColumnModel().getColumn(1).setMaxWidth(50);
stockTable.getColumnModel().getColumn(1).setMinWidth(50);
stockTable.setBackground(Color.white);
stockTable.setGridColor(Color.BLACK);
stockTable.setFont(new Font("Verdana", 20, 15));
stockTable.setRowHeight(40);
stockTable.getTableHeader().setResizingAllowed(false);
stockTable.getTableHeader().setReorderingAllowed(false);
stockTable.getTableHeader().setRequestFocusEnabled(false);
JScrollPane scrollStock = new JScrollPane(stockTable);
JPanel stockScrollPanel = new JPanel(new FlowLayout());
// stockTable.setPreferredSize(new Dimension(800, 400));
// stockScrollPanel.setPreferredSize(new Dimension(800, 600));
stockScrollPanel.add(scrollStock);
int row = stockTable.getRowCount();
double totalPrice = 0;
int totalAmount = 0;
for (int i = 0; i < row; i++) {
totalPrice += (Double) stockTable.getValueAt(i, 5);
totalAmount += (Integer) stockTable.getValueAt(i, 3);
}
// String totalPriceResult = new Double(totalPrice).toString();
String totalAmountResult = new Integer(totalAmount).toString();
JLabel totalPriceLabel = new JLabel("Total Price in Stock ");
totalPriceLabel.setFont(new Font("Verdana", Font.BOLD, 18));
JLabel totalPriceText = new JLabel(df.format(totalPrice));
totalPriceText.setFont(new Font("Arial", Font.PLAIN, 16));
JLabel totalAmountLabel = new JLabel("Total Amount in Stock ");
totalAmountLabel.setFont(new Font("Verdana", Font.BOLD, 18));
JLabel totalAmountText = new JLabel(totalAmountResult);
totalAmountText.setFont(new Font("Arial", Font.PLAIN, 16));
JPanel southLayout = new JPanel(new GridLayout(1, 1));
JPanel priceLayout = new JPanel(new FlowLayout());
JPanel amountLayout = new JPanel(new FlowLayout());
priceLayout.add(totalPriceLabel);
priceLayout.add(totalPriceText);
amountLayout.add(totalAmountLabel);
amountLayout.add(totalAmountText);
southLayout.add(amountLayout);
southLayout.add(priceLayout);
JLabel northLabel = new JLabel("MACHINE " + (ID + 1));
northLabel.setHorizontalAlignment(SwingConstants.CENTER);
northLabel.setFont(new Font("Verdana", Font.BOLD, 25));
stockPanel.add(northLabel, BorderLayout.NORTH);
stockPanel.add(stockScrollPanel, BorderLayout.CENTER);
stockPanel.add(southLayout, BorderLayout.SOUTH);
mainListPanel.add(stockPanel);
}
return mainListPanel;
}
public ReporteAlumnos() {
conn = conectionTest.conectaraDB();
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setBounds(100, 100, 1500, 644);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
setLocationRelativeTo(null);
JLabel lblReporteAlumnos = new JLabel("Reportes de alumnos");
lblReporteAlumnos.setFont(new Font("Tahoma", Font.PLAIN, 18));
lblReporteAlumnos.setBounds(10, 11, 194, 30);
contentPane.add(lblReporteAlumnos);
JButton btnBuscarAlumno = new JButton("Buscar alumno");
btnBuscarAlumno.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
String nombreAlumno = txtNombre.getText();
String apellidoAlumno = txtApellido1.getText();
String querybuscarAlumno =
"Select * "
+ "from Alumnos "
+ "where Nombre = '"
+ nombreAlumno
+ "'"
+ "and [Apellido 1] = '"
+ apellidoAlumno
+ "'";
String queryultpago =
"Select Alumnos.Nombre,Alumnos.[Apellido 1],Pagos.Monto_pago,Pagos.Fecha_pago,Pagos.Concepto_pago "
+ "from Alumnos inner join Pagos on Alumnos.Id_Alumno = Pagos.ID_Alumno "
+ "Where Nombre = '"
+ nombreAlumno
+ "' and Fecha_pago < GETDATE()";
String queryAsistencia =
"Select Count(Asistencia.Fecha) "
+ "from Alumnos inner join Asistencia on Alumnos.Id_Alumno = Asistencia.ID_Alumno "
+ "where Nombre = '"
+ nombreAlumno
+ "' and [Apellido 1] = '"
+ apellidoAlumno
+ "' and Fecha < GETDATE()";
String queryAsistDetalle =
"Select Asistencia.Fecha, alumnos.nombre, alumnos.[Apellido 1] "
+ "from Alumnos inner join Asistencia on Alumnos.Id_Alumno = Asistencia.ID_Alumno "
+ "where Nombre = '"
+ nombreAlumno
+ "' and [Apellido 1] = '"
+ apellidoAlumno
+ "' and Fecha < GETDATE()";
String querypruebas =
"select Alumnos.Nombre, "
+ "Alumnos.[Apellido 1], "
+ "Mediciones.FechaPrueba, "
+ "Mediciones.LadoALado, "
+ "Mediciones.Seguidillas, "
+ "Mediciones.SaltoLargo, "
+ "Mediciones.Abs, "
+ "Mediciones.Peso, "
+ "Mediciones.Talla "
+ "from Alumnos inner join Mediciones on Alumnos.Id_Alumno = Mediciones.ID_Alumno Where "
+ "Nombre = '"
+ nombreAlumno
+ "' and [Apellido 1] = '"
+ apellidoAlumno
+ "' and FechaPrueba < GETDATE()";
try {
// crear un statement
Statement stmt = conn.createStatement();
// crear un result set
ResultSet rs =
stmt.executeQuery(
querybuscarAlumno); // esta linea crea un result set con el query que
// definimos en la variable query
Statement stmt2 = conn.createStatement();
ResultSet rs2 = stmt2.executeQuery(queryultpago);
Statement stmt3 = conn.createStatement();
ResultSet rs3 = stmt3.executeQuery(queryAsistencia);
Statement stmt4 = conn.createStatement();
ResultSet rs4 = stmt4.executeQuery(queryAsistDetalle);
Statement stmt5 = conn.createStatement();
ResultSet rs5 = stmt5.executeQuery(querypruebas);
while (rs.next()) {
String Nombre =
rs.getString(
"Nombre"); // crea el string nombre y le asigna el valor del result set que
// tiene la columna nombre
String Apellido1 = rs.getString("Apellido 1");
String nombreCompleto1 = Nombre + " " + Apellido1;
String Mensualidad = rs.getString("Mensualidad");
nombreCompleto.setText(nombreCompleto1);
txtMensualidad.setText(Mensualidad);
}
while (rs2.next()) {
String montoultpago = rs2.getString("Monto_pago");
String concultpago = rs2.getString("Concepto_pago");
txtUltimoPago.setText(montoultpago);
txtConcepto.setText(concultpago);
}
while (rs3.next()) {
int reslt = rs3.getInt(1);
String resultado = String.valueOf(reslt);
txtAsistencia.setText(resultado);
}
table_2.setModel(
DbUtils.resultSetToTableModel(
rs4)); // llena la tabla 2 con los resultados del result set. Utiliza el jar
// r2xml
table_3.setModel(DbUtils.resultSetToTableModel(rs5));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
});
btnBuscarAlumno.setBounds(348, 60, 138, 23);
contentPane.add(btnBuscarAlumno);
table = new JTable();
table.setBounds(34, 263, 149, -143);
table.setBackground(Color.white);
table.setOpaque(true);
contentPane.add(table);
txtNombre = new JTextField();
txtNombre.setText("Nombre");
txtNombre.setBounds(31, 61, 121, 20);
contentPane.add(txtNombre);
txtNombre.setColumns(10);
txtApellido1 = new JTextField();
txtApellido1.setText("Apellido 1");
txtApellido1.setBounds(180, 61, 110, 20);
contentPane.add(txtApellido1);
txtApellido1.setColumns(10);
JLabel lblNombreCompleto = new JLabel("Nombre completo");
lblNombreCompleto.setBounds(34, 92, 194, 14);
contentPane.add(lblNombreCompleto);
nombreCompleto = new JTextField();
nombreCompleto.setEnabled(false);
nombreCompleto.setBounds(34, 106, 194, 20);
contentPane.add(nombreCompleto);
nombreCompleto.setColumns(10);
JLabel lblFechaInicial = new JLabel("Inicio del reporte");
lblFechaInicial.setBounds(34, 199, 118, 14);
contentPane.add(lblFechaInicial);
txtDeEnero = new JTextField();
txtDeEnero.setEnabled(false);
txtDeEnero.setText("4 de enero 2016");
txtDeEnero.setBounds(162, 196, 103, 20);
contentPane.add(txtDeEnero);
txtDeEnero.setColumns(10);
JLabel lblMensualidad = new JLabel("Mensualidad");
lblMensualidad.setBounds(34, 137, 86, 14);
contentPane.add(lblMensualidad);
txtMensualidad = new JTextField();
txtMensualidad.setEnabled(false);
txtMensualidad.setBounds(34, 156, 86, 20);
contentPane.add(txtMensualidad);
txtMensualidad.setColumns(10);
txtUltimoPago = new JTextField();
txtUltimoPago.setEnabled(false);
txtUltimoPago.setBounds(152, 156, 86, 20);
contentPane.add(txtUltimoPago);
txtUltimoPago.setColumns(10);
JLabel lblUltimoPago = new JLabel("Ultimo pago");
lblUltimoPago.setBounds(152, 137, 86, 14);
contentPane.add(lblUltimoPago);
JLabel lblNewLabel = new JLabel("Concepto");
lblNewLabel.setBounds(267, 137, 159, 14);
contentPane.add(lblNewLabel);
txtConcepto = new JTextField();
txtConcepto.setEnabled(false);
txtConcepto.setBounds(267, 156, 279, 20);
contentPane.add(txtConcepto);
txtConcepto.setColumns(10);
JLabel lblAsistenciaDuranteEl = new JLabel("Asistencia durante el periodo");
lblAsistenciaDuranteEl.setBounds(85, 263, 186, 14);
contentPane.add(lblAsistenciaDuranteEl);
txtAsistencia = new JTextField();
txtAsistencia.setEnabled(false);
txtAsistencia.setBounds(130, 283, 53, 20);
contentPane.add(txtAsistencia);
txtAsistencia.setColumns(10);
JLabel lblDetalle = new JLabel("Detalle de asistencia");
lblDetalle.setBounds(100, 314, 149, 14);
contentPane.add(lblDetalle);
JLabel lblComptenciasDuranteEl = new JLabel("Comptencias durante el periodo");
lblComptenciasDuranteEl.setBounds(431, 263, 209, 14);
contentPane.add(lblComptenciasDuranteEl);
textField_7 = new JTextField();
textField_7.setEnabled(false);
textField_7.setBounds(477, 283, 53, 20);
contentPane.add(textField_7);
textField_7.setColumns(10);
JLabel lblDetalle_1 = new JLabel("Detalle de Competencias");
lblDetalle_1.setBounds(450, 314, 159, 14);
contentPane.add(lblDetalle_1);
JLabel lblMedicionesFisicas = new JLabel("Mediciones fisicas");
lblMedicionesFisicas.setBounds(809, 263, 138, 14);
contentPane.add(lblMedicionesFisicas);
JLabel lblDetalle_2 = new JLabel("Detalle de mediciones");
lblDetalle_2.setBounds(809, 314, 127, 14);
contentPane.add(lblDetalle_2);
JScrollPane scrollPane = new JScrollPane();
scrollPane.setBounds(34, 338, 289, 245);
contentPane.add(scrollPane);
table_2 = new JTable();
scrollPane.setViewportView(table_2);
JScrollPane scrollPane_1 = new JScrollPane();
scrollPane_1.setBounds(699, 363, 606, 210);
contentPane.add(scrollPane_1);
table_3 = new JTable();
scrollPane_1.setViewportView(table_3);
JButton btnMenuPrincipal = new JButton("Menu Principal");
btnMenuPrincipal.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
MainMenu mm = new MainMenu();
mm.setVisible(true);
close();
}
});
btnMenuPrincipal.setBounds(496, 60, 121, 23);
contentPane.add(btnMenuPrincipal);
table_1 = new JTable();
table_1.setModel(new DefaultTableModel(new Object[][] {}, new String[] {"New column"}));
}
public RedigerKategori() {
this.setBackground(new Color(51, 161, 201));
setLayout(null);
JLabel TilføjKategori = new JLabel("Rediger Kategori");
TilføjKategori.setIcon(
new ImageIcon(TilføjVare.class.getResource("/presentation/resources/add32.png")));
TilføjKategori.setFont(new Font("sansserif", Font.BOLD, 24));
TilføjKategori.setForeground(Color.black);
TilføjKategori.setBounds(30, 30, 250, 30);
this.add(TilføjKategori);
JLabel TilføjKategorinavn = new JLabel("Kategorinavn:");
TilføjKategorinavn.setFont(new Font("Tahoma", Font.PLAIN, 12));
TilføjKategorinavn.setBounds(140, 90, 140, 20);
TilføjKategorinavn.setForeground(Color.black);
add(TilføjKategorinavn);
kategorinavnText = new JTextField();
kategorinavnText.setBounds(230, 90, 300, 20);
add(kategorinavnText);
Button sletKategori = new Button("Slet");
sletKategori.setBackground(new Color(255, 215, 10));
sletKategori.setBounds(380, 160, 70, 22);
sletKategori.setForeground(Color.black);
add(sletKategori);
sletKategori.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent arg0) {
controller.slet();
}
});
Button TilføjKategori1 = new Button("Gem");
TilføjKategori1.setBackground(new Color(255, 215, 10));
TilføjKategori1.setBounds(460, 160, 70, 22);
TilføjKategori1.setForeground(Color.black);
add(TilføjKategori1);
Ktable1 = new JTable();
Ktable1.setBounds(12, 10, 710, 57);
Ktable1.setBackground(new Color(238, 238, 238));
add(Ktable1);
JLabel TilføjOverKategori = new JLabel("Over kategori:");
TilføjOverKategori.setFont(new Font("Tahoma", Font.PLAIN, 12));
TilføjOverKategori.setBounds(140, 120, 140, 20);
TilføjOverKategori.setForeground(Color.black);
add(TilføjOverKategori);
TilføjKategori1.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent arg0) {
System.out.println(controller);
controller.updateKategori(kategorinavnText, combobox1);
}
});
combobox1 = new JComboBox<String>();
combobox1.setBounds(230, 120, 300, 20);
add(combobox1);
Ktable = new JTable();
Ktable.setBounds(12, 71, 710, 405);
Ktable.setBackground(new Color(238, 238, 238));
add(Ktable);
}
