private void initGUI() {
JPanel pCommand = new JPanel();
pResult = new JPanel();
nsSplitPane = new JSplitPane(JSplitPane.VERTICAL_SPLIT, pCommand, pResult);
pCommand.setLayout(new BorderLayout());
pResult.setLayout(new BorderLayout());
Font fFont = new Font("Dialog", Font.PLAIN, 12);
txtCommand = new JTextArea(5, 40);
txtCommand.setMargin(new Insets(5, 5, 5, 5));
txtCommand.addKeyListener(this);
txtCommandScroll = new JScrollPane(txtCommand);
txtResult = new JTextArea(20, 40);
txtResult.setMargin(new Insets(5, 5, 5, 5));
txtResultScroll = new JScrollPane(txtResult);
txtCommand.setFont(fFont);
txtResult.setFont(new Font("Courier", Font.PLAIN, 12));
/*
// button replaced by toolbar
butExecute = new JButton("Execute");
butExecute.addActionListener(this);
pCommand.add(butExecute, BorderLayout.EAST);
*/
pCommand.add(txtCommandScroll, BorderLayout.CENTER);
gResult = new GridSwing();
gResultTable = new JTable(gResult);
gScrollPane = new JScrollPane(gResultTable);
// getContentPane().setLayout(new BorderLayout());
pResult.add(gScrollPane, BorderLayout.CENTER);
// Set up the tree
rootNode = new DefaultMutableTreeNode("Connection");
treeModel = new DefaultTreeModel(rootNode);
tTree = new JTree(treeModel);
tScrollPane = new JScrollPane(tTree);
tScrollPane.setPreferredSize(new Dimension(120, 400));
tScrollPane.setMinimumSize(new Dimension(70, 100));
txtCommandScroll.setPreferredSize(new Dimension(360, 100));
txtCommandScroll.setMinimumSize(new Dimension(180, 100));
gScrollPane.setPreferredSize(new Dimension(460, 300));
ewSplitPane = new JSplitPane(JSplitPane.HORIZONTAL_SPLIT, tScrollPane, nsSplitPane);
fMain.getContentPane().add(ewSplitPane, BorderLayout.CENTER);
doLayout();
fMain.pack();
}
public void actionPerformed(ActionEvent e) {
int k = 0;
try {
rs = statement.executeQuery("select * from hostelStatus");
while (rs.next()) {
data[k][0] = rs.getString(1);
data[k][1] = rs.getString(2);
data[k][2] = rs.getString(3);
k++;
}
data[k][0] = " ";
data[k][1] = " ";
data[k][2] = " ";
table = new JTable(data, col);
table.setFont(new Font("Serif", Font.BOLD, 16));
table.setBackground(new Color(250, 250, 250));
JScrollPane jsp = new JScrollPane(table);
jsp.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_NEVER);
jsp.setBounds(5, 100, 590, 200);
cn.add(jsp);
} catch (Exception sq) {
JOptionPane.showMessageDialog(null, "error" + sq);
}
}
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();
}
public void doLayout() {
Dimension sz = getSize();
textAreaMessage.setBounds(0, 0, sz.width, 50);
int xparts = (sz.width - (2 * 125)) / 3;
buttonOk.setBounds(xparts, 55, 125, 40);
buttonCancel.setBounds(xparts + 125 + xparts, 55, 125, 40);
scrollPane.setBounds(0, 100, sz.width, sz.height - 100);
scrollPane.doLayout();
}
public CFInternetSwingVersionListJPanel(
ICFInternetSwingSchema argSchema,
ICFLibAnyObj argContainer,
ICFInternetVersionObj argFocus,
Collection<ICFInternetVersionObj> argDataCollection,
ICFJRefreshCallback refreshCallback,
boolean sortByChain) {
super();
final String S_ProcName = "construct-schema-focus";
if (argSchema == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "argSchema");
}
// argFocus is optional; focus may be set later during execution as
// conditions of the runtime change.
swingSchema = argSchema;
swingFocus = argFocus;
swingContainer = argContainer;
swingRefreshCallback = refreshCallback;
swingSortByChain = sortByChain;
setSwingDataCollection(argDataCollection);
dataTable = new JTable(getDataModel(), getDataColumnModel(), getDataListSelectionModel());
dataTable.addMouseListener(getDataListMouseAdapter());
dataTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
dataTable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
dataTable.setUpdateSelectionOnSort(true);
dataTable.setRowHeight(25);
getDataListSelectionModel().addListSelectionListener(getDataListSelectionListener());
dataScrollPane =
new JScrollPane(
dataTable,
ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS,
ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);
dataScrollPane.setColumnHeader(
new JViewport() {
@Override
public Dimension getPreferredSize() {
Dimension sz = super.getPreferredSize();
sz.height = 25;
return (sz);
}
});
dataTable.setFillsViewportHeight(true);
// Do initial layout
setSize(1024, 480);
JMenuBar menuBar = getPanelMenuBar();
add(menuBar);
menuBar.setBounds(0, 0, 1024, 25);
add(dataScrollPane);
dataScrollPane.setBounds(0, 25, 1024, 455);
adjustListMenuBar();
doLayout();
swingIsInitializing = false;
}
public void doLayout() {
Dimension sz = getSize();
splitPane.setBounds(0, 0, sz.width, sz.height);
splitPane.doLayout();
attrScrollPane.doLayout();
eltJTabbedPane.doLayout();
}
public CFSecuritySwingISOCurrencyAskDeleteJPanel(
ICFSecuritySwingSchema argSchema, ICFSecurityISOCurrencyObj argFocus) {
super();
final String S_ProcName = "construct-schema-focus";
if (argSchema == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "argSchema");
}
// argFocus is optional; focus may be set later during execution as
// conditions of the runtime change.
swingSchema = argSchema;
swingFocus = argFocus;
// Construct the various objects
textAreaMessage = new JTextArea("Are you sure you want to delete this ISO Currency?");
actionOk = new ActionOk();
actionCancel = new ActionCancel();
buttonOk = new JButton(actionOk);
buttonCancel = new JButton(actionCancel);
attrJPanel = argSchema.getISOCurrencyFactory().newAttrJPanel(argFocus);
scrollPane = new CFHSlaveJScrollPane(attrJPanel);
// Lay out the widgets
setSize(1024, 480);
Dimension min = new Dimension(480, 300);
setMinimumSize(min);
add(textAreaMessage);
textAreaMessage.setBounds(0, 0, 1024, 50);
int xparts = (768 - (2 * 125)) / 3;
add(buttonOk);
buttonOk.setBounds(xparts, 55, 125, 40);
add(buttonCancel);
buttonCancel.setBounds(xparts + 125 + xparts, 55, 125, 40);
add(scrollPane);
scrollPane.setBounds(0, 100, 1024, 480 - 100);
}
public CFSecuritySwingISOTimezoneFinderJPanel(ICFSecuritySwingSchema argSchema) {
super();
final String S_ProcName = "construct-schema-focus";
if (argSchema == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "argSchema");
}
swingSchema = argSchema;
dataTable = new JTable(getDataModel(), getDataColumnModel(), getDataListSelectionModel());
dataTable.addMouseListener(getDataListMouseAdapter());
dataTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
dataTable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
dataTable.setUpdateSelectionOnSort(true);
dataTable.setRowHeight(25);
getDataListSelectionModel().addListSelectionListener(getDataListSelectionListener());
dataScrollPane =
new JScrollPane(
dataTable,
ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS,
ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);
dataScrollPane.setColumnHeader(
new JViewport() {
@Override
public Dimension getPreferredSize() {
Dimension sz = super.getPreferredSize();
sz.height = 25;
return (sz);
}
});
dataTable.setFillsViewportHeight(true);
add(dataScrollPane);
loadData(true);
doLayout();
swingIsInitializing = false;
}
stab(ResultSet k) {
super("PATIENT FOUND");
String[] chd = {
"Date",
"Patient ID",
"Name",
"Gender",
"Age",
"Weight",
"Address",
"Contact No.",
"Doctor Name",
"Symptoms",
"Dignosis",
"Fee: Rs.",
"Blood Group"
};
// DefaultTableModel dtm=new DefaultTableModel();
// jt.setModel(new DefaultTableModel(arr,chd));
jt = new JTable();
jsp = new JScrollPane(jt);
btn = new JButton("CLOSE");
btn.addActionListener(this);
int i = 0;
try {
while (k.next()) {
arr[i][0] = k.getString(1);
// System.out.println("ddddddddddddd"+arr[i][0]);
arr[i][1] = "" + k.getInt(2);
arr[i][2] = k.getString(3) + " " + k.getString(4) + " " + k.getString(5);
arr[i][3] = k.getString(6);
arr[i][4] = "" + k.getInt(7);
arr[i][5] = k.getString(8);
arr[i][6] = k.getString(9);
arr[i][7] = k.getString(10);
arr[i][8] = k.getString(11);
arr[i][9] = k.getString(12);
arr[i][10] = k.getString(13);
arr[i][11] = "" + k.getInt(14);
arr[i][12] = k.getString(15);
arr[i][13] = k.getString(16);
// dtm.insertRow(i,new Object[]{patient.rs.getString(1),
// patient.rs.getInt(2),patient.rs.getString(3)+patient.rs.getString(4)+patient.rs.getString(5),patient.rs.getString(6),patient.rs.getInt(7),patient.rs.getString(8),patient.rs.getString(9),patient.rs.getString(10),patient.rs.getString(11),patient.rs.getString(12),patient.rs.getString(13),patient.rs.getInt(14)});
i++;
}
} catch (Exception e12) {
System.out.println("" + e12);
}
jt.setModel(new DefaultTableModel(arr, chd));
Container con = getContentPane();
con.setLayout(null);
jsp.setBounds(20, 20, 1230, 600);
btn.setBounds(685, 630, 100, 30);
add(jsp);
add(btn);
setSize(1330, 800);
setVisible(true);
}
public void doLayout() {
JComponent compo;
Dimension sz = getSize();
compo = getPanelMenuBar();
compo.setBounds(0, 0, sz.width, 25);
dataScrollPane.setBounds(0, 25, sz.width, sz.height - 25);
}
@Override
public void run() {
// TODO Auto-generated method stub
try {
Socket s = new Socket(hostin, portin);
InputStream ins = s.getInputStream();
OutputStream os = s.getOutputStream();
ir = new BufferedReader(new InputStreamReader(ins));
pw = new PrintWriter(new OutputStreamWriter(os), true);
pw.print(nick);
while (true) {
String line = ir.readLine();
jta.append(line + "\n");
jsp.getVerticalScrollBar().setValue(jsp.getVerticalScrollBar().getMaximum());
}
} catch (IOException e) {
e.printStackTrace();
}
}
public void doLayout() {
Dimension sz = getSize();
final int buttonWidth = 100;
final int buttonHeight = 25;
final int buttonSpacing = 10;
final int spTop = buttonSpacing + buttonHeight + buttonSpacing;
int buttonStart = (sz.width - ((3 * buttonWidth) + (2 * buttonSpacing))) / 2;
if (buttonStart < 0) {
buttonStart = 0;
}
int spHeight = sz.height - spTop;
if (spHeight < 0) {
spHeight = 0;
}
buttonChooseNone.setBounds(buttonStart, buttonSpacing, buttonWidth, buttonHeight);
buttonChooseSelected.setBounds(
buttonStart + buttonWidth + buttonSpacing, buttonSpacing, buttonWidth, buttonHeight);
buttonCancel.setBounds(
buttonStart + buttonWidth + buttonSpacing + buttonWidth + buttonSpacing,
buttonSpacing,
buttonWidth,
buttonHeight);
dataScrollPane.setBounds(0, spTop, sz.width, spHeight);
}
public CFInternetSwingISOCountryPickerJPanel(
ICFInternetSwingSchema argSchema,
ICFSecurityISOCountryObj argFocus,
ICFLibAnyObj argContainer,
Collection<ICFSecurityISOCountryObj> argDataCollection,
ICFInternetSwingISOCountryChosen whenChosen) {
super();
final String S_ProcName = "construct-schema-focus";
if (argSchema == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "argSchema");
}
if (whenChosen == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 5, "whenChosen");
}
invokeWhenChosen = whenChosen;
// argFocus is optional; focus may be set later during execution as
// conditions of the runtime change.
swingSchema = argSchema;
swingFocus = argFocus;
swingContainer = argContainer;
setSwingDataCollection(argDataCollection);
dataTable = new JTable(getDataModel(), getDataColumnModel(), getDataListSelectionModel());
dataTable.addMouseListener(getDataListMouseAdapter());
dataTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
dataTable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
dataTable.setUpdateSelectionOnSort(true);
dataTable.setRowHeight(25);
getDataListSelectionModel().addListSelectionListener(getDataListSelectionListener());
dataScrollPane =
new JScrollPane(
dataTable,
ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS,
ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);
dataScrollPane.setColumnHeader(
new JViewport() {
@Override
public Dimension getPreferredSize() {
Dimension sz = super.getPreferredSize();
sz.height = 25;
return (sz);
}
});
dataTable.setFillsViewportHeight(true);
actionCancel = new ActionCancel();
buttonCancel = new JButton(actionCancel);
actionChooseNone = new ActionChooseNone();
buttonChooseNone = new JButton(actionChooseNone);
actionChooseSelected = new ActionChooseSelectedISOCountry();
buttonChooseSelected = new JButton(actionChooseSelected);
// Do initial layout
setSize(1024, 480);
add(buttonChooseNone);
add(buttonChooseSelected);
add(buttonCancel);
add(dataScrollPane);
dataScrollPane.setBounds(0, 35, 1024, 455);
doLayout();
setSwingFocusAsISOCountry(argFocus);
}
/**
* Static Init.
*
* <pre>
* mainPanel
* northPanel
* centerPanel
* xMatched
* xPanel
* xMathedTo
* southPanel
* </pre>
*
* @throws Exception
*/
private void jbInit() throws Exception {
mainPanel.setLayout(mainLayout);
northPanel.setLayout(northLayout);
// LineRefProv_Label.setText(Msg.getMsg(Env.getCtx(), "RecordNo",new String[]
// {""+LineRefProv.getXX_VMR_PO_LineRefProv_ID()}));
LineRefProv_Label.setText("");
southPanel.setLayout(southLayout);
bNewProduct.setText(Msg.translate(Env.getCtx(), "NewProduct"));
bNewProduct.setEnabled(true);
bDisassociate.setText(Msg.translate(Env.getCtx(), "Disassociate"));
bDisassociate.setEnabled(false);
centerPanel.setLayout(centerLayout);
xProductScrollPane.setBorder(xProductBorder);
xProductScrollPane.setPreferredSize(new Dimension(450, 150));
xAssociateScrollPane.setBorder(xAssociateBorder);
xAssociateScrollPane.setPreferredSize(new Dimension(450, 58));
xPanel.setLayout(xLayout);
mainPanel.add(northPanel, BorderLayout.NORTH);
northPanel.add(
LineRefProv_Label,
new GridBagConstraints(
0,
0,
1,
1,
0.0,
0.0,
GridBagConstraints.EAST,
GridBagConstraints.NONE,
new Insets(12, 12, 5, 5),
0,
0));
mainPanel.add(southPanel, BorderLayout.SOUTH);
mainPanel.add(centerPanel, BorderLayout.CENTER);
centerPanel.add(xProductScrollPane, BorderLayout.NORTH);
xProductScrollPane.getViewport().add(xProductTable, null);
centerPanel.add(xAssociateScrollPane, BorderLayout.SOUTH);
centerPanel.add(xPanel, BorderLayout.CENTER);
xAssociateScrollPane.getViewport().add(xAssociateTable, null);
southPanel.add(
bDisassociate,
new GridBagConstraints(
2,
0,
1,
1,
0.0,
0.0,
GridBagConstraints.EAST,
GridBagConstraints.NONE,
new Insets(5, 12, 5, 12),
0,
0));
southPanel.add(
bNewProduct,
new GridBagConstraints(
8,
0,
1,
1,
0.0,
0.0,
GridBagConstraints.WEST,
GridBagConstraints.NONE,
new Insets(5, 12, 5, 12),
0,
0));
} // jbInit
public void doLayout() {
Dimension sz = getSize();
dataScrollPane.setBounds(0, 0, sz.width, sz.height);
dataScrollPane.doLayout();
}
public void createGUI() {
setLayout(new BorderLayout());
toolBar = new JToolBar("options", JToolBar.HORIZONTAL);
toolBar.setFloatable(false);
toolBar.setOpaque(true);
toolBar.setBackground(new Color(154, 12, 12));
toolBar.setFont(new Font(Font.SANS_SERIF, Font.PLAIN, 15));
selectAllCB = new JCheckBox("Select All");
selectAllCB.setVisible(false);
selectAllCB.setForeground(Color.white);
selectAllCB.addActionListener(this);
refreshBut = new JButton(new ImageIcon(this.getClass().getResource("/images/reloadIcon.png")));
refreshBut.setVisible(false);
refreshBut.setToolTipText("Refresh");
refreshBut.setForeground(new Color(20, 88, 49));
refreshBut.addActionListener(this);
backBut = new JButton(new ImageIcon(this.getClass().getResource("/images/backIcon.png")));
backBut.setVisible(false);
backBut.setToolTipText("Back");
backBut.setForeground(new Color(20, 88, 49));
backBut.addActionListener(this);
deleteBut = new JButton(new ImageIcon(this.getClass().getResource("/images/trashIcon.png")));
deleteBut.setToolTipText("Delete");
deleteBut.setForeground(Color.red);
deleteBut.setVisible(false);
deleteBut.addActionListener(this);
deleteBut.setBackground(Color.red);
restoreBut = new JButton(new ImageIcon(this.getClass().getResource("/images/restoreIcon.png")));
restoreBut.setToolTipText("Restore");
restoreBut.setForeground(Color.blue);
restoreBut.setVisible(false);
restoreBut.addActionListener(this);
toolBar.addSeparator(new Dimension(10, 5));
toolBar.add(selectAllCB);
toolBar.add(backBut);
toolBar.add(refreshBut);
toolBar.add(deleteBut);
toolBar.add(restoreBut);
add(toolBar, "North");
JPanel centPan = new JPanel(new GridBagLayout());
centPan.setBackground(new Color(52, 86, 70));
JLabel label = new JLabel("Select A Category From Left Pane");
label.setFont(new Font("arial", Font.BOLD, 35));
label.setForeground(Color.yellow);
centPan.add(label);
contentPan = new JScrollPane(centPan);
contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0));
add(contentPan, "Center");
contentPan.repaint();
db = new Database();
// inboxSet = db.getData("SELECT * FROM messages WHERE tag='inbox' ORDER BY msg_id
// desc");
// sentmailSet = db.getData("SELECT * FROM messages WHERE tag='sentmail' ORDER BY msg_id
// desc");
// draftSet = db.getData("SELECT * FROM messages WHERE tag='draft' ORDER BY msg_id
// desc");
// outboxSet = db.getData("SELECT * FROM messages WHERE tag='outbox' ORDER BY msg_id
// desc");
// trashSet = db.getData("SELECT * FROM messages,trash WHERE messages.tag='trash' and
// messages.msg_id=trash.msg_id ORDER BY deleted_at desc");
}
public void setContent(String cat) {
cat = cat.trim();
selectAllCB.setVisible(false);
selectAllCB.setSelected(false);
deleteBut.setVisible(false);
restoreBut.setVisible(false);
refreshBut.setVisible(true);
Object columns[] = null;
int count = 0;
switch (cat) {
case "Inbox":
columns = new Object[] {"", "From", "Date", "Subject", "Content"};
count = Database.getCount("Inbox");
workingSet = db.getData("SELECT * FROM messages WHERE tag='inbox' ORDER BY msg_id desc");
;
break;
case "SentMail":
columns = new Object[] {"", "To", "Date", "Subject", "Content"};
count = Database.getCount("Sentmail");
workingSet = db.getData("SELECT * FROM messages WHERE tag='sentmail' ORDER BY msg_id desc");
break;
case "Draft":
columns = new Object[] {"", "To", "Date", "Subject", "Content"};
count = Database.getCount("Draft");
workingSet = db.getData("SELECT * FROM messages WHERE tag='draft' ORDER BY msg_id desc");
break;
case "Outbox":
columns = new Object[] {"", "To", "Date", "Subject", "Content"};
count = Database.getCount("Outbox");
workingSet = db.getData("SELECT * FROM messages WHERE tag='outbox' ORDER BY msg_id desc");
break;
case "Trash":
// restoreBut.setVisible(true);
columns = new Object[] {"", "To/From", "Date", "Subject", "Content"};
count = Database.getCount("Trash");
workingSet =
db.getData(
"SELECT * FROM messages,trash WHERE messages.tag='trash' and messages.msg_id=trash.msg_id ORDER BY deleted_at desc");
break;
default:
System.out.println("in default case");
}
if (count > 0) {
selectAllCB.setVisible(true);
rows = new Object[count][];
msgID = new int[count];
try {
workingSet.beforeFirst();
for (int i = 0; i < count && workingSet.next(); i++) {
msgID[i] = workingSet.getInt(1);
rows[i] =
new Object[] {
false,
workingSet.getString(2),
workingSet.getDate(3),
workingSet.getString(4),
workingSet.getString(5)
};
}
} catch (SQLException sqlExc) {
JOptionPane.showMessageDialog(null, sqlExc, "EXCEPTION", JOptionPane.ERROR_MESSAGE);
sqlExc.printStackTrace();
}
tableModel = new MyDefaultTableModel(rows, columns);
table = new JTable(tableModel);
table.getSelectionModel().addListSelectionListener(this);
table.addMouseListener(this);
table.getTableHeader().setOpaque(true);
table.getTableHeader().setReorderingAllowed(false);
// table.getTableHeader().setBackground(Color.blue);
table.getTableHeader().setForeground(Color.blue);
// table.setRowSelectionAllowed(false);
// table.setColumnSelectionAllowed(false);
table.setFont(new Font(Font.SANS_SERIF, Font.PLAIN, 14));
table.setRowHeight(20);
table.setFillsViewportHeight(true);
TableColumn column = null;
for (int i = 0; i < 5; i++) {
column = table.getColumnModel().getColumn(i);
if (i == 0) {
column.setPreferredWidth(6);
} else if (i == 3) {
column.setPreferredWidth(250);
} else if (i == 4) {
column.setPreferredWidth(450);
} else {
column.setPreferredWidth(40);
}
}
table.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
remove(contentPan);
contentPan = new JScrollPane(table);
contentPan.setBackground(Color.orange);
contentPan.setOpaque(true);
contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0));
add(contentPan, "Center");
Home.home.homeFrame.setVisible(true);
} else {
JPanel centPan = new JPanel(new GridBagLayout());
centPan.setBackground(new Color(52, 86, 70));
JLabel label = new JLabel("No Messages In This Category");
label.setFont(new Font(Font.SANS_SERIF, Font.BOLD, 22));
label.setForeground(Color.orange);
centPan.add(label);
remove(contentPan);
contentPan = new JScrollPane(centPan);
contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0));
add(contentPan, "Center");
contentPan.repaint();
}
}
public NewTaskFrame() throws SQLException {
this.setModal(true);
this.setTitle("Create Task"); // title of frame
this.setSize(400, 350);
this.setLayout(new BorderLayout()); // layout of frame
JLabel task_id = new JLabel("ID:");
JLabel task_name = new JLabel("Name:");
JLabel task_desc = new JLabel("Description:");
JLabel priority = new JLabel("Level of Priority:");
JLabel duedate = new JLabel("Due Date (yyyy-mm-dd)");
JLabel numberofdays = new JLabel("Number of days required:");
JLabel skills_required = new JLabel("Skills Required:");
Object[] id_possibilities = {1, 2, 3, 4, 5, 6, 7, 8, 9, 0};
StringBuffer generated_name = new StringBuffer("t");
for (int i = 0; i < 6; ++i) {
generated_name.append(
id_possibilities[new java.util.Random().nextInt(id_possibilities.length)]);
}
task_idfield = new JTextField(generated_name.toString());
taskname_field = new JTextField();
taskdesc_field = new JTextArea();
priority_checkbox = new JCheckBox("High", false);
numberofdays_field = new JTextField();
format = new SimpleDateFormat("dd-MM-yyyy"); // set format
duedate_field = new JFormattedTextField(format);
// set the duedatefield to tomorrow (since minimum task length = 1)
java.util.Calendar cal = java.util.Calendar.getInstance();
cal.setTime(new Date()); // get current date
cal.add(Calendar.DAY_OF_MONTH, 1); // add 1 to current date
Date date = cal.getTime(); // get this date
duedate_field.setValue(date); // set this date to the field
// panel to hold labels and text fields
JPanel labeltextpanel = new JPanel();
labeltextpanel.setLayout(new GridLayout(7, 2));
labeltextpanel.add(task_id);
labeltextpanel.add(task_idfield);
labeltextpanel.add(task_name);
labeltextpanel.add(taskname_field);
labeltextpanel.add(task_desc);
labeltextpanel.add(taskdesc_field);
labeltextpanel.add(priority);
labeltextpanel.add(priority_checkbox);
labeltextpanel.add(numberofdays);
labeltextpanel.add(numberofdays_field);
labeltextpanel.add(duedate);
labeltextpanel.add(duedate_field);
labeltextpanel.add(skills_required);
this.getSkills();
// main panel for frame including its layout
JPanel mainPanel = new JPanel();
mainPanel.setLayout(new BorderLayout());
mainPanel.add(labeltextpanel, BorderLayout.CENTER);
// buttons
clear_button = new JButton("Clear");
submit_button = new JButton("Submit");
// add listeners to buttons
clear_button.addActionListener(this);
submit_button.addActionListener(this);
// create panel for buttons and add buttons
JPanel buttonpanel = new JPanel();
buttonpanel.setLayout(new FlowLayout());
buttonpanel.add(clear_button);
buttonpanel.add(submit_button);
JPanel checkbox_panel = new JPanel();
checkbox_panel.setLayout(new FlowLayout());
for (int i = 0; i < skill_list.size(); i++) {
checkbox_panel.add(skill_list.get(i)); // make this panel flowlayout
}
scrollpane = new JScrollPane(checkbox_panel);
scrollpane.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
JPanel panel = new JPanel();
panel.setLayout(new BorderLayout());
panel.add(mainPanel, BorderLayout.CENTER);
panel.add(scrollpane, BorderLayout.SOUTH);
// add the main panel to main frame
add(panel, BorderLayout.CENTER);
add(buttonpanel, BorderLayout.SOUTH);
this.setVisible(true);
}
/* Clear all existing nodes from the tree model and rebuild from scratch.
*/
protected void refreshTree() {
DefaultMutableTreeNode propertiesNode;
DefaultMutableTreeNode leaf;
// First clear the existing tree by simply enumerating
// over the root node's children and removing them one by one.
while (treeModel.getChildCount(rootNode) > 0) {
DefaultMutableTreeNode child = (DefaultMutableTreeNode) treeModel.getChild(rootNode, 0);
treeModel.removeNodeFromParent(child);
child.removeAllChildren();
child.removeFromParent();
}
treeModel.nodeStructureChanged(rootNode);
treeModel.reload();
tScrollPane.repaint();
// Now rebuild the tree below its root
try {
// Start by naming the root node from its URL:
rootNode.setUserObject(dMeta.getURL());
// get metadata about user tables by building a vector of table names
String usertables[] = {"TABLE", "GLOBAL TEMPORARY", "VIEW"};
ResultSet result = dMeta.getTables(null, null, null, usertables);
Vector tables = new Vector();
// sqlbob@users Added remarks.
Vector remarks = new Vector();
while (result.next()) {
tables.addElement(result.getString(3));
remarks.addElement(result.getString(5));
}
result.close();
// For each table, build a tree node with interesting info
for (int i = 0; i < tables.size(); i++) {
String name = (String) tables.elementAt(i);
DefaultMutableTreeNode tableNode = makeNode(name, rootNode);
ResultSet col = dMeta.getColumns(null, null, name, null);
// sqlbob@users Added remarks.
String remark = (String) remarks.elementAt(i);
if ((remark != null) && !remark.trim().equals("")) {
makeNode(remark, tableNode);
}
// With a child for each column containing pertinent attributes
while (col.next()) {
String c = col.getString(4);
DefaultMutableTreeNode columnNode = makeNode(c, tableNode);
String type = col.getString(6);
makeNode("Type: " + type, columnNode);
boolean nullable = col.getInt(11) != DatabaseMetaData.columnNoNulls;
makeNode("Nullable: " + nullable, columnNode);
}
col.close();
DefaultMutableTreeNode indexesNode = makeNode("Indices", tableNode);
ResultSet ind = dMeta.getIndexInfo(null, null, name, false, false);
String oldiname = null;
// A child node to contain each index - and its attributes
while (ind.next()) {
DefaultMutableTreeNode indexNode = null;
boolean nonunique = ind.getBoolean(4);
String iname = ind.getString(6);
if ((oldiname == null || !oldiname.equals(iname))) {
indexNode = makeNode(iname, indexesNode);
makeNode("Unique: " + !nonunique, indexNode);
oldiname = iname;
}
// And the ordered column list for index components
makeNode(ind.getString(9), indexNode);
}
ind.close();
}
// Finally - a little additional metadata on this connection
propertiesNode = makeNode("Properties", rootNode);
makeNode("User: "******"ReadOnly: " + cConn.isReadOnly(), propertiesNode);
makeNode("AutoCommit: " + cConn.getAutoCommit(), propertiesNode);
makeNode("Driver: " + dMeta.getDriverName(), propertiesNode);
makeNode("Product: " + dMeta.getDatabaseProductName(), propertiesNode);
makeNode("Version: " + dMeta.getDatabaseProductVersion(), propertiesNode);
} catch (SQLException se) {
propertiesNode = makeNode("Error getting metadata:", rootNode);
makeNode(se.getMessage(), propertiesNode);
makeNode(se.getSQLState(), propertiesNode);
}
treeModel.nodeStructureChanged(rootNode);
treeModel.reload();
tScrollPane.repaint();
}
