loginmanager.java

这个一个餐厅预定系统,可实现查询目前餐厅预订情况,实现餐桌预订以及就餐时为顾客调节餐桌的情况.

package bookingsystem;
import java.sql.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class LoginManager {
    public boolean login(String userloginID,String userpassword){
                boolean flag=false;

                Connection cn=ConnectionDB.getCon();
                Statement st=null;
                ResultSet rs=null;



                String sql ="select * from LOGIN where user_id = '"+userloginID+"' and user_password = '"+userpassword+"'";
                try {
                        st=cn.createStatement();
                        rs=st.executeQuery(sql);
                } catch (SQLException e) {
                        e.printStackTrace();
                }
                                try {
                                        if(rs.next())
                                                flag=true;
                                        else
                                                flag=false;
                                } catch (SQLException e) {
                                        e.printStackTrace();
                                }

                ConnectionDB.close(rs);
                ConnectionDB.close(cn);
                ConnectionDB.close(st);
                return flag;
        }

}