loginmanager.java~2~

来自「这个一个餐厅预定系统,可实现查询目前餐厅预订情况,实现餐桌预订以及就餐时为顾客调」· JAVA~2~ 代码 · 共 47 行

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.getDBCon();
                Statement st=null;
                ResultSet rs=null;



                String sql ="select * from login where loginID = '"+userloginID+"' and 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;
        }

}