📄 perform.java
字号:
JOptionPane.showMessageDialog(desktop,"出现异常！","提示",1);
ex.printStackTrace();
}finally {
try {
if(stmt != null)
stmt = null;
if(!conn.isClosed()) {
DBConnection.closeDBConnection();
}
}catch(Exception ex) {
ex.printStackTrace();
}
}
}
});
modifyUser.setLayout(null);
modifyUser.setTitle("修改用户");
modifyUser.add(lab_preModify);
modifyUser.add(lab_Modified);
modifyUser.add(lab_userName);
modifyUser.add(txt_userName);
modifyUser.add(lab_userType);
modifyUser.add(txt_userType);
modifyUser.add(lab_userName1);
modifyUser.add(txt_userName1);
modifyUser.add(lab_userType1);
modifyUser.add(txt_userType1);
modifyUser.add(btn_modifyUser);
modifyUser.setVisible(true);
desktop.add(modifyUser,0);
}
}
class AddSupplier extends Perform {
public AddSupplier(JDesktopPane desktop) {
this.desktop = desktop;
}
private JLabel lab_supplierName, lab_address,lab_linkMan,lab_telephone;
private JTextField txt_supplierName,txt_address,txt_linkMan,txt_telephone;
private JButton btn_addSupplier;
private String supplierName,address,linkMan,telephone;
MyInternalFrame addSupplier = new MyInternalFrame();
public void actionPerformed(ActionEvent e) {
lab_supplierName = new JLabel("供应商名称：");
txt_supplierName = new JTextField();
lab_address = new JLabel("地址：");
txt_address = new JTextField();
lab_linkMan = new JLabel("联系人:");
txt_linkMan = new JTextField();
lab_telephone = new JLabel("联系电话:");
txt_telephone = new JTextField();
btn_addSupplier = new JButton("添加供应商");
lab_supplierName.setBounds(50,100,120,30);
txt_supplierName.setBounds(200,100,120,30);
lab_address.setBounds(50,150,120,30);
txt_address.setBounds(200,150,120,30);
lab_linkMan.setBounds(50,200,120,30);
txt_linkMan.setBounds(200,200,120,30);
lab_telephone.setBounds(50,250,120,30);
txt_telephone.setBounds(200,250,120,30);
btn_addSupplier.setBounds(370,130,120,30);
btn_addSupplier.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
supplierName = txt_supplierName.getText();
address = txt_address.getText();
linkMan = txt_linkMan.getText();
telephone = txt_telephone.getText();
txt_supplierName.setText("");
txt_address.setText("");
txt_linkMan.setText("");
txt_telephone.setText("");
Connection conn = DBConnection.getDBConnection();
Statement stmt = null;
try {
stmt = conn.createStatement();
String sql = "insert into supplier values(null,'" + supplierName.trim()
+ "','" + address.trim() + "','" + linkMan.trim() + "','" + telephone.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();
}
}
}
});
addSupplier.setLayout(null);
addSupplier.setTitle("添加供应商");
addSupplier.add(lab_supplierName);
addSupplier.add(txt_supplierName);
addSupplier.add(lab_address);
addSupplier.add(txt_address);
addSupplier.add(lab_linkMan);
addSupplier.add(txt_linkMan);
addSupplier.add(lab_telephone);
addSupplier.add(txt_telephone);
addSupplier.add(btn_addSupplier);
addSupplier.setVisible(true);
desktop.add(addSupplier,0);
}
}
class DelSupplier extends Perform {
public DelSupplier(JDesktopPane desktop) {
this.desktop = desktop;
}
private JLabel lab_supplierName;
private JTextField txt_supplierName;
private JButton btn_delSupplier;
MyInternalFrame delSupplier = new MyInternalFrame();
public void actionPerformed(ActionEvent e) {
lab_supplierName = new JLabel("请输入要删除的供应商名称：");
txt_supplierName = new JTextField();
btn_delSupplier = new JButton("删除供应商");
lab_supplierName.setBounds(50,100,170,30);
txt_supplierName.setBounds(250,100,120,30);
btn_delSupplier.setBounds(400,100,120,30);
btn_delSupplier.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
String supplierName = txt_supplierName.getText();
txt_supplierName.setText("");
Connection conn = DBConnection.getDBConnection();
Statement stmt = null;
ResultSet rs = null;
String sql = null;
try {
stmt = conn.createStatement();
sql = "select * from supplier where supplierName = '" + supplierName + "'";
rs = stmt.executeQuery(sql);
if(rs.next()) {
sql = "delete from supplier where supplierName = '" + supplierName + "'";
stmt.execute(sql);
JOptionPane.showMessageDialog(desktop,"供应商删除成功！","提示",1);
}else
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();
}
}
}
});
delSupplier.setLayout(null);
delSupplier.setTitle("删除供应商");
delSupplier.add(lab_supplierName);
delSupplier.add(txt_supplierName);
delSupplier.add(btn_delSupplier);
delSupplier.setVisible(true);
desktop.add(delSupplier,0);
}
}
class ModifySupplier extends Perform {
public ModifySupplier(JDesktopPane desktop) {
this.desktop = desktop;
}
private JLabel lab_supplierName, lab_address,lab_linkMan,lab_telephone,lab_supplierName1, lab_address1,lab_linkMan1,lab_telephone1;
private JTextField txt_supplierName,txt_address,txt_linkMan,txt_telephone,txt_supplierName1,txt_address1,txt_linkMan1,txt_telephone1;
private JButton btn_modifyUser;
String supplierName = null;
String address = null;
String linkMan = null;
String telephone = null;
int supplierId = 0;
MyInternalFrame modifyUser = new MyInternalFrame();
public void actionPerformed(ActionEvent e) {
lab_supplierName = new JLabel("供应商名称：");
txt_supplierName = new JTextField();
txt_supplierName.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;
supplierName = txt_supplierName.getText();
try {
stmt = conn.createStatement();
sql = "select * from supplier where supplierName = '" + supplierName + "'";
rs = stmt.executeQuery(sql);
if(rs.next()) {
supplierId = rs.getInt("supplierId");
address = rs.getString("address");
linkMan = rs.getString("linkMan");
telephone = rs.getString("telephone");
txt_address.setText(address);
txt_linkMan.setText(linkMan);
txt_telephone.setText(telephone);
}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_address = new JLabel("地址：");
txt_address = new JTextField();
txt_address.setEditable(false);
lab_linkMan = new JLabel("联系人:");
txt_linkMan = new JTextField();
txt_linkMan.setEditable(false);
lab_telephone = new JLabel("联系电话:");
txt_telephone = new JTextField();
txt_telephone.setEditable(false);
btn_modifyUser = new JButton("修改供应商信息");
lab_preModify.setBounds(50,60,150,30);
lab_Modified.setBounds(350, 60, 200, 30);
lab_supplierName.setBounds(50,100,120,30);
txt_supplierName.setBounds(200,100,120,30);
lab_address.setBounds(50,150,120,30);
txt_address.setBounds(200,150,120,30);
lab_linkMan.setBounds(50,200,120,30);
txt_linkMan.setBounds(200,200,120,30);
lab_telephone.setBounds(50,250,120,30);
txt_telephone.setBounds(200,250,120,30);
btn_modifyUser.setBounds(500,400,150,30);
lab_supplierName1 = new JLabel("供应商名称");
lab_address1 = new JLabel("地址");
txt_supplierName1 = new JTextField();
txt_address1 = new JTextField();
lab_linkMan1 = new JLabel("联系人:");
txt_linkMan1 = new JTextField();
lab_telephone1 = new JLabel("联系电话:");
txt_telephone1 = new JTextField();
lab_supplierName1.setBounds(350,100,120,30);
txt_supplierName1.setBounds(500,100,120,30);
lab_address1.setBounds(350,150,120,30);
txt_address1.setBounds(500,150,120,30);
lab_linkMan1.setBounds(350,200,120,30);
txt_linkMan1.setBounds(500,200,120,30);
lab_telephone1.setBounds(350,250,120,30);
txt_telephone1.setBounds(500,250,120,30);
btn_modifyUser.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
supplierName = txt_supplierName1.getText();
address = txt_address1.getText();
linkMan = txt_linkMan1.getText();
telephone = txt_telephone1.getText();
txt_supplierName.setText("");
txt_address.setText("");
txt_linkMan.setText("");
txt_telephone.setText("");
txt_supplierName1.setText("");
txt_address1.setText("");
txt_linkMan1.setText("");
txt_telephone1.setText("");
Connection conn = DBConnection.getDBConnection();
Statement stmt = null;
String sql = null;
try {
stmt = conn.createStatement();
sql = "update supplier set supplierName = '" + supplierName
+ "',address = '" + address + "',linkMan = '" + linkMan
+"',telephone = '" + telephone + "' where supplierId = " + supplierId;
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(stmt != null)
stmt = null;
if(!conn.isClosed()) {
DBConnection.closeDBConnection();
}
}catch(Exception ex) {
ex.printStackTrace();
}
}
}
});
modifyUser.setLayout(null);
modifyUser.setTitle("修改供应商");
modifyUser.add(lab_preModify);
modifyUser.add(lab_Modified);
modifyUser.add(lab_supplierName);
modifyUser.add(txt_supplierName);
modifyUser.add(lab_address);
modifyUser.add(txt_address);
modifyUser.add(lab_linkMan);
modifyUser.add(txt_linkMan);
modifyUser.add(lab_telephone);
modifyUser.add(txt_telephone);
modifyUser.add(lab_supplierName1);
modifyUser.add(txt_supplierName1);
modifyUser.add(lab_address1);
modifyUser.add(t⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -