walkin.java

餐厅管理系统毕业设计

import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Calendar;
import java.util.Date;
import java.util.Vector;
import javax.swing.*;
import javax.swing.table.AbstractTableModel;
public class WalkIn {
	String username = "root";
    String password = "right";
    String jdbcDriver="com.mysql.jdbc.Driver";
    String url="jdbc:mysql://localhost:3306/resturant";  
    JTable jTable=new JTable();
    JScrollPane jScroll;
	Vector vector;
	AbstractTableModel tm;
	String title[]={"预定号码","人数","日期","时间","桌号","姓名"};
	ResultSet rSet=null;  
	JFrame f=new JFrame();
	Container contentPane=f.getContentPane();    
	JButton jButton1=new JButton("查询");
    JButton jButton2=new JButton("安排座位");
    JButton jButton3=new JButton("退出");
    public WalkIn(){
    	contentPane.setLayout(new FlowLayout(FlowLayout.LEFT));
		contentPane.add(jButton1);
		contentPane.add(jButton2);
		contentPane.add(jButton3);
		display();
		f.setSize(480,500);
    	f.setVisible(true);
		jButton1.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e) {
				reserch();
			}
		});
		jButton2.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e) {
			    MakeWalkIn makeWalkIn=new MakeWalkIn();	
			}
		});
		jButton3.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e) {
				f.dispose();;
			}
		});
    }//    
    void reserch(){
        Connection con = null;
       	Statement stmt = null;
       	int a=getmonth();
       	int b=getday();
       	String Reserch="SELECT * FROM Reservation WHERE date="+"\""+a+"."+b+"\""+";";
       	    try{
    	         Class.forName(jdbcDriver);
    	        }
    	    catch(ClassNotFoundException se){
    	         System.err.print(se.getMessage());
    	          }
            try{
            	 con=DriverManager.getConnection(url,username,password);
                 stmt=con.createStatement();
                 rSet=stmt.executeQuery(Reserch);
                 vector.removeAllElements();
                 while(rSet.next()){
                 Vector rec_vector=new Vector();
               	 rec_vector.addElement(String.valueOf(rSet.getString("oid")));
               	 rec_vector.addElement(String.valueOf(rSet.getString("covers")));
               	 rec_vector.addElement(String.valueOf(rSet.getString("date")));
               	 rec_vector.addElement(String.valueOf(rSet.getString("time")));
               	 rec_vector.addElement(String.valueOf(rSet.getString("table_id")));
               	 rec_vector.addElement(String.valueOf(rSet.getString("custom_id")));
               	 rec_vector.addElement(String.valueOf(rSet.getString("arrivetime")));
               	 vector.addElement(rec_vector);
               	}
                 tm.fireTableStructureChanged();               //更新表格
                 rSet.close();
                 con.close();
               }
             catch(SQLException se){
               System.err.println(se.getMessage());
                }
             finally{
             try{
                   if(con!=null){
                                  con.close();
                                  }
                   if(stmt!=null){
                                  stmt.close();
                                  }
             }catch(Exception ex){}          //忽略
                  }
    }
    
    void display(){
    	vector=new Vector();
    	tm=new AbstractTableModel(){
              public int getColumnCount(){         //行
            	  return title.length;
              }
              public int getRowCount(){            //列
            	  return vector.size();
              }
              public Object getValueAt(int row,int column){           //取得单元格的属性值
            	  if(!vector.isEmpty()){
            		  return ((Vector)vector.elementAt(row)).elementAt(column);
            	  }
            	  else{
            		  return null;
            	  }
              }
              public void setValueAt(Object value,int row,int column){  //数据模型不可编辑，方法设置为空
            	        }    
              
    	
    	      public String getColumnName(int column){     //区列名 
    		          return title[column];
    	              }
    	      public Class getColimnClass(int c){
    		          return getValueAt(0,c).getClass();    //取得列所属对象类
    	              }
    	      public boolean isCellEditable(int row,int column){       //设置单元格不可编辑
    		          return false;
    	              }
    	};
    	jTable=new JTable(tm);
    	jTable.setToolTipText("DISPLAY");             //设置提示
    	jTable.setAutoResizeMode(jTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);    //设置表格调整尺寸模式
    	jTable.setCellSelectionEnabled(false);         //设置单元格的选择方式
    	jTable.setShowHorizontalLines(true);        //是否有分割线
    	jTable.setShowVerticalLines(true);
        jScroll=new JScrollPane(jTable);
        jScroll.setBounds(6, 20, 250, 250);
        contentPane.add(jScroll);
    }
    public int getmonth(){
    	Calendar calendar=Calendar.getInstance();
        calendar.setTime(new Date());
        int month=calendar.get(Calendar.MONTH)+1;   
        return month;
    }
    public int getday(){
    	Calendar calendar=Calendar.getInstance();
        calendar.setTime(new Date());
        int day=calendar.get(Calendar.DAY_OF_MONTH);  
        return day;
    }
}//