package inventory;
import java.awt.*;
import java.awt.event.*;
import java.sql.ResultSet;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
public class SelectSuplier {
public JPanel panel;
JLabel id,name,person,TelNo,Phone,Code,Fax,city; //客户编号，姓名，联系人，联系电话，联系手机，邮编，传真，地址
JTextField txtid,txtname,txtcity,txtperson,txtTelNo,txtCode,txtPhone,txtFax;
JButton add,select,update,delete;
JComboBox city1,city2,city3;
DefaultTableModel model;
JTable table;
JScrollPane panes;
SqlHelper help;
public SelectSuplier()
{
try
{
help=new SqlHelper("inventory","sa","225502");
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null, ex.getMessage());
return;
}
panel=new JPanel(null);
panel.setBorder(null);
panel.setBounds(10,20,1030,700);
//标签
id=new JLabel("供应商编号:");
id.setBounds(60,20,100,30);
name=new JLabel("供应商名称:");
name.setBounds(250,20,100,30);
person=new JLabel("供应商联系人:");
person.setBounds(440,20,100,30);
TelNo=new JLabel("供应商电话:");
TelNo.setBounds(640,20,100,30);
Phone=new JLabel("供应商手机:");
Phone.setBounds(60,60,100,30);
Fax=new JLabel("供应商传真:");
Fax.setBounds(250,60,100,30);
Code=new JLabel("供应商邮编:");
Code.setBounds(440,60,100,30);
city=new JLabel("供应商地址:");
city.setBounds(60,100,100,30);
//文本框
txtid=new JTextField();
txtid.setBounds(140,20,100,25);
txtid.setForeground(Color.red);
txtid.setEditable(false);
txtname=new JTextField();
txtname.setBounds(330,20,100,25);
txtperson=new JTextField();
txtperson.setBounds(530,20,100,25);
txtTelNo=new JTextField();
txtTelNo.setBounds(720,20,100,25);
txtPhone=new JTextField();
txtPhone.setBounds(140,60,100,25);
txtFax=new JTextField();
txtFax.setBounds(330,60,100,25);
txtCode=new JTextField();
txtCode.setBounds(530,60,100,25);
txtcity=new JTextField();
txtcity.setBounds(480,100,150,25);
city1=new JComboBox();
city1.setBounds(135,100,100,25);
city1.addItem("湖南省");
city1.addItem("湖北省");
city1.addItem("广东省");
city2=new JComboBox();
city2.setBounds(250,100,100,25);
city3=new JComboBox();
city3.setBounds(360,100,100,25);
//按钮
add=new JButton("添加");
add.setBounds(840,0,80,30);
select=new JButton("查询");
select.setBounds(840,35,80,30);
update=new JButton("修改");
update.setBounds(840,70,80,30);
delete=new JButton("删除");
delete.setBounds(840,105,80,30);
city1.addItemListener(new ItemListener() {
@Override
public void itemStateChanged(ItemEvent e) {
if(e.getStateChange()!=ItemEvent.SELECTED)
{
return;
}
city2.removeAllItems();
if(city1.getSelectedItem().equals("湖南省"))
{
String hunan[]={"长沙市","郴州市","怀化市","湘潭市"};
for (int i = 0; i < hunan.length; i++)
{
city2.addItem(hunan[i]);
}
}
if(city1.getSelectedItem()=="广东省")
{
String guangdong[]={"江门市","佛山市","广州市","惠州市"};
for (int i = 0; i < guangdong.length; i++)
{
city2.addItem(guangdong[i]);
}
}
if(city1.getSelectedItem()=="湖北省")
{
String hubei[]={"黄冈市","黄石市","荆门市","武汉市"};
for (int i = 0; i < hubei.length; i++)
{
city2.addItem(hubei[i]);
}
}
}
});
city2.addItemListener(new ItemListener() {
@Override
public void itemStateChanged(ItemEvent e) {
if(e.getStateChange()!=ItemEvent.SELECTED)
{
return;
}
city3.removeAllItems();
if(city2.getSelectedItem().toString().equals("长沙市"))
{
String changsha[]={"天心区","岳麓区","雨花区","芙蓉区","开福区","长沙县"};
for (int i = 0; i < changsha.length; i++) {
city3.addItem(changsha[i]);
}
}
if(city2.getSelectedItem().toString().equals("郴州市"))
{
String chenzhou[]={"桂东县","桂阳县","嘉禾县","临武县","汝城县","宜章县","永兴县"};
for (int i = 0; i < chenzhou.length; i++)
{
city3.addItem(chenzhou[i]);
}
}
if(city2.getSelectedItem().equals("怀化市"))
{
System.out.println(1);
String[] huaihua={"辰溪县","会同县","沅陵县","溆浦县"};
for (int j = 0; j < huaihua.length; j++)
{
city3.addItem(huaihua[j]);
}
}
if(city2.getSelectedItem()=="湘潭市")
{
String[] xiangtan={"韶山市","湘潭市","湘潭县","湘乡市"};
for (int i = 0; i < xiangtan.length; i++)
{
city3.addItem(xiangtan[i]);
}
}
if(city2.getSelectedItem()=="黄冈市")
{
String huanggang[]={ "红安县","黄冈市","黄梅县","罗田县","麻城市","团风县","武穴市","英山县","蕲春县","浠水县"};
for (int i = 0; i < huanggang.length; i++)
{
city3.addItem(huanggang[i]);
}
}
if(city2.getSelectedItem()=="黄石市")
{
String huangshi[]={"铁山区","黄石港区","阳新县","下陆区","西塞山区"};
for (int i = 0; i < huangshi.length; i++)
{
city3.addItem(huangshi[i]);
}
}
if(city2.getSelectedItem()=="荆门市")
{
String [] jingmen={"东宝区","摄刀区","钟祥市","京山县","孝南区","应城 ","安陆 ","汉川 ","孝昌县","大悟县","云梦县"};
for (int j = 0; j < jingmen.length; j++)
{
city3.addItem(jingmen[j]);
}
}
if(city2.getSelectedItem()=="武汉市")
{
String wuhan []={"江岸区","江汉区","硚口区","汉阳区","武昌区","青山区"," 洪山区","东西湖区","汉南区","蔡甸区","江夏区","黄 陂区","新洲区"};
for (int i = 0; i < wuhan.length; i++)
{
city3.addItem(wuhan[i]);
}
}
if(city2.getSelectedItem()=="江门市")
{
String jiangmen[]={"江海区","蓬江区","新会区","台山市","开平 ","鹤山 ","恩平 "};
for (int i = 0; i < jiangmen.length; i++)
{
city3.addItem(jiangmen[i]);
}
}
if(city2.getSelectedItem()=="佛山市")
{
String foshan[]={"禅城区","南海区","顺德区","三水区","高明区"};
for (int i = 0; i < foshan.length; i++)
{
city3.addItem(foshan[i]);
}
}
if(city2.getSelectedItem()=="广州市")
{
String guangzhou[]={"越秀区","荔湾区","海珠区","天河区","白云区","黄埔区","番禺区","花都区","南沙区","萝岗区","增城 ","从化 "};
for (int i = 0; i < guangzhou.length; i++)
{
city3.addItem(guangzhou[i]);
}
}
if(city2.getSelectedItem()=="惠州市")
{
String huizhou[]={"惠城区","惠阳区","博罗县","惠东县","龙门县"};
for (int i = 0; i < huizhou.length; i++)
{
city3.addItem(huizhou[
商品库存管理系统java+sql server_Java_sql server
版权申诉
5星 · 超过95%的资源 185 浏览量
2022-09-21
03:01:09
上传
评论 1
收藏 186KB ZIP 举报 
商品库存管理系统java+sql server_Java_sql server （106个子文件） 
SelectCommodity.class 8KB Selectincert.class 7KB SelectCommodity$2.class 6KB SelectCustomer.class 5KB Admin.class 5KB SelectSuplier.class 5KB SelectCommodity$4.class 5KB SelectSuplier$7.class 5KB SelectCommodity$3.class 5KB SelectCustomer$7.class 5KB MyAdmin.class 5KB SelectSuplier$2.class 4KB SelectCustomer$4.class 4KB SelectCustomer$6.class 4KB SelectCustomer$2.class 4KB SelectSuplier$5.class 4KB SelectSuplier$4.class 4KB Myzhuce.class 4KB Commodity$1.class 4KB Selectincert$4.class 4KB Increase.class 4KB Commodity.class 4KB MyAdmin$4.class 4KB MyAdmin$3.class 4KB MyAdmin$2.class 4KB Supplier.class 4KB Supplier$4.class 4KB Selectincert$6.class 4KB AddCustomer$4.class 4KB AddCustomer.class 3KB Myzhuce$3.class 3KB Selectincert$5.class 3KB Selectincert$3.class 3KB Mydenglu.class 3KB Selectincert$7.class 3KB Myzhaohui.class 3KB Selectincert$2.class 3KB Myzhaohui$3.class 3KB zhanghao.class 3KB Increase$2.class 3KB SelectCustomer$5.class 3KB SelectSuplier$6.class 3KB Increase$1.class 3KB SelectCustomer$8.class 3KB Mydenglu$3.class 3KB SelectSuplier$8.class 2KB AddCustomer$2.class 2KB Supplier$2.class 2KB MyAdmin$5.class 2KB SelectCommodity$5.class 2KB Selectincert$8.class 2KB SqlHelper.class 2KB Selectincert$9.class 2KB zhanghao$1.class 2KB SelectCommodity$6.class 2KB MyAdmin$6.class 2KB Myzhuce$2.class 2KB SelectCustomer$1.class 2KB SelectSuplier$1.class 2KB Mydenglu$2.class 2KB Mydenglu$1.class 2KB AddCustomer$1.class 1KB Myzhaohui$4.class 1KB Admin$5.class 1KB Supplier$1.class 1KB Myzhuce$1.class 1KB AddCustomer$3.class 1KB Supplier$3.class 1KB Admin$7.class 1KB Admin$8.class 1KB Admin$9.class 1KB Admin$6.class 1KB Admin$2.class 1KB Admin$4.class 1KB Admin$1.class 1KB Admin$3.class 1KB Mydenglu$4.class 869B Myzhaohui$1.class 847B Myzhaohui$2.class 773B SelectCommodity$1.class 607B Selectincert$1.class 604B SelectCustomer$3.class 601B SelectSuplier$3.class 595B MyAdmin$1.class 559B mymian.class 545B .classpath 378B SelectSuplier.java 28KB SelectCustomer.java 27KB SelectCommodity.java 24KB Selectincert.java 21KB MyAdmin.java 14KB AddCustomer.java 9KB Supplier.java 8KB Myzhuce.java 7KB Admin.java 6KB Commodity.java 6KB Mydenglu.java 5KB Myzhaohui.java 5KB Increase.java 5KB zhanghao.java 2KB共 106 条
- 1
- 2
alvarocfc
- 粉丝: 105
- 资源: 1万+
下载权益
C知道特权
VIP文章
课程特权
VIP享7折，此内容立减3.57元 开通VIP
评论14