frameproductstoryinformation.java

鞋类企业信息管理系统Java,这是一个毕业设计

import javax.swing.*;

import java.sql.*;
import java.awt.*;
import java.awt.event.*;


public class FrameProductStoryInformation extends JFrame {
	ResultSet rs;
	String sql;
	private DB_Manager db =new DB_Manager();
	JLabel lb1 = new JLabel("款型",JLabel.RIGHT),
	       lb2 = new JLabel("          颜色",JLabel.RIGHT),
	       lb36 = new JLabel("36 ",JLabel.RIGHT),
	       lb37 = new JLabel("37 ",JLabel.RIGHT),
	       lb38 = new JLabel("38 ",JLabel.RIGHT),
	       lb39 = new JLabel("39 ",JLabel.RIGHT),
	       lb40 = new JLabel("40 ",JLabel.RIGHT),
	       lb41 = new JLabel("41 ",JLabel.RIGHT),
	       lb42 = new JLabel("42 ",JLabel.RIGHT),
	       lb43 = new JLabel("43 ",JLabel.RIGHT),
	       lb44 = new JLabel("44 ",JLabel.RIGHT);
	
	JTextField jTextkuanxing = new JTextField(8),
	           jText36 = new JTextField(8),
	           jText37 = new JTextField(8),
	           jText38 = new JTextField(8),
	           jText39 = new JTextField(8),
	           jText40 = new JTextField(8),
	           jText41 = new JTextField(8),
	           jText42 = new JTextField(8),
	           jText43 = new JTextField(8),
	           jText44 = new JTextField(8);
	
	JComboBox jCombocolor = new JComboBox();
	
	JButton jButtonSearch = new JButton("查询");
	JButton jButtonfirst = new JButton("第一条");
	JButton jButtonpre = new JButton("前一条");
	JButton jButtonnext = new JButton("下一条");
	JButton jButtonlast = new JButton("最后一条");
	JButton jButtonupdate = new JButton("更新");
	JButton jButtondelete = new JButton("删除");
	JButton jButtonCancel = new JButton("退出");
	
	private void makeGUI(){
		
		jCombocolor.addItem("");
		jCombocolor.addItem("red");
		jCombocolor.addItem("black");
		jCombocolor.addItem("blue");
		Container cp = getContentPane();
		cp.setLayout(new BorderLayout());
		
		JPanel jpNorth = new JPanel();
		jpNorth.add(lb1);   jpNorth.add(jTextkuanxing);
		jpNorth.add(lb2);   jpNorth.add(jCombocolor);
		jpNorth.add(new JLabel("    "));
		jpNorth.add(jButtonSearch);
		cp.add(jpNorth,BorderLayout.NORTH);
		
		JPanel jpCenter = new JPanel();
		jpCenter.setLayout(new GridLayout(3,6,6,40));
		jpCenter.add(lb36);   jpCenter.add(jText36);
		jpCenter.add(lb39);   jpCenter.add(jText39);
		jpCenter.add(lb42);   jpCenter.add(jText42);
		jpCenter.add(lb37);   jpCenter.add(jText37);
		jpCenter.add(lb40);   jpCenter.add(jText40);
		jpCenter.add(lb43);   jpCenter.add(jText43);
		jpCenter.add(lb38);   jpCenter.add(jText38);
		jpCenter.add(lb41);   jpCenter.add(jText41);
		jpCenter.add(lb44);   jpCenter.add(jText44);
		cp.add(jpCenter,BorderLayout.CENTER);
		
		JPanel jpSouch = new JPanel();
		jpSouch.setLayout(new FlowLayout());
		jpSouch.add(jButtonfirst);
		jpSouch.add(jButtonpre);
		jpSouch.add(jButtonnext);
		jpSouch.add(jButtonlast);
		jpSouch.add(jButtonupdate);
		jpSouch.add(jButtondelete);
		jpSouch.add(jButtonCancel);
		cp.add(jpSouch,BorderLayout.SOUTH);
		cp.add(new JLabel("                 "),BorderLayout.EAST);
	}
	
	private void eventAction(){
		jButtonSearch.addActionListener(
			new ActionListener(){
				public void actionPerformed(ActionEvent e){
                  //定义变量，用来判断是否是第一个查询条件
				    boolean  isfirst =true;
				    sql="select * from ProductStore ";
				     if (jTextkuanxing.getText().trim().length() ==0)
				   //如果款型的查询条件不为空
				     {}
				     else
				     {
				        sql=sql+"  where  Model='"+jTextkuanxing.getText().trim()+"'";
				        isfirst=false;
				      }
				  //如果颜色的查询条件不为空
				    if (jCombocolor.getSelectedItem().toString().trim() .length() ==0)
				    {}
				    else
				    {
				      if (isfirst)
				   //如果是第一个查询条件
				      sql=sql+" where Color='"+jCombocolor.getSelectedItem().toString().trim() +"'";
				      else //如果是第二个查询条件
				       sql=sql+" and Color='"+jCombocolor.getSelectedItem().toString().trim() +"'";
				    }
				    //执行数据库的查询操作
				            rs =db.getResult(sql);
				             try {
				               if(! rs.equals(null) )
				    //判断返回的结果集是否为空，若不为空显示第一条记录
				               {  rs.next();
				                  showResult();
				               }
				             }
				             catch (SQLException ex) {
				             }
				  }

				
			});
		
		
		jButtonfirst.addActionListener(
				new ActionListener(){
					public void actionPerformed(ActionEvent e){
						try {
			                rs.first() ;
			                showResult();
			             }
			             catch (SQLException ex) {
			             }
					}
				});
		
		jButtonpre.addActionListener(
				new ActionListener(){
					public void actionPerformed(ActionEvent e){
						 try {
			                 if(! rs.isFirst() )
			                 {  rs.previous();
			                    showResult();
			                 }
			               }
			               catch (SQLException ex) {
			               }
					}
				});
		
		jButtonnext.addActionListener(
				new ActionListener(){
					public void actionPerformed(ActionEvent e){
						 try {
			                 if(! rs.isLast())
			                  {  rs.next();
			                     showResult();
			                  }
			                }catch (SQLException ex) 
			                { }				
			                }
				});
		
		jButtonlast.addActionListener(
				new ActionListener(){
					public void actionPerformed(ActionEvent e){
						try {
			                  rs.last();
			                   showResult();
			                }
			            catch (SQLException ex) {
			                }
					}
				});
		
		jButtonupdate.addActionListener(
				new ActionListener(){
					public void actionPerformed(ActionEvent e){
						sql="update ProductStore set Number36='"+jText36.getText().trim() +"',";
					     sql=sql+" Number37='"+jText37.getText().trim() +"',";
					     sql=sql+" Number38='"+jText38.getText().trim() +"',";
					     sql=sql+" Number39='"+jText39.getText().trim() +"',";
					     sql=sql+" Number40='"+jText40.getText().trim() +"',";
					     sql=sql+" Number41='"+jText41.getText().trim() +"',";
					     sql=sql+" Number42='"+jText42.getText().trim() +"',";
					     sql=sql+" Number43='"+jText43.getText().trim() +"',";
					     sql=sql+" Number44='"+jText44.getText().trim() +"' ";
					     sql=sql+" where Model='"+jTextkuanxing.getText().trim() +"'";
					     sql=sql+" and Color ='"+jCombocolor.getSelectedItem().toString().trim() +"'";
					       //使用DBManager对象执行操作 ，并返回成功或失败信息
					     if(db.executeSql(sql))
					         JOptionPane.showMessageDialog(null,"操作成功！");
					     else
					         JOptionPane.showMessageDialog(null,"操作失败！");
					}
				});
		
		jButtondelete.addActionListener(
				new ActionListener(){
					public void actionPerformed(ActionEvent e){
						sql="delete from ProductStore where Model='"+jTextkuanxing.getText().trim() +"'";
						sql= sql+" and Color ='"+jCombocolor.getSelectedItem().toString().trim() +"'";
						//使用DB_Manager对象执行操作 ，并返回成功或失败信息
						if(db.executeSql(sql))
						   JOptionPane.showMessageDialog(null,"操作成功！");
						else
						   JOptionPane.showMessageDialog(null,"操作失败！");
						}
				});
		
		jButtonCancel.addActionListener(
				new ActionListener(){
					public void actionPerformed(ActionEvent e){
						exit();
					}
				});
	}
	
	
	private void exit(){
		this.dispose();
	}
	void showResult(){
	    try {
	         jTextkuanxing.setText(rs.getString("Model") );
	         jCombocolor.setSelectedItem(rs.getString("Color") ) ;

	         jText36.setText(rs.getString("Number36") );
	         jText37.setText(rs.getString("Number37") );
	         jText38.setText(rs.getString("Number38") );
	         jText39.setText(rs.getString("Number39") );
	         jText40.setText(rs.getString("Number40") );
	         jText41.setText(rs.getString("Number41") );
	         jText42.setText(rs.getString("Number42") );
	         jText43.setText(rs.getString("Number43") );
	         jText44.setText(rs.getString("Number44") );

	       }
	       catch (SQLException ex) {
	         System.out.println(ex.toString() ) ;
	       }


	  }

	
	
	 FrameProductStoryInformation(String title){
		 super(title);
		 makeGUI();
		 eventAction();
		 addWindowListener(new WinLis());
	 }
	 
	 class WinLis extends WindowAdapter
		{
			public void windowClosing(WindowEvent e)
			{
				exit();
			}
		}
	  
	public static void main(String[] args) {
		 FrameProductStoryInformation store = new  FrameProductStoryInformation("产品库存信息管理");
		 store.setBounds(125,130,550,260);
		 store.validate();
		 store.setVisible(true);
	}

}