modifyborrowinfo.java

基于目前许多中小型公司, 机关,中小学校,大学院系等都有自己的图书库, 供内部人员借阅。传统的手工登记办法

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package libsystem;

import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

/**
 *
 * @author admin
 */
public class ModifyBorrowInfo extends JFrame{
    private JPanel panel;
    private JLabel lborrowid=new JLabel("借阅号:");
    private JLabel lbookid=new JLabel("书    号:");
    private JLabel lreaderid=new JLabel("学    号:");
    private JLabel lisout=new JLabel("借    出:");
    private JLabel lborrowdata=new JLabel("借出日期:");
    private JLabel lisreturn=new JLabel("归    还:");
    private JLabel lreturndata=new JLabel("归还日期:");
    private JLabel tips=new JLabel("请输入书号进行查询");
    
    private JTextField borrowid=new JTextField();
    private JTextField bookid=new JTextField();
    private JTextField readerid=new JTextField();
    private JTextField borrowdate=new JTextField();
    private JTextField returndate=new JTextField();
    private JComboBox isreturn = new JComboBox();
    private JComboBox isout=new JComboBox();
    private JButton submit = new JButton("修改");
    private JButton searchbut = new JButton("查询");
    public ModifyBorrowInfo(){
        	super("修改借阅信息");
                this.setBounds(320,160,400,350);
                panel =new JPanel(null);
                panel.setBackground(Color.black);
                add(panel);
                InitComponent();
                super.setVisible(true);

    }

    private void InitComponent() {
        lborrowid.setForeground(Color.white);
        lborrowid.setBounds(30, 11, 51, 33);
        lbookid.setForeground(Color.white);
        lbookid.setBounds(30, 55, 51, 33);
        lreaderid.setForeground(Color.white);
        lreaderid.setBounds(30, 99, 51, 33);
        lisout.setForeground(Color.white);
        lisout.setBounds(30, 143, 51, 33);
        lborrowdata.setBounds(170, 143, 61, 33);
        lborrowdata.setForeground(Color.white);
        lisreturn.setForeground(Color.white);
        lisreturn.setBounds(30, 187, 61, 33);
        lreturndata.setForeground(Color.white);
        lreturndata.setBounds(170, 187, 61, 33);
        searchbut.setBounds(100, 251, 89, 22);
        searchbut.addActionListener(new Search());
        submit.setBounds(200, 251, 89, 22);
        submit.addActionListener(new ActionListener(){
            public void actionPerformed(ActionEvent e) {
                    try {
                        String SQL = "update  Borrow set 借出='"+isout.getSelectedItem()+"',"+"借出日期='"+borrowdate.getText()+"',"
                                +"归还='"+isreturn.getSelectedItem()+"',"+"归还日期='"+returndate.getText()
                                +"' where 书号='"+bookid.getText()+"';";
                        ConnDataBase.getConnection().createStatement().executeUpdate(SQL);
                        JOptionPane.showMessageDialog(null, "修改信息成功!");
                        dispose();
                    } catch (SQLException ex) {
                        JOptionPane.showMessageDialog(null, "修改信息失败", "警告",JOptionPane.WARNING_MESSAGE);
        		return;
                    }
                }              
            });

        submit.setVisible(true);
        searchbut.setVisible(true);
        borrowid.setEditable(false);
        //borrowid.setText( getCurrDate(2)+(int)(Math.random()*9999));
        borrowid.setBounds(85, 11, 91, 25);
        //readerid.setText("");
        readerid.setBounds(85, 99, 71, 25);
        readerid.setEditable(false);
        bookid.setBounds(85, 55, 71, 25);
	isout.setBounds(85, 143, 50, 25);
	isout.addItem("否");
	isout.addItem("是");
        isout.addItemListener(new ItemListener(){
            public void itemStateChanged(ItemEvent e) {
                if(e.getItem().equals("是"))borrowdate.setText(getCurrDate(1));
                if(e.getItem().equals("否"))borrowdate.setText("");
            }
        });
	isout.setForeground(Color.black);
	isout.setBackground(Color.white);
        isreturn.setBounds(85, 187, 50, 25);
	isreturn.addItem("否");
	isreturn.addItem("是");
        isreturn.addItemListener(new ItemListener(){
            public void itemStateChanged(ItemEvent e) {
                if(e.getItem().equals("是"))returndate.setText(getCurrDate(1));
                if(e.getItem().equals("否"))returndate.setText("");
            } 
        });
	isreturn.setForeground(Color.black);
	isreturn.setBackground(Color.white);
        borrowdate.setText("");
        borrowdate.setBounds(232, 143, 100, 25);
        borrowdate.setEditable(false);
        returndate.setText("");
        returndate.setBounds(232, 187, 100, 25);
        returndate.setEditable(false);
        tips.setBounds(120, 280, 150, 40);
        panel.add(tips);
        panel.add(returndate);
        panel.add(borrowdate);
        panel.add(isreturn);
        panel.add(isout);
        panel.add(bookid);
        panel.add(borrowid);
        panel.add(readerid);
        panel.add(submit);
        panel.add(searchbut);
        panel.add(lreturndata);
        panel.add(lisreturn);
        panel.add(lborrowdata);
        panel.add(lisout);
        panel.add(lreaderid);
        panel.add(lbookid);
        panel.add(lborrowid);
    }
    private String getCurrDate(int type){
        Date d=new Date();
        SimpleDateFormat sdf;
        if(type==1) sdf=new SimpleDateFormat("yyyy-MM-dd");
        else if(type==2)sdf=new SimpleDateFormat("MMdd");
        else sdf=new SimpleDateFormat("yyyy-MM-dd");
        return sdf.format(d);
    }

class Search implements ActionListener {

        public void actionPerformed(ActionEvent e) {
            String value=bookid.getText();
            if(!value.equals("")){
            String SQL="select * from Borrow where 书号='"+value+"'";
            try {
                ResultSet rs = ConnDataBase.getConnection().createStatement().executeQuery(SQL);
                if(rs.next()){
                    borrowid.setText(rs.getString("借阅号"));
                    readerid.setText(rs.getString("学号"));
                    String outs=rs.getString("借出");
                    isout.setSelectedItem(outs);
                    if(outs.equals("否"))
                        borrowdate.setText("");
                    else
                        borrowdate.setText(rs.getString("借出日期").substring(0, 10));
                    String returns=rs.getString("归还");
                    isreturn.setSelectedItem(returns);
                    if(returns.equals("否"))
                        returndate.setText("");
                    else
                        returndate.setText(rs.getString("归还日期").substring(0, 10));
                }else JOptionPane.showMessageDialog(null, "查无此号", "警告",JOptionPane.WARNING_MESSAGE);
                } catch (SQLException ex) {
                JOptionPane.showMessageDialog(null, "请输入正确的书号进行查询", "警告",JOptionPane.WARNING_MESSAGE);
                ex.printStackTrace();
                return;
                }
            }
            else{
                JOptionPane.showMessageDialog(null, "请输入书号进行查询", "警告",JOptionPane.WARNING_MESSAGE);
                return;
            }
        }
    
}
}