systemmanage.java

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

package book;

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

import javax.swing.ImageIcon;
import javax.swing.JCheckBox;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
//系统设置
public class SystemManage extends Mb {
	
	private JLabel icon;
	
    private ButtonIcon ok,quxiao,close;
    
    private JCheckBox statr,data;
    
    private boolean  boo,boo1;
    
    private ResultSet rs;
    
    private PreparedStatement pstmt = null;
	SystemManage(String s, int i, int j) {
		super(s, i, j);
		con.setLayout(null);
		getBool();
		shezhi();
		add();
	}

	void getBool(){
		try {
			MainDAO dao=new MainDAO();
			rs=dao.getSelect("select * from xitongshezhi");
			rs.next();
			boo=rs.getBoolean("启动显示");
			boo1=rs.getBoolean("关闭备份");
			rs.close();
			dao.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	void shezhi(){
		
		
		icon=new JLabel(new ImageIcon("./data/image/heard/xitongshezhi.jpg"));
		icon.setBounds(0,5,360,50);
		
		statr=new JCheckBox("启动的时候自动打开过期未还的借阅列表",boo);
		statr.setBounds(40,60,300,18);
		data=new JCheckBox("退出系统时自动备份数据库",boo1);
		data.setBounds(40,100,250,18);
		
		ok=new ButtonIcon("确定");
		ok.setBounds(40,140,70,25);
		ok.addActionListener(new ActionListener(){

			public void actionPerformed(ActionEvent arg0) {
				try {
					MainDAO dao=new MainDAO();
					String str = "update xitongshezhi set 启动显示=?,关闭备份=?";
					pstmt = dao.getPreparedStatement(str);
					pstmt.setBoolean(1,statr.isSelected());
					pstmt.setBoolean(2,data.isSelected());
					pstmt.executeUpdate();
					pstmt.close();
					dao.close();
					JOptionPane.showMessageDialog(statr,"修改成功!!!!!");
				} catch (SQLException e) {
					e.printStackTrace();
				}

				}	
		});
		
		quxiao=new ButtonIcon("取消");
		quxiao.setBounds(140,140,70,25);
		quxiao.addActionListener(new ActionListener(){

			public void actionPerformed(ActionEvent arg0) {
				try {
					statr.setSelected(boo);
					data.setSelected(boo1);
					MainDAO dao=new MainDAO();
					String str = "update xitongshezhi set 启动显示=?,关闭备份=?";
					pstmt = dao.getPreparedStatement(str);
					pstmt.setBoolean(1,boo);
					pstmt.setBoolean(2,boo1);
					pstmt.executeUpdate();
					pstmt.close();
					dao.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}

				}	
		});
		
		
		
		close=new ButtonIcon("关闭");
		close.setBounds(240,140,70,25);
		close.addActionListener(new ActionListener(){

			public void actionPerformed(ActionEvent arg0) {
				close();
			}
		});
	}
	
	void add(){
		con.add(icon);
		con.add(statr);
		con.add(data);
		con.add(ok);
		con.add(quxiao);
		con.add(close);
		
	}
}