public static Integer getEID (String txt) {
            Database db = dbconnect();
            String query;
            Integer _int = null;
	try {
                query = ("SELECT EID FROM employee WHERE username = ? AND bDeleted = 0");
                db.prepare(query);
                db.bind_param(1, txt);
		ResultSet rs = db.executeQuery(); 
                while(rs.next()) {
                    _int = rs.getInt(1);
                }
	        db.close();      
                
        } catch (SQLException e) {
            Error_Frame.Error(e.toString());
        } 
        return _int;
    }