Java源码社

基于java的Swing+MySQL理发店会员管理系统(java+swing+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

041323580309

051323580309

061323580309

071323580309

081323580309

091323580309

基于java的Swing+MySQL理发店会员管理系统(java+swing+mysql)

登录：
admin 123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34


public class ConsumeFrame extends JFrame {
	JPanel pane;
	DefaultTableModel dtm;
	JTable tbl;
	
	JRadioButton rbtnmphone;
	JRadioButton rbtnmname;
	JRadioButton rbtnmember;
	JRadioButton rbtnnotmember;
	
	JTextField txtmtop;
	JTextField txtmtopLayMoney;
	JLabel lblTopMoney;
	JButton btnmsearch;
	JScrollPane spane;
	
	JLabel lblserItem;
	JLabel lblAgio;
	JLabel lblSerEmployee;
	JLabel lblSerOprator;
	JTextField txtOperater;
	JLabel lblcode;
	JTextField txtcode;
	
	JCheckBox ckWash;
	JLabel lblWash;
	JTextField txtWash;
	
	JLabel lblFire;
	JCheckBox ckFire;
	JTextField txtFire;
	
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
	public  void fillTable3() {
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		for (int i = 0; i < listser.size(); i++) {
			Services ser = listser.get(i);
			dtm.addRow(new Object[] {ser.getSerid(),ser.getSername(),ser.getSermoney()});
		}
	}
	
	public  void fillTable4() {
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		for (int i = 0; i < listcon.size(); i++) {
			Consume con = listcon.get(i);
			dtm.addRow(new Object[] {con.getConid(),con.getConmphone(),con.getConemid(),
					con.getConserid(),con.getCondate(),con.getConagio(),con.getConmoney(),con.getConremark()});
		}
	}
	
	public  void fillTable5() {
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		for (int i = 0; i < listcon.size(); i++) {
			Consume con = listcon.get(i);
			dtm.addRow(new Object[] {con.getConid(),con.getConmphone(),con.getConemid(),
					con.getConserid(),con.getCondate(),con.getConagio(),con.getConmoney(),con.getConremark()});
		}
	}
	

	public void clearTable() {
		// 清空表格模型中的数据
		dtm.getDataVector().clear();
		// 通知所有相关控件表格模型中数据的变动(刷新)
		dtm.fireTableDataChanged();
	}

	// public static void main(String[] args) {
	// new QueryMFrame();
	// }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
				JOptionPane.showMessageDialog(null, "密码修改成功");
				ChangeMPassFrame.this.dispose();
				}
				else JOptionPane.showMessageDialog(null, "两次密码输入不一致,请重新输入！", "提示", JOptionPane.WARNING_MESSAGE);
			}
			else if(txtcmpass.getText().length() ==0){
				JOptionPane.showMessageDialog(null, "请输入原密码！", "提示", JOptionPane.WARNING_MESSAGE);
			}
			else if(!txtcmpass.getText().equals(m.getMpass())){
				JOptionPane.showMessageDialog(null, "密码输入错误,请重新输入原密码！", "提示", JOptionPane.WARNING_MESSAGE);
			}
		}
	});
}

//重置手机号码窗体设置
if(x == 2){	
	lblcmpassnew = new JLabel("新手机号码");	
	lblcmpassnew2 = new JLabel("确认手机号码");			
	btnChangePass = new JButton("修改手机号码");
	txtcmpassnewphone = new JTextField(); //	
	txtcmpassnewphone.setBounds(110, 100, 120, 25);
	txtcmpassnew2phone = new JTextField();//
	txtcmpassnew2phone.setBounds(110, 150, 120, 25);
	//验证密码
	btnSubmitPass.addActionListener(new ActionListener() {
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			if(txtcmpass.getText().equals(m.getMpass())){
				txtcmpass.setBackground(Color.white);
				JOptionPane.showMessageDialog(null, "原始密码验证通过");					
			}
			else if(!txtcmpass.getText().equals(m.getMpass())){
				txtcmpass.setBackground(new Color(255, 0, 0));
				JOptionPane.showMessageDialog(null, "原始密码输入错误,请重新输入！", "提示", JOptionPane.WARNING_MESSAGE);
			}
		}
	});
	
	btnChangePass.addActionListener(new ActionListener() {
		@Override
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
					em.setEmid(rs.getInt("emid"));
					em.setEmname(rs.getString("emname"));
					em.setEmsex(rs.getString("emsex"));
					em.setEmage(rs.getInt("emage"));
					em.setEmphone(rs.getString("emphone"));
					em.setEmtel(rs.getString("emtel"));
					em.setEmaddr(rs.getString("emaddr"));
					em.setEmbirth(rs.getDate("embirth"));
					em.setEmcard(rs.getString("emcard"));
					em.setEmindate(rs.getDate("emindate"));
					em.setEmjob(rs.getString("emjob"));
					list.add(em);
				}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			closeSelect();
		}
		return list;
	}
	
	//按照电话号码查询
	public static List selectManage(String emphone){
		String sql = "select * from tblEmployee where manage=?";
		List list = new ArrayList();
		list.add(emphone);
		rs = DBManage.selectMember(sql, list);
		List <Employee> listmember = new ArrayList<Employee>();
		try {
			while(rs.next()){
				Employee em = new Employee();
//				Member m = new Member(rs.getInt("mid"),rs.getString("mphone"),rs.getString("mname"),rs.getString("msex"),rs.getInt("mage"),rs.getDate("mbirth"),rs.getString("maddr"),rs.getDate("mindate"),rs.getInt("maddmoney"),rs.getInt("mintegral"));
				em.setEmid(rs.getInt("emid"));
				em.setEmname(rs.getString("emname"));
				em.setEmsex(rs.getString("emsex"));
				em.setEmage(rs.getInt("emage"));
				em.setEmphone(rs.getString("emphone"));
				em.setEmtel(rs.getString("emtel"));
				em.setEmaddr(rs.getString("emaddr"));
				em.setEmbirth(rs.getDate("embirth"));
				em.setEmcard(rs.getString("emcard"));
				em.setEmindate(rs.getDate("emindate"));
				em.setEmjob(rs.getString("emjob"));
				listmember.add(em);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
lblemtel.setFont(new Font("楷体", Font.BOLD, 14));
lblemtel.setBounds(40, 285, 70, 25);
txtemtel = new JTextField();
txtemtel.setBounds(100, 285, 120, 25);

//设为管理员
lblmanage.setText("管理账户名");
lblmanage.setFont(new Font("楷体", Font.BOLD, 14));
lblmanage.setBounds(40, 320, 70, 25);
lblmanage.setVisible(false);
txtmanage = new JTextField();
txtmanage.setBounds(100, 320, 120, 25);
txtmanage.setVisible(false);

lblmanagepass = new JLabel("管理密码");
lblmanagepass.setFont(new Font("楷体", Font.BOLD, 14));
lblmanagepass.setBounds(260, 320, 70, 25);
lblmanagepass.setVisible(false);
txtmanagepass = new JPasswordField();
txtmanagepass.setEchoChar('*');
txtmanagepass.setBounds(330, 320, 100, 25);
txtmanagepass.setVisible(false);

btnreg.setText("更新");
btnreg.setBounds(70, 360, 100, 30);

btnrturn.setText("返回");
btnrturn.setBounds(180, 360, 100, 30);
btnmanage = new JButton("修改管理");
btnmanage.setBounds(290, 360, 100, 30);

returnAct();	

btnmanage.addActionListener(new ActionListener() {
	@Override
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		
		if(JOptionPane.showInputDialog("请输入原密码:").equals(EmployeeDAO.selectByManageReturnPass(txtmanage.getText()))){
			txtmanage.setVisible(true);
			lblmanage.setVisible(true);
			lblmanagepass.setVisible(true);
			txtmanagepass.setVisible(true);
			btnmanage.setEnabled(false);
		}
		else JOptionPane.showMessageDialog(null, "密码输入错误无法,请重新输入");
	}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
}

//按照ID删除记录
public static void deleteByEmID(int emid){
	
	String sql = "delete from tblemployee where emid = ?";
	List list = new ArrayList();
	list.add(emid);
	DBManage.executeSql(sql, list);
}

//查询全部
public static List<Employee> selectAll(){
	String sql = "select * from tblEmployee";
	rs =DBManage.selectMember(sql, null);
	List<Employee> list = new ArrayList<Employee>();
	try {
			while(rs.next()){
				Employee em = new Employee();
				em.setEmid(rs.getInt("emid"));
				em.setEmname(rs.getString("emname"));
				em.setEmsex(rs.getString("emsex"));
				em.setEmage(rs.getInt("emage"));
				em.setEmphone(rs.getString("emphone"));
				em.setEmtel(rs.getString("emtel"));
				em.setEmaddr(rs.getString("emaddr"));
				em.setEmbirth(rs.getDate("embirth"));
				em.setEmcard(rs.getString("emcard"));
				em.setEmindate(rs.getDate("emindate"));
				em.setEmjob(rs.getString("emjob"));
				list.add(em);
			}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	finally{
		closeSelect();
	}
	return list;
}

//按照电话号码查询

项目链接：
https://javayms.github.io?id=031323580309201dg
https://javayms.pages.dev?id=031323580309201dg