fajinsetup.java

JAVA编写的图书馆管理系统

//罚金设置
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.event.*;
import java.sql.*;
import java.io.*;
import java.util.*;

public class FajinSetup extends JFrame implements ActionListener
{   private JLabel MoneyLabel,ViewLabel,DayLabel;
	private JTextField MoneyTextField;
	private JRadioButton YesBtn,NoBtn;
	private ButtonGroup choice;
	private JButton ModifyBtn,CancelBtn;
    private JPanel panel;
	private JFrame frame;
	private PreparedStatement pstmt;
	private Connection con;
    private Statement stmt;
    private String yesORno;
	public FajinSetup()
	{   JFrame.setDefaultLookAndFeelDecorated(true);
	    frame=new JFrame("罚金设置");
	    Font font1=new Font("宋体",Font.PLAIN,13);
	    Container content=frame.getContentPane();
	    content.setLayout(null);
	    ImageIcon icon=new ImageIcon("images/home.gif");
	    frame.setIconImage(icon.getImage());
        frame.setResizable(false);

        //--初始化各个组件--
		MoneyLabel=new JLabel("超期罚款金额:");
		DayLabel=new JLabel("元/天");
		ViewLabel=new JLabel("自动显示到/超期信息:");

        choice=new ButtonGroup();
        YesBtn=new JRadioButton("是");
        YesBtn.setSelected(true);
        choice.add(YesBtn);
        NoBtn=new JRadioButton("否");
        choice.add(NoBtn);

		MoneyTextField=new JTextField();

		ModifyBtn=new JButton("提 交");
		CancelBtn=new JButton("取 消");

		//--设置各个组件的事件--
        ModifyBtn.addActionListener(this);
		CancelBtn.addActionListener(this);
		YesBtn.addActionListener(this);
		NoBtn.addActionListener(this);

        //--设置各个组件的大小和位置--
        MoneyLabel.setBounds(10,15,100,25);
        MoneyTextField.setBounds(120,15,100,25);
        DayLabel.setBounds(225,15,50,25);
        ViewLabel.setBounds(10,50,140,25);
        YesBtn.setBounds(160,50,40,25);
		NoBtn.setBounds(215,50,40,25);
        ModifyBtn.setBounds(40,90,80,25);
        CancelBtn.setBounds(160,90,80,25);

        //--设置各个组件的字体--
        MoneyLabel.setFont(font1);
        MoneyTextField.setFont(font1);
		DayLabel.setFont(font1);
	    ViewLabel.setFont(font1);
	    YesBtn.setFont(font1);
		NoBtn.setFont(font1);
		ModifyBtn.setFont(font1);
		CancelBtn.setFont(font1);

        //--添加各个组件--
        panel=new JPanel();
        panel.setLayout(null);
        panel.setBorder(
			 	 		 BorderFactory.createCompoundBorder(
			 	 		 BorderFactory.createEtchedBorder(),
	                     BorderFactory.createLoweredBevelBorder()));
	    panel.setBounds(10,10,280,130);
		panel.add(MoneyLabel);
		panel.add(MoneyTextField);
		panel.add(DayLabel);
	    panel.add(ViewLabel);
	    panel.add(YesBtn);
	    panel.add(NoBtn);
		panel.add( ModifyBtn);
		panel.add(CancelBtn);
		content.add(panel);

        //--初始化窗体--
		frame.pack();
		frame.setLocationRelativeTo(null);
		frame.setBounds(400,150,305,180);
		frame.setVisible(true);
	}

	/**public void itemStateChanged(ItemEvent eg)
	{
	  if(eg.getItemSelectable()==YesBtn)
	  {yesORno="是";}
	  if(eg.getItemSelectable()==NoBtn)
	  {yesORno="否";}
	 }**/

	public void actionPerformed(ActionEvent e)
	{  Object obj=e.getSource();
	  if(YesBtn.isSelected())
	  {yesORno="是";}
	  if(NoBtn.isSelected())
	  {yesORno="否";}
	  if(obj==CancelBtn)
	    { int m=JOptionPane.showConfirmDialog(this, "您确定要放弃设置超期罚金吗？", "确认对话框",JOptionPane.YES_NO_OPTION);
		  if(m==JOptionPane.YES_OPTION)
		  {frame.dispose();}
        }
	  if(obj== ModifyBtn)
	    { try{ Update();}
	      catch(SQLException ed){}
         }
	}

    public void Update() throws SQLException
    { String fajin=MoneyTextField.getText().trim();
      String bianhao="1";
      float fajin1;
      fajin1=Float.valueOf(fajin).floatValue();
      String strurl =
	  	             "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
	  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	  catch (ClassNotFoundException e) {}
	  con= DriverManager.getConnection(strurl);
	  Statement stmt = con.createStatement();
	  if (fajin.equals(""))
	  	 JOptionPane.showMessageDialog(null, "请输入超期罚款金额！", "警告",JOptionPane.WARNING_MESSAGE);
	  else
	  	 { ResultSet rs = stmt.executeQuery("select * from 罚金设置 ");
	  	   stmt.executeUpdate("update 罚金设置 set 每日罚金='"+fajin1+"',是否自动显示='"+yesORno+"'where 编号='" + bianhao + "'");
		   JOptionPane.showMessageDialog(null, "罚款金额设置成功!");
		  }

	}

	public static void main(String[]args)
		{   try {
	            UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
	            }
	        catch(Exception e) {
	            e.printStackTrace();
	           }
			new FajinSetup();
	}
}