booksale.java

站长这都是自己写的 一定要帮我开通啊谢谢了

	    deleteclear.setSize(80,20);
	    deleteclear.setLocation(40,360);
	    
	    returntoselect=new JButton("返回");
	    returntoselect.setFont(myFont);
	    returntoselect.setForeground(color);
	    returntoselect.setSize(80,20);
	    returntoselect.setLocation(180,360);
	    
	    deletekucun=new JButton("删除库存");
	    deletekucun.setFont(myFont);
	    deletekucun.setForeground(color);
	    deletekucun.setSize(120,20);
	    deletekucun.setLocation(130,255);
	    
	    deletemanager=new JButton("删除管理员");
	    deletemanager.setFont(myFont);
	    deletemanager.setForeground(color);
	    deletemanager.setSize(120,20);
	    deletemanager.setLocation(130,290);
	    
	    deleteprovider=new JButton("删除供应商");
	    deleteprovider.setFont(myFont);
	    deleteprovider.setForeground(color);
	    deleteprovider.setSize(120,20);
	    deleteprovider.setLocation(130,325);
	    
        ButtonGroup bg1=new ButtonGroup();//按钮组
        
        addchoice1=new JRadioButton("库存表");       
		bg1.add(addchoice1);
		addchoice1.setFont(myFont);
		addchoice1.setSize(80,25);
		addchoice1.setForeground(color);
		addchoice1.setBackground(null);
		addchoice1.setLocation(10,255);
        //?怎么样将初始状态选择为 库存表
		
	    addchoice2=new JRadioButton("供应商表");	    
	    bg1.add(addchoice2);
	    addchoice2.setFont(myFont);
	    addchoice2.setSize(100,25);
	    addchoice2.setForeground(color);
		addchoice2.setBackground(null);
		addchoice2.setLocation(10,325);
		
		addchoice3=new JRadioButton("管理员表");	    
	    bg1.add(addchoice3);
	    addchoice3.setFont(myFont);
	    addchoice3.setSize(100,25);
	    addchoice3.setForeground(color);
		addchoice3.setBackground(null);
		addchoice3.setLocation(10,290);
				
		Container deletecp=getContentPane();	
		deletecp.setLayout(null);//将布局方式设置为空
		
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setSize(300,450);
			
		deletecp.add(hint);
		deletecp.add(hint1);
		deletecp.add(ID);
		deletecp.add(Password);											
		deletecp.add(bookname);	 		
		deletecp.add(bookISBN);
		deletecp.add(provider);
		deletecp.add(Tprovider);
		deletecp.add(Tbookname);
		deletecp.add(TbookISBN);
		deletecp.add(deleteclear);
		deletecp.add(returntoselect);
		deletecp.add(deletekucun);
		deletecp.add(deleteprovider);
		deletecp.add(deletemanager);
		deletecp.add(addchoice1);
		deletecp.add(addchoice2);
		deletecp.add(addchoice3);
		
		addchoice1.addItemListener(this);
		addchoice2.addItemListener(this);
		addchoice3.addItemListener(this);
		deletekucun.addActionListener(this);
		deleteprovider.addActionListener(this);
		deletemanager.addActionListener(this);
		returntoselect.addActionListener(this);
		deleteclear.addActionListener(this);
		
		deletecp.setBackground(new Color(240,248,255));
		setVisible(false);//将窗口设置为可见
   }

	public void actionPerformed(ActionEvent e) 
	{
		if(e.getSource()==returntoselect)
		{
			this.setVisible(false);
			selectface.setVisible(true);		
	    }
		else if(e.getSource()==deleteclear)
		{
			deleteclear();
		}
		else
		try
		{
			String getinfor1=Tbookname.getText();
			String getinfor2=TbookISBN.getText();
			String getinfor3=Tprovider.getText();
			String deletekucunsql="delete from kucun where bookname='"+getinfor1+"'and ISBN='"+getinfor2+"'";
			String deletemanagersql="delete from manager where ID='"+getinfor1+"'and PS='"+getinfor2+"'";
			String deleteprovidersql="delete from provider where bookname='"+getinfor1+"'and ISBN='"+getinfor2+"'and provider='"+getinfor3+"'";
			if(e.getSource()==deletekucun)
			{
				if(getinfor1.length()==0||getinfor2.length()==0)
				{  
					JOptionPane.showMessageDialog(null,"输入错误或您输入的书名不存在");
				}
				else
				methods.change(deletekucunsql);
			}
			else if(e.getSource()==deletemanager)
			{
				if(getinfor1.length()==0||getinfor2.length()==0)
				{  
					JOptionPane.showMessageDialog(null,"输入错误或您输入的ID不存在");
				}
				else
				methods.change(deletemanagersql);
			}
			else if(e.getSource()==deleteprovider)
			{
				if(getinfor1.length()==0||getinfor2.length()==0||getinfor3.length()==0)
				{  
					JOptionPane.showMessageDialog(null,"输入错误或您输入的书名不存在");
				}
				else
				methods.change(deleteprovidersql);
			}
		}catch(Exception eq){System.out.print(eq.getMessage());}
	}

	private void deleteclear() 
	{
		Tprovider.setText(null);
		Tbookname.setText(null);
		TbookISBN.setText(null);
	}

	@SuppressWarnings("deprecation")
	public void itemStateChanged(ItemEvent e)
	{
		try
		{
			JRadioButton Choice=(JRadioButton)e.getItemSelectable();
			if(Choice.getLabel()=="库存表")
			{ 
				deletemanager.setEnabled(false);
				deleteprovider.setEnabled(false);
				deletekucun.setEnabled(true);
				deleteclear();
				kucunvisible();
			}
			else if(Choice.getLabel()=="供应商表")
			{
				deletemanager.setEnabled(false);
				deleteprovider.setEnabled(true);
				deletekucun.setEnabled(false);
				deleteclear();
				stockvisible();
			}
			else if(Choice.getLabel()=="管理员表")
			{
				deletekucun.setEnabled(false);
				deleteprovider.setEnabled(false);
				deletemanager.setEnabled(true);
				deleteclear();
				managervisible();
			}
		}catch(NullPointerException er){System.out.print(er.getMessage());}
	}
	
	private void managervisible() {
		ID.setVisible(true);
		Password.setVisible(true);
		provider.setVisible(false);
		Tprovider.setVisible(false);
		bookname.setVisible(false);
		bookISBN.setVisible(false);
		Tprovider.setVisible(false);
	}

	private void stockvisible() {
		bookname.setVisible(true);
		bookISBN.setVisible(true);
		ID.setVisible(false);
		Password.setVisible(false);
		provider.setVisible(true);
		Tprovider.setVisible(true);
	}

	private void kucunvisible() {
		bookname.setVisible(true);
		bookISBN.setVisible(true);
		provider.setVisible(false);
		Tprovider.setVisible(false);
		ID.setVisible(false);
		Password.setVisible(false);
		Tprovider.setVisible(false);
	}
}

//查询操作
class query extends JFrame implements ActionListener
{
	private static final long serialVersionUID = 1L;
	
	method methods=new method();
	
	JLabel hint;//显示"请输入关键字进行查询"
	JTextField Tkeyword;
	JTextArea showkeyinfor=new JTextArea();
	JScrollPane showkeyinforscroll=new JScrollPane(showkeyinfor);
	JButton gogo;//显示"库存"
	JButton gogo1;//显示"供应商"
	JButton gogo2;//显示"退货"
	JButton gogo3;//显示"销售"
	JButton gogo4;//显示"进货"
	JButton queryclear;//显示"清除"
	JButton returntoselect;//显示"返回"
	
	selectface selectface;
	
	public query(selectface selectptr)
	{
        super("欢迎进入图书销售系统查询界面");
        
        selectface=selectptr;
        
        Font myFont=new Font("宋体",Font.PLAIN,16);
    	Color color=new Color(34,139,34);
		
        hint=new JLabel("请输入关键字进行查询"); 
        hint.setFont(myFont);
        hint.setSize(230,25);
        hint.setLocation(10,10);
	    
        Tkeyword=new JTextField();
        Tkeyword.setFont(myFont);
        Tkeyword.setForeground(new Color(65,105,225));
        Tkeyword.setSize(285,25);
        Tkeyword.setLocation(10,45);
	    
	    gogo=new JButton("库存");
	    gogo.setFont(myFont);
	    gogo.setForeground(color);
	    gogo.setSize(100,25);
	    gogo.setLocation(10,80);
	    
	    gogo1=new JButton("供应商");
	    gogo1.setFont(myFont);
	    gogo1.setForeground(color);
	    gogo1.setSize(100,25);
	    gogo1.setLocation(10,115);
	    
	    gogo2=new JButton("退货");
	    gogo2.setFont(myFont);
	    gogo2.setForeground(color);
	    gogo2.setSize(100,25);
	    gogo2.setLocation(10,150);
	    
	    gogo3=new JButton("销售");
	    gogo3.setFont(myFont);
	    gogo3.setForeground(color);
	    gogo3.setSize(100,25);
	    gogo3.setLocation(10,185);
	    
	    gogo4=new JButton("进货");
	    gogo4.setFont(myFont);
	    gogo4.setForeground(color);
	    gogo4.setSize(100,25);
	    gogo4.setLocation(10,220);
	    
	    
	    returntoselect=new JButton("返回");
	    returntoselect.setFont(myFont);
	    returntoselect.setForeground(color);
	    returntoselect.setSize(100,25);
	    returntoselect.setLocation(10,290);
	    
	    queryclear=new JButton("清除");
	    queryclear.setFont(myFont);
	    queryclear.setForeground(color);
	    queryclear.setSize(100,25);
	    queryclear.setLocation(10,255);	
	    
	    showkeyinforscroll.setForeground(color);
	    showkeyinforscroll.setBackground(new Color(240,248,255));
	    showkeyinforscroll.setSize(180,295);
	    showkeyinforscroll.setLocation(115,80);
	    
	    Container querycp=getContentPane();	
		querycp.setLayout(null);
		
		querycp.add(hint);
		querycp.add(Tkeyword);
		querycp.add(gogo);
		querycp.add(gogo1);
		querycp.add(gogo2);
		querycp.add(gogo3);
		querycp.add(gogo4);
		querycp.add(queryclear);
		querycp.add(showkeyinforscroll);
		querycp.add(returntoselect);
		
		gogo.addActionListener(this);
		gogo1.addActionListener(this);
		gogo2.addActionListener(this);
		gogo3.addActionListener(this);
		gogo4.addActionListener(this);
		returntoselect.addActionListener(this);
		queryclear.addActionListener(this);
		
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setSize(315,450);
		
		querycp.setBackground(new Color(65,105,225));
		setVisible(false);
	}

	public void actionPerformed(ActionEvent e) 
	{
		try
		{
			String getkey=Tkeyword.getText();
		    if(e.getSource()==queryclear)
			{
				showkeyinfor.setText(null);
			}
			else if(e.getSource()==returntoselect)
			{
				this.setVisible(false);
				selectface.setVisible(true);
			}
		    else if(e.getSource()==gogo)
		    {
		    	showkeyinfor.setText(null);
		    	methods.query("kucun", "bookname", "ISBN",getkey, showkeyinfor);
		    	isshow();
		    }	
		    else if(e.getSource()==gogo1)
		    {
		    	showkeyinfor.setText(null);
		    	methods.query("provider", "bookname", "ISBN",getkey, showkeyinfor);
		    	isshow();
		    }
		    else if(e.getSource()==gogo2)
		    {
		    	showkeyinfor.setText(null);
		    	methods.query("tuihuo", "bookname", "ISBN", getkey, showkeyinfor);
		    	isshow();
		    }
		    else if(e.getSource()==gogo3)
		    {
		    	showkeyinfor.setText(null);
		    	methods.query("rxiaoshou", "bookname", "ISBN", getkey, showkeyinfor);
		    	isshow();
		    }
		    else if(e.getSource()==gogo4)
		    {
		    	showkeyinfor.setText(null);
		    	methods.query("jhuoku", "bookname", "ISBN", getkey, showkeyinfor);
		    	isshow();
		    }
		    
		}catch(Exception eq){System.out.print(eq.getMessage());}	
	}

	/**
	 * @throws HeadlessException
	 */
	private void isshow() throws HeadlessException
	{
		if(showkeyinfor.getText().length()==0)
		{
			JOptionPane.showMessageDialog(null,"你要查询的纪录不存在！");
		}
	}	
}

class method 
{
	int nowmount=0;//将库存的图书现在的数量赋值给nowmount
	String kucunbookname=null;//将库存的图书的书名赋值给kucunboolname
	String kucunauthor=null;//将库存的图书的作者赋值给kucunauthor
	float kuc