?? returnbookfrm.java
字號:
import java.util.*;
import java.awt.*;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.Date;
class Returnbookfrm extends JFrame implements ActionListener
{
JLabel l_msg,l_user,l_bookname,l_data,l_beizhu;
JTextField t_user,t_bookname,t_data,t_beizhu;
JButton b_enter,b_clear,b_back;
JPanel pan1,pan2,pan3,pan4,pan5,pan6;
Date d;
NetConn sql;
Statement sqll;
Returnbookfrm()
{
l_msg =new JLabel("還書窗口 ");
l_user =new JLabel("還書者:");
l_bookname =new JLabel("書 名:");
l_data =new JLabel("日 期:");
l_beizhu =new JLabel("備 注:");
t_user =new JTextField("",12);
t_bookname =new JTextField("",12);
t_data =new JTextField("",12);
d=new Date();
t_data.setText(d.toLocaleString());
t_beizhu =new JTextField("",12);
b_enter =new JButton("確定");
b_clear =new JButton("清除");
b_back =new JButton("返回");
b_enter.addActionListener(this);
b_clear.addActionListener(this);
b_back.addActionListener(this);
pan1=new JPanel();pan2=new JPanel();pan3=new JPanel();pan4=new JPanel();pan5=new JPanel();pan6=new JPanel();
pan1.add(l_msg);pan2.add(l_user);pan2.add(t_user);pan3.add(l_bookname);pan3.add(t_bookname);
pan4.add(l_data);pan4.add(t_data);pan5.add(l_beizhu);pan5.add(t_beizhu);pan6.add(b_enter);pan6.add(b_clear);pan6.add(b_back);
setLayout(new GridLayout(6,1));
add(pan1);add(pan2);add(pan3);add(pan4);add(pan5);add(pan6);
setBounds(400,100,400,500);
sql=new NetConn();
}
public void actionPerformed(ActionEvent ed)
{
if(ed.getSource()==b_back)
{
if(ed.getSource()==b_back)
{
dispose();
}
}
else if(ed.getSource()==b_clear)
{
t_user.setText("");t_beizhu.setText("");t_bookname.setText("");
}
else if(ed.getSource()==b_enter)
{
try
{
sqll=sql.connect();
String a1="'"+t_data.getText()+"'";
String a2="'"+t_beizhu.getText()+"'";
String a3="'"+t_user.getText()+"'";
String a4="'"+t_bookname.getText()+"'";
String a5="'"+"y"+"'";
String temp="update bookbrowse set returndata ="+a1+", isreturn ="+a5+", beizhu ="+a2+" where studentname ="+a3;
sqll.executeUpdate(temp);
l_msg.setText("還書成功");
}
catch(SQLException eg)
{}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -