infoselect.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 InfoSelect extends JFrame{
	String sql;       
	String[] temp;	  
	JTextField jtcompare1,jtcompare2;	
	JButton jb1,jb2;	
	JComboBox jco1,jco2,jco3;
	JTable t;
	Vector v = new Vector();
	MyTableModel model = new MyTableModel();
	JScrollPane js;
	static final String[] title = {"商品编号","商品名称","商品价格","商品数量","商品折扣"};	
	InfoSelect(JDesktopPane jd){
		if((jd.getAllFrames().length)>=1)
			return;	
		final JInternalFrame inf = new JInternalFrame("商品信息查询窗口",false,true,false,true);
		final Container cinf = getContentPane();
		cinf.setLayout(new FlowLayout());
		jb1 = new JButton("查   询");
		jb2 = new JButton("返   回");
		jtcompare1 = new JTextField(8);
		jtcompare2 = new JTextField(8);
		jco1 = new JComboBox();
		jco2 = new JComboBox();
		jco3 = new JComboBox();
		jco1.addItem("按商品编号");
		jco1.addItem("按商品名称");
		jco1.addItem("按商品价格");
		jco1.addItem("按商品数量");
		jco1.addItem("按商品折扣");
		jco2.addItem("   = ");
		jco2.addItem("包含");
		jco3.setVisible(false);
		jtcompare2.setVisible(false);
		cinf.add(jco1);
		cinf.add(jco2);
		cinf.add(jtcompare1);
		cinf.add(jco3);
		cinf.add(jtcompare2);
		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("按商品编号") || eJco3.getItem().equals("按商品名称")){
					jco2.removeAllItems();
					jco2.addItem("   = ");
					jco2.addItem("包含");					
					System.out.println ("false");
				}
				else{
					jco2.removeAllItems();
					jco2.addItem("   = ");
					jco2.addItem("   > ");
					System.out.println ("true");
				}
			}
		});
		
		jco2.addItemListener(new ItemListener(){
			public void itemStateChanged(ItemEvent eJco3){
					if(eJco3.getItem().equals("   = ")){
						jco3.setVisible(false);
						jtcompare2.setVisible(false);
					}
					else if(eJco3.getItem().equals("   > ")){
						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(580,400);
		inf.setVisible(true);
	}	
	class TableListener extends MouseAdapter{
		private JInternalFrame inf;
		private Container cinf;
		TableListener(JInternalFrame inf,Container cinf){
			this.inf = inf;
			this.cinf = cinf;
		}
		public void mouseReleased(MouseEvent e) {
			int id = t.getSelectedRow();
			if(id==-1){
				System.out.println (id);
				return;
			}
			v = ((MyTableModel)t.getModel()).getRowData(id);
			System.out.println (id);
			temp = new String[5];
			temp[0] = (String)v.get(0);
			temp[1] = (String)v.get(1);
			temp[2] = (String)v.get(2);
			temp[3] = (String)v.get(3);
			temp[4] = (String)v.get(4);
			System.out.println (temp[0]);
			System.out.println (temp[1]);
			System.out.println (temp[2]);
			System.out.println (temp[3]);
			try{
				new ShopInfo().ifLoad(temp[0],temp[1],temp[2],temp[3],temp[4]);
				update(inf,cinf);
			}
			catch(Exception et){
				System.out.println ("提取数据出错");
			}
		}
	}
	
	void update(JInternalFrame inf,Container cinf){
		try{
			if(jtcompare1.getText().equals("")){
				sql = "select * from commodiy_id";
			}	
			else if(jco1.getSelectedItem()=="按商品编号"){
				if(jco2.getSelectedIndex()==0)
					sql = "select * from commodiy_id where sid=" + jtcompare1.getText();
				else
					sql = "select * from commodiy_id where sid like '%" + jtcompare1.getText() + "%'";
			}
			else if(jco1.getSelectedItem()=="按商品名称"){
				if(jco2.getSelectedIndex()==0)
					sql = "select * from commodiy_id where sname=" + "'" + jtcompare1.getText() + "'";
				else
					sql = "select * from commodiy_id where sname like '%" + jtcompare1.getText() + "%'";
			}
			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 commodiy_id where sprice=" + jtcompare1.getText();
				else{
					if(jtcompare2.getText().length()==0)
						sql = "select * from commodiy_id where sprice  > "+jtcompare1.getText();
					else
						sql = "select * from commodiy_id where sprice  between "+jtcompare1.getText() + "+0.1 and " + jtcompare2.getText() + "-0.1";
					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 commodiy_id where scount=" + jtcompare1.getText();
				else{
					if(jtcompare2.getText().length()==0)
						sql = "select * from commodiy_id where scount  > "+jtcompare1.getText();
					else
						sql = "select * from commodiy_id where scount  between "+jtcompare1.getText() + "+0.1 and " + jtcompare2.getText() + "-0.1";
					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 commodiy_id where sdiscount=" + "'" + jtcompare1.getText() + "'";
				else{
					if(jtcompare2.getText().length()==0)
						sql = "select * from commodiy_id where sdiscount  > "+jtcompare1.getText();
					else
						sql = "select * from commodiy_id where sdiscount  between "+jtcompare1.getText() + "+0.1 and " + jtcompare2.getText() + "-0.1";
					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(550,300));
				cinf.add(js);
			}else{
				t.setModel(model);
				t.updateUI();
			}			
			conn.closeConnection();	
		}catch(Exception e){
			e.printStackTrace();
		}		
	}	
	
}