📄 back_book.java
字号:
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.util.Date;
class Back_book extends Frame implements ActionListener
{
Label label1 = new Label("借阅者编号");
TextField textField1 = new TextField();
Label label2 = new Label("图书编号");
TextField textField2 = new TextField();
Label label4 = new Label("姓名");
TextField textField3 = new TextField();
Label label5 = new Label("书名");
TextField textField4 = new TextField();
Label label7 = new Label("年龄");
Label label8 = new Label("专业");
Label label9 = new Label("性别");
Label label10 = new Label("系别");
TextField textField5 = new TextField();
TextField textField6 = new TextField();
TextField textField7 = new TextField();
TextField textField8 = new TextField();
TextField textField9 = new TextField();
Label label11 = new Label("过期天数");
Label label12 = new Label("作者");
Label label13 = new Label("出版社");
Label label14 = new Label("数量");
Label label15 = new Label("价格");
Label label16 = new Label("罚款金额");
TextField textField10 = new TextField();
TextField textField11 = new TextField();
TextField textField12 = new TextField();
TextField textField13 = new TextField();
TextField textField14 = new TextField();
Button button1 = new Button("提交");
Button button2 = new Button("重置");
Connection conn;
Statement stmt;
ResultSet rs;
String strurl;
Date today=new Date();
Date last=new Date();
int d;
String day;
public Back_book() throws Exception
{
super("还书窗口");
setSize(500,450);
setLayout(null);
setBackground(new Color(0,100,255));
this.setLocation(200,200);
label1.setBounds (61, 309, 68, 22);
label2.setBounds(254, 311, 59, 22);
label4.setBounds( 62, 65, 60, 22);
label5.setBounds( 249, 69, 60, 16);
label7.setBounds( 62, 93, 60, 22);
label8.setBounds( 62, 149, 60, 22);
label9.setBounds( 62, 123, 60, 22);
label10.setBounds( 62, 175, 60, 22);
textField1.setBounds( 137, 305, 79, 24);
textField2.setBounds( 326, 303, 94, 26);
textField3.setBounds( 132, 63, 83, 23);
textField4.setBounds( 322, 61, 97, 24);
textField5.setBounds( 132, 90, 83, 23);
textField6.setBounds( 132, 118, 83, 23);
textField7.setBounds( 133, 145, 83, 23);
textField8.setBounds( 133, 169, 83, 23);
textField9.setBounds( 133, 197, 83, 23);
textField10.setBounds( 322, 87, 97, 24);
textField11.setBounds( 322, 112, 97, 24);
textField12.setBounds( 322, 139, 97, 24);
textField13.setBounds( 322, 167, 97, 24);
textField14.setBounds( 322, 198, 97, 24);
label11.setBounds( 62, 199, 60, 22);
label12.setBounds( 249, 96, 62, 16);
label13.setBounds( 249, 120, 59, 16);
label14.setBounds( 249, 145, 59, 16);
label15.setBounds( 249, 173, 63, 16);
label16.setBounds( 249, 205, 59, 16);
button1.setBounds( 116, 367, 85, 26);
button1.addActionListener(this);
button2.setBounds( 306, 368, 83, 24);
button2.addActionListener(this);
add(label1);
add(label2);
add(label11);
add(label4);
add(label7);
add(label9);
add(label8);
add(label10);
add(textField9);
add(textField3);
add(textField5);
add(textField6);
add(textField7);
add(textField8);
add(label16);
add(label5);
add(label12);
add(label13);
add(label14);
add(label15);
add(textField13);
add(textField4);
add(textField10);
add(textField11);
add(textField12);
add(textField14);
add(textField1);
add(textField2);
add(button1);
add(button2);
strurl ="jdbc:odbc:book";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(strurl);
stmt = conn.createStatement();
setVisible(true);
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){
dispose();
setVisible(false);
}
});
}
public void actionPerformed(ActionEvent e)
{
String str=e.getActionCommand();
String str1;
int s;
s=0;
if (str.equals("提交"))
{
if(textField1.getText().equals(""))
{
JOptionPane.showMessageDialog(null, "不能为空", "提示",
JOptionPane.WARNING_MESSAGE);
}
else
{
try
{
rs = stmt.executeQuery("SELECT * FROM add_people where id='"+textField1.getText()+"'");
if(rs.next())
{
textField3.setText(rs.getString("name"));
textField5.setText(rs.getString("age"));
textField6.setText(rs.getString("sex"));
textField7.setText(rs.getString("z_ye"));
textField8.setText(rs.getString("x_bie"));
}
rs = stmt.executeQuery("SELECT * FROM add_book where idd='"+textField2.getText()+"'");
if(rs.next())
{
textField4.setText(rs.getString("bookname"));
textField10.setText(rs.getString("author"));
textField11.setText(rs.getString("push_c"));
textField12.setText(rs.getString("shuliang"));
textField13.setText(rs.getString("jiage"));
}
rs = stmt.executeQuery("select * FROM Loan_book where id='" + textField1.getText() +"' and idd='"+textField2.getText()+"'");
if(rs.next())
{
day=rs.getString("loan_time");
long n=Date.parse(day);
day = today.toString();
long m= Date.parse(day);
double fakuan;
String JinE;
m=m-n;
m=m / 86400000;
if (m>=7){
m=m-7;
day=String.valueOf(m);
textField9.setText(day);
fakuan=Double.longBitsToDouble(m);
fakuan=m* 0.05;
day=String.valueOf(fakuan);
JinE=String.valueOf(fakuan);
textField14.setText(JinE);
}
JOptionPane.showMessageDialog(null, "点确定将还书", "警告",
JOptionPane.WARNING_MESSAGE);
rs = stmt.executeQuery("select * from add_book where idd ='"+textField2.getText()+"'" );
if(rs.next()){
s=rs.getInt("shuliang");
s=s+1;
stmt.execute(
"update add_book set shuliang='"+s+"' where idd='"+textField2.getText()+"'");
}
stmt.execute("DELETE * FROM Loan_book where id='" + textField1.getText() +"' and idd='"+textField2.getText()+"'");
}
else{
JOptionPane.showMessageDialog(null, "这位读者没有借书", "提示",
JOptionPane.WARNING_MESSAGE);
}
}
catch (Exception eg) {
JOptionPane.showMessageDialog(null, "操作错误", "提示",
JOptionPane.WARNING_MESSAGE);
eg.printStackTrace();
}
}
textField1.setText("");
textField2.setText("");
textField5.setText("");
textField3.setText("");
textField4.setText("");
textField6.setText("");
textField7.setText("");
textField8.setText("");
textField9.setText("");
textField9.setText("");
textField10.setText("");
textField11.setText("");
textField12.setText("");
textField13.setText("");
textField14.setText("");
}
if(str.equals("重置"))
{
textField1.setText("");
textField2.setText("");
textField5.setText("");
textField4.setText("");
textField3.setText("");
textField6.setText("");
textField7.setText("");
textField8.setText("");
textField9.setText("");
textField9.setText("");
textField10.setText("");
textField11.setText("");
textField12.setText("");
textField13.setText("");
textField14.setText("");
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -