📄 rukuchuli.java
字号:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
import java.util.*;
import java.sql.*;
import java.io.*;
public class RukuChuli extends JFrame implements ActionListener
{
JLabel lb1,lb2,lb3,lb4,lb5,lb6,lb7,lbda,lba;//lbda用来做头
JButton b1,b2,b3;
JTextField jt1,jt2,jt3,jt4,jt5,jt6;
JComboBox cbb=new JComboBox();
JComboBox cbb2=new JComboBox();
JPanel p[]=new JPanel[8];
JPanel pp=new JPanel();
JPanel p1=new JPanel();
int i=0;
int j=0;
public RukuChuli()
{
super("进货表");
cbb.addItem("");
try
{
String url="jdbc:odbc:Test";
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//String sql1="select * from spxz";
//s.executeQuery(sql1);
ResultSet r=s.executeQuery("select * from spxz");
r.first();
do{
cbb.addItem(r.getString(1));
}while(r.next());
r.close();
s.close();
}
catch(Exception e)
{
}
cbb.setSelectedIndex(0);
///////商品性质
cbb2.addItem("");
try
{
String url="jdbc:odbc:Test";
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet r=s.executeQuery("select * from gonghuodanwei");
r.first();
do{
cbb2.addItem(r.getString(2));
}while(r.next());
r.close();
s.close();
}
catch(Exception e)
{
}
cbb2.setSelectedIndex(0);
/////////商品名称
lb1=new JLabel("商品名称:");
lb2=new JLabel("商品单价:");
lb3=new JLabel("进货数量:");
lba=new JLabel("商品种类:");
lb4=new JLabel("接手人 :");
lb5=new JLabel("进货时间:");
lb6=new JLabel("进货金额:");
lb7=new JLabel("供货单位:");
lbda=new JLabel(" 进 货 表");
jt1=new JTextField(20);
jt2=new JTextField(20);
jt3=new JTextField(20);
jt4=new JTextField(20);
jt5=new JTextField(20);
jt6=new JTextField(20);
jt6.setEditable(false);
Statement s;
ResultSet rs;
b1=new JButton("确定");
b2=new JButton("取消");
b3=new JButton("增加商品种类");
Container con=getContentPane();
con.setLayout(new GridLayout(10,1));
for(int i=0;i<=7;i++)
{
p[i]=new JPanel();
p[i].setBackground(new Color(189,196,196));
}
p[0].add(lbda);
pp=new JPanel();
p1=new JPanel();
pp.setBackground(new Color(189,196,196));
pp.add(lba);
pp.add(cbb);
p[1].add(lb1);
p[1].add(jt1);
p[2].add(lb2);
p[2].add(jt2);
p[3].add(lb3);
p[3].add(jt3);
p[4].add(lb4);
p[4].add(jt4);
p[5].add(lb5);
p[5].add(jt5);
p[6].add(lb6);
p[6].add(jt6);
p1.setBackground(new Color(189,196,196));
p1.add(lb7);
p1.add(cbb2);
p[7].add(b1);
p[7].add(b2);
p[7].add(b3);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
con.add(p[0]);
con.add(pp);
// for(int i=1;i<=7;i++)
// {
con.add(p[1]);
con.add(p[2]);
con.add(p[3]);
con.add(p1);
con.add(p[4]);
con.add(p[5]);
con.add(p[6]);
con.add(p[7]);
// }
super.setVisible(true);
super.setSize(350,500);
super.setResizable(false);
}
public void actionPerformed(ActionEvent e)
{
try
{
if(e.getSource()==b2)
{
jt1.setText("");
jt2.setText("");
jt3.setText("");
jt4.setText("");
jt5.setText("");
jt6.setText("");
cbb.setSelectedIndex(0);
}
else if(e.getSource()==b3)
{
String e1=JOptionPane.showInputDialog(null,"请输入你要增加的种类:");
if(!e1.equals(""))
{
try{
String url="jdbc:odbc:Test";
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String e2="insert into spxz values('"+e1+"')";
s.executeUpdate(e2);
JOptionPane.showMessageDialog(null,"成功加入这类商品");
this.dispose();
}catch(Exception e111)
{
JOptionPane.showMessageDialog(null,"已经有这类商品了，不用添加");
}
}
else
{
JOptionPane.showMessageDialog(null,"不能为空");
}
}
else if(e.getSource()==b1)
{
if(jt1.getText().equals("")||jt2.getText().equals("")||jt3.getText().equals("")||jt4.getText().equals("")||jt5.getText().equals(""))
{
JOptionPane.showMessageDialog(null,"信息必须全部填满","提示",JOptionPane.WARNING_MESSAGE);
}
else//不为孔
{
String q1=null;
String x2=null;
String x3=null;
q1=JOptionPane.showInputDialog(null,"请输入商品名称:");
x2=JOptionPane.showInputDialog(null,"请输入商品单价:");
x3=JOptionPane.showInputDialog(null,"请输入商品数量:");
if(q1.equals(jt1.getText())&&x2.equals(jt2.getText())&&x3.equals(jt3.getText()))
{
Float i1,i2;
i1=Float.parseFloat(jt2.getText());
i2=Float.parseFloat(jt3.getText());
Float i3=i1*i2;
jt6.setText(""+i3);
String cbbS=cbb.getSelectedItem().toString();
String cbbS2=cbb2.getSelectedItem().toString();
String url="jdbc:odbc:Test";
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql1="insert into in1 "
+"values('"+jt1.getText()+"','"+jt2.getText()+"','"+jt3.getText()+"','"+jt6.getText()+"','"+jt4.getText()+"','"+jt5.getText()+"','"+cbbS+"','"+cbbS2+"')";
s.executeUpdate(sql1);
// System.out.print(1);
// float m;
// m=Float.parseFloat(jt3.getText());
// System.out.print(m);
// String sql2="insert into tj "
// +"values('"+jt1.getText()+"',1,'"+jt3.getText()+"',0,0,'"+jt3.getText()+"')";
// s.executeUpdate(sql2);
// System.out.print(21);
JOptionPane.showMessageDialog(null,"商品成功入库，可以记录","提示",JOptionPane.INFORMATION_MESSAGE);
////////////////////////////////////////////////////////////
//////////////////////接下来是账本统计功能
ResultSet re=s.executeQuery("select * from zhangben");
re.first();
do{
/////查找
if(re.getString(2).equals(jt1.getText()))
{
j=1;
break;
}
}while(re.next());
float x;
float y1,y2;
x=Float.parseFloat(jt6.getText());
System.out.println("总金额"+x);
if(j==1)
{
y1=Float.parseFloat(re.getString(3));//进货数量
y2=Float.parseFloat(re.getString(5));//紧，俄
y1=y1+x;
y2=y2-x;
System.out.println(y1);
System.out.println(y2);
String sq="update zhangben set jhjg ='"+y1+"',yl='"+y2+"' where spmc ='"+jt1.getText()+"' ";
s.executeUpdate(sq);
JOptionPane.showMessageDialog(null,"账本处理完毕","提示",JOptionPane.INFORMATION_MESSAGE);
}
else if(j==0)
{
String sq1="insert into zhangben "
+ "values('"+jt1.getText()+"','"+x+"',0,'"+(-x)+"','"+cbbS+"')";
s.executeUpdate(sq1);
JOptionPane.showMessageDialog(null,"账本添加成功","提示",JOptionPane.INFORMATION_MESSAGE);
}
///////////////////////////接下来是统计功能模块
///////////首先查找这个货物有没有
ResultSet rs=s.executeQuery("select * from tj");
rs.first();
do{
/////查找
if(rs.getString(2).equals(jt1.getText()))
{
i=1;
break;
}
}while(rs.next());
if(i==1)
{
String s1,s2,s3,s4,s5;
float m1,m2,m3,m4,m5;
s1=rs.getString(3);
m1=Float.parseFloat(s1);
m1++;
s3=jt3.getText();
m3=Float.parseFloat(s3);
s2=rs.getString(4);
m2=Float.parseFloat(s2);
m2=m2+m3;
s4=rs.getString(7);
m4=Float.parseFloat(s4);
m4=m4+m3;
System.out.print(m1);
s5=rs.getString(8);
m5=Float.parseFloat(s5);
m5=m5-Float.parseFloat(jt6.getText());
System.out.print(m1);
System.out.print(m2);
System.out.print(m3);
String sql2="update tj set jinsl ='"+m1+"',jinhuo='"+m2+"',zlsum='"+m4+"',yl='"+m5+"' where spmc ='"+jt1.getText()+"' ";
s.executeUpdate(sql2);
JOptionPane.showMessageDialog(null,"商品数量成功已经更新","提示",JOptionPane.INFORMATION_MESSAGE);
}////////////////////i===1
else if(i==0)
{
float x1;
x1=Float.parseFloat(jt6.getText());
String sql2="insert into tj "
+"values('"+jt1.getText()+"',1,'"+jt3.getText()+"',0,0,'"+jt3.getText()+"','"+(-x1)+"','"+cbbS+"')";
s.executeUpdate(sql2);
JOptionPane.showMessageDialog(null,"原本没有该商品，现在加入成功","提示",JOptionPane.INFORMATION_MESSAGE);
}////////////////i==0
jt1.setText("");
jt2.setText("");
jt3.setText("");
jt4.setText("");
jt5.setText("");
jt6.setText("");
cbb.setSelectedIndex(0);
cbb2.setSelectedIndex(0);
}//////////equal
else{
JOptionPane.showMessageDialog(null,"两次输入的不一样，所以不能出库");
jt1.setText("");
jt2.setText("");
jt3.setText("");
jt4.setText("");
jt5.setText("");
jt6.setText("");
cbb.setSelectedIndex(0);
cbb2.setSelectedIndex(0);
}
}//////////////不为空
}//////e.soure=b1
}//try
catch(Exception we)
{
}//catch
}////public class
public static void main(String args[])
{
new RukuChuli();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -