📄 market.java
字号:
*/
public void aundry()//流水账
{
String sDispA = "select * from IntoL order by ILD desc";
DL = new JDialog(f,"流水账",true);
DL.setLayout(new BorderLayout());
try
{
rs = stmt.executeQuery(sDispA);
}
catch(SQLException sqle)
{
System.out.println(sqle.toString());
}
c=DL.getContentPane();
//c = new Container();
panel2=new JPanel();
String[] name={"商品代码","供应商名称","入库单号","入库日期","价格","已付款项","数量"}; //保存在String数组里
String[][] data1=new String[0][0];
defaultModel=new DefaultTableModel(data1,name);
table=new JTable(defaultModel);
table.setPreferredScrollableViewportSize(new Dimension(500,300));//设定高度和宽度
JScrollPane s=new JScrollPane(table);//创建JScrollPane对象并指定内部控件
panel2.add(s);
c.add(panel2,BorderLayout.CENTER);
DL.add(new Label(" 入库流水账如下"),BorderLayout.NORTH);
//DL.add(c,BorderLayout.CENTER);
JPanel cDl = new JPanel();
cDl.add(new JLabel(""));
DL.add(cDl,BorderLayout.SOUTH);
closeDL.addActionListener(mo);
try
{
//首先要删除table中的数据
int rowCount=defaultModel.getRowCount()-1;//取得table中的数据行；
int j=rowCount;
for(int i=0;i<=rowCount;i++)
{
defaultModel.removeRow(j);//删除rowCount行的数据；
defaultModel.setRowCount(j);//重新设置行数；
j=j-1;
}
while(rs.next())
{
Vector data=new Vector();
data.addElement(rs.getString(1));
data.addElement(rs.getString(2));
data.addElement(rs.getString(3));
data.addElement(rs.getString(4));
data.addElement(rs.getString(5));
data.addElement(rs.getString(6));
data.addElement(rs.getString(7));
defaultModel.addRow(data);
}
table.revalidate();//更新表格
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
DL.setSize(600,400);
DL.setLocation(300,180);
DL.setVisible(true);
}
public void DispG()//流水账
{
String sDispG = "select * from Goods";
G = new JDialog(f,"流水账",true);
G.setLayout(new BorderLayout());
try
{
rs = stmt.executeQuery(sDispG);
}
catch(SQLException sqle)
{
System.out.println(sqle.toString());
}
c=G.getContentPane();
//c = new Container();
panel2=new JPanel();
String[] name={"商品代码","商品名称","商品类别","生产日期","保质期","价格"}; //保存在String数组里
String[][] data1=new String[0][0];
defaultModel=new DefaultTableModel(data1,name);
table=new JTable(defaultModel);
table.setPreferredScrollableViewportSize(new Dimension(500,300));//设定高度和宽度
JScrollPane s=new JScrollPane(table);//创建JScrollPane对象并指定内部控件
panel2.add(s);
c.add(panel2,BorderLayout.CENTER);
G.add(new Label(" 商品列表如下"),BorderLayout.NORTH);
//DL.add(c,BorderLayout.CENTER);
JPanel cDl = new JPanel();
cDl.add(new JLabel(""));cDl.add(closeG);
G.add(cDl,BorderLayout.SOUTH);
closeG.addActionListener(mo);
try
{
//首先要删除table中的数据
int rowCount=defaultModel.getRowCount()-1;//取得table中的数据行；
int j=rowCount;
for(int i=0;i<=rowCount;i++)
{
defaultModel.removeRow(j);//删除rowCount行的数据；
defaultModel.setRowCount(j);//重新设置行数；
j=j-1;
}
while(rs.next())
{
Vector data=new Vector();
data.addElement(rs.getString(1));
data.addElement(rs.getString(2));
data.addElement(rs.getString(3));
data.addElement(rs.getString(4));
data.addElement(rs.getString(5));
data.addElement(rs.getString(6));
defaultModel.addRow(data);
}
table.revalidate();//更新表格
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
G.setSize(600,400);
G.setLocation(300,180);
G.setVisible(true);
}
public void DispS()//流水账
{
String S = "select * from suplyer";
DispS = new JDialog(f,"流水账",true);
DispS.setLayout(new BorderLayout());
try
{
rs = stmt.executeQuery(S);
}
catch(SQLException sqle)
{
System.out.println(sqle.toString());
}
c=DispS.getContentPane();
//c = new Container();
panel2=new JPanel();
String[] name={"商品代码","供应商名称","地址","电话号码","电子邮箱","传真","信誉"}; //保存在String数组里
String[][] data1=new String[0][0];
defaultModel=new DefaultTableModel(data1,name);
table=new JTable(defaultModel);
table.setPreferredScrollableViewportSize(new Dimension(500,300));//设定高度和宽度
JScrollPane s=new JScrollPane(table);//创建JScrollPane对象并指定内部控件
panel2.add(s);
c.add(panel2,BorderLayout.CENTER);
DispS.add(new Label(" 供应商情况如下"),BorderLayout.NORTH);
//DL.add(c,BorderLayout.CENTER);
JPanel cDl = new JPanel();
cDl.add(new JLabel(""));cDl.add(closeSuply);
DispS.add(cDl,BorderLayout.SOUTH);
closeSuply.addActionListener(mo);
try
{
//首先要删除table中的数据
int rowCount=defaultModel.getRowCount()-1;//取得table中的数据行；
int j=rowCount;
for(int i=0;i<=rowCount;i++)
{
defaultModel.removeRow(j);//删除rowCount行的数据；
defaultModel.setRowCount(j);//重新设置行数；
j=j-1;
}
while(rs.next())
{
Vector data=new Vector();
data.addElement(rs.getString(1));
data.addElement(rs.getString(2));
data.addElement(rs.getString(3));
data.addElement(rs.getString(4));
data.addElement(rs.getString(5));
data.addElement(rs.getString(6));
data.addElement(rs.getString(7));
// data.addElement(rs.getString(8));
defaultModel.addRow(data);
}
table.revalidate();//更新表格
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
DispS.setSize(600,400);
DispS.setLocation(300,180);
DispS.setVisible(true);
}
public void aundryOut()//出库流水账
{
String sDispA = "select * from OutL order by OLD desc";
OL = new JDialog(f,"出库流水账",true);
OL.setLayout(new BorderLayout());
try
{
rs = stmt.executeQuery(sDispA);
}
catch(SQLException sqle)
{
System.out.println(sqle.toString());
}
c=OL.getContentPane();
//c = new Container();
panel2=new JPanel();
String[] name={"商品代码","供应商名称","出库单号","出库日期","价格","已付款项","数量"}; //保存在String数组里
String[][] data1=new String[0][0];
defaultModel=new DefaultTableModel(data1,name);
table=new JTable(defaultModel);
table.setPreferredScrollableViewportSize(new Dimension(500,300));//设定高度和宽度
JScrollPane s=new JScrollPane(table);//创建JScrollPane对象并指定内部控件
panel2.add(s);
c.add(panel2,BorderLayout.CENTER);
OL.add(new Label(" 出库流水账如下"),BorderLayout.NORTH);
//DL.add(c,BorderLayout.CENTER);
JPanel cDl = new JPanel();
cDl.add(new JLabel(""));cDl.add(closeOL);
OL.add(cDl,BorderLayout.SOUTH);
closeOL.addActionListener(mo);
try
{
//首先要删除table中的数据
int rowCount=defaultModel.getRowCount()-1;//取得table中的数据行；
int j=rowCount;
for(int i=0;i<=rowCount;i++)
{
defaultModel.removeRow(j);//删除rowCount行的数据；
defaultModel.setRowCount(j);//重新设置行数；
j=j-1;
}
while(rs.next())
{
Vector data=new Vector();
data.addElement(rs.getString(1));
data.addElement(rs.getString(2));
data.addElement(rs.getString(3));
data.addElement(rs.getString(4));
data.addElement(rs.getString(5));
data.addElement(rs.getString(6));
data.addElement(rs.getString(7));
defaultModel.addRow(data);
}
table.revalidate();//更新表格
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
OL.setSize(600,400);
OL.setLocation(300,180);
OL.setVisible(true);
}
public void clear()
{
gno.setText("");
sname.setText("");
ItemNo.setText("");
price.setText("");
payed.setText("");
amount.setText("");
Calendar now=Calendar.getInstance();
String time=now.get(Calendar.YEAR)+"-"+(now.get(Calendar.MONTH)+1)+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND);
ILD.setText(time);
sno.setText("");
sAddress.setText("");
sPhoneNo.setText("");
sEmail.setText("");
sFax.setText("");
sHonor.setText("");
// sLoad.setText("");
}
public void clear2()
{
gno.setText("");
gname.setText("");
proY.setText("");
proM.setText("");
proD.setText("");
gPrice.setText("");
}
public void Rejection()
{
re = new JDialog(f,"退货管理",true);
JLabel l = new JLabel(" 商品退货信息录入");
JPanel R1 = new JPanel();
JPanel R2 = new JPanel();
JPanel reDate = new JPanel();
R1.setLayout(new GridLayout(7,2));
R1.add(new JLabel(""));R1.add(new JLabel(""));
R1.add(new JLabel("商品代码"));R1.add(gno);
R1.add(new JLabel(""));R1.add(new JLabel(""));
/* reDate.add(reY);reDate.add(new JLabel("年"));
reDate.add(reM);reDate.add(new JLabel("月"));
reDate.add(reD);reDate.add(new JLabel("日"));
R1.add(new JLabel("退货日期"));R1.add(reDate);*/
R1.add(new JLabel(""));R1.add(new JLabel(""));
R1.add(new JLabel("退货原因"));R1.add(reReason);
R1.add(new JLabel(""));R1.add(new JLabel(""));
R2.add(new JLabel(" "));
R2.add(handel);
R2.add(new JLabel(" "));
re.setLayout(new BorderLayout());
re.add(l,BorderLayout.NORTH);
re.add(R1,BorderLayout.CENTER);
re.add(R2,BorderLayout.SOUTH);
re.add(new JLabel(" "),BorderLayout.EAST);
re.add(new JLabel(" "),BorderLayout.WEST);
if(handel.getActionListeners().length == 0)
{
handel.addActionListener(new Monitor());
}
gno.addActionListener(new Monitor());
reY.addActionListener(new Monitor());
reM.addActionListener(new Monitor());
reD.addActionListener(new Monitor());
reReason.addActionListener(new Monitor());
re.setSize(600,400);
re.setLocation(350,220);
re.setVisible(true);
System.out.println("我是倩！！！！！！！！！！！");
}
public void Re()
{
// String ReDate = reY.getText()+"/"+ reM.getText()+"/"+reD.getText();
String strSql = "insert into Rejection (gno,reReason,reTimes, ReDate)" + " values ( "+
"'" +gno.getText()
// + "','" +ReDate
+ "', '" + reReason.getText()
+ "', " + 1
+ ",now())" ;
System.out.println("strSql 1 "+strSql);
try
{
rs = stmt.executeQuery("select * from LiaStock where gno = '"+ gno.getText() + "'");
System.out.println("select * from LiaStock where gno = '"+ gno.getText() + "'");
if(rs.next()) //库中有
{
System.out.println("库中有 ");
rs2 = stmt.executeQuery("select * from Rejection where gno = '"+ gno.getText() + "'");
System.out.println("select * from Rejection where gno = '"+ gno.getText() + "'");
if(rs2.next()) //退货中有
{System.out.println("0000000000000000000");
int reTime = rs2.getInt("reTimes");
String reReasons = rs2.getString("reReason");
String reasons = reReasons+" ; "+ reReason.getText();
System.out.println("reasons "+reasons );
int x = reTime+1;
String strSql2 = "update Rejection set reTimes = '" + x +"' where gno='"+ gno.getText() + "'";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -