fpanel14.java

丽婴房库存销售系统 描述：C/S构架

package src1;
import java.awt.Color;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.util.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;

//import lyf.InsertTest;
//import lyf.InsertTest.jButton1_ActionHandler;
//import lyf.InsertTest.jButton2_ActionHandler;
public class FPanel14 extends FunctionPanel implements ActionListener{

	private Connection connect=null;
    private Statement st=null;
    private ResultSet rset=null;
    private JButton jButton1=null;
    private JButton jButton2=null;
    private JLabel jlabel1,jlabel2,jlabel3,jlabel4;
    private JTextField jTextField1,jTextField2,jTextField3,jTextField4,jTextField5;
    private JTable jTable=null;
    private JPanel jPanel1,jPanel2;
    private String sql=null;
    DefaultTableModel model=new DefaultTableModel();
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public FPanel14() {
		operationLabel.setText("操作：总出库量");
		
		// TODO Auto-generated constructor stub
		jTable=new JTable(model);
		InitTable();
		this.setLayout(null);
		jButton1=new JButton("查询");
		jButton2=new JButton("总量统计");
		jTextField1=new JTextField(9);
		jTextField2=new JTextField(9);
		jTextField3=new JTextField(9);
		jTextField4=new JTextField(9);
		jTextField5=new JTextField(9);
		jlabel1 = new JLabel("产 品 号  ");
		jlabel2 = new JLabel("仓 库 号  ");
		jlabel3 = new JLabel("时间范围");
		jlabel4= new JLabel("至");
		jlabel1.setBounds(50, 20, 70, 23);jTextField1.setBounds(110, 20, 70, 23);
		jlabel2.setBounds(50, 80, 70, 23);jTextField2.setBounds(110, 80, 70, 23);
		jlabel3.setBounds(200, 20,70, 23);jTextField3.setBounds(260, 20, 70, 23);
		jlabel4.setBounds(335, 20,20, 20);jTextField4.setBounds(350, 20,70, 23);
		jButton1.setBounds(100,130,90,30);jButton2.setBounds(250,130,90,30);
		jTextField5.setBounds(360, 130,60, 28);
		jPanel1=new JPanel();
		jPanel2=new JPanel();
		jPanel1.setBounds(20, 40, 500, 160);
		jPanel1.setLayout(null);
		jPanel2.setBounds(20, 220, 550, 300);
		
		jPanel1.add(jTextField1);jPanel1.add(jlabel1);
		jPanel1.add(jTextField2);jPanel1.add(jlabel2);
		jPanel1.add(jTextField3);jPanel1.add(jlabel3);
		jPanel1.add(jTextField4);jPanel1.add(jlabel4);
		jPanel1.add(jTextField5);
		jPanel1.add(jButton1);
		jPanel1.add(jButton2);
		
		jPanel1.setBackground(new Color(240,255,255));
		jPanel2.setBackground(new Color(240,255,255));
		
		this.add(jPanel1);
		this.add(jPanel2);
		jPanel1.setVisible(true);jPanel2.setVisible(true);
		
		jButton1.addActionListener(this);
		//this.setSize(600, 600);
		this.setVisible(false);
		
	}
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		int rowCount=model.getRowCount()-1;
		while(rowCount>=0){
			model.removeRow(rowCount);
			model.setRowCount(rowCount);
			rowCount--;
		}
		if(jTextField1.getText().trim().equals("")){
			JOptionPane.showMessageDialog(null,"产品号不许为空！");
			return;
		}
		if(jTextField2.getText().trim().equals("")){
			JOptionPane.showMessageDialog(null,"仓库号不许为空！");
			return;
		}
		if(jTextField3.getText().trim().equals("") || jTextField3.getText().trim().equals("")){
			JOptionPane.showMessageDialog(null,"时间不许为空！");
			return;
		}
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
	try{
		connect=DriverManager.getConnection("jdbc:odbc:MSSQL");
		st=connect.createStatement();
		//st.executeUpdate(sql);
		//connect.commit();
	}catch (SQLException e2) {
		// TODO Auto-generated catch block
		e2.printStackTrace();
		
	}
	
	sql="select * from 出库表 where 产品号=";
	sql=sql+"'"+jTextField1.getText().trim()+
	"' and 仓库号='"+jTextField2.getText().trim()+"' and 出库时间 between '"+
	Date.parse(jTextField3.getText().trim())+"' and '"+jTextField3.getText().trim()+"';";
	
	try{
		rset=st.executeQuery(sql);
		while(rset.next()){
			Vector<String> tempvector=new Vector<String>(1,1);
			tempvector.add(rset.getString("出库单号"));
			tempvector.add(rset.getString("产品号"));
			tempvector.add(rset.getString("仓库号"));
			tempvector.add(rset.getString("出库量"));
			tempvector.add(rset.getString("出库时间"));
			model.addRow(tempvector);
			}
		System.out.println(sql);
	}catch (SQLException e3) {
		// TODO Auto-generated catch block
		e3.printStackTrace();
		
	}
	if(e.getSource()==jButton2){
		int total=0;
		try {
			while(rset.next()){
				total=total+rset.getInt("出库量");
			}
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		jTextField4.setText(String.valueOf(total));
	}
		
	}
	void InitTable(){
		model.addColumn("出库单号");
		model.addColumn("产品号");
		model.addColumn("仓库号");
		model.addColumn("出库量");
		model.addColumn("出库时间");
	}

}