?? huanshuframe.java
字號:
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.util.Date;
class HuanShuFrame 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 HuanShuFrame() throws Exception
{
super("還書窗口");
setSize(500,450);
setLayout(null);
setBackground(new Color(110,200,150));
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:Library";
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 LLZB where 借閱者編號='"+textField1.getText()+"'");
if(rs.next())
{
textField3.setText(rs.getString("姓名"));
textField5.setText(rs.getString("年齡"));
textField6.setText(rs.getString("性別"));
textField7.setText(rs.getString("專業"));
textField8.setText(rs.getString("系別"));
}
rs = stmt.executeQuery("SELECT * FROM TSB where 圖書編號='"+textField2.getText()+"'");
if(rs.next())
{
textField4.setText(rs.getString("書名"));
textField10.setText(rs.getString("作者"));
textField11.setText(rs.getString("出版社"));
textField12.setText(rs.getString("數量"));
textField13.setText(rs.getString("價格"));
}
rs = stmt.executeQuery("select * FROM JHB where 借閱者編號='" + textField1.getText() +"' and 圖書編號='"+textField2.getText()+"'");
if(rs.next())
{
day=rs.getString("借書日期");
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 TSB where 圖書編號 ='"+textField2.getText()+"'" );
if(rs.next()){
s=rs.getInt("數量");
s=s+1;
stmt.execute(
"update TSB set 數量='"+s+"' where 圖書編號='"+textField2.getText()+"'");
}
stmt.execute("DELETE * FROM JHB where 借閱者編號='" + textField1.getText() +"' and 圖書編號='"+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 + -