buyinfoselect.java

用java开发的一个进销存,开发工具jc, 数据库sql server

package classfile;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;
import javax.swing.table.AbstractTableModel;
import java.util.Vector;
class BuyInfoSelect extends JFrame{
	String sql;      
	String[] temp;	 
	JTextField jtcompare1,jtcompare2;	
	Vector v = new Vector();
	MyTableModel model = new MyTableModel();
	JButton jb1,jb2;	
	JComboBox jco1,jco2,jco3;	
	JTable t;
	JScrollPane js;		
	JPanel card = new JPanel();
	static final String[] title = {"VIP编号","操作员","商品编号","商品名称","商品单价","购买数量","VIP折扣","合计金额","业务日期"};	
	BuyInfoSelect(JDesktopPane jd){
		if((jd.getAllFrames().length)>=1)	
			return;	
		final JInternalFrame inf = new JInternalFrame("VIP购物信息查询",false,true,false,true);
		final Container cinf = getContentPane();
		cinf.setLayout(new FlowLayout());
		jb1 = new JButton("查   询");
		jb2 = new JButton("返   回");
		jtcompare1 = new JTextField(10);
		jtcompare2 = new JTextField(10);
		jco1 = new JComboBox();
		jco2 = new JComboBox();
		jco3 = new JComboBox();
		jco1.addItem("VIP编号");
		jco1.addItem("操作员");
		jco1.addItem("商品编号");
		jco1.addItem("商品名称");
		jco1.addItem("商品单价");
		jco1.addItem("购买数量");
		jco1.addItem("VIP折扣");
		jco1.addItem("合计金额");
		jco1.addItem("业务日期");
		jco2.addItem("   = ");
		jco2.addItem("包含");
		jco3.addItem("   < ");
		card.add(jco3);
		card.add(jtcompare2);
		card.setVisible(false);
		cinf.add(jco1);
		cinf.add(jco2);
		cinf.add(jtcompare1);
		cinf.add(card);
		cinf.add(jb1);
		cinf.add(jb2);
		inf.add(cinf);
		jd.add(inf);
		jco1.addItemListener(new ItemListener(){
			public void itemStateChanged(ItemEvent eJco3){
				if(eJco3.getItem().equals("VIP编号") || eJco3.getItem().equals("操作员") || eJco3.getItem().equals("商品编号") || eJco3.getItem().equals("商品名称")){
					jco2.removeAllItems();
					jco2.addItem("   = ");
					jco2.addItem("包含");					
					card.setVisible(false);
					System.out.println ("false");
				}
				else{
					jco2.removeAllItems();
					jco2.addItem("   = ");
					jco2.addItem("   > ");
					card.setVisible(true);
					System.out.println ("true");
				}
			}
		});
		
		jco2.addItemListener(new ItemListener(){
			public void itemStateChanged(ItemEvent eJco3){
				if(eJco3.getItem().equals("   = ")){
					jco3.setVisible(false);
					jtcompare2.setVisible(false);
				}
				else{
					jco3.removeAllItems();
					jco3.addItem("   < ");
					jco3.setVisible(true);
					jtcompare2.setVisible(true);
				}
			}
		});
		jb1.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				update(inf,cinf);
				jtcompare1.setText("");
				jtcompare2.setText("");
			}
		});	
		
		jb2.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				try{
					inf.setClosed(true);	
				}
				catch(Exception eJb2){
					System.out.println ("关闭窗体失败");
				}
			}
		});		
		
		update(inf,cinf);
		inf.setSize(650,480);
		inf.setVisible(true);
	}	
	class TableListener extends MouseAdapter{
		private JInternalFrame inf;
		private Container cinf;
		TableListener(JInternalFrame inf,Container cinf){
			this.inf = inf;
			this.cinf = cinf;
		}
	}
	void update(JInternalFrame inf,Container cinf){
		try{
			if(jtcompare1.getText().equals("")){
				sql = "select * from consume";
			}	
			else if(jco1.getSelectedItem()=="VIP编号"){
				try{
					System.out.println (jtcompare1.getText());
					Integer.parseInt(jtcompare1.getText());
					
				}
				catch(Exception eJtcompare1){
					JOptionPane.showMessageDialog(null,"VIP编号只能为数字");
					System.out.println (jtcompare1.getText());
					return;
				}				
				if(jco2.getSelectedIndex()==0)
					sql = "select * from consume where vip_no=" + jtcompare1.getText();
				else{
					sql = "select * from consume where vip_no like '%" + jtcompare1.getText() + "%'";
					
				}
			}
			else if(jco1.getSelectedItem()=="操作员"){
				if(jco2.getSelectedIndex()==0)
					sql = "select * from consume where username=" + "'" + jtcompare1.getText() + "'";
				else
					sql = "select * from consume where username like '%" + jtcompare1.getText() + "%'";
			}
			else if(jco1.getSelectedItem()=="商品编号"){
				try{
					Integer.parseInt(jtcompare1.getText());
				}
				catch(Exception eJtcompare1){
					JOptionPane.showMessageDialog(null,"商品编号只能为数字");
					return;
				}
				if(jco2.getSelectedIndex()==0)
					sql = "select * from consume where sid=" + jtcompare1.getText();
				else{
					sql = "select * from consume where sid like '%" + jtcompare1.getText() + "%'";
				}
			}
			else if(jco1.getSelectedItem()=="商品名称"){
				if(jco2.getSelectedIndex()==0)
					sql = "select * from consume where sname='" + jtcompare1.getText() + "'";
				else
					sql = "select * from consume where sname like '%" + jtcompare1.getText() + "%'";
				System.out.println (sql);
			}			
			else if(jco1.getSelectedItem()=="商品单价"){
				try{
					System.out.println (jtcompare1.getText());
					System.out.println (jtcompare2.getText());
					Integer.parseInt(jtcompare1.getText());
					if(!jtcompare2.getText().equals(""))
						Integer.parseInt(jtcompare2.getText());
				}
				catch(Exception eJtcompare1){
					System.out.println (eJtcompare1.getClass());
					JOptionPane.showMessageDialog(null,"查询失败,单价输入有误!");
					return;
				}
				if(jco2.getSelectedIndex()==0)
					sql = "select * from consume where sprice=" + jtcompare1.getText();
				else{		
					if(jtcompare2.getText().length()==0)
						sql = "select * from consume where sprice  > "+jtcompare1.getText();
					else
						sql = "select * from consume where sprice  between "+jtcompare1.getText() + "+0.1 and " + jtcompare2.getText() + "-0.1";
					System.out.println (sql);
				}
			}			
			else if(jco1.getSelectedItem()=="购买数量"){
				try{			
					Integer.parseInt(jtcompare1.getText());
					if(!jtcompare2.getText().equals(""))
						Integer.parseInt(jtcompare2.getText());
				}
				catch(Exception eJtcompare1){
					JOptionPane.showMessageDialog(null,"查询失败,数量输入有误!");
					return;
				}
				if(jco2.getSelectedIndex()==0)
					sql = "select * from consume where scount=" + jtcompare1.getText();
				else{					
					if(jtcompare2.getText().length()==0)
						sql = "select * from consume where scount  > "+jtcompare1.getText();
					else
						sql = "select * from consume where scount  between "+jtcompare1.getText() + "+0.1 and " + jtcompare2.getText() + "-0.1";
					System.out.println (sql);
				}
			}
			else if(jco1.getSelectedItem()=="VIP折扣"){
				try{
					Integer.parseInt(jtcompare1.getText());
					if(!jtcompare2.getText().equals(""))	
						Integer.parseInt(jtcompare2.getText());
				}
				catch(Exception eJtcompare1){
					JOptionPane.showMessageDialog(null,"查询失败,折扣输入有误!");
					return;
				}			
				if(jco2.getSelectedIndex()==0)
					sql = "select * from consume where sdiscount=" + jtcompare1.getText();
				else{					
					if(jtcompare2.getText().length()==0)
						sql = "select * from consume where sdiscount  > "+jtcompare1.getText();
					else
						sql = "select * from consume where sdiscount  between "+jtcompare1.getText() + "+0.1 and " + jtcompare2.getText() + "-0.1";
					System.out.println (sql);
				}
			}
			else if(jco1.getSelectedItem()=="合计金额"){
				try{
					Integer.parseInt(jtcompare1.getText());
					if(!jtcompare2.getText().equals(""))
						Integer.parseInt(jtcompare2.getText());
				}
				catch(Exception eJtcompare1){
					JOptionPane.showMessageDialog(null,"查询失败,金额输入有误!");
					return;
				}				
				if(jco2.getSelectedIndex()==0)
					sql = "select * from consume where sincome=" + jtcompare1.getText();
				else{					
					if(jtcompare2.getText().length()==0)
						sql = "select * from consume where sincome  > "+jtcompare1.getText();
					else
						sql = "select * from consume where sincome  between "+jtcompare1.getText() + "+0.1 and " + jtcompare2.getText() + "-0.1";
					System.out.println (sql);
				}
			}
			else if(jco1.getSelectedItem()=="业务日期"){
				jtcompare2.setText("");	
				if(jco2.getSelectedIndex()==0)
					sql = "select * from consume where sdate='" + jtcompare1.getText() + "'";
				else{
					
					if(jtcompare2.getText().length()==0)
						sql = "select * from consume where sdate  > '"+jtcompare1.getText() + "'";
					else
						sql = "select * from consume where sdate  between '"+jtcompare1.getText() + "' and'" + jtcompare2.getText() + "'";
					System.out.println (sql);
				}
			}							
			MakeDatebase conn = new MakeDatebase();
			conn.rct = conn.sta.executeQuery(sql);
			System.out.println (sql);

			model.setData(title,conn.rct);
			model.fireTableStructureChanged();
			if(t == null){
				t = new JTable(model);
				t.addMouseListener(new TableListener(inf,cinf));
				js = new JScrollPane(t);
				js.setPreferredSize(new Dimension(630,400));
				cinf.add(js);
			}else{
				t.setModel(model);
				t.updateUI();
			}			
			conn.closeConnection();	
		}catch(Exception e){
			e.printStackTrace();
		}		
	}	
	
}