JavaSwing / C# 自助洗衣系统

说明

此系统同时支持mysql，sqlserver,有javaswing窗体和C#窗体两套代码

数据库文件

自助洗衣系统

数据库设计

关系模型

管理员(主键,用户名,密码,姓名,电话)

用户(主键,用户名,密码,名称,性别,电话,身份证)

订单(主键,用户,洗衣模式,水量,开始时间,订单状态,价格)

故障报警(主键,洗衣机编号,故障描述,创建时间)

数据字典

管理员表

用户表

订单表

故障报警表

部分代码

package com.codeying.frame;import com.codeying.dao.EmployeeDao;
import com.codeying.entity.Employee;import com.codeying.dao.DepartmentDao;
import com.codeying.entity.Department;import com.codeying.utils.JdbcUtils;
import com.codeying.utils.Utils;
import com.mysql.jdbc.StringUtils;import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.net.URL;public class MyInfoEmployee extends JInternalFrame {private JPanel jContentPane;private JLabel label_role = new JLabel("角色");private JTextField tb_role = new JTextField();private JLabel label_username = new JLabel("用户名");private JTextField tb_username= new JTextField();private JLabel label_name = new JLabel("姓名");private JTextField tb_name= new JTextField();private JLabel label_gender = new JLabel("性别");private JComboBox tb_gender = new JComboBox();private JLabel label_department = new JLabel("部门");private JComboBox tb_department = new JComboBox();private JLabel label_birth = new JLabel("出生日期");private JTextField tb_birth= new JTextField();private JLabel label_minzu = new JLabel("名族");private JTextField tb_minzu= new JTextField();private JLabel label_socialposition = new JLabel("政治面貌");private JTextField tb_socialposition= new JTextField();private JLabel label_xueli = new JLabel("学历");private JComboBox tb_xueli = new JComboBox();private JLabel label_position = new JLabel("职位");private JTextField tb_position= new JTextField();private JLabel label_stauts = new JLabel("在职状态");private JComboBox tb_stauts = new JComboBox();private JButton btn = new JButton("保存");private URL imgURL ;private BtnListener btnListener;public MyInfoEmployee (){init();}/*** 监听类*/public class BtnListener implements ActionListener {public void actionPerformed(ActionEvent e) {Employee t = Login.employee;                                                                                                                                                  //不可为空字段if (StringUtils.isNullOrEmpty(tb_name .getText().trim())){JOptionPane.showMessageDialog(null, "姓名 不可为空");return;}if(FormEmployeeAdd .illegalAdd( Login.employee .getId(),"username",tb_username .getText().trim())){JOptionPane.showMessageDialog(null, "用户名 : 已存在！");return;}t.setUsername (tb_username .getText().trim());t.setName (tb_name .getText().trim());t.setGender ((String)(tb_gender .getSelectedItem()));//下拉框t.setDepartmentId (getByIndexDepartmentId (tb_department .getSelectedIndex()));//外键t.setBirth (tb_birth .getText().trim());t.setMinzu (tb_minzu .getText().trim());t.setSocialposition (tb_socialposition .getText().trim());t.setXueli ((String)(tb_xueli .getSelectedItem()));//下拉框t.setPosition (tb_position .getText().trim());t.setStauts ((String)(tb_stauts .getSelectedItem()));//下拉框//提交EmployeeDao dao = EmployeeDao.me();int res = dao.updateById(t);if(res==1){Login.employee = t;JOptionPane.showMessageDialog(null, "更新成功！");}else{JOptionPane.showMessageDialog(null, "更新失败");}}}/*** 初始化界面*/public void init(){//设置下拉框\外键tb_gender .addItem("");tb_gender .addItem("男");tb_gender .addItem("女");setDepartmentId(tb_department);tb_xueli .addItem("");tb_xueli .addItem("本科");tb_xueli .addItem("硕士");tb_xueli .addItem("博士");tb_xueli .addItem("大专");tb_xueli .addItem("其他");tb_stauts .addItem("");tb_stauts .addItem("在职");tb_stauts .addItem("离职");tb_stauts .addItem("退休");tb_stauts .addItem("实习");//设置主窗体this.setSize(296, 350);this.setTitle("个人中心");//窗体名this.setResizable(true);this.setClosable(true);this.setMaximizable(true);this.setIconifiable(true);int x = 29,y = 0;label_username.setBounds(new Rectangle(x, y, 71, 19));tb_username.setBounds(new Rectangle(x+90, y, 124, 23));tb_username.setText(Login.employee .getUsername());tb_username.setEditable(false);y+=30;label_role.setBounds(new Rectangle(x, y, 71, 19));tb_role.setBounds(new Rectangle(x+90, y, 124, 23));tb_role.setText(Login.employee .getRole());tb_role.setEditable(false);y+=30;//TODO 其他属性label_name .setBounds(new Rectangle(x, y, 71, 19));tb_name .setBounds(new Rectangle(x+90, y, 124, 23));tb_name .setText(Login.employee . getName ());y+=30;label_gender .setBounds(new Rectangle(x, y, 71, 19));tb_gender .setBounds(new Rectangle(x+90, y, 124, 23));tb_gender .setSelectedItem(Login.employee .getGender ());y+=30;label_department .setBounds(new Rectangle(x, y, 71, 19));tb_department .setBounds(new Rectangle(x+90, y, 124, 23));tb_department .setSelectedItem( getActiveDepartmentId (Login. employee .getDepartmentId ()) );y+=30;label_birth .setBounds(new Rectangle(x, y, 71, 19));tb_birth .setBounds(new Rectangle(x+90, y, 124, 23));tb_birth .setText(Login.employee . getBirth ());y+=30;label_minzu .setBounds(new Rectangle(x, y, 71, 19));tb_minzu .setBounds(new Rectangle(x+90, y, 124, 23));tb_minzu .setText(Login.employee . getMinzu ());y+=30;label_socialposition .setBounds(new Rectangle(x, y, 71, 19));tb_socialposition .setBounds(new Rectangle(x+90, y, 124, 23));tb_socialposition .setText(Login.employee . getSocialposition ());y+=30;label_xueli .setBounds(new Rectangle(x, y, 71, 19));tb_xueli .setBounds(new Rectangle(x+90, y, 124, 23));tb_xueli .setSelectedItem(Login.employee .getXueli ());y+=30;label_position .setBounds(new Rectangle(x, y, 71, 19));tb_position .setBounds(new Rectangle(x+90, y, 124, 23));tb_position .setText(Login.employee . getPosition ());y+=30;label_stauts .setBounds(new Rectangle(x, y, 71, 19));tb_stauts .setBounds(new Rectangle(x+90, y, 124, 23));tb_stauts .setSelectedItem(Login.employee .getStauts ());y+=30;btn.setBounds(new Rectangle(130, y, 100, 26));getRootPane().setDefaultButton(btn);// 设置回车键jContentPane = new JPanel();// 新建jPanel面板jContentPane.setLayout(null);jContentPane.setBackground(new Color(255, 255, 255));setContentPane(jContentPane);jContentPane.add(label_username);jContentPane.add(tb_username);jContentPane.add(label_role);jContentPane.add(tb_role);//TODOjContentPane.add(label_name);jContentPane.add(tb_name);jContentPane.add(label_gender);jContentPane.add(tb_gender);jContentPane.add(label_department);jContentPane.add(tb_department);jContentPane.add(label_birth);jContentPane.add(tb_birth);jContentPane.add(label_minzu);jContentPane.add(tb_minzu);jContentPane.add(label_socialposition);jContentPane.add(tb_socialposition);jContentPane.add(label_xueli);jContentPane.add(tb_xueli);jContentPane.add(label_position);jContentPane.add(tb_position);jContentPane.add(label_stauts);jContentPane.add(tb_stauts);jContentPane.add(btn);btnListener = new BtnListener();btn.addActionListener(btnListener);}//存储外键数据 tb_departmentprivate java.util.List<Department> listDepartmentId;private void setDepartmentId (JComboBox comboBox){DepartmentDao dao = DepartmentDao.me();listDepartmentId = dao.list();comboBox.addItem("");for (Department i:listDepartmentId){comboBox.addItem(i.getName ());//对应外键字段}}//获取idprivate String getByIndexDepartmentId (int index){index = index-1;if(index<0 || index>=listDepartmentId .size()){return "";}return listDepartmentId .get(index).getId();}//回显时private String getActiveDepartmentId (String id){for (Department i:listDepartmentId){if(i.getId().equals(id)){return i.getName ();//对应外键字段}}return "请选择";}}

系统截图