-
Notifications
You must be signed in to change notification settings - Fork 0
/
Book_IssuePanel.java
121 lines (103 loc) · 3.16 KB
/
Book_IssuePanel.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
package com.cruds.swingproj;
import java.awt.CardLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import java.util.Date;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
public class Book_IssuePanel extends JPanel
{
JTable tableUSN;
JTable tableISBN;
JTextField txtUSN;
JLabel lblUSN;
JTextField txtISBN;
JLabel lblISBN;
JButton btnsearchUSN;
JButton btnsearchISBN;
JScrollPane spaneUSN;
JScrollPane spaneISBN;
JButton btnissue;
JButton btnhome;
Vector<String> ColUSN;
Vector<String> ColISBN;
BookDAO dao = new BookDAO();
IssuebookDAO dao1 = new IssuebookDAO();
public Book_IssuePanel()
{
ColUSN = new Vector<>();
lblUSN = new JLabel("Student USN");
txtUSN = new JTextField(7);
ColUSN.add("USN");
ColUSN.add("Name");
ColISBN = new Vector<>();
lblISBN = new JLabel("Book ISBN");
txtISBN = new JTextField(7);
ColISBN.add("ISBN");
ColISBN.add("Title");
ColISBN.add("Category");
ColISBN.add("No of Books");
ColISBN.add("Author Name");
ColISBN.add("Email ID");
tableUSN = new JTable(null, ColUSN);
spaneUSN = new JScrollPane(tableUSN);
btnsearchUSN = new JButton("Search");
btnsearchUSN.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
String strUsn = txtUSN.getText();
tableUSN.setModel(new DefaultTableModel(dao1.getStudentUSN(strUsn), ColUSN));
}
});
tableISBN = new JTable(null, ColISBN);
spaneISBN = new JScrollPane(tableISBN);
btnsearchISBN = new JButton("Search");
btnsearchISBN.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
String strIsbn = txtISBN.getText();
tableISBN.setModel(new DefaultTableModel(dao1.getBookISBN(Integer.parseInt(strIsbn)), ColISBN));
}
});
btnissue = new JButton("Issue");
btnissue.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e)
{
int rowidx = tableUSN.getSelectedRow();
String strUsn = (String) tableUSN.getModel().getValueAt(rowidx, 0);
String strISBN = (String) tableISBN.getModel().getValueAt(rowidx, 0);
if(dao1.book_issue(new Student(strUsn),DateUtil.getCurrDateAsSQLDate(),Integer.parseInt(strISBN)))
{
JOptionPane.showMessageDialog(parent(), "Book Issued", "Success",JOptionPane.INFORMATION_MESSAGE);
layout.show(parent(), "LIST STUDENT BOOKS");
}
}
});
btnhome = new JButton("Home");
btnhome.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
CardLayout card = (CardLayout) getParent().getLayout();
card.show(getParent(),"HOMEPANEL");
}
});
add(lblUSN);
add(txtUSN);
add(btnsearchUSN);
add(lblISBN);
add(txtISBN);
add(btnsearchISBN);
add(spaneISBN);
add(spaneUSN);
add(btnissue);
add(btnhome);
}
}