📄 frame11.java~53~
字号:
package bookmanagesystem;
import java.awt.BorderLayout;
import javax.swing.*;
import javax.swing.JFrame;
import java.awt.Color;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JButton;
import javax.swing.JTextField;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import java.sql.SQLException;
import java.util.Calendar;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
ot attributable
* @version 1.0
*/
public class Frame11 extends JFrame {
public Frame11() {
try {
setBounds(300,250,400,300);
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
Calendar calendar=Calendar.getInstance();
getContentPane().setLayout(null);
this.getContentPane().setBackground(new Color(0, 66, 92));
this.setResizable(false);
this.setTitle("书籍还入");
this.setVisible(true);
jButton3.addActionListener(new Frame11_jButton3_actionAdapter(this));
jButton1.addActionListener(new Frame11_jButton1_actionAdapter(this));
jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel8.setForeground(Color.red);
jLabel8.setText("*");
jLabel8.setBounds(new Rectangle(352, 41, 12, 15));
jLabel9.setForeground(Color.white);
jLabel9.setText("备注：");
jLabel9.setBounds(new Rectangle(51, 142, 42, 15));
jTextField5.setBounds(new Rectangle(116, 86, 231, 20));
jLabel10.setForeground(Color.white);
jLabel10.setText("ISBN：");
jLabel10.setBounds(new Rectangle(51, 91, 48, 15));
jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel11.setForeground(Color.red);
jLabel11.setText("*");
jLabel11.setBounds(new Rectangle(352, 91, 12, 15));
jButton2.addActionListener(new Frame11_jButton2_actionAdapter(this));
jLabel12.setBounds(new Rectangle(25, 180, 68, 64));
jLabel12.setIcon(new ImageIcon("xueren_big.jpg"));
this.getContentPane().add(jLabel1);
jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel7.setForeground(Color.red);
jLabel7.setText("*");
jLabel7.setBounds(new Rectangle(353, 66, 12, 15));
jTextField4.setBounds(new Rectangle(116, 136, 231, 21));
jButton3.setBounds(new Rectangle(272, 194, 75, 25));
jButton3.setText("退出");
jTextField1.setBounds(new Rectangle(116, 35, 231, 21));
jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel6.setForeground(Color.red);
jLabel6.setBounds(new Rectangle(352, 66, 12, 15));
jButton2.setBounds(new Rectangle(114, 194, 75, 25));
jButton2.setText("重置");
jTextField2.setBounds(new Rectangle(116, 60, 231, 21));
jLabel5.setForeground(Color.white);
jLabel5.setText("书名：");
jLabel5.setBounds(new Rectangle(51, 60, 42, 21));
jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel4.setForeground(Color.red);
jLabel4.setText("*");
jLabel4.setBounds(new Rectangle(352, 116, 12, 15));
jTextField3.setBounds(new Rectangle(116, 110, 231, 21));
jTextField3.setText(String.valueOf(calendar.get(Calendar.YEAR))+"-"+String.valueOf(calendar.get(Calendar.MONTH)+1)+"-"+String.valueOf(calendar.get(Calendar.DAY_OF_MONTH)));
jTextField3.setEnabled(false);
jLabel3.setForeground(Color.white);
jLabel3.setText("日期：");
jLabel3.setBounds(new Rectangle(51, 112, 42, 19));
jLabel2.setForeground(Color.white);
jLabel2.setText("用户名：");
jLabel2.setBounds(new Rectangle(51, 35, 58, 21));
this.getContentPane().add(jButton1);
this.getContentPane().add(jLabel2);
this.getContentPane().add(jButton2);
this.getContentPane().add(jTextField1);
this.getContentPane().add(jButton3);
this.getContentPane().add(jTextField2);
this.getContentPane().add(jTextField5);
this.getContentPane().add(jTextField3);
this.getContentPane().add(jTextField4);
this.getContentPane().add(jLabel5);
this.getContentPane().add(jLabel3);
this.getContentPane().add(jLabel9);
this.getContentPane().add(jLabel10);
this.getContentPane().add(jLabel8);
this.getContentPane().add(jLabel6);
this.getContentPane().add(jLabel7);
this.getContentPane().add(jLabel11);
this.getContentPane().add(jLabel4);
this.getContentPane().add(jLabel12);
jButton1.setBounds(new Rectangle(192, 194, 75, 25));
jButton1.setText("录入");
}
JLabel jLabel1 = new JLabel();
JButton jButton1 = new JButton();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JTextField jTextField3 = new JTextField();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JTextField jTextField2 = new JTextField();
JButton jButton2 = new JButton();
JLabel jLabel6 = new JLabel();
JTextField jTextField1 = new JTextField();
JButton jButton3 = new JButton();
JTextField jTextField4 = new JTextField();
JLabel jLabel7 = new JLabel();
JLabel jLabel8 = new JLabel();
JLabel jLabel9 = new JLabel();
JTextField jTextField5 = new JTextField();
JLabel jLabel10 = new JLabel();
JLabel jLabel11 = new JLabel();
JLabel jLabel12 = new JLabel();
public void jButton2_actionPerformed(ActionEvent e) {
jTextField1.setText(null);
jTextField2.setText(null);
jTextField4.setText(null);
jTextField5.setText(null);
}
public void jButton3_actionPerformed(ActionEvent e) {
dispose();
}
public void jButton1_actionPerformed(ActionEvent e) {
String str1="",str2="",str3="",str4="",str5="";
String str7="",str8="",str9="",str10="";
DataBaseManager dbm = new DataBaseManager();
ResultSet rs;
if(jTextField1.getText().equals(""))
{JOptionPane.showMessageDialog(this,"还书者姓名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
else if(jTextField2.getText().equals(""))
{JOptionPane.showMessageDialog(this,"书名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
else if(jTextField5.getText().equals(""))
{JOptionPane.showMessageDialog(this,"ISBN号不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
else if(jTextField3.getText().equals(""))
{JOptionPane.showMessageDialog(this,"还入日期不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
else
{
str1=jTextField1.getText();
str2=jTextField2.getText();
try
{str5=jTextField5.getText();
int r=Integer.parseInt(str5);
str3=jTextField3.getText();
str4=jTextField4.getText();
str7="SELECT * FROM bookBrowse WHERE StudentName="+"'"+str1+"' AND BookName='"+str2+"' AND Is_Returned='否' AND ISBN='"+str5+"'";
str8="UPDATE bookBrowse SET ReturnDate="+"'"+str3+"',Com='"+str4+"', Is_Returned='是' WHERE StudentName="+"'"+str1+"' AND BookName='"+str2+"' AND Is_Returned='否' AND ISBN='"+str5+"'";
str9="UPDATE books SET Books_count=Books_count+1 WHERE BookName="+"'"+str2+"' AND ISBN='"+str5+"'";
try
{
rs=dbm.getResult(str7);
if(rs.next())
{
dbm.updateSql(str8);
dbm.updateSql(str9);
JOptionPane.showMessageDialog(this,"录入成功！","提示信息",JOptionPane.INFORMATION_MESSAGE);
dispose();
}
else
{JOptionPane.showMessageDialog(this,"用户名不存在，或者书名、ISBN错误，或书已经还了！","警告对话框",JOptionPane.WARNING_MESSAGE);
jTextField1.setText(null);
jTextField2.setText(null);
jTextField3.setText(null);
jTextField4.setText(null);
jTextField5.setText(null);
}
}
catch(SQLException e3){}
dbm.closeConnection();
}
catch(NumberFormatException e7)
{JOptionPane.showMessageDialog(this,"ISBN号只能由数字组成！","警告对话框",JOptionPane.WARNING_MESSAGE);
jTextField5.setText("");}
}
}
}
class Frame11_jButton1_actionAdapter implements ActionListener {
private Frame11 adaptee;
Frame11_jButton1_actionAdapter(Frame11 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class Frame11_jButton3_actionAdapter implements ActionListener {
private Frame11 adaptee;
Frame11_jButton3_actionAdapter(Frame11 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class Frame11_jButton2_actionAdapter implements ActionListener {
private Frame11 adaptee;
Frame11_jButton2_actionAdapter(Frame11 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -