package pchat;

import java.sql.*;

public class MainChatData {
    public MainChatData() {
    }

    //判斷密碼和用戶名是否正確
    public boolean istrue(String name, String pass) {
        Connection con = SQLData.sqlData();
        Statement st = null;
        ResultSet rs = null;
        boolean avaiable = false;
        try {
            st = con.createStatement();
            rs = st.executeQuery("select * from Login");
            while (rs.next()) {
                if (rs.getString(1).equals(name) && rs.getString(2).equals(pass)) {
                    avaiable = true;
                    break;
                }
            }
        } catch (SQLException ee) {
        } finally {
            try {
                rs.close();
                st.close();
                con.close();
            } catch (Exception ee) {}
        }

        return avaiable;
    }
}