📄 perform.java
字号:
try {
medId = txt_goodsId.getText().trim();
list = query.getIdQuery(medId);
int size = list.size();
System.out.println("size = " + size);
if(size > 0) {
for( int i = 0 ; i < list.size() ; i ++ ) {
Vector vector = new Vector();
dbSell =(DBSellTable) list.get(i);
vector.add(dbSell.getCustomerId());
vector.add(dbSell.getMedicineId());
vector.add(dbSell.getSellQuantity());
vector.add(dbSell.getSellDate());
vector.add(dbSell.getSellPrice());
defTableModel.addRow(vector);
//defTableModel.fireTableDataChanged();
}
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
}
else {
JOptionPane.showMessageDialog(desktop,"没有满足条件的查询结果！","提示",1);//0是错误类型x,1是信息类型圆形i，2是警告三角i,3是问号
return;
}
}
catch (Exception ae) {
ae.printStackTrace();
}
}
}
class QueryAsGoodsNamePerform implements ActionListener {
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
List list = new ArrayList();
Query query = new SellQuery();
DBSellTable dbSell = new DBSellTable();
DefaultTableModel defTableModel = (DefaultTableModel)jTable.getModel();
String goodsName;
((DefaultTableModel)jTable.getModel()).getDataVector().removeAllElements();
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
try {
goodsName = txt_goodsName.getText().trim();
list = query.getNameQuery(goodsName);
int size = list.size();
if(size > 0) {
for( int i = 0 ; i < list.size() ; i ++ ) {
Vector vector = new Vector();
dbSell =(DBSellTable) list.get(i);
vector.add(dbSell.getCustomerId());
vector.add(dbSell.getMedicineId());
vector.add(dbSell.getSellQuantity());
vector.add(dbSell.getSellDate());
vector.add(dbSell.getSellPrice());
defTableModel.addRow(vector);
//defTableModel.fireTableDataChanged();
}
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
}
else {
JOptionPane.showMessageDialog(desktop,"没有满足条件的查询结果！","提示",1);//0是错误类型x,1是信息类型圆形i，2是警告三角i,3是问号
return;
}
}
catch (Exception ae) {
ae.printStackTrace();
}
}
}
class QueryAsSellDatePerform implements ActionListener {
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
List list = new ArrayList();
Query query = new SellQuery();
DBSellTable dbSell = new DBSellTable();
DefaultTableModel defTableModel = (DefaultTableModel)jTable.getModel();
String dateFrom,dateTo;
((DefaultTableModel)jTable.getModel()).getDataVector().removeAllElements();
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
try {
dateFrom = txt_sellDateFrom.getText().trim();
dateTo = txt_sellDateTo.getText().trim();
list = query.getDateQuery(dateFrom,dateTo);
int size = list.size();
//System.out.println("size = " + size);
if(size > 0) {
for( int i = 0 ; i < list.size() ; i ++ ) {
Vector vector = new Vector();
dbSell =(DBSellTable) list.get(i);
vector.add(dbSell.getCustomerId());
vector.add(dbSell.getMedicineId());
vector.add(dbSell.getSellQuantity());
vector.add(dbSell.getSellDate());
vector.add(dbSell.getSellPrice());
defTableModel.addRow(vector);
//defTableModel.fireTableDataChanged();
}
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
}
else {
JOptionPane.showMessageDialog(desktop,"没有满足条件的查询结果！","提示",1);//0是错误类型x,1是信息类型圆形i，2是警告三角i,3是问号
return;
}
}
catch (Exception ae) {
ae.printStackTrace();
}
}
}
}
class ExitSysPerform implements ActionListener {
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
System.exit(0);
}
}
class AddUserPerform extends Perform {
private JLabel lab_userName, lab_userType;
private JTextField txt_userName,txt_userType;
private JButton btn_addUser;
MyInternalFrame addUser = new MyInternalFrame();
public AddUserPerform(JDesktopPane desktop) {
this.desktop = desktop;
}
public void actionPerformed(ActionEvent e) {
lab_userName = new JLabel("用户名称：");
txt_userName = new JTextField();
lab_userType = new JLabel("用户类型：");
txt_userType = new JTextField();
btn_addUser = new JButton("添加用户");
lab_userName.setBounds(50,100,120,30);
txt_userName.setBounds(200,100,120,30);
lab_userType.setBounds(50,150,120,30);
txt_userType.setBounds(200,150,120,30);
btn_addUser.setBounds(370,130,120,30);
btn_addUser.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
String userName = txt_userName.getText();
String userType = txt_userType.getText();
txt_userName.setText("");
txt_userType.setText("");
Connection conn = DBConnection.getDBConnection();
Statement stmt = null;
try {
stmt = conn.createStatement();
String sql = "insert into user values(null,'" + userName.trim() + "','" + userType.trim() + "')";
stmt.execute(sql);
JOptionPane.showMessageDialog(desktop,"添加成功！","提示",1);
}catch(SQLException sql_ex) {
JOptionPane.showMessageDialog(desktop,"连接出现SQL异常！","提示",1);
sql_ex.printStackTrace();
}catch(Exception ex) {
JOptionPane.showMessageDialog(desktop,"出现异常！","提示",1);
ex.printStackTrace();
}finally {
try {
if(!conn.isClosed()) {
DBConnection.closeDBConnection();
}
}catch(Exception ex) {
ex.printStackTrace();
}
}
}
});
addUser.setLayout(null);
addUser.setTitle("添加用户");
addUser.add(lab_userName);
addUser.add(txt_userName);
addUser.add(lab_userType);
addUser.add(txt_userType);
addUser.add(btn_addUser);
addUser.setVisible(true);
desktop.add(addUser,0);
}
}
class DelUserPerform extends Perform {
public DelUserPerform(JDesktopPane desktop) {
this.desktop = desktop;
}
private JLabel lab_userName;
private JTextField txt_userName;
private JButton btn_delUser;
MyInternalFrame delUser = new MyInternalFrame();
public void actionPerformed(ActionEvent e) {
lab_userName = new JLabel("请输入要删除的用户名称：");
txt_userName = new JTextField();
btn_delUser = new JButton("删除用户");
lab_userName.setBounds(50,100,170,30);
txt_userName.setBounds(250,100,120,30);
btn_delUser.setBounds(400,100,120,30);
btn_delUser.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
String userName = txt_userName.getText();
txt_userName.setText("");
Connection conn = DBConnection.getDBConnection();
Statement stmt = null;
try {
stmt = conn.createStatement();
String sql = "delete from user where userName = '" + userName + "'";
stmt.execute(sql);
JOptionPane.showMessageDialog(desktop,"用户删除成功！","提示",1);
}catch(SQLException sql_ex) {
JOptionPane.showMessageDialog(desktop,"连接出现SQL异常！","提示",1);
sql_ex.printStackTrace();
}catch(Exception ex) {
JOptionPane.showMessageDialog(desktop,"出现异常！","提示",1);
ex.printStackTrace();
}finally {
try {
if(!conn.isClosed()) {
DBConnection.closeDBConnection();
}
}catch(Exception ex) {
ex.printStackTrace();
}
}
}
});
delUser.setLayout(null);
delUser.setTitle("删除用户");
delUser.add(lab_userName);
delUser.add(txt_userName);
delUser.add(btn_delUser);
delUser.setVisible(true);
desktop.add(delUser,0);
}
}
class ModifyUserPerform extends Perform {
public ModifyUserPerform(JDesktopPane desktop) {
this.desktop = desktop;
}
private JLabel lab_userName, lab_userType,lab_userName1, lab_userType1;
private JTextField txt_userName,txt_userType,txt_userName1,txt_userType1;
private JButton btn_modifyUser;
String userName = null;
String userType = null;
int userId = 0;
MyInternalFrame modifyUser = new MyInternalFrame();
public void actionPerformed(ActionEvent e) {
lab_userName = new JLabel("用户名称：");
txt_userName = new JTextField();
txt_userName.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent focusevent) {
}
public void focusLost(FocusEvent focusevent) {
Connection conn = DBConnection.getDBConnection();
Statement stmt = null;
ResultSet rs = null;
String sql = null;
String userName = txt_userName.getText();
try {
stmt = conn.createStatement();
sql = "select * from user where userName = '" + userName + "'";
rs = stmt.executeQuery(sql);
if(rs.next()) {
userId = rs.getInt("userId");
userType = rs.getString("userType");
txt_userType.setText(userType);
}else {
JOptionPane.showMessageDialog(null, "此用户不存在","提示",1);
}
}catch (SQLException sql_ex) {
sql_ex.printStackTrace();
}catch (Exception ex) {
ex.printStackTrace();
}finally {
if(rs != null)
rs = null;
if(stmt != null)
stmt = null;
if(conn != null)
conn = null;
}
}
});
JLabel lab_preModify = new JLabel("修改前信息:");
JLabel lab_Modified = new JLabel("请填写修改后信息:");
lab_userType = new JLabel("用户类型：");
txt_userType = new JTextField();
txt_userType.setEditable(false);
btn_modifyUser = new JButton("修改用户");
lab_preModify.setBounds(50,60,150,30);
lab_Modified.setBounds(350, 60, 200, 30);
lab_userName.setBounds(50,100,120,30);
txt_userName.setBounds(200,100,120,30);
lab_userType.setBounds(50,150,120,30);
txt_userType.setBounds(200,150,120,30);
btn_modifyUser.setBounds(350,200,120,30);
lab_userName1 = new JLabel("用户名称");
lab_userType1 = new JLabel("用户类型");
txt_userName1 = new JTextField();
txt_userType1 = new JTextField();
lab_userName1.setBounds(350,100,120,30);
txt_userName1.setBounds(500,100,120,30);
lab_userType1.setBounds(350,150,120,30);
txt_userType1.setBounds(500,150,120,30);
btn_modifyUser.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
userName = txt_userName1.getText();
userType = txt_userType1.getText();
System.out.println("userType = " + userType);
txt_userName.setText("");
txt_userType.setText("");
txt_userName1.setText("");
txt_userType1.setText("");
Connection conn = DBConnection.getDBConnection();
Statement stmt = null;
String sql = null;
try {
stmt = conn.createStatement();
sql = "update user set userName = '" + userName
+ "',userType = '" + userType + "' where userId = " + userId;
stmt.execute(sql);
JOptionPane.showMessageDialog(desktop,"修改成功！","提示",1);
}catch(SQLException sql_ex) {
JOptionPane.showMessageDialog(desktop,"连接出现SQL异常！","提示",1);
sql_ex.printStackTrace();
}catch(Exception ex) {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -