vipselect.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 VIPSelect extends JFrame{
	String sql;       
	String[] temp;		
	JTextField jtcompare1,jtcompare2;
	JButton jb1,jb2;
	JComboBox jco1,jco2,jco3;
	JTable t = null;
	
	MyTableModel model = new MyTableModel();
	JScrollPane js;
	static final String[] title = {"VIP编号","VIP姓名","家庭住址","出生日期","职业"};	
	VIPSelect(){}
	VIPSelect(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("VIP姓名");
		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("VIP编号") || eJco3.getItem().equals("VIP姓名") || 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);
			}
		});	
		
		jb2.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				try{
					inf.setClosed(true);
				}
				catch(Exception eJb2){
					System.out.println ("关闭窗体失败");
				}
			}
		});		
		
		update(inf,cinf);
		inf.setSize(600,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)
				return;
			Vector 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]);
			System.out.println (temp[4]);
			
			try{
				new VIPInfo().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 vip_no,vip_name,vip_age,vip_date,vip_type from VIPID";
			}	
			else if(jco1.getSelectedItem()=="VIP编号"){
				if(jco2.getSelectedIndex()==0)
					sql = "select vip_no,vip_name,vip_age,vip_date,vip_type from VIPID where vip_no=" + jtcompare1.getText();
				else
					sql = "select vip_no,vip_name,vip_age,vip_date,vip_type from VIPID where vip_no like '%" + jtcompare1.getText() + "%'";
			}
			else if(jco1.getSelectedItem()=="VIP姓名"){
				if(jco2.getSelectedIndex()==0)
					sql = "select vip_no,vip_name,vip_age,vip_date,vip_type from VIPID where vip_name=" + "'" + jtcompare1.getText() + "'";
				else
					sql = "select vip_no,vip_name,vip_age,vip_date,vip_type from VIPID where vip_name like '%" + jtcompare1.getText() + "%'";
			}
			else if(jco1.getSelectedItem()=="家庭住址"){
				if(jco2.getSelectedIndex()==0)
					sql = "select vip_no,vip_name,vip_age,vip_date,vip_type from VIPID where vip_age='" + jtcompare1.getText() + "'";
				else
					sql = "select vip_no,vip_name,vip_age,vip_date,vip_type from VIPID where vip_age like '%" + jtcompare1.getText() + "%'";
			}
			else if(jco1.getSelectedItem()=="出生日期"){
				if(jco2.getSelectedIndex()==0)
					sql = "select vip_no,vip_name,vip_age,vip_date,vip_type from VIPID where vip_date=" + "'" + jtcompare1.getText() + "'";
				else
				{
					if(jtcompare2.getText().length()==0)
						sql = "select vip_no,vip_name,vip_age,vip_date,vip_type from VIPID where vip_date  > '"+jtcompare1.getText() + "'";
					else
						sql = "select vip_no,vip_name,vip_age,vip_date,vip_type from VIPID where vip_date  between '"+jtcompare1.getText() + "' and '" + jtcompare2.getText() + "'";
					System.out.println (sql);								
				}
			}
			MakeDatebase conn = new MakeDatebase();
			System.out.println (sql);
			conn.rct = conn.sta.executeQuery(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){
			System.out.println ("error");
		}		
	}	
}