private void add(Component c, GridBagConstraints gbc, int x, int y, int w, int h) {
gbc.gridx = x;
gbc.gridy = y;
gbc.gridwidth = w;
gbc.gridheight = h;
getContentPane().add(c, gbc);
}
private void addToGridBag(
GridBagLayout gb,
GridBagConstraints c,
Container cont,
JComponent item,
int x,
int y,
int w,
int h) {
c.gridx = x;
c.gridy = y;
c.gridwidth = w;
c.gridheight = h;
gb.setConstraints(item, c);
cont.add(item);
}
private Container createReturnPane() {
// Create return button
returnButton = new JButton(returnAction);
// Create text fields
retISBN = new JTextField(15);
retCustID = new JTextField(15);
// Create panel and layout
JPanel pane = new JPanel();
pane.setOpaque(false);
GridBagLayout gb = new GridBagLayout();
pane.setLayout(gb);
GridBagConstraints c = new GridBagConstraints();
c.insets = new Insets(1, 5, 1, 5);
// Fill panel
c.anchor = GridBagConstraints.EAST;
addToGridBag(gb, c, pane, new JLabel("ISBN:"), 0, 0, 1, 1);
addToGridBag(gb, c, pane, new JLabel("Customer ID:"), 0, 1, 1, 1);
c.anchor = GridBagConstraints.WEST;
c.fill = GridBagConstraints.HORIZONTAL;
addToGridBag(gb, c, pane, retISBN, 1, 0, 3, 1);
addToGridBag(gb, c, pane, retCustID, 1, 1, 3, 1);
c.fill = GridBagConstraints.NONE;
addToGridBag(gb, c, pane, returnButton, 4, 0, 1, 3);
// Set up VK_ENTER triggering the return button in this panel
InputMap input = pane.getInputMap(WHEN_ANCESTOR_OF_FOCUSED_COMPONENT);
input.put(getKeyStroke("ENTER"), "returnAction");
pane.getActionMap().put("returnAction", returnAction);
return pane;
}
public General_Info() {
pic.setIcon(userPic);
String url = "jdbc:odbc:lib";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection(url);
} catch (ClassNotFoundException cnfex) {
System.err.println("Failed to load driver");
cnfex.printStackTrace();
System.exit(1);
} catch (SQLException sqlex) {
System.err.println("unable to connect");
sqlex.printStackTrace();
}
// validation for telephone
tel_text.addKeyListener(
new KeyAdapter() {
public void keyTyped(KeyEvent e) {
char c = e.getKeyChar();
if (!((Character.isDigit(c)
|| (c == KeyEvent.VK_BACK_SPACE)
|| (c == KeyEvent.VK_DELETE)))) {
getToolkit().beep();
e.consume();
}
}
});
// validation for fax
fax_text.addKeyListener(
new KeyAdapter() {
public void keyTyped(KeyEvent e) {
char c = e.getKeyChar();
if (!((Character.isDigit(c)
|| (c == KeyEvent.VK_BACK_SPACE)
|| (c == KeyEvent.VK_DELETE)))) {
getToolkit().beep();
e.consume();
}
}
});
patron_text.setText("P-");
patron_text.addFocusListener(
new MyActionListener() {
public void focusLost(FocusEvent e) {
try {
Statement statement = connection.createStatement();
String query2 =
"SELECT * FROM patronmaster " + "WHERE id = '" + patron_text.getText() + "'";
ResultSet rs2 = statement.executeQuery(query2);
int cnt = 0;
while (rs2.next()) {
cnt++;
}
if (cnt != 0) {
try {
userPic = new ImageIcon(patron_text.getText() + ".gif");
pic.setIcon(userPic);
} catch (Exception ex) {
ex.printStackTrace();
pic.setIcon(userPic);
}
String query1 =
"SELECT * FROM patronmaster " + "WHERE id = '" + patron_text.getText() + "'";
ResultSet rs1 = statement.executeQuery(query1);
try {
rs1.next();
int confirm =
JOptionPane.showConfirmDialog(
null,
"This record Exists, would you like to update it?",
"CONFIRM",
JOptionPane.YES_NO_OPTION);
if (confirm == JOptionPane.NO_OPTION) {
patron_text.setEditable(false);
name_text.setEditable(false);
passport_text.setEditable(false);
expiry_date_text.setEditable(false);
reg_by_text.setEditable(false);
reg_date_text.setEditable(false);
textArea.setEditable(false);
tel_text.setEditable(false);
fax_text.setEditable(false);
email_text.setEditable(false);
} else {
}
name_text.setText(rs1.getString(2));
passport_text.setText(rs1.getString(3));
expiry_date_text.setText(rs1.getString(6));
reg_by_text.setText(rs1.getString(7));
reg_date_text.setText(rs1.getString(8));
textArea.setText(rs1.getString(9));
tel_text.setText(rs1.getString(10));
fax_text.setText(rs1.getString(11));
email_text.setText(rs1.getString(12));
status_combo.setSelectedItem(rs1.getString(4));
salute_combo.setSelectedItem(rs1.getString(5));
group_combo.setSelectedItem(rs1.getString(13));
statement.close();
} catch (SQLException sqlex) {
pic.setIcon(userPic);
}
}
} catch (SQLException sqlex) {
pic.setIcon(userPic);
}
}
});
scroll.add(address);
scroll.add(scrollPane);
text.setLayout(new GridBagLayout());
GridBagConstraints gbc = new GridBagConstraints();
gbc.gridy = 0;
gbc.gridx = 0;
text.add(tel, gbc);
gbc.gridy = 1;
text.add(fax, gbc);
gbc.gridy = 2;
text.add(email, gbc);
gbc.gridy = 0;
gbc.gridx = 2;
text.add(tel_text, gbc);
gbc.gridy = 1;
text.add(fax_text, gbc);
gbc.gridy = 2;
text.add(email_text, gbc);
pic.setSize(50, 50);
pane1.add(scroll, BorderLayout.CENTER);
pane1.add(pic, BorderLayout.EAST);
pane1.add(text, BorderLayout.WEST);
add(pane1);
}
public Summary(int patient_id) {
this.patient_id = patient_id;
setTitle("Summary");
setSize(
(int) (Toolkit.getDefaultToolkit().getScreenSize().getWidth()),
(int) (Toolkit.getDefaultToolkit().getScreenSize().getHeight()) - 40);
setResizable(false);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
head = new JLabel("MEDI_SCAN DIAGNOSTIC LAB SERVICES", SwingConstants.CENTER);
head.setForeground(Color.WHITE);
Font f2 = new Font("Papyrus", Font.BOLD, 36);
head.setFont(f2);
res = new JLabel("RESULT SUMMARY", SwingConstants.CENTER);
res.setForeground(Color.WHITE);
Font f3 = new Font("Papyrus", Font.BOLD, 28);
res.setFont(f3);
Font f1 = new Font("Goudy Old Style", Font.BOLD, 16);
hello = new JLabel("Hello Mr./Miss ");
hello.setForeground(new Color(54, 34, 174));
hello.setFont(f1);
fin = new JLabel("Your Medical Test Is Finished");
fin.setFont(f1);
fin.setForeground(new Color(54, 34, 174));
pname = new JLabel("Patient Name");
pname.setForeground(new Color(54, 34, 174));
pname.setFont(f1);
ldate = new JLabel("Test Date");
ldate.setForeground(new Color(54, 34, 174));
ldate.setFont(f1);
age = new JLabel("Age");
age.setForeground(new Color(54, 34, 174));
age.setFont(f1);
sex = new JLabel("Sex");
sex.setForeground(new Color(54, 34, 174));
sex.setFont(f1);
tname = new JLabel("Test Name");
tname.setForeground(new Color(54, 34, 174));
tname.setFont(f1);
nvalue = new JLabel("Normal Value");
nvalue.setForeground(new Color(54, 34, 174));
nvalue.setFont(f1);
trate = new JLabel("Test Rate");
trate.setForeground(new Color(54, 34, 174));
trate.setFont(f1);
tresult = new JLabel("Test Result");
tresult.setForeground(new Color(54, 34, 174));
tresult.setFont(f1);
tamt = new JLabel("Total Amout");
tamt.setForeground(new Color(54, 34, 174));
tamt.setFont(f1);
exit = new JButton("EXIT");
exit.setFont(f1);
pHead = new JPanel(new GridLayout(2, 1));
pHead.setBackground(new Color(134, 134, 234));
pCenter = new JPanel(new GridBagLayout());
pCenter.setBackground(new Color(211, 248, 253));
pCom = new JPanel(new BorderLayout());
pCom.setBackground(new Color(211, 248, 253));
pSouth = new JPanel(new FlowLayout(FlowLayout.RIGHT));
pSouth.setBackground(new Color(211, 248, 253));
// Adding Icon on top-left.
ImageIcon img = new ImageIcon("pics/logo.jpg");
this.setIconImage(img.getImage());
try {
Connection con = JDBCConnection.getConnection();
PreparedStatement pstmt =
con.prepareStatement(
"Select first_name,last_name,age,sex,test_id,tdate from patientreg where patient_id=?");
pstmt.setInt(1, this.patient_id);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
first_name = rs.getString("first_name");
lname = rs.getString("last_name");
name = new JLabel(first_name + " " + lname);
name1 = new JLabel(first_name + " " + lname);
p_age = rs.getInt("age");
pAge = new JLabel(p_age + "");
p_sex = rs.getString("sex");
psex = new JLabel(p_sex);
t_id = rs.getInt("test_id");
t_date = rs.getString("tdate");
date1 = new JLabel(t_date);
}
} catch (SQLException s) {
s.printStackTrace();
}
try {
Connection con = JDBCConnection.getConnection();
PreparedStatement pstmt =
con.prepareStatement("Select test_result from reportbydoctor where patient_id=?");
pstmt.setInt(1, this.patient_id);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
te_res = rs.getString("test_result");
result = new JLabel(te_res);
}
} catch (SQLException s) {
s.printStackTrace();
}
try {
Connection con = JDBCConnection.getConnection();
PreparedStatement pstmt =
con.prepareStatement("select normal_val,rate,test_name from addtest where test_id=?");
pstmt.setInt(1, t_id);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
n_value = rs.getInt("normal_val");
normal_value1 = new JLabel(n_value + "");
te_rate = rs.getInt("rate");
rate1 = new JLabel(te_rate + "");
rate2 = new JLabel(te_rate + "");
te_name = rs.getString("test_name");
testname = new JLabel(te_name);
}
} catch (SQLException a) {
a.printStackTrace();
}
content = getContentPane();
// for label hello
GridBagConstraints gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 1;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 50, 20, 0);
pCenter.add(hello, gc);
// for label name1
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 1;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 0);
pCenter.add(name1, gc);
// for label fin
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 3;
gc.gridwidth = 2;
gc.gridy = 1;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(fin, gc);
// for label pname
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 2;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(pname, gc);
// for label name
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 2;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(name, gc);
// for label ldate
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 3;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(ldate, gc);
// for label date1
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 3;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(date1, gc);
// for label age
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 4;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(age, gc);
// for label pAge
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 4;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(pAge, gc);
// for label sex
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 5;
gc.ipadx = 125;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(sex, gc);
// for label psex
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 5;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(psex, gc);
// for label tname
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 6;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(tname, gc);
// for label nvalue
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 6;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(nvalue, gc);
// for label trate
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 3;
gc.gridwidth = 1;
gc.gridy = 6;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(trate, gc);
// for label tresult
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 4;
gc.gridwidth = 1;
gc.gridy = 6;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(tresult, gc);
// for label testname
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 7;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(testname, gc);
// for label normal_value1
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 7;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(normal_value1, gc);
// for label rate1
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 3;
gc.gridwidth = 1;
gc.gridy = 7;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(rate1, gc);
// for label result
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 4;
gc.gridwidth = 1;
gc.gridy = 7;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(result, gc);
// for label tamt
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 3;
gc.gridwidth = 1;
gc.gridy = 8;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(tamt, gc);
// for label rate2
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 4;
gc.gridwidth = 1;
gc.gridy = 8;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(rate2, gc);
exit.addActionListener(this);
pSouth.add(exit);
content.add(pSouth, BorderLayout.SOUTH);
pHead.add(head);
pHead.add(res);
content.add(pHead, BorderLayout.NORTH);
content.add(pCenter, BorderLayout.CENTER);
setVisible(true);
}
private Container createBorrowPane() {
// Initialise date combo boxes
borDay = new JComboBox();
borMonth = new JComboBox();
borYear = new JComboBox();
String[] days = new String[31];
for (int i = 0; i < 31; i++) days[i] = String.valueOf(i + 1);
String[] months = {
"January",
"February",
"March",
"April",
"May",
"June",
"July",
"August",
"September",
"October",
"November",
"December"
};
String[] years = {
"2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012", "2013", "2014"
};
borDay.setModel(new DefaultComboBoxModel(days));
borMonth.setModel(new DefaultComboBoxModel(months));
borYear.setModel(new DefaultComboBoxModel(years));
Calendar today = Calendar.getInstance();
borDay.setSelectedIndex(today.get(DAY_OF_MONTH) - 1);
borMonth.setSelectedIndex(today.get(MONTH));
borYear.setSelectedIndex(today.get(YEAR) - 2005);
// Create borrow button
borrowButton = new JButton(borrowAction);
// Create text fields
borISBN = new JTextField(15);
borCustID = new JTextField(15);
// Create panel and layout
JPanel pane = new JPanel();
pane.setOpaque(false);
GridBagLayout gb = new GridBagLayout();
pane.setLayout(gb);
GridBagConstraints c = new GridBagConstraints();
c.insets = new Insets(1, 5, 1, 5);
// Fill panel
c.anchor = GridBagConstraints.EAST;
addToGridBag(gb, c, pane, new JLabel("ISBN:"), 0, 0, 1, 1);
addToGridBag(gb, c, pane, new JLabel("Customer ID:"), 0, 1, 1, 1);
addToGridBag(gb, c, pane, new JLabel("Due Date:"), 0, 2, 1, 1);
c.anchor = GridBagConstraints.WEST;
c.fill = GridBagConstraints.HORIZONTAL;
addToGridBag(gb, c, pane, borISBN, 1, 0, 3, 1);
addToGridBag(gb, c, pane, borCustID, 1, 1, 3, 1);
c.fill = GridBagConstraints.NONE;
addToGridBag(gb, c, pane, borDay, 1, 2, 1, 1);
addToGridBag(gb, c, pane, borMonth, 2, 2, 1, 1);
addToGridBag(gb, c, pane, borYear, 3, 2, 1, 1);
addToGridBag(gb, c, pane, borrowButton, 4, 0, 1, 3);
// Set up VK_ENTER triggering the borrow button in this panel
InputMap input = pane.getInputMap(WHEN_ANCESTOR_OF_FOCUSED_COMPONENT);
input.put(getKeyStroke("ENTER"), "borrowAction");
pane.getActionMap().put("borrowAction", borrowAction);
return pane;
}
public QueryDBFrame() {
setTitle("QueryDB");
setSize(400, 300);
addWindowListener(
new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
getContentPane().setLayout(new GridBagLayout());
GridBagConstraints gbc = new GridBagConstraints();
authors = new JComboBox();
authors.setEditable(false);
authors.addItem("Any");
publishers = new JComboBox();
publishers.setEditable(false);
publishers.addItem("Any");
result = new JTextArea(4, 50);
result.setEditable(false);
priceChange = new JTextField(8);
priceChange.setText("-5.00");
try {
// 连接数据库
con = getConnection();
stmt = con.createStatement();
// 将数据库中的作者名添加到组合框
String query = "SELECT Name FROM Authors";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) authors.addItem(rs.getString(1));
// 将出版社名添加到组合框
query = "SELECT Name FROM Publishers";
rs = stmt.executeQuery(query);
while (rs.next()) publishers.addItem(rs.getString(1));
} catch (Exception e) {
result.setText("Error " + e);
}
gbc.fill = GridBagConstraints.NONE;
gbc.weightx = 100;
gbc.weighty = 100;
add(authors, gbc, 0, 0, 2, 1);
add(publishers, gbc, 2, 0, 2, 1);
gbc.fill = GridBagConstraints.NONE;
JButton queryButton = new JButton("Query");
queryButton.addActionListener(this);
add(queryButton, gbc, 0, 1, 1, 1);
JButton changeButton = new JButton("Change prices");
changeButton.addActionListener(this);
add(changeButton, gbc, 2, 1, 1, 1);
gbc.fill = GridBagConstraints.HORIZONTAL;
add(priceChange, gbc, 3, 1, 1, 1);
gbc.fill = GridBagConstraints.BOTH;
add(result, gbc, 0, 2, 4, 1);
}
