基于java+mysql的swing+mysql理发店会员管理系统(java+swing+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于java+mysql的Swing+MySQL理发店会员管理系统(java+swing+mysql)
登录:
admin 123456
e.printStackTrace();
}
return rs;
}
//关闭释放资源
public static void closeAll() {
if (ps != null) {
try {
ps.close();
ps = null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (con != null) {
try {
con.close();
con = null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public class Consume {
public int getConid() {
return conid;
}
public void setConid(int conid) {
this.conid = conid;
}
public String getConmphone() {
return conmphone;
lblAgio.setBounds(280, 280, 50, 20);
String [] agio = {"95","90","85","80","75","70","65","60","55","50"};
cboConAgio = new JComboBox(agio);
cboConAgio.setBounds(280, 312, 50, 20);
List <Employee> listem = EmployeeDAO.selectAll();
Vector <String> vec = new Vector<String>();
for (int i = 0; i < listem.size(); i++) {
Employee em = listem.get(i);
vec.add(em.getEmname());
}
lblSerEmployee = new JLabel("理发员");
lblSerEmployee.setBounds(340, 280, 70, 20);
lblSerEmployee.setFont(new Font("楷体", Font.PLAIN, 14));
lblSerEmployee.setForeground(Color.blue);
cboEmployee = new JComboBox(vec);
cboEmployee.setBounds(340, 312, 70, 20);
lblSerOprator = new JLabel("操作员");
lblSerOprator.setFont(new Font("楷体", Font.PLAIN, 14));
lblSerOprator.setForeground(Color.blue);
lblSerOprator.setBounds(420, 280, 70, 20);
txtOperater = new JTextField("001");
txtOperater.setBounds(420, 312, 70, 20);
lblcode = new JLabel("累计积分");
lblcode.setFont(new Font("楷体", Font.PLAIN, 14));
lblcode.setForeground(Color.blue);
lblcode.setBounds(500, 280, 60, 20);
txtcode = new JTextField();
txtcode.setBounds(500, 312, 50, 20);
txtcode.setEditable(false);
lblTopMoney = new JLabel("金额总计");
lblTopMoney.setBounds(570, 280, 80, 20);
lblTopMoney.setFont(new Font("楷体", Font.BOLD, 14));
lblTopMoney.setForeground(Color.red);
txtTotolMoney = new JTextField();
txtTotolMoney.setBounds(560, 312, 125, 45);
txtTotolMoney.setFont(new Font("楷体", Font.BOLD, 43));
txtTotolMoney.setForeground(new Color(70, 200, 70));
txtTotolMoney.setEditable(false);
lblremark = new JLabel("备注");
lblremark.setBounds(340, 350, 60, 20);
lblremark.setFont(new Font("楷体", Font.PLAIN, 14));
lblremark.setForeground(Color.blue);
txtremark = new JTextArea();
txtremark.setBounds(340, 372, 180, 70);
this.setBounds(390, 150,375, 270);
this.setResizable(false);
pane = new JPanel();
pane.setLayout(null);
lblcmpass = new JLabel("原密码");
lblcmpass.setBounds(30, 50, 70, 25);
txtcmpass = new JPasswordField();
txtcmpass.setEchoChar('*');
txtcmpass.setBounds(110, 50, 120, 25);
btnSubmitPass = new JButton("验证原密码");
btnSubmitPass.setBounds(240, 50, 100, 25);
//修改密码窗体
if(x == 1){
lblcmpassnew = new JLabel("新密码");
lblcmpassnew2 = new JLabel("确认密码");
btnChangePass = new JButton("修改密码");
txtcmpassnew = new JPasswordField();
txtcmpassnew.setEchoChar('*');
txtcmpassnew.setBounds(110, 100, 120, 25);
txtcmpassnew2 = new JPasswordField();
txtcmpassnew2.setEchoChar('*');
txtcmpassnew2.setBounds(110, 150, 120, 25);
pane.add(txtcmpassnew);
pane.add(txtcmpassnew2);
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
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(txtcmpass.getText().equals(m.getMpass()) && txtcmpass.getText().length() !=0){
if(txtcmpassnew.getText().equals(txtcmpassnew2.getText())){
this.emsex =emsex;
this.emage = emage;
this.emphone =emphone;
this.emtel =emtel;
this.emaddr =emaddr;
this.embirth =embirth;
this.emcard =emcard;
this.emindate =emindate;
this.emjob =emjob;
};
public Employee(String emname,String emsex,int emage,String emphone,String emtel,String emaddr,Date embirth,String emcard,Date emindate,String emjob,String manage,String managepass){
this.emname =emname;
this.emsex =emsex;
this.emage = emage;
this.emphone =emphone;
this.emtel =emtel;
this.emaddr =emaddr;
this.embirth =embirth;
this.emcard =emcard;
this.emindate =emindate;
this.emjob =emjob;
this.manage = manage;
this.managepass = managepass;
};
public Employee( int emid,String emname,String emsex,int emage,String emphone,String emtel,
String emaddr,Date embirth,String emcard,Date emindate,String emjob,String manage,String managepass){
this.emid =emid;
this.emname =emname;
this.emsex =emsex;
this.emage = emage;
this.emphone =emphone;
this.emtel =emtel;
this.emaddr =emaddr;
this.embirth =embirth;
this.emcard =emcard;
this.emindate =emindate;
this.emjob =emjob;
this.manage = manage;
this.managepass = managepass;
};
public Employee( int emid,String emname,String emsex,int emage,String emphone,String emtel,
pane.add(lblmanage);
pane.add(txtmanage);
pane.add(lblmanagepass);
pane.add(txtmanagepass);
}
//x = 22时 为员工信息修改
if(x == 22){
this.setTitle("员工信息修改");
lblmindate.setText("入职日期");
btnreg.setBounds(70, 360, 100, 30);
//调整位置
lblmid = new JLabel("编号");
lblmid.setFont(new Font("楷体", Font.BOLD, 14));
lblmid.setBounds(40, 110, 50, 25);
txtmid = new JTextField();
txtmid.setBounds(100, 110, 120, 25);
txtmid.setEnabled(false);
lblmname.setBounds(260, 110, 50, 25);
txtmname.setBounds(310, 115, 120, 25);
lblmphone.setBounds(40, 145, 50, 25);
txtmphone.setBounds(100, 145, 120, 25);
lblemjob= new JLabel("职位");
lblemjob.setFont(new Font("楷体", Font.BOLD, 14));
lblemjob.setBounds(40, 250, 50, 25);
txtemjob= new JTextField();
txtemjob.setBounds(100, 250, 120, 25);
lblemcard = new JLabel("身份证号");
lblemcard.setFont(new Font("楷体", Font.BOLD, 14));
lblemcard.setBounds(260, 250, 70, 25);
txtemcard = new JTextField();
txtemcard.setBounds(330, 250, 100, 25);
lblemtel = new JLabel("固定电话");
lblemtel.setFont(new Font("楷体", Font.BOLD, 14));
lblemtel.setBounds(40, 285, 70, 25);
txtemtel = new JTextField();
txtemtel.setBounds(100, 285, 120, 25);
JLabel lblmage;
JLabel lblmbirth;
JLabel lblmaddr;
JLabel lblmindate;
JLabel lblmaddmoney;
JLabel lblmaddmintegral;
//添加员工信息
JLabel lblemcard;
JLabel lblemjob;
JLabel lblemtel;
JButton btnreg;
JButton btnrturn;
JButton btnmanage;
JButton btnSubmitPass;
JButton btnChangePass;
JButton btninmoney;
JButton btnChangeAccount;
JButton btnChangePause;
JLabel lblcmpass;
JTextField txtcmpass;
JLabel lblcmpassnew;
JPasswordField txtcmpassnew;
public RegistFrame(int x) {
this.setBounds(390, 150, 475, 500);
this.setResizable(false);
pane = new JPanel();
pane.setLayout(null);
lblmid = new JLabel();
txtmid = new JTextField();
lblmphone = new JLabel("手机号");
lblmphone.setFont(new Font("楷体", Font.BOLD, 14));
lblmphone.setBounds(40, 110, 50, 25);
txtmphone = new JTextField();
txtmphone.setBounds(100, 110, 120, 25);
lblmpass = new JLabel();
txtmpass = new JPasswordField();
lblmname = new JLabel("姓名");
lblmname.setFont(new Font("楷体", Font.BOLD, 14));
lblmname.setBounds(40, 145, 50, 25);
txtmname = new JTextField();
txtmname.setBounds(100, 145, 120, 25);
lblmsex = new JLabel("性别");
btnChangePass = new JButton("修改密码");
txtcmpassnew = new JPasswordField();
txtcmpassnew.setEchoChar('*');
txtcmpassnew.setBounds(110, 100, 120, 25);
txtcmpassnew2 = new JPasswordField();
txtcmpassnew2.setEchoChar('*');
txtcmpassnew2.setBounds(110, 150, 120, 25);
pane.add(txtcmpassnew);
pane.add(txtcmpassnew2);
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
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(txtcmpass.getText().equals(m.getMpass()) && txtcmpass.getText().length() !=0){
if(txtcmpassnew.getText().equals(txtcmpassnew2.getText())){
MemberDAO.changeMemberPassByID(txtcmpassnew.getText(),m.getMid());
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);
}
}
});
}
//按照电话号码查询
public static List selectByEmPhone(String emphone){
String sql = "select * from tblEmployee where emphone=?";
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);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
closeSelect();
}
return listmember;
}
//按照ID查询
public static Employee selectByEmIDReturnEM(int emid){
String sql = "select * from tblEmployee where emid=?";
List list = new ArrayList();
list.add(emid);
rs = DBManage.selectMember(sql, list);
Employee em = null;
try {
while(rs.next()){
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"));
this.setTitle("非会员消费记录查询");
btnmsearch.setBounds(307, 10, 80, 25);
rbtnmphone.setVisible(false);
rbtnmname.setVisible(false);
txtmtop.setVisible(false);
btnchange.setVisible(false);
btndelete.setVisible(false);
dtm = new DefaultTableModel();
dtm.addColumn("消费编号");
dtm.addColumn("会员编号");
dtm.addColumn("员工编号");
dtm.addColumn("服务编号");
dtm.addColumn("消费日期");
dtm.addColumn("折扣");
dtm.addColumn("金额");
dtm.addColumn("备注");
tbl = new JTable(dtm);
tbl.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
spane = new JScrollPane(tbl);
spane.setBounds(7, 50, 680, 400);
pane.add(spane);
// 查询消费记录监听器
btnmsearch.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
listcon = ConsumeDAO.selectByPhone("000001");
fillTable5();
}
});
}
//公共部分
pane.add(rbtnmname);
pane.add(rbtnmphone);
pane.add(txtmtop);
pane.add(btnmsearch);
pane.add(btnchange);
pane.add(btndelete);
this.add(pane);
this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
this.setVisible(true);
}
public void fillTable() {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
List<Member> list = null;
List <Employee> listem = null;
List <Services> listser = null;
final List <JCheckBox> listcbo= new ArrayList<JCheckBox>();
protected int mid2;
String conmphone = "";
String conmname = "";
public ConsumeFrame() {
this.setTitle("结账管理系统");
this.setBounds(290, 140, 700, 520);
this.setResizable(false);
pane = new JPanel();
pane.setLayout(null);
rbtnmember = new JRadioButton("会员");
rbtnmember.setSelected(true);
rbtnmember.setBounds(30, 10, 70, 25);
rbtnmember.setFont(new Font("楷体", Font.BOLD, 14));
rbtnmember.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
txtmtop.setEditable(true);
btnmsearch.setEnabled(true);
rbtnmphone.setEnabled(true);
rbtnmname.setEnabled(true);
txtmtopLayMoney.setEnabled(true);
}
});
rbtnnotmember = new JRadioButton("非会员");;
rbtnnotmember.setBounds(30, 40, 70, 25);
rbtnnotmember.setFont(new Font("楷体", Font.BOLD, 14));
EmployeeDAO.updateEmployee(em);
JOptionPane.showMessageDialog(null, "恭喜您更新成功");
RegistFrame.this.dispose();
} catch (ParseException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
}
});
pane.add(lblemjob);
pane.add(txtemjob);
pane.add(lblemcard);
pane.add(txtemcard);
pane.add(lblmpass);
pane.add(txtmpass);
pane.add(lblemtel);
pane.add(txtemtel);
pane.add(btnmanage);
pane.add(lblmanage);
pane.add(txtmanage);
pane.add(lblmanagepass);
pane.add(txtmanagepass);
}
//修改服务信息
if(x == 31){
new ChangeServices(1);
}
//公共部分
pane.add(lblmid);
pane.add(txtmid);
pane.add(btnreg);
pane.add(btnrturn);
pane.add(lblmphone);
pane.add(lblmname);
pane.add(lblmsex);
pane.add(lblmage);
pane.add(lblmbirth);
pane.add(lblmaddr);
pane.add(lblmindate);
pane.add(txtmphone);
pane.add(txtmname);
pane.add(txtmsex);
pane.add(txtmage);
tbl.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
spane = new JScrollPane(tbl);
spane.setBounds(7, 50, 680, 400);
pane.add(spane);
// 查询消费记录监听器
btnmsearch.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
listcon = ConsumeDAO.selectByPhone("000001");
fillTable5();
}
});
}
//公共部分
pane.add(rbtnmname);
pane.add(rbtnmphone);
pane.add(txtmtop);
pane.add(btnmsearch);
pane.add(btnchange);
pane.add(btndelete);
this.add(pane);
this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
this.setVisible(true);
}
public void fillTable() {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for (int i = 0; i < list.size(); i++) {
Member m = list.get(i);
dtm.addRow(new Object[] { m.getMid(), m.getMphone(), m.getMname(),
m.getMsex(), m.getMage(), sdf.format(m.getMbirth()),
m.getMaddr(), sdf.format(m.getMindate()), m.getMaddmoney(),
m.getMintegral() });
}
}
btnsersbumit.setBounds(95, 280, 100, 25);
btnserreturn.setBounds(260, 280, 100, 25);
txtsermoney.setEditable(false);
lblsername.setText("备注");
this.setTitle("更改消费记录信息");
btnsersbumit.setText("更新");
btnsersbumit.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(JOptionPane.showConfirmDialog(null, "您确认要更改该消费记录的信息吗") == JOptionPane.YES_OPTION){
ConsumeDAO.updateConsumeByConID(Integer.parseInt(txtserid.getText()));
JOptionPane.showMessageDialog(null, "恭喜您更新成功");
ChangeServices.this.dispose();
}
}
});
pane.add(txtremark);
}
pane.add(lblserid);
pane.add(lblsername);
pane.add(lblsermoney);
pane.add(txtserid);
pane.add(txtsermoney);
pane.add(btnsersbumit);
pane.add(btnserreturn);
this.add(pane);
this.setDefaultCloseOperation(EXIT_ON_CLOSE);
this.setVisible(true);
}
public void returnAct() {
btnserreturn.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
ChangeServices.this.dispose();
}
});
DBManage.executeSql(strSql, list);
}
//根据消费ID更改
public static void updateConsumeByConID(int conid){
String strSql = "update tblConsume conremark =? where conid=? ";
List list = new ArrayList();
list.add(conid);
DBManage.executeSql(strSql, list);
}
//按照conID更改电话号码
public static void updateConsumePhoneByConID(String conmphone ,int conid){
String strSql = "update tblConsume set conmphone =? where conid=? ";
List list = new ArrayList();
list.add(conmphone);
list.add(conid);
DBManage.executeSql(strSql, list);
}
//查询全部
public static List<Consume> selectAll(){
String strSql = "select * from tblConsume";
List list = new ArrayList();
rs = DBManage.selectMember(strSql, null);
List <Consume> listmember = new ArrayList<Consume>();
try {
while(rs.next()){
Consume s = new Consume();
s.setConid(rs.getInt("conid"));
s.setConmphone(rs.getString("conmphone"));
s.setConemid(rs.getInt("conemid"));
s.setConserid(rs.getInt("conserid"));
s.setCondate(rs.getDate("condate"));
s.setConagio(rs.getInt("conagio"));
s.setConmoney(rs.getInt("conmoney"));
s.setConremark(rs.getString("conremark"));
listmember.add(s);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
closeSelect();
}
return listmember;
}
//按照消费ID查询
this.emage = emage;
this.emphone =emphone;
this.emtel =emtel;
this.emaddr =emaddr;
this.embirth =embirth;
this.emcard =emcard;
this.emindate =emindate;
this.emjob =emjob;
this.manage = manage;
this.managepass = managepass;
};
public Employee( int emid,String emname,String emsex,int emage,String emphone,String emtel,
String emaddr,Date embirth,String emcard,String emjob,String manage,String managepass){
this.emid =emid;
this.emname =emname;
this.emsex =emsex;
this.emage = emage;
this.emphone =emphone;
this.emtel =emtel;
this.emaddr =emaddr;
this.embirth =embirth;
this.emcard =emcard;
this.emjob =emjob;
this.manage = manage;
this.managepass = managepass;
};
public Employee(int emid,String emname,String emsex,int emage,String emphone,String emtel,
String emaddr,Date embirth,String emcard,String emjob){
this.emid =emid;
this.emname =emname;
this.emsex =emsex;
this.emage = emage;
this.emphone =emphone;
this.emtel =emtel;
this.emaddr =emaddr;
this.embirth =embirth;
this.emcard =emcard;
this.emjob =emjob;
};
}
mnsys.add(ServicesAdd);
mnsys.add(ServicesManage);
mnsys.add(DataInitialize);
mnsys.add(NoteManage);
mnsys.add(LogManage);
mnsys.add(BackRenew);
//添加到菜单栏
mnb.add(mnMemberManage);
mnb.add(mnConsume);
mnb.add(mnEmployee);
mnb.add(mnQuery);
mnb.add(mnindiv);
mnb.add(mnsys);
lblwelcom = new JLabel("欢迎使用会员管理系统");
lblwelcom.setFont(new Font("宋体", Font.BOLD, 25));
lblwelcom.setBounds(200, 120, 380, 70);
lblloginuser = new JLabel("用户名");
lblloginuser.setBounds(280, 250, 100, 25);
txtloginuser = new JTextField();
txtloginuser.setBounds(345, 250, 130, 25);
lblloginpwd = new JLabel("密码");
lblloginpwd.setBounds(280, 287, 100, 25);
txtloginpwd = new JTextField();
txtloginpwd.setBounds(345, 287, 130, 25);
btnlogin = new JButton("提交");
btnlogin.setBounds(290, 325, 80, 25);
btnreset = new JButton("重置");
btnreset.setBounds(390, 325, 80, 25);
pane.add(txtloginuser);
pane.add(txtloginpwd);
pane.add(lblwelcom);
pane.add(lblloginuser);
pane.add(lblloginpwd);
pane.add(btnlogin);
pane.add(btnreset);
mnMemberManage.setEnabled(false);
mnConsume.setEnabled(false);
mnEmployee.setEnabled(false);
mnQuery.setEnabled(false);
mnindiv.setEnabled(false);
mnsys.setEnabled(false);
public class MemberDAO {
static ResultSet rs = null;
public static void addMember(Member m){
String sql = "insert into tblMember (mpass,mphone,mname,msex,mage,mbirth,maddr,mindate,maddmoney,mintegral) values (?,?,?,?,?,?,?,?,?,?)";
List list = new ArrayList();
list.add(m.getMpass());
list.add(m.getMphone());
list.add(m.getMname());
list.add(m.getMsex());
list.add(m.getMage());
list.add(new java.sql.Date(m.getMbirth().getTime()));
list.add(m.getMaddr());
list.add(new java.sql.Date(m.getMindate().getTime()));
list.add(m.getMaddmoney());
list.add(m.getMintegral());
DBManage.executeSql(sql, list);
}
//删除
public static void DeleteALL(){
String sqldelConsume = "delete from tblConsume"; //初始化数据
String sqldelEmployee = "delete from tblEmployee"; //初始化数据
String sqldelMember= "delete from tblMember"; //初始化数据
String sqldelServices = "delete from tblServices"; //初始化数据
DBManage.executeSql(sqldelConsume, null);
DBManage.executeSql(sqldelEmployee, null);
DBManage.executeSql(sqldelMember, null);
DBManage.executeSql(sqldelServices, null);
}
//按照ID删除会员
public static void deleteByID(int mid){
String sql = "delete from tblmember where mid = ?";
List list = new ArrayList();
list.add(mid);
DBManage.executeSql(sql, list);
}
//按照编号ID更改全部信息
public static void updateMember(Member m){
String sql = "update tblmember set mphone=?,mname = ?, msex = ?,mage = ?,mbirth = ?,maddr = ?,mindate = ?,maddmoney = ?,mintegral = ? where mid = ?";
List list = new ArrayList();
list.add(m.getMphone());
list.add(m.getMname());
list.add(m.getMsex());
list.add(m.getMage());
list.add(new java.sql.Date(m.getMbirth().getTime()));
list.add(m.getMaddr());
list.add(new java.sql.Date(m.getMindate().getTime()));
list.add(m.getMaddmoney());
list.add(m.getMintegral());
list.add(m.getMid());
DBManage.executeSql(sql, list);
}