latefeemanage.java

简单的书店管理系统,是课设期间教师指导完成的,希望会对大家有帮助!

package book;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;

public class LateFeeManage extends Mb {
	
	private JLabel picer;
	private ButtonIcon ok,close;
	private PreparedStatement pstmt = null;
	private JTextField text;
	LateFeeManage(String s, int i, int j) throws SQLException {
		super(s, i, j);
		con.setLayout(null);
		shezhi();
		add();
	}
	
	void shezhi(){
		picer=new JLabel("请输入日滞纳金金额");
		picer.setBounds(90,20,200,18);
		
		text=new JTextField();
		text.setBounds(90,50,120,18);
		
		ok=new ButtonIcon("确定");
		ok.setBounds(70,80,70,25);
		ok.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				
				try {
					MainDAO dao = new MainDAO();
					String str = "update zhinajin set 日滞纳金=?";
					pstmt = dao.getPreparedStatement(str);
					pstmt.setFloat(1,Float.parseFloat(text.getText()));
					pstmt.executeUpdate();
					pstmt.close();
					dao.close();
					
					JOptionPane.showMessageDialog(text, "日滞纳金修改成功，现在日滞纳金为"+text.getText()+"/天");
				} catch (SQLException e1) {
					e1.printStackTrace();
				}
				
	          
			}
		});
		
		close=new ButtonIcon("关闭");
		close.setBounds(160,80,70,25);
		close.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
	         close(); 
			}
		});
		
	}
	
	void Judge(){
		
	}
	
	void add(){
		
		con.add(picer);
		con.add(text);
		con.add(ok);
		con.add(close);
		
	}
}