java 实训成果进销存管理系统

package c基本信息管理; import java.awt.*; import javax.swing.*; import 数据库连接.数据库连接; import java.awt.event.*; import java.sql.SQLException; import java.util.regex.Pattern; public class 客户管理 extends JFrame implements ActionListener, ItemListener { private JLabel kehuID, quancheng, kehuaddress, kehushort, phonenum, linkman, Email, bankname, banknum, linkphone, fax, postcode; private JTextField tquancheng, tkehuaddress, tkehushort, tphonenum, tlinkman, tEmail, tbankname, tbanknum, tlinkphone, tfax, tpostcode, tkehuID; private JButton saveButton, resetButton; private JLabel mquancheng, mkehuaddress, mkehushort, mphonenum, mlinkman, mEmail, mbankname, mbanknum, mlinkphone, mfax, mpostcode, mkehuID; private JTextField mtkehuaddress, mtkehushort, mtphonenum, mtlinkman, mtEmail, mtbankname, mtbanknum, mtlinkphone, mtfax, mtpostcode, mtkehuID; private Choice mtquancheng; private JButton deleteButton, modifyButton; private JLabel dkehuid; private JTextField tdkehuid; private JTabbedPane tabbedPane; String kk = null; public 客户管理() { super("客户信息管理"); tabbedPane = new JTabbedPane(); JPanel padd = new JPanel();// 客户添加面板 padd.setBackground(Color.white); saveButton = new JButton("保存"); saveButton.addActionListener(this); saveButton.setBounds(80, 260, 60, 20); resetButton = new JButton("重置"); resetButton.addActionListener(this); resetButton.setBounds(290, 260, 60, 20); kehuID = new JLabel("客户编号:"); kehuID.setBounds(20, 10, 60, 15); tkehuID = new JTextField(); tkehuID.setEditable(false); tkehuID.setBounds(90, 8, 150, 20); //客户编号的初始化 //默认值 数据库连接.load(); 数据库连接.conn(); 数据库连接.exeSql(); try { 数据库连接.rs = 数据库连接.stmt.executeQuery("select id from kehu"); 数据库连接.rs.last();// 记录指示器到最后一条记录 int rows = 数据库连接.rs.getRow();// 得到记录数 数据库连接.rs.beforeFirst();// 设置记录指示器 if(rows==0){ tkehuID.setText("K10000001"); } else{ while (数据库连接.rs.next()) { kk=数据库连接.rs.getString(1); } long a=Long.parseLong(kk.substring(1, kk.length())); a++; tkehuID.setText("K"+String.valueOf(a)); } 数据库连接.close1(); } catch (Exception e1) { e1.printStackTrace(); } quancheng = new JLabel("客户全称:"); quancheng.setBounds(20, 38, 60, 15); tquancheng = new JTextField(); tquancheng.setBounds(90, 35, 120, 20); kehushort = new JLabel("客户简称:"); kehushort.setBounds(215, 38, 60, 15); tkehushort = new JTextField(); tkehushort.setBounds(275, 35, 120, 20); kehuaddress = new JLabel("客户地址:"); kehuaddress.setBounds(20, 66, 60, 15); tkehuaddress = new JTextField(); tkehuaddress.setBounds(90, 63, 280, 20); postcode = new JLabel("邮政编码:"); postcode.setBounds(20, 93, 60, 15); tpostcode = new JTextField(); tpostcode.setBounds(90, 90, 120, 20); phonenum = new JLabel("手 机:"); phonenum.setBounds(215, 93, 60, 15); tphonenum = new JTextField(); tphonenum.setBounds(275, 90, 120, 20); fax = new JLabel("传 真:"); fax.setBounds(20, 120, 60, 15); tfax = new JTextField(); tfax.setBounds(90, 116, 280, 20); linkman = new JLabel("联 系 人:"); linkman.setBounds(20, 147, 60, 15); tlinkman = new JTextField(); tlinkman.setBounds(90, 142, 120, 20); linkphone = new JLabel("固定电话:"); linkphone.setBounds(215, 147, 60, 15); tlinkphone = new JTextField(); tlinkphone.setBounds(275, 142, 120, 20); Email = new JLabel("电子邮件:"); Email.setBounds(20, 174, 60, 15); tEmail = new JTextField(); tEmail.setBounds(90, 174, 280, 20); bankname = new JLabel("开户银行:"); bankname.setBounds(20, 201, 60, 15); tbankname = new JTextField(); tbankname.setBounds(90, 201, 280, 20); banknum = new JLabel("银行帐号:"); banknum.setBounds(20, 228, 60, 15); tbanknum = new JTextField(); tbanknum.setBounds(90, 228, 280, 20); padd.setLayout(null); padd.add(kehuID); padd.add(tkehuID); padd.add(quancheng); padd.add(tquancheng); padd.add(kehuaddress); padd.add(tkehuaddress); padd.add(kehushort); padd.add(tkehushort); padd.add(postcode); padd.add(tpostcode); padd.add(phonenum); padd.add(tphonenum); padd.add(fax); padd.add(tfax); padd.add(linkman); padd.add(tlinkman); padd.add(linkphone); padd.add(tlinkphone); padd.add(Email); padd.add(tEmail); padd.add(bankname); padd.add(tbankname); padd.add(banknum); padd.add(tbanknum); padd.add(saveButton); padd.add(resetButton); JPanel pmodify = new JPanel();// 客户修改面板 pmodify.setBackground(Color.white); mkehuID = new JLabel("客户编号:"); mkehuID.setBounds(20, 10, 60, 15); mtkehuID = new JTextField(); mtkehuID.setEditable(false); mtkehuID.setBounds(90, 8, 150, 20); mquancheng = new JLabel("客户全称:"); mquancheng.setBounds(20, 38, 60, 15); mtquancheng = new Choice(); mtquancheng.addItemListener(this); mtquancheng.setBounds(90, 35, 120, 20); 数据库连接.load(); 数据库连接.conn(); 数据库连接.exeSql(); try { 数据库连接.rs = 数据库连接.stmt.executeQuery("select khname from kehu"); 数据库连接.rs.last();// 记录指示器到最后一条记录 数据库连接.rs.beforeFirst();// 设置记录指示器 while (数据库连接.rs.next()) { mtquancheng.addItem(数据库连接.rs.getString(1)); } 数据库连接.close1(); } catch (Exception e1) { e1.printStackTrace(); } mkehushort = new JLabel("客户简称:"); mkehushort.setBounds(215, 38, 60, 15); mtkehushort = new JTextField(); mtkehushort.setBounds(275, 35, 120, 20); mkehuaddress = new JLabel("客户地址:"); mkehuaddress.setBounds(20, 66, 60, 15); mtkehuaddress = new JTextField(); mtkehuaddress.setBounds(90, 63, 280, 20); mpostcode = new JLabel("邮政编码:"); mpostcode.setBounds(20, 93, 60, 15); mtpostcode = new JTextField(); mtpostcode.setBounds(90, 90, 120, 20); mphonenum = new JLabel("手 机:"); mphonenum.setBounds(215, 93, 60, 15); mtphonenum = new JTextField(); mtphonenum.setBounds(275, 90, 120, 20); mfax = new JLabel("传 真:"); mfax.setBounds(20, 120, 60, 15); mtfax = new JTextField(); mtfax.setBounds(90, 116, 280, 20); mlinkman = new JLabel("联 系 人:"); mlinkman.setBounds(20, 147, 60, 15); mtlinkman = new JTextField(); mtlinkman.setBounds(90, 142, 120, 20); mlinkphone = new JLabel("固定电话:"); mlinkphone.setBounds(215, 147, 60, 15); mtlinkphone = new JTextField(); mtlinkphone.setBounds(275, 142, 120, 20); mEmail = new JLabel("电子邮件:"); mEmail.setBounds(20, 174, 60, 15); mtEmail = new JTextField(); mtEmail.setBounds(90, 174, 280, 20); mbankname = new JLabel("开户银行:"); mbankname.setBounds(20, 201, 60, 15); mtbankname = new JTextField(); mtbankname.setBounds(90, 201, 280, 20); mbanknum = new JLabel("银行帐号:"); mbanknum.setBounds(20, 228, 60, 15); mtbanknum = new JTextField(); mtbanknum.setBounds(90, 228, 280, 20); modifyButton = new JButton("修改"); modifyButton.setBounds(190, 260, 60, 20); modifyButton.addActionListener(this); pmodify.setLayout(null); pmodify.add(mkehuID); pmodify.add(mtkehuID); pmodify.add(mquancheng); pmodify.add(mtquancheng); pmodify.add(mkehushort); pmodify.add(mtkehushort); pmodify.add(mkehuaddress); pmodify.add(mtkehuaddress); pmodify.add(mpostcode); pmodify.add(mtpostcode); pmodify.add(mphonenum); pmodify.add(mtphonenum); pmodify.add(mfax); pmodify.add(mtfax); pmodify.add(mlink