import .*;
import .*;
import .*;
import .*;
import ;
public class LoginBackPanel extends JFrame implements ActionListener{
private static final long serialVersionUID = 1L;
JButton button1,button2;
JTextField F1;
Choice c;
Container ct = getContentPane();
public LoginBackPanel(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(panel);
(new FlowLayout(,60,20));
c = new Choice();
(" Boss ");
(" Salesman ");
JLabel J1 = new JLabel("验证身份:");
JLabel J2 = new JLabel("登录密码:");
F1 = new JTextField(9);
button1 = new JButton("登录");
button2 = new JButton("退出");
(this);
(this);
(J1);
(c);
(J2);
(F1);
(button1);
(button2);
add(panel);
}
public void setBak(){ //设置背景方法
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语.jpg");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==button1){
if(().equals(" Boss
")&&().equals("boss")){
();
BS bs=new BS("管理员界面");
(500,250);
(450,250);
(true);
}
if(().equals(" Salesman
")&&().equals("salesman")){
();
SL sl=new SL("销售员界面");
(500,250);
(450,250);
(true);
}
}
if(()==button2){
(0);
}
}
public static void main(String[]args){
LoginBackPanel lgp=new LoginBackPanel("管理系统登录");
(_ON_CLOSE);
(300,200);
(550,250);
(true);
}
}
class BS extends JFrame implements ActionListener{
JButton B1,B2,B3,B4,B5,B6,B7;
Container ct = getContentPane();
public BS(String str){
super(str);
setBak();
JPanel JP = new JPanel();
(false);
(JP);
(new FlowLayout(,30,50));
B1 = new JButton("销售情况");
B2 = new JButton("客户退货");
B3 = new JButton("销售收款");
B4 = new JButton("客户信息");
B5 = new JButton("员工管理");
B6 = new JButton("进货信息");
B7 = new JButton("更换角色");
(this);
(this);
(this);
(this);
(this);
(this);
(this);
(B1);
(B2);
(B3);
(B4);
(B5);
(B6);
(B7);
add(JP);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
();
CXFPXX cxfpxx = new CXFPXX("日常销售—【发票情况】");
(700,300);
(350,250);
(true);
}
if(()==B2){
();
XSTHXX xsthxx = new XSTHXX("日常销售—【销售退货】");
(700,300);
(350,250);
(true);
}
if(()==B3){
();
XSXXCX xsxxcx = new XSXXCX("日常销售—【销售收款】");
(700,300);
(350,250);
(true);
}
if(()==B4){
();
HYXXCX hyxxcx = new HYXXCX("基本信息管理—【会员信息】");
(700,300);
(350,250);
(true);
}
if(()==B5){
();
YGGL yggl = new YGGL("员工管理—【员工信息】");
(500,200);
(450,250);
(true);
}
if(()==B6){
();
JHXX jhxx = new JHXX("商品更新—【进货信息】");
(300,150);
(500,250);
(true);
}
if(()==B7){
();
LoginBackPanel xt = new LoginBackPanel("管理系统登录");
(300,200);
(550,250);
(true);
}
}
}
class BG2 extends AbstractTableModel{
String rq,ph,mc,bh,dj,sl,je;
final String[] columnNames={"开票日期","销售票号","商品名称","商品编号","商品单价/
元","销售数量/个","销售金额/元"};
Object[][]data=new Object[100][7];
public BG2(){
int m=0;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e){
}
try{
con=(url,"sa","123456");
stmt=();
sql="SELECT * FROM 销售发票 ";
ResultSet rs=(sql);
while(()){
rq=(1);
ph=(2);
mc=(3);
bh=(4);
dj=(5);
sl=(6);
je=(7);
data[m][0]=rq;data[m][1]=ph;data[m][2]=mc;data[m][3]=bh;data[m][4]=dj;data[m][5]=sl;dat
a[m++][6]=je;
}
();
();
}catch(SQLException e){
("0");
}
}
public int getColumnCount(){
return ;
}
public int getRowCount(){
return ;
}
public String getColumnName(int col){
return columnNames[col];
}
public Object getValueAt(int row,int col){
return data[row][col];
}
public void setValueAt(Object value,int row,int col){
int numRows=getRowCount();
int numCols=getColumnCount();
for(int i=0;i<numRows;i++){
for(int j=0;j<numCols;j++){
(" "+data[i][j]);
}
}
}
}
class CXFPXX extends JFrame implements ActionListener{
BG2 bg2;
JTable t;
JButton b;
JPanel p;
JScrollPane s;
public CXFPXX(String str){
super(str);
setLayout(new BorderLayout());
b = new JButton("确定");
(this);
p = new JPanel();
(b);
bg2 = new BG2();
t = new JTable(bg2);
s = new JScrollPane(t);
add(s,"Center");
add(p,"South");
}
public void actionPerformed(ActionEvent e){
if(()==b){
();
BS cxfpxx = new BS("管理员界面");
(500,250);
(450,250);
(true);
}
}
}
class BG3 extends AbstractTableModel{
String rq,mc,yy,sl,je;
final String[] columnNames={"退货日期","商品名称","退货原因","退货数量/件","退货金
额/元"};
Object[][]data=new Object[100][5];
public BG3(){
int m=0;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e){
}
try{
con=(url,"sa","123456");
stmt=();
sql="SELECT * FROM 退货记录 ";
ResultSet rs=(sql);
while(()){
rq=(1);
mc=(2);
yy=(3);
sl=(4);
je=(5);
data[m][0]=rq;data[m][1]=mc;data[m][2]=yy;data[m][3]=sl;data[m++][4]=je;
}
();
();
}catch(SQLException e){
("0");
}
}
public int getColumnCount(){
return ;
}
public int getRowCount(){
return ;
}
public String getColumnName(int col){
return columnNames[col];
}
public Object getValueAt(int row,int col){
return data[row][col];
}
public void setValueAt(Object value,int row,int col){
int numRows=getRowCount();
int numCols=getColumnCount();
for(int i=0;i<numRows;i++){
for(int j=0;j<numCols;j++){
(" "+data[i][j]);
}
}
}
}
class XSTHXX extends JFrame implements ActionListener{
BG3 bg3;
JTable t;
JButton b;
JPanel p;
JScrollPane s;
public XSTHXX(String str){
super(str);
setLayout(new BorderLayout());
b = new JButton("确定");
(this);
p = new JPanel();
(b);
bg3 = new BG3();
t = new JTable(bg3);
s = new JScrollPane(t);
add(s,"Center");
add(p,"South");
}
public void actionPerformed(ActionEvent e){
if(()==b){
();
BS cxfpxx = new BS("管理员界面");
(500,250);
(450,250);
(true);
}
}
}
class BG4 extends AbstractTableModel{
String rq,mc,dj,sl,je;
final String[] columnNames={"开票日期","商品名称","商品单价/元","销售数量/个","销售
金额/元"};
Object[][]data=new Object[100][5];
public BG4(){
int m=0;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e){
}
try{
con=(url,"sa","123456");
stmt=();
sql="SELECT 开票日期,商品名称,[商品单价/元],[销售数量/个],[销售金额/元]
FROM 销售发票 ";
ResultSet rs=(sql);
while(()){
rq=(1);
mc=(2);
dj=(3);
sl=(4);
je=(5);
data[m][0]=rq;data[m][1]=mc;;data[m][2]=dj;data[m][3]=sl;data[m++][4]=je;
}
();
();
}catch(SQLException e){
("0");
}
}
public int getColumnCount(){
return ;
}
public int getRowCount(){
return ;
}
public String getColumnName(int col){
return columnNames[col];
}
public Object getValueAt(int row,int col){
return data[row][col];
}
public void setValueAt(Object value,int row,int col){
int numRows=getRowCount();
int numCols=getColumnCount();
for(int i=0;i<numRows;i++){
for(int j=0;j<numCols;j++){
(" "+data[i][j]);
}
}
}
}
class XSXXCX extends JFrame implements ActionListener{
BG4 bg4;
JTable t;
JButton b;
JPanel p;
JScrollPane s;
public XSXXCX(String str){
super(str);
setLayout(new BorderLayout());
b = new JButton("确定");
(this);
p = new JPanel();
(b);
bg4 = new BG4();
t = new JTable(bg4);
s = new JScrollPane(t);
add(s,"Center");
add(p,"South");
}
public void actionPerformed(ActionEvent e){
if(()==b){
();
BS cxfpxx = new BS("管理员界面");
(500,250);
(450,250);
(true);
}
}
}
class BG5 extends AbstractTableModel{
String ch,lx,dz,rq;
final String[] columnNames={"客户称呼","联系方式","客户地址","入会日期"};
Object[][]data=new Object[100][4];
public BG5(){
int m=0;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e){
}
try{
con=(url,"sa","123456");
stmt=();
sql="SELECT * FROM 客户信息 ";
ResultSet rs=(sql);
while(()){
ch=(1);
lx=(2);
dz=(3);
rq=(4);
data[m][0]=ch;data[m][1]=lx;data[m][2]=dz;data[m++][3]=rq;
}
();
();
}catch(SQLException e){
("0");
}
}
public int getColumnCount(){
return ;
}
public int getRowCount(){
return ;
}
public String getColumnName(int col){
return columnNames[col];
}
public Object getValueAt(int row,int col){
return data[row][col];
}
public void setValueAt(Object value,int row,int col){
int numRows=getRowCount();
int numCols=getColumnCount();
for(int i=0;i<numRows;i++){
for(int j=0;j<numCols;j++){
(" "+data[i][j]);
}
}
}
}
class HYXXCX extends JFrame implements ActionListener{
BG5 bg5;
JTable t;
JButton b;
JPanel p;
JScrollPane s;
public HYXXCX(String str){
super(str);
setLayout(new BorderLayout());
b = new JButton("确定");
(this);
p = new JPanel();
(b);
bg5 = new BG5();
t = new JTable(bg5);
s = new JScrollPane(t);
add(s,"Center");
add(p,"South");
}
public void actionPerformed(ActionEvent e){
if(()==b){
();
BS cxfpxx = new BS("管理员界面");
(500,250);
(450,250);
(true);
}
}
}
class YGGL extends JFrame implements ActionListener{
JButton B1,B2,B3,B4,B5;
Container ct = getContentPane();
public YGGL(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,40));
B1 = new JButton("添加员工");
B2 = new JButton("删除员工");
B3 = new JButton("员工名单");
B4 = new JButton("更新信息");
B5 = new JButton("返回");
(this);
(this);
(this);
(this);
(this);
(B1);
(B2);
(B3);
(B4);
(B5);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
();
TJYG tjyg = new TJYG("员工管理—【添加员工】");
(400,350);
(450,200);
(true);
}
if(()==B2){
();
SCYG scyg = new SCYG("员工管理—【删除员工】");
(300,150);
(550,300);
(true);
}
if(()==B3){
();
YGMDXX ygmdxx = new YGMDXX("员工管理—【员工名单】");
(700,300);
(350,250);
(true);
}
if(()==B4){
();
GXXX gxxx = new GXXX("员工管理—【更新信息】");
(300,200);
(500,250);
(true);
}
if(()==B5){
();
BS bs = new BS("管理员界面");
(500,250);
(450,250);
(true);
}
}
}
class TJYG extends JFrame implements ActionListener{
JLabel L1,L2,L3,L4,L5;
JTextField T1,T2,T3,T4,T5;
JButton B1,B2;
Container ct = getContentPane();
public TJYG(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,25));
L1 = new JLabel("员工名称:");
L2 = new JLabel("员工编号:");
L3 = new JLabel("员工职位:");
L4 = new JLabel("聘请日期:");
L5 = new JLabel("联系方式:");
T1=new JTextField(10);
T2=new JTextField(10);
T3=new JTextField(10);
T4=new JTextField(10);
T5=new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(L2);
(T2);
(L3);
(T3);
(L4);
(T4);
(L5);
(T5);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="INSERT INTO 人员管理(员工名称,员工编号,员工职位,聘请日期,联系方式)
VALUES('"+()+"','"+()+"','"+()+"','"+()+"','"+
ext()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 添 加 员 工 成 功 ！ "," 提 示
",_MESSAGE);
("");
("");
("");
("");
("");
}
if(()==B2){
();
YGGL yggl=new YGGL("员工管理—【员工信息】");
(500,200);
(450,250);
(true);
}
}
}
class SCYG extends JFrame implements ActionListener{
JLabel L1;
JTextField T1;
JButton B1,B2;
Container ct = getContentPane();
public SCYG(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,20));
L1 = new JLabel("员工名称:");
T1=new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="DELETE FROM 人员管理 WHERE(员工名称='"+()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 成 功 删 除 ！ "," 提 示
",_MESSAGE);
("");
}
if(()==B2){
();
YGGL yggl = new YGGL("员工管理—【员工信息】");
(500,200);
(450,250);
(true);
}
}
}
class BG6 extends AbstractTableModel{
String mc,bh,zw,rq,lx;
final String[] columnNames={"员工名称","员工编号","员工职位","聘请日期","联系方式
"};
Object[][]data=new Object[100][5];
public BG6(){
int m=0;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e){
}
try{
con=(url,"sa","123456");
stmt=();
sql="SELECT * FROM 人员管理 ";
ResultSet rs=(sql);
while(()){
mc=(1);
bh=(2);
zw=(3);
rq=(4);
lx=(5);
data[m][0]=mc;data[m][1]=bh;data[m][2]=zw;data[m][3]=rq;data[m++][4]=lx;
}
();
();
}catch(SQLException e){
("0");
}
}
public int getColumnCount(){
return ;
}
public int getRowCount(){
return ;
}
public String getColumnName(int col){
return columnNames[col];
}
public Object getValueAt(int row,int col){
return data[row][col];
}
public void setValueAt(Object value,int row,int col){
int numRows=getRowCount();
int numCols=getColumnCount();
for(int i=0;i<numRows;i++){
for(int j=0;j<numCols;j++){
(" "+data[i][j]);
}
}
}
}
class YGMDXX extends JFrame implements ActionListener{
BG6 bg6;
JTable t;
JButton b;
JPanel p;
JScrollPane s;
public YGMDXX(String str){
super(str);
setLayout(new BorderLayout());
b = new JButton("确定");
(this);
p = new JPanel();
(b);
bg6 = new BG6();
t = new JTable(bg6);
s = new JScrollPane(t);
add(s,"Center");
add(p,"South");
}
public void actionPerformed(ActionEvent e){
if(()==b){
();
YGGL yggl=new YGGL("员工管理—【员工信息】");
(500,200);
(450,250);
(true);
}
}
}
class GXXX extends JFrame implements ActionListener{
JLabel L1,L2;
JTextField T1,T2;
JButton B1,B2;
Container ct = getContentPane();
public GXXX(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,20));
L1 = new JLabel("员工名称:");
L2 = new JLabel("员工职位:");
T1 = new JTextField(10);
T2 = new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(L2);
(T2);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="UPDATE 人员管理 SET 员工职位='"+()+ "' WHERE(员工名称
='"+()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 更 新 成 功 ！ "," 提 示
",_MESSAGE);
("");
("");
}
if(()==B2){
();
YGGL yggl=new YGGL("员工管理—【员工信息】");
(500,200);
(450,250);
(true);
}
}
}
class JHXX extends JFrame implements ActionListener{
JButton B1,B2,B3;
Container ct = getContentPane();
public JHXX(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,20));
B1 = new JButton("进货审查");
B2 = new JButton("进货结账");
B3 = new JButton("返回");
(this);
(this);
(this);
(B1);
(B2);
(B3);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
();
JHSC jhsc = new JHSC("进货信息—【进货审查】");
(700,300);
(350,250);
(true);
}
if(()==B2){
();
JHZDXX jhzdxx = new JHZDXX("进货付款—【进货结账】");
(300,200);
(500,250);
(true);
}
if(()==B3){
();
BS bs = new BS("管理员界面");
(500,250);
(450,250);
(true);
}
}
}
class BG7 extends AbstractTableModel{
String mc,sl,dj,je,fk,rq;
final String[] columnNames={"货物名称","进货数量/份","进货单价/元","总需金额/元","
付款情况","进货日期"};
Object[][]data=new Object[100][6];
public BG7(){
int m=0;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e){
}
try{
con=(url,"sa","123456");
stmt=();
sql="SELECT * FROM 进货信息 ";
ResultSet rs=(sql);
while(()){
mc=(1);
sl=(2);
dj=(3);
je=(4);
fk=(5);
rq=(6);
data[m][0]=mc;data[m][1]=sl;data[m][2]=dj;data[m][3]=je;data[m][4]=fk;data[m++][5]=rq;
}
();
();
}catch(SQLException e){
("0");
}
}
public int getColumnCount(){
return ;
}
public int getRowCount(){
return ;
}
public String getColumnName(int col){
return columnNames[col];
}
public Object getValueAt(int row,int col){
return data[row][col];
}
public void setValueAt(Object value,int row,int col){
int numRows=getRowCount();
int numCols=getColumnCount();
for(int i=0;i<numRows;i++){
for(int j=0;j<numCols;j++){
(" "+data[i][j]);
}
}
}
}
class JHSC extends JFrame implements ActionListener{
BG7 bg7;
JTable t;
JButton b;
JPanel p;
JScrollPane s;
public JHSC(String str){
super(str);
setLayout(new BorderLayout());
b = new JButton("确定");
(this);
p = new JPanel();
(b);
bg7 = new BG7();
t = new JTable(bg7);
s = new JScrollPane(t);
add(s,"Center");
add(p,"South");
}
public void actionPerformed(ActionEvent e){
if(()==b){
();
JHXX jhxx = new JHXX("商品更新—【进货信息】");
(300,150);
(500,250);
(true);
}
}
}
class JHZDXX extends JFrame implements ActionListener{
JLabel L1,L2;
JTextField T1,T2;
JButton B1,B2;
Container ct = getContentPane();
public JHZDXX(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,20));
L1 = new JLabel("货物名称:");
L2 = new JLabel("付款情况:");
T1 = new JTextField(10);
T2 = new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(L2);
(T2);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="UPDATE 进货信息 SET 付款情况='"+()+ "' WHERE(货物名称
='"+()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 更 新 成 功 ！ "," 提 示
",_MESSAGE);
("");
("");
}
if(()==B2){
();
JHXX jhxx = new JHXX("商品更新—【进货信息】");
(300,150);
(500,250);
(true);
}
}
}
class SL extends JFrame implements ActionListener{
JButton B1,B2,B3,B4,B5,B6;
Container ct = getContentPane();
public SL(String str){
super(str);
setBak();
JPanel JP = new JPanel();
(false);
(new FlowLayout(,30,50));
B1 = new JButton("销售发票");
B2 = new JButton("退货登记");
B3 = new JButton("查询商品");
B4 = new JButton("客户信息");
B5 = new JButton("进货信息");
B6 = new JButton("更换角色");
(this);
(this);
(this);
(this);
(this);
(this);
(B1);
(B2);
(B3);
(B4);
(B5);
(B6);
add(JP);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
();
TJFP tjfp = new TJFP("日常销售—【添加发票】");
(450,400);
(450,200);
(true);
}
if(()==B2){
();
DJTH djth = new DJTH("日常销售—【登记退货】");
(400,300);
(500,250);
(true);
}
if(()==B3){
();
CXSP cxsp = new CXSP("日常销售—【查询商品】");
(300,150);
(550,250);
(true);
}
if(()==B4){
();
KHXX khxx = new KHXX("基本信息管理—【客户信息】");
(500,150);
(450,250);
(true);
}
if(()==B5){
();
JHQK jhqk = new JHQK("基本信息管理—【进货情况】");
(500,250);
(450,250);
(true);
}
if(()==B6){
();
LoginBackPanel xt = new LoginBackPanel("管理系统登录");
(300,200);
(550,250);
(true);
}
}
}
class TJFP extends JFrame implements ActionListener{
JLabel L1,L2,L3,L4,L5,L6,L7;
JTextField T1,T2,T3,T4,T5,T6,T7;
JButton B1,B2;
Container ct = getContentPane();
public TJFP(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(panel);
(new FlowLayout(,100,20));
L1 = new JLabel("开票日期: ");
L2 = new JLabel("销售票号: ");
L3 = new JLabel("商品名称: ");
L4 = new JLabel("商品编号: ");
L5 = new JLabel("商品单价(元):");
L6 = new JLabel("销售数量(个):");
L7 = new JLabel("销售金额(元):");
T1=new JTextField(10);
T2=new JTextField(10);
T3=new JTextField(10);
T4=new JTextField(10);
T5=new JTextField(10);
T6=new JTextField(10);
T7=new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(L2);
(T2);
(L3);
(T3);
(L4);
(T4);
(L5);
(T5);
(L6);
(T6);
(L7);
(T7);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="INSERT INTO 销 售 发 票
VALUES('"+()+"','"+()+"','"+()+"','"+()+"','"+
ext()+"','"+()+"','"+()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 成 功 登 记 ！ "," 提 示
",_MESSAGE);
("");
("");
("");
("");
("");
("");
("");
}
if(()==B2){
();
SL sl=new SL("销售员界面");
(500,250);
(450,250);
(true);
}
}
}
class DJTH extends JFrame implements ActionListener{
Container ct = getContentPane();
JLabel L1,L2,L3,L4,L5;
JTextField T1,T2,T3,T4,T5;
JButton B1,B2;
public DJTH(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,90,20));
L1 = new JLabel("退货日期： ");
L2 = new JLabel("商品名称： ");
L3 = new JLabel("退货原因： ");
L4 = new JLabel("退货数量/件： ");
L5 = new JLabel("退货金额/元： ");
T1=new JTextField(10);
T2=new JTextField(10);
T3=new JTextField(10);
T4=new JTextField(10);
T5=new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(L2);
(T2);
(L3);
(T3);
(L4);
(T4);
(L5);
(T5);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="INSERT INTO 退货记录(退货日期,商品名称,退货原因,[退货数量/件],[退货
金 额 / 元 ])
VALUES('"+()+"','"+()+"','"+()+"','"+()+"','"+
ext()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 退 货 成 功 ！ "," 提 示
",_MESSAGE);
("");
("");
("");
("");
("");
}
if(()==B2){
();
SL sl=new SL("销售员界面");
(500,250);
(450,250);
(true);
}
}
}
class CXSP extends JFrame implements ActionListener{
JLabel L1;
static JTextField T1;
JButton B1,B2;
Container ct = getContentPane();
public CXSP(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,20));
L1 = new JLabel("商品名称:");
T1=new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
();
CXSPXX sl=new CXSPXX("商品信息");
(700,300);
(350,250);
(true);
}
if(()==B2){
();
SL sl=new SL("销售员界面");
(500,250);
(450,250);
(true);
}
}
}
class BG1 extends AbstractTableModel{
String mc,bh,sl,dj,cj,dz;
final String[] columnNames={"商品名称","商品编号","剩余数量/件","商品单价/元","生产
厂家","生产地址"};
Object[][]data=new Object[100][6];
public BG1(){
int m=0;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e){
}
try{
con=(url,"sa","123456");
stmt=();
sql="SELECT * FROM 商品信息 WHERE(商品名称='"+()+"')";
ResultSet rs=(sql);
while(()){
mc=(1);
bh=(2);
sl=(3);
dj=(4);
cj=(5);
dz=(6);
data[m][0]=mc;data[m][1]=bh;data[m][2]=sl;data[m][3]=dj;data[m][4]=cj;data[m++][5]=dz;
}
();
();
}catch(SQLException e){
("0");
}
}
public int getColumnCount(){
return ;
}
public int getRowCount(){
return ;
}
public String getColumnName(int col){
return columnNames[col];
}
public Object getValueAt(int row,int col){
return data[row][col];
}
public void setValueAt(Object value,int row,int col){
int numRows=getRowCount();
int numCols=getColumnCount();
for(int i=0;i<numRows;i++){
for(int j=0;j<numCols;j++){
(" "+data[i][j]);
}
}
}
}
class CXSPXX extends JFrame implements ActionListener{
BG1 bg1;
JTable t;
JButton b;
JPanel p;
JScrollPane s;
public CXSPXX(String str){
super(str);
setLayout(new BorderLayout());
b = new JButton("确定");
(this);
p = new JPanel();
(b);
bg1 = new BG1();
t = new JTable(bg1);
s = new JScrollPane(t);
add(s,"Center");
add(p,"South");
}
public void actionPerformed(ActionEvent e){
if(()==b){
();
CXSP cxsp = new CXSP("日常销售—【查询商品】");
(300,150);
(550,250);
(true);
}
}
}
class KHXX extends JFrame implements ActionListener{
JButton B1,B2,B3,B4;
Container ct = getContentPane();
public KHXX(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,20));
B1 = new JButton("添加客户");
B2 = new JButton("客户信息");
B3 = new JButton("删除客户");
B4 = new JButton("返回");
(this);
(this);
(this);
(this);
(B1);
(B2);
(B3);
(B4);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
();
TJKH tjkh = new TJKH("顾客管理—【添加客户】");
(350,300);
(550,250);
(true);
}
if(()==B2){
();
HYXXCX2 hyxxcx2 = new HYXXCX2("顾客管理—【客户查询】");
(700,300);
(350,250);
(true);
}
if(()==B3){
();
SCKH sckh = new SCKH("顾客管理—【删除客户】");
(300,150);
(550,250);
(true);
}
if(()==B4){
();
SL sl = new SL("销售员界面");
(500,250);
(450,250);
(true);
}
}
}
class TJKH extends JFrame implements ActionListener{
JLabel L1,L2,L3,L4;
JTextField T1,T2,T3,T4;
JButton B1,B2;
Container ct = getContentPane();
public TJKH(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,25));
L1 = new JLabel("客户称呼");
L2 = new JLabel("联系方式");
L3 = new JLabel("客户地址");
L4 = new JLabel("入会日期");
T1=new JTextField(10);
T2=new JTextField(10);
T3=new JTextField(10);
T4=new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(L2);
(T2);
(L3);
(T3);
(L4);
(T4);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="INSERT INTO 客 户 信 息 ( 客 户 称 呼 , 联 系 方 式 , 客 户 地 址 , 入 会 日 期 )
VALUES('"+()+"','"+()+"','"+()+"','"+()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 添 加 成 功 ！ "," 提 示
",_MESSAGE);
("");
("");
("");
("");
}
if(()==B2){
();
KHXX khxx=new KHXX("基本信息管理—【客户信息】");
(500,150);
(450,250);
(true);
}
}
}
class BG9 extends AbstractTableModel{
String ch,lx,dz,rq;
final String[] columnNames={"客户称呼","联系方式","客户地址","入会日期"};
Object[][]data=new Object[100][4];
public BG9(){
int m=0;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e){
}
try{
con=(url,"sa","123456");
stmt=();
sql="SELECT * FROM 客户信息 ";
ResultSet rs=(sql);
while(()){
ch=(1);
lx=(2);
dz=(3);
rq=(4);
data[m][0]=ch;data[m][1]=lx;data[m][2]=dz;data[m++][3]=rq;
}
();
();
}catch(SQLException e){
("0");
}
}
public int getColumnCount(){
return ;
}
public int getRowCount(){
return ;
}
public String getColumnName(int col){
return columnNames[col];
}
public Object getValueAt(int row,int col){
return data[row][col];
}
public void setValueAt(Object value,int row,int col){
int numRows=getRowCount();
int numCols=getColumnCount();
for(int i=0;i<numRows;i++){
for(int j=0;j<numCols;j++){
(" "+data[i][j]);
}
}
}
}
class HYXXCX2 extends JFrame implements ActionListener{
BG5 bg5;
JTable t;
JButton b;
JPanel p;
JScrollPane s;
public HYXXCX2(String str){
super(str);
setLayout(new BorderLayout());
b = new JButton("确定");
(this);
p = new JPanel();
(b);
bg5 = new BG5();
t = new JTable(bg5);
s = new JScrollPane(t);
add(s,"Center");
add(p,"South");
}
public void actionPerformed(ActionEvent e){
if(()==b){
();
KHXX khxx=new KHXX("基本信息管理—【客户信息】");
(500,150);
(450,250);
(true);
}
}
}
class SCKH extends JFrame implements ActionListener{
JLabel L1;
JTextField T1;
JButton B1,B2;
Container ct = getContentPane();
public SCKH(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,20));
L1 = new JLabel("客户称呼");
T1=new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="DELETE FROM 客户信息 WHERE(客户称呼='"+()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 成 功 删 除 ！ "," 提 示
",_MESSAGE);
("");
}
if(()==B2){
();
KHXX khxx = new KHXX("基本信息管理—【客户信息】");
(500,150);
(450,250);
(true);
}
}
}
class JHQK extends JFrame implements ActionListener{
JButton B1,B2,B3,B4;
Container ct = getContentPane();
public JHQK(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,60));
B1 = new JButton("进货登记");
B2 = new JButton("进货复查");
B3 = new JButton("进货结账");
B4 = new JButton("返回上一界面");
(this);
(this);
(this);
(this);
(B1);
(B2);
(B3);
(B4);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
();
JHXXDJ jhxxdj = new JHXXDJ("进货登记—【进货信息】");
(400,320);
(500,220);
(true);
}
if(()==B2){
();
JHZD jhzd = new JHZD("进货审查—【进货账单】");
(700,300);
(350,250);
(true);
}
if(()==B3){
();
JHJZ jhjz = new JHJZ("进货付款—【进货结账】");
(300,200);
(500,250);
(true);
}
if(()==B4){
();
SL sl = new SL("销售员界面");
(500,250);
(450,250);
(true);
}
}
}
class JHXXDJ extends JFrame implements ActionListener{
Container ct = getContentPane();
JLabel L1,L2,L3,L4,L5,L6;
JTextField T1,T2,T3,T4,T5,T6;
JButton B1,B2;
public JHXXDJ(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,15));
L1 = new JLabel("货物名称： ");
L2 = new JLabel("进货数量/份: ");
L3 = new JLabel("进货单价/元: ");
L4 = new JLabel("总需金额/元: ");
L5 = new JLabel("付款情况： ");
L6 = new JLabel("进货日期： ");
T1=new JTextField(10);
T2=new JTextField(10);
T3=new JTextField(10);
T4=new JTextField(10);
T5=new JTextField(10);
T6=new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(L2);
(T2);
(L3);
(T3);
(L4);
(T4);
(L5);
(T5);
(L6);
(T6);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="INSERT INTO 进货信息(货物名称,[进货数量/份],[进货单价/元],[总需金额/
元 ], 付 款 情 况 , 进 货 日 期 )
VALUES('"+()+"','"+()+"','"+()+"','"+()+"','"+
ext()+"','"+()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 进 货 成 功 ！ "," 提 示
",_MESSAGE);
("");
("");
("");
("");
("");
("");
}
if(()==B2){
();
JHQK jhqk=new JHQK("基本信息管理—【进货情况】");
(500,250);
(450,250);
(true);
}
}
}
class BG8 extends AbstractTableModel{
String mc,sl,dj,je,fk,rq;
final String[] columnNames={"货物名称","进货数量/份","进货单价/元","总需金额/元","
付款情况","进货日期"};
Object[][]data=new Object[100][6];
public BG8(){
int m=0;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e){
}
try{
con=(url,"sa","123456");
stmt=();
sql="SELECT * FROM 进货信息 ";
ResultSet rs=(sql);
while(()){
mc=(1);
sl=(2);
dj=(3);
je=(4);
fk=(5);
rq=(6);
data[m][0]=mc;data[m][1]=sl;data[m][2]=dj;data[m][3]=je;data[m][4]=fk;data[m++][5]=rq;
}
();
();
}catch(SQLException e){
("0");
}
}
public int getColumnCount(){
return ;
}
public int getRowCount(){
return ;
}
public String getColumnName(int col){
return columnNames[col];
}
public Object getValueAt(int row,int col){
return data[row][col];
}
public void setValueAt(Object value,int row,int col){
int numRows=getRowCount();
int numCols=getColumnCount();
for(int i=0;i<numRows;i++){
for(int j=0;j<numCols;j++){
(" "+data[i][j]);
}
}
}
}
class JHZD extends JFrame implements ActionListener{
BG8 bg8;
JTable t;
JButton b;
JPanel p;
JScrollPane s;
public JHZD(String str){
super(str);
setLayout(new BorderLayout());
b = new JButton("确定");
(this);
p = new JPanel();
(b);
bg8 = new BG8();
t = new JTable(bg8);
s = new JScrollPane(t);
add(s,"Center");
add(p,"South");
}
public void actionPerformed(ActionEvent e){
if(()==b){
();
JHQK jhqk=new JHQK("基本信息管理—【进货情况】");
(500,250);
(450,250);
(true);
}
}
}
class JHJZ extends JFrame implements ActionListener{
JLabel L1,L2;
JTextField T1,T2;
JButton B1,B2;
Container ct = getContentPane();
public JHJZ(String str){
super(str);
setBak();
JPanel panel = new JPanel();
(false);
(new FlowLayout(,60,20));
L1 = new JLabel("货物名称:");
L2 = new JLabel("付款情况:");
T1 = new JTextField(10);
T2 = new JTextField(10);
B1 = new JButton("确定");
B2 = new JButton("返回");
(this);
(this);
(L1);
(T1);
(L2);
(T2);
(B1);
(B2);
add(panel);
}
public void setBak(){
((JPanel)()).setOpaque(false);
ImageIcon img = new ImageIcon("e://数据库课程设计//六月物语 ");
JLabel background = new JLabel(img);
().add(background, new Integer(_VALUE));
(0, 0, (), ());
}
public void actionPerformed(ActionEvent e){
if(()==B1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=课程设计";
Connection con;
String sql;
Statement stmt;
try{
("");
}catch( e1){
();
}
try{
con=(url,"sa","123456");
stmt=();
sql="UPDATE 进货信息 SET 付款情况='"+()+ "' WHERE(货物名称
='"+()+"')";
(sql);
();
();
}catch(SQLException e2){
();
}
(this," 更 新 成 功 ！ "," 提 示
",_MESSAGE);
("");
("");
}
if(()==B2){
();
JHQK jhqk=new JHQK("基本信息管理—【进货情况】");
(500,250);
(450,250);
(true);
}
}
}
