package service;

import dao.ConfigDAO;
import entity.Config;

public class ConfigService {
	public static final String budget = "budget";
	public static final String mysqlPath = "mysqlPath";
	public static final String default_budget = "500";

	static ConfigDAO dao= new ConfigDAO();
	static{
		init();
	}

	public static void init(){
		init(budget, default_budget);
		init(mysqlPath, "");
	}
	
	private static void init(String key, String value) {
		
		Config config= dao.getByKey(key);
		if(config==null){
			Config c = new Config();
			c.setKey(key);
			c.setValue(value);
			dao.add(c);
		}
	}

	public String get(String key) {
		Config config= dao.getByKey(key);
		return config.getValue();
	}
	
	public void update(String key, String value){
		Config config= dao.getByKey(key);
		config.setValue(value);
		dao.update(config);		
	}
	
	public int getIntBudget() {
		return Integer.parseInt(get(budget));
	}
	
}

package gui.listener;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;
import java.io.File;

import javax.swing.JOptionPane;

import gui.panel.ConfigPanel;
import service.ConfigService;
import util.GUIUtil;

public class ConfigListener implements ActionListener{

	@Override
	public void actionPerformed(ActionEvent e) {
		ConfigPanel p = ConfigPanel.instance;
		if(!GUIUtil.checkNumber(p.tfBudget, "本月预算"))
			return;
		String mysqlPath =p.tfMysqlPath.getText();
		if(0!=mysqlPath.length()){
			File commandFile = new File(mysqlPath,"bin/mysql.exe");
			if(!commandFile.exists()){
				JOptionPane.showMessageDialog(p, "Mysql路径不正确");
				p.tfMysqlPath.grabFocus();
				return;
			}
		}
		
		ConfigService cs= new ConfigService();
		cs.update(ConfigService.budget,p.tfBudget.getText());
		cs.update(ConfigService.mysqlPath,mysqlPath);
		
		JOptionPane.showMessageDialog(p, "设置修改成功");

	}

}

package gui.panel;

import java.awt.BorderLayout;
import java.awt.GridLayout;

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

import gui.listener.ConfigListener;
import util.ColorUtil;
import util.GUIUtil;

public class ConfigPanel extends JPanel {
	static {
		GUIUtil.useLNF();
	}

	public static ConfigPanel instance = new ConfigPanel();

	JLabel lBudget = new JLabel("本月预算(￥)");
	public JTextField tfBudget = new JTextField("0");

	JLabel lMysql = new JLabel("Mysql安装目录");
	public JTextField tfMysqlPath = new JTextField("");

	JButton bSubmit = new JButton("更新");

	public ConfigPanel() {
		GUIUtil.setColor(ColorUtil.grayColor, lBudget, lMysql);
		GUIUtil.setColor(ColorUtil.blueColor, bSubmit);

		JPanel pInput = new JPanel();
		JPanel pSubmit = new JPanel();
		int gap = 40;
		pInput.setLayout(new GridLayout(4, 1, gap, gap));

		pInput.add(lBudget);
		pInput.add(tfBudget);
		pInput.add(lMysql);
		pInput.add(tfMysqlPath);

		pSubmit.add(bSubmit);

		this.setLayout(new BorderLayout());
		this.add(pInput, BorderLayout.NORTH);
		this.add(pSubmit, BorderLayout.CENTER);
		
		addListener();
	}

	public static void main(String[] args) {
		GUIUtil.showPanel(ConfigPanel.instance);
	}
	
	public void addListener() {
		ConfigListener l =new ConfigListener();
		bSubmit.addActionListener(l);
	}
	
}