frameproductininformation.java

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

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;
import java.util.*;
import java.sql.*;
public class FrameProductInInformation extends JFrame{
	
	 //定义所用的结果集
	  ResultSet rs;
	  //定义sql语句变量
	  String sql;
	  //定义DBManeger对象，利用其中的方法来操作数据库
	   private DB_Manager db =new DB_Manager();

	
	JLabel lb1 = new JLabel("款型",JLabel.RIGHT);
	JLabel lb3 = new JLabel("     颜色",JLabel.RIGHT),lb4 = new JLabel("操作员",JLabel.RIGHT),lb5 = new JLabel("备注",JLabel.RIGHT);
	JLabel 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 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);
    
	JTextField jTextoperator = new JTextField(8),
	jTextdate = new JTextField(8), jTextcomment = new JTextField(38);
	
	JTextField jTextkuanxing = new JTextField(15);
	JComboBox jCombocolor = new JComboBox();
	JButton jButtonSearch = new JButton("查询");
	
	JButton jButtonfitst = 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 top = new JPanel();
		top.setLayout(new FlowLayout());
		top.add(lb1);   top.add(jTextkuanxing);
		top.add(lb3);  top.add(jCombocolor);  
		top.add(new JLabel("     "));
		top.add(jButtonSearch);
		cp.add(top,BorderLayout.NORTH);
		JPanel par = new JPanel();
		par.setLayout(new BorderLayout());
		
		JPanel cent = new JPanel();
		cent.setLayout(new GridLayout(4,6,5,20));
		cent.add(lb36);  cent.add(jText36);
		cent.add(lb39);  cent.add(jText39);
		cent.add(lb42);  cent.add(jText42);
		cent.add(lb37);  cent.add(jText37);
		cent.add(lb40);  cent.add(jText40);
		cent.add(lb43);  cent.add(jText43);
		cent.add(lb38);  cent.add(jText38);
		cent.add(lb41);  cent.add(jText41);
		cent.add(lb44);  cent.add(jText44);
		cent.add(lb4);  cent.add(jTextoperator);
		cent.add(new JLabel("日期",JLabel.RIGHT));   cent.add(jTextdate);
		cent.add(new JLabel("  "));   cent.add(new JLabel("  "));	
		par.add(cent,BorderLayout.CENTER);
		
		JPanel souch = new JPanel();
		souch.setLayout(new FlowLayout());
		souch.add(lb5);   souch.add(jTextcomment);
		par.add(souch,BorderLayout.SOUTH);
		cp.add(par,BorderLayout.CENTER);
		
		JPanel bottom = new JPanel();
		bottom.setLayout(new FlowLayout());
		bottom.add(jButtonfitst);
		bottom.add(jButtonpre);
		bottom.add(jButtonnext);
		bottom.add(jButtonlast);
		bottom.add(jButtonupdate);
		bottom.add(jButtondelete);
		bottom.add(jButtonCancel);
		cp.add(bottom,BorderLayout.SOUTH);
	}
	
	private void eventProcess(){
		jButtonSearch.addActionListener(
			new ActionListener(){
				public void actionPerformed(ActionEvent e){
//					定义变量，用来判断是否是第一个查询条件
				    boolean  isfirst =true;

				        sql="select * from ProductIn ";
				  //如果款型的查询条件不为空
				         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) {
				            JOptionPane.showMessageDialog(null," search failed!");
				         }

				}
			});
	
		jButtonfitst.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 ProductIn 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+"Operator='"+jTextoperator.getText().trim() +"', ";
					       sql=sql+" Datein='"+jTextdate.getText().trim() +"', ";
					        sql=sql+" Comment='"+jTextcomment.getText().trim() +"' ";
					      sql=sql+" where Model='"+jTextkuanxing.getText().trim() +"'";
					      sql=sql+" and Color ='"+jCombocolor.getSelectedItem().toString().trim() +"'";
					      //由DBManager对象执行更新操作
					      if(db.executeSql(sql))
					      {   //若成功，提示成功
					           System.out.println(sql+"update successed!") ;
					           JOptionPane.showMessageDialog(null,"更新成功!");
					          }
					            else
					            {
					              //若失败，提示失败
					              System.out.println(sql + "更新失败");
					              JOptionPane.showMessageDialog(null,"更新失败!");
					            }

					}
				});
	
		jButtondelete.addActionListener(
				new ActionListener(){
					public void actionPerformed(ActionEvent e){
						sql="delete from ProductIn 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,"删除失败!");

			  }
	
					
				});
	
		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") ) ;
	      jTextdate.setText(rs.getString("datein") );
	      jTextoperator.setText(rs.getString("operator") );
	      jTextcomment.setText(rs.getString("comment") );
	      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) {
	    }


	  }

	
	
	
	
	FrameProductInInformation(String title){
		super(title);
		makeGUI();
		eventProcess();
		addWindowListener(new WinLis());
	}
	
	class WinLis extends WindowAdapter
	{
		public void windowClosing(WindowEvent e)
		{
			exit();
		}
	}
	
	public static void main(String[] args) {
		FrameProductInInformation newInfo = new FrameProductInInformation("产品入库信息管理");
		newInfo.setBounds(120,130,550,300);
		newInfo.setVisible(true);
		newInfo.validate();
	}

}