📄 bookframe.java
字号:
}
});
}
return jButton5;
}
/**
* This method initializes jButton6
*
* @return javax.swing.JButton
*/
private JButton getJButton6() {
if (jButton6 == null) {
jButton6 = new JButton();
jButton6.setBounds(new Rectangle(16, 120, 120, 30));
jButton6.setText("所有借阅记录");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
int count = 0,index = 0;
try{
String query = "select * from Borrow";
resultSet = statement.executeQuery(query);
resultSet.last();
count = resultSet.getRow();
resultSet.close();
}catch(Exception sqlE){
sqlE.printStackTrace();
}
String query = "select reader.id,reader.name,book.id,book.name,borrow.borrowTime "
+"from reader,book,borrow "
+"where "
+"reader.id = borrow.readerId "
+"and book.id = borrow.bookId";
String[][]data = new String[count][];
try{
ResultSet resultSet = statement.executeQuery(query);
while(resultSet.next()){
String readerId = resultSet.getString(1);
String readerName = resultSet.getString(2);
String bookId = resultSet.getString(3);
String bookName = resultSet.getString(4);
String borrowTime = resultSet.getString(5);
data[index] = new String[5];
data[index][0]=readerId.trim();
data[index][1]=readerName.trim();
data[index][2]=bookId.trim();
data[index][3]=bookName.trim();
data[index][4]=borrowTime.trim();
index++;
//text+="读者Id:"+readerId+"\n姓名:"+readerName+"\n书号:"+ bookId+"\n书名:"+bookName+"\n借阅时间:"+borrowTime+"\n";
}
TableDialog tableDialog = new TableDialog(null,data);
//tableDialog.pack();
tableDialog.show();
//JOptionPane.showMessageDialog(null, text,"借阅信息",JOptionPane.INFORMATION_MESSAGE);
resultSet.close();
}catch(Exception sqlE){
sqlE.printStackTrace();
}
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return jButton6;
}
/**
* This method initializes jButton7
*
* @return javax.swing.JButton
*/
private JButton getJButton7() {
if (jButton7 == null) {
jButton7 = new JButton();
jButton7.setBounds(new Rectangle(16, 168, 120, 30));
jButton7.setText("插入新书资料");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
if(!loadId.trim().equals(new String("admin"))) {
JOptionPane.showMessageDialog(null, "您没有相关的权限", "不成功", JOptionPane.ERROR_MESSAGE);
return;
}
insertBookFrame = new InsertBookFrame(connection);
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return jButton7;
}
/**
* This method initializes jButton8
*
* @return javax.swing.JButton
*/
private JButton getJButton8() {
if (jButton8 == null) {
jButton8 = new JButton();
jButton8.setBounds(new Rectangle(14, 223, 120, 30));
jButton8.setText("综合信息");
jButton8.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
String readerCount = "select count(*) from reader";
String bookCount = "select count(*) from book";
String borrowCount = "select count(*) from borrow";
String text = "";
try{
ResultSet readerResultSet = statement.executeQuery(readerCount);
readerResultSet.next();
int readerC = readerResultSet.getInt(1);
text+="读者信息:"+readerC+"条\n";
}catch(Exception sqlE){
sqlE.printStackTrace();
}
try{
ResultSet bookResultSet = statement.executeQuery(bookCount);
bookResultSet.next();
int bookC = bookResultSet.getInt(1);
text+="图书记录:"+bookC+"条\n";
}catch(Exception sqlE){
sqlE.printStackTrace();
}
try{
ResultSet borrowResultSet = statement.executeQuery(borrowCount);
borrowResultSet.next();
int borrowC = borrowResultSet.getInt(1);
text+="借阅记录:"+borrowC+"条\n";
}catch(Exception sqlE){
sqlE.printStackTrace();
}
JOptionPane.showMessageDialog(null, text,"统计信息",JOptionPane.INFORMATION_MESSAGE);
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return jButton8;
}
/**
* This method initializes jScrollPane
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane() {
if (jScrollPane == null) {
jLabel5 = new JLabel();
jLabel5.setText("");
//jLabel5.setIcon(new ImageIcon("Icon\\1.jpg"));
jScrollPane = new JScrollPane();
jScrollPane.setBounds(new Rectangle(30, 6, 148, 190));
jScrollPane.setViewportView(jLabel5);
}
return jScrollPane;
}
/**
* This method initializes jScrollPane1
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane1() {
if (jScrollPane1 == null) {
jLabel6 = new JLabel();
jLabel6.setText("");
jScrollPane1 = new JScrollPane();
jScrollPane1.setBounds(new Rectangle(225, 6, 148, 190));
jScrollPane1.setViewportView(jLabel6);
}
return jScrollPane1;
}
/**
* This method initializes jScrollPane2
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane2() {
if (jScrollPane2 == null) {
jLabel11 = new JLabel();
jLabel11.setText("");
jScrollPane2 = new JScrollPane();
jScrollPane2.setBounds(new Rectangle(421, 6, 148, 190));
jScrollPane2.setViewportView(jLabel11);
}
return jScrollPane2;
}
/**
* This method initializes jScrollPane3
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane3() {
if (jScrollPane3 == null) {
jLabel12 = new JLabel();
jLabel12.setText("");
jScrollPane3 = new JScrollPane();
jScrollPane3.setBounds(new Rectangle(27, 256, 148, 190));
jScrollPane3.setViewportView(jLabel12);
}
return jScrollPane3;
}
/**
* This method initializes jScrollPane4
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane4() {
if (jScrollPane4 == null) {
jLabel13 = new JLabel();
jLabel13.setText("");
jScrollPane4 = new JScrollPane();
jScrollPane4.setBounds(new Rectangle(225, 256, 148, 190));
jScrollPane4.setViewportView(jLabel13);
}
return jScrollPane4;
}
/**
* This method initializes jScrollPane5
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane5() {
if (jScrollPane5 == null) {
jLabel17 = new JLabel();
jLabel17.setText("");
jScrollPane5 = new JScrollPane();
jScrollPane5.setBounds(new Rectangle(418, 256, 148, 190));
jScrollPane5.setViewportView(jLabel17);
}
return jScrollPane5;
}
/**
* This method initializes jButton9
*
* @return javax.swing.JButton
*/
private JButton getJButton9() {
if (jButton9 == null) {
jButton9 = new JButton();
jButton9.setBounds(new Rectangle(242, 44, 62, 25));
jButton9.setText("搜索");
jButton9.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
if(jTextField.getText().length()==0){
JOptionPane.showMessageDialog(null, "请输入相关内容", "ERROR", JOptionPane.ERROR_MESSAGE);
return;
}
String methodSelect = null;
String[] method = {"id","name","sort","author","publish"};
methodSelect = method[jComboBox.getSelectedIndex()];
String query = null;
if(jRadioButton.isSelected()){
query = "select * from Book where " + methodSelect + "=" + "'" + jTextField.getText() + "'";
}else{
query = "select * from Book where " + methodSelect + " like " + "'%" + jTextField.getText() + "%'";
}
//System.out.println(query);
try{
resultSet = statement.executeQuery(query);
resultSet.last();
int count = resultSet.getRow();
resultSet.first();
resultSet.previous();
for(int i=0;i<6;i++){
if(resultSet.next()){
String id = resultSet.getString("id");
String name = resultSet.getString("name");
String text = "<html>"
+"编号:"+id
+"<br>"
+"书名:"+name
+"</html>";
jLabelTextCollect[i].setText(text);
jLabelCollect[i].setIcon(new ImageIcon(resultSet.getBytes("cover")));
idList[i] = id;
}
else{
jLabelTextCollect[i].setText(null);
jLabelCollect[i].setIcon(null);
idList[i] = null;
}
}
}catch(Exception sqlE){
sqlE.printStackTrace();
}
//System.out.println(query);
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return jButton9;
}
/**
* This method initializes jTextField
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField() {
if (jTextField == null) {
jTextField = new JTextField();
jTextField.setBounds(new Rectangle(113, 45, 124, 24));
}
return jTextField;
}
/**
* This method initializes jButton10
*
* @return javax.swing.JButton
*/
private JButton getJButton10() {
if (jButton10 == null) {
jButton10 = new JButton();
jButton10.setBounds(new Rectangle(444, 7, 118, 24));
jButton10.setText("我借的书");
jButton10.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
try{
String query = "select * from Book "
+ "where id in ("
+ "select bookId from borrow "
+ "where readerId = "
+ "'"+loadId+"')";
//System.out.println(query);
resultSet = statement.executeQuery(query);
resultSet.last();
int count = resultSet.getRow();
//System.out.println(count);
resultSet.first();
resultSet.previous();
for(int i=0;i<6;i++){
if(resultSet.next()){
String id = resultSet.getString("id");
String name = resultSet.getString("name");
String text = "<html>"
+"编号:"+id
+"<br>"
+"书名:"+name
+"</html>";
jLabelTextCollect[i].setText(text);
jLabelCollect[i].setIcon(new ImageIcon(resultSet.getBytes("cover")));
idList[i] = id;
}else{
jLabelTextCollect[i].setText(null);
jLabelCollect[i].setIcon(null);
}
}
}catch(Exception sqlE){
sqlE.printStackTrace();
}
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return jButton10;
}
} // @jve:decl-index=0:visual-constraint="20,11"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -