数据库课程设计商品销售管理系统Word下载.docx
《数据库课程设计商品销售管理系统Word下载.docx》由会员分享,可在线阅读,更多相关《数据库课程设计商品销售管理系统Word下载.docx(71页珍藏版)》请在冰豆网上搜索。
button1=newJButton(登录);
button2=newJButton(退出);
button1.addActionListener(this);
button2.addActionListener(this);
panel.add(J1);
panel.add(c);
panel.add(J2);
panel.add(F1);
panel.add(button1);
panel.add(button2);
add(panel);
publicvoidsetBak()/设置背景方法(JPanel)this.getContentPane().setOpaque(false);
ImageIconimg=newImageIcon(e:
/数据库课程设计/六月物语.jpg);
JLabelbackground=newJLabel(img);
this.getLayeredPane().add(background,newInteger(Integer.MIN_VALUE);
background.setBounds(0,0,img.getIconWidth(),img.getIconHeight();
publicvoidactionPerformed(ActionEvente)if(e.getSource()=button1)if(c.getSelectedItem().equals(Boss)&
F1.getText().equals(boss)this.dispose();
BSbs=newBS(管理员界面);
bs.setSize(500,250);
bs.setLocation(450,250);
bs.setVisible(true);
if(c.getSelectedItem().equals(Salesman)&
F1.getText().equals(salesman)this.dispose();
SLsl=newSL(销售员界面);
sl.setSize(500,250);
sl.setLocation(450,250);
sl.setVisible(true);
if(e.getSource()=button2)System.exit(0);
publicstaticvoidmain(Stringargs)LoginBackPanellgp=newLoginBackPanel(管理系统登录);
lgp.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
lgp.setSize(300,200);
lgp.setLocation(550,250);
lgp.setVisible(true);
classBSextendsJFrameimplementsActionListenerJButtonB1,B2,B3,B4,B5,B6,B7;
publicBS(Stringstr)super(str);
JPanelJP=newJPanel();
JP.setOpaque(false);
ct.add(JP);
JP.setLayout(newFlowLayout(FlowLayout.CENTER,30,50);
B1=newJButton(销售情况);
B2=newJButton(客户退货);
B3=newJButton(销售收款);
B4=newJButton(客户信息);
B5=newJButton(员工管理);
B6=newJButton(进货信息);
B7=newJButton(更换角色);
B1.addActionListener(this);
B2.addActionListener(this);
B3.addActionListener(this);
B4.addActionListener(this);
B5.addActionListener(this);
B6.addActionListener(this);
B7.addActionListener(this);
JP.add(B1);
JP.add(B2);
JP.add(B3);
JP.add(B4);
JP.add(B5);
JP.add(B6);
JP.add(B7);
add(JP);
publicvoidsetBak()(JPanel)this.getContentPane().setOpaque(false);
/数据库课程设计/六月物语1.jpg);
publicvoidactionPerformed(ActionEvente)if(e.getSource()=B1)this.dispose();
CXFPXXcxfpxx=newCXFPXX(日常销售【发票情况】);
cxfpxx.setSize(700,300);
cxfpxx.setLocation(350,250);
cxfpxx.setVisible(true);
if(e.getSource()=B2)this.dispose();
XSTHXXxsthxx=newXSTHXX(日常销售【销售退货】);
xsthxx.setSize(700,300);
xsthxx.setLocation(350,250);
xsthxx.setVisible(true);
if(e.getSource()=B3)this.dispose();
XSXXCXxsxxcx=newXSXXCX(日常销售【销售收款】);
xsxxcx.setSize(700,300);
xsxxcx.setLocation(350,250);
xsxxcx.setVisible(true);
if(e.getSource()=B4)this.dispose();
HYXXCXhyxxcx=newHYXXCX(基本信息管理【会员信息】);
hyxxcx.setSize(700,300);
hyxxcx.setLocation(350,250);
hyxxcx.setVisible(true);
if(e.getSource()=B5)this.dispose();
YGGLyggl=newYGGL(员工管理【员工信息】);
yggl.setSize(500,200);
yggl.setLocation(450,250);
yggl.setVisible(true);
if(e.getSource()=B6)this.dispose();
JHXXjhxx=newJHXX(商品更新【进货信息】);
jhxx.setSize(300,150);
jhxx.setLocation(500,250);
jhxx.setVisible(true);
if(e.getSource()=B7)this.dispose();
LoginBackPanelxt=newLoginBackPanel(管理系统登录);
xt.setSize(300,200);
xt.setLocation(550,250);
xt.setVisible(true);
classBG2extendsAbstractTableModelStringrq,ph,mc,bh,dj,sl,je;
finalStringcolumnNames=开票日期,销售票号,商品名称,商品编号,商品单价/元,销售数量/个,销售金额/元;
Objectdata=newObject1007;
publicBG2()intm=0;
Stringurl=jdbc:
microsoft:
sqlserver:
/localhost:
1433;
DatabaseName=课程设计;
Connectioncon;
Stringsql;
Statementstmt;
tryClass.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);
catch(java.lang.ClassNotFoundExceptione)trycon=DriverManager.getConnection(url,sa,123456);
stmt=con.createStatement();
sql=SELECT*FROM销售发票;
ResultSetrs=stmt.executeQuery(sql);
while(rs.next()rq=rs.getString
(1);
ph=rs.getString
(2);
mc=rs.getString(3);
bh=rs.getString(4);
dj=rs.getString(5);
sl=rs.getString(6);
je=rs.getString(7);
datam0=rq;
datam1=ph;
datam2=mc;
datam3=bh;
datam4=dj;
datam5=sl;
datam+6=je;
stmt.close();
con.close();
catch(SQLExceptione)System.out.println(0);
publicintgetColumnCount()returncolumnNames.length;
publicintgetRowCount()returndata.length;
publicStringgetColumnName(intcol)returncolumnNamescol;
publicObjectgetValueAt(introw,intcol)returndatarowcol;
publicvoidsetValueAt(Objectvalue,introw,intcol)intnumRows=getRowCount();
intnumCols=getColumnCount();
for(inti=0;
inumRows;
i+)for(intj=0;
jnumCols;
j+)System.out.print(+dataij);
classCXFPXXextendsJFrameimplementsActionListenerBG2bg2;
JTablet;
JButtonb;
JPanelp;
JScrollPanes;
publicCXFPXX(Stringstr)super(str);
setLayout(newBorderLayout();
b=newJButton(确定);
b.addActionListener(this);
p=newJPanel();
p.add(b);
bg2=newBG2();
t=newJTable(bg2);
s=newJScrollPane(t);
add(s,Center);
add(p,South);
publicvoidactionPerformed(ActionEvente)if(e.getSource()=b)this.dispose();
BScxfpxx=newBS(管理员界面);
cxfpxx.setSize(500,250);
cxfpxx.setLocation(450,250);
classBG3extendsAbstractTableModelStringrq,mc,yy,sl,je;
finalStringcolumnNames=退货日期,商品名称,退货原因,退货数量/件,退货金额/元;
Objectdata=newObject1005;
publicBG3()intm=0;
sql=SELECT*FROM退货记录;
mc=rs.getString
(2);
yy=rs.getString(3);
sl=rs.getString(4);
je=rs.getString(5);
datam1=mc;
datam2=yy;
datam3=sl;
datam+4=je;
classXSTHXXextendsJFrameimplementsActionListenerBG3bg3;
publicXSTHXX(Stringstr)super(str);
bg3=newBG3();
t=newJTable(bg3);
classBG4extendsAbstractTableModelStringrq,mc,dj,sl,je;
finalStringcolumnNames=开票日期,商品名称,商品单价/元,销售数量/个,销售金额/元;
publicBG4()intm=0;
sql=SELECT开票日期,商品名称,商品单价/元,销售数量/个,销售金额/元FROM销售发票;
dj=rs.getString(3);
datam2=dj;
classXSXXCXextendsJFrameimplementsActionListenerBG4bg4;
publicXSXXCX(Stringstr)super(str);
bg4=newBG4();
t=newJTable(bg4);
classBG5extendsAbstractTableModelStringch,lx,dz,rq;
finalStringcolumnNames=客户称呼,联系方式,客户地址,入会日期;
Objectdata=newObject1004;
publicBG5()intm=0;
sql=SELECT*FROM客户信息;
while(rs.next()ch=rs.getString
(1);
lx=rs.getString
(2);
dz=rs.getString(3);
rq=rs.getString(4);
datam0=ch;
datam1=lx;
datam2=dz;
datam+3=rq;
classHYXXCXextendsJFrameimplementsActionListenerBG5bg5;
publicHYXXCX(Stringst