药品管理系统毕业设计(论文)-毕业论文设计管理系统

}

Connection conn = DB.getConn();

Statement stmt = DB.getStatement(conn);

String sql = \ try { }

JOptionPane.showMessageDialog(null, \恭喜您,修改成功\恭喜\return true;

stmt.executeUpdate(sql); e.printStackTrace();

JOptionPane.showMessageDialog(null, \修改失败\警告\return false;

} catch (SQLException e) {

user.getUsername()+\

user.getPassword()+\where username ='\

System.out.println(sql);

//显示模块 com.ahut.frame.usermgr 用户添加核心代码: //显示用户添加界面

JPanel editPanel = new JPanel();

editPanel.setBorder(BorderFactory.createTitledBorder(\添加用户\editPanel.setLayout(new GridLayout(2,1)); JPanel upPanel = new JPanel();

upPanel.setBorder(BorderFactory.createTitledBorder(\用户信息%upPanel.setLayout(new GridLayout(3,1)); JPanel jp1 = new JPanel(); JPanel jp2 = new JPanel(); JPanel jp3 = new JPanel(); jp1.add(new JLabel(\用户名%username = new JTextField(\password = new JPasswordField(\password2 = new JPasswordField(\jp1.add(username); upPanel.add(jp1);

jp2.add(new JLabel(\密码\jp2.add(password);

jp3.add(new JLabel(\再次密码\jp3.add(password2); upPanel.add(jp2); upPanel.add(jp3);

editPanel.add(upPanel);

共65页 第 37 页

JPanel addUserSubmitPanel = new JPanel(); JButton addUserSubmitBtn = new JButton(\提交\JButton addUserCancelBtn = new JButton(\取消\addUserSubmitPanel.add(addUserSubmitBtn); addUserSubmitPanel.add(addUserCancelBtn); editPanel.add(addUserSubmitPanel);

addUserSubmitBtn.addActionListener(new addUserSubmitListener()); addUserCancelBtn.addActionListener(new addUserCancelListener()); add(editPanel,BorderLayout.CENTER); //提交用户添加时执行的操作

public class addUserSubmitListener implements ActionListener { 1);

//用户修改的核心代码: //核心代码:

JPanel editPanel = new JPanel();

editPanel.setLayout(new GridLayout(0,2));

editPanel.setBorder(BorderFactory.createTitledBorder(\修改用户\JPanel leftPanel = new JPanel();

leftPanel.setLayout(new GridLayout(0,1));

leftPanel.setBorder(BorderFactory.createTitledBorder(\用户列表\UserDao ud = new UserDao();

userlist = new JList(ud.findUser());

leftPanel.add(new JScrollPane(userlist, 22, 31));

userlist.addListSelectionListener(new userlistListener()); editPanel.add(leftPanel);

JPanel rightPanel = new JPanel();

rightPanel = new JPanel(new BorderLayout());

rightPanel.setBorder(BorderFactory.createTitledBorder(\用户信息\

}

}else { }

User user = new User();

user.setUsername(username.getText().trim()); user.setPassword(password.getText().trim()); user.setRank(0);

UserDao ud = new UserDao(); ud.regeist(user);

public void actionPerformed(ActionEvent e) {

System.out.println(\

if (password.getText().trim().equals(\

JOptionPane.showMessageDialog(null, \输入不正确\警告\

|| !password.getText().trim().equals(password2.getText().trim())) {

共65页 第 38 页

rightPanel.setLayout(new FlowLayout()); unfld = new JTextField(\pwdfld = new JTextField(\rankfld = new JTextField(\

JPanel jPanel1 = new JPanel(new GridLayout(0, 1)); jPanel1.add(new JLabel(\用户名:\jPanel1.add(new JLabel(\密码:\jPanel1.add(new JLabel(\权限:\

JPanel jPanel2 = new JPanel(new GridLayout(0, 1)); jPanel2.add(unfld); jPanel2.add(pwdfld); jPanel2.add(rankfld);

rightPanel.add(jPanel1, \rightPanel.add(jPanel2, \editPanel.add(rightPanel);

add(editPanel,BorderLayout.CENTER);

JPanel modifyUserSubmitPanel = new JPanel();

JButton modifyUserSubmitBtn = new JButton(\修改用户\modifyUserSubmitPanel.add(modifyUserSubmitBtn); add(modifyUserSubmitPanel,BorderLayout.SOUTH);

//监听器

public class modifyUserSubmitListener implements ActionListener { 1);

}

}

}else {

int i = JOptionPane.showConfirmDialog(null, \是否修改该用if(i == 1) return;

UserDao ud = new UserDao(); User user = new User();

user.setUsername(unfld.getText().trim()); user.setPassword(pwdfld.getText().trim());

if(rankfld.getText().trim().equals(\系统管理员\ }

ud.modify(user);

user.setRank(1); user.setRank(0);

}else {

public void actionPerformed(ActionEvent e) {

if(username == null || username.equals(\

JOptionPane.showMessageDialog(null, \未选中用户\警告\

户？修改将无法恢复！\警告\

共65页 第 39 页

5.3 销售管理模块

销售管理界面如图5.3所示。

图5.3 销售界面

关键代码如下：（点击“销售”时系统执行的操作）

//DAO中的处理

public boolean sales(SalesOrder so) { \

+ so.getMid() + \+ so.getNum() + \System.out.println(sql); try { }

return true;}

stmt.executeUpdate(sql); e.printStackTrace(); return false;

} catch (SQLException e) { Connection conn = DB.getConn();

Statement stmt = DB.getStatement(conn);

String sql = \

//com.ahut.frame.salesMgr包中执行的操作

共65页 第 40 页