בגרות במדעי המחשב תכנות באינטרנט 899282/899372 - קיץ 2021

SELECT phoneNumber
FROM AllStudents
WHERE firstName LIKE 'A%' OR lastName LIKE 'B%';

<table border = '1'><tr><td>7</td></tr><tr><td>14</td></tr><tr><td>21</td></tr><tr><td>28</td></tr><tr><td>35</td></tr><tr><td>42</td></tr><tr><td>49</td></tr></table>

+----+
| 7  |
+----+
| 14 |
+----+
| 21 |
+----+
| 28 |
+----+
| 35 |
+----+
| 42 |
+----+
| 49 |
+----+

function isStrongPassword ()
{
    var password = document.getElementById("password").value;
    if (password.length < 8)
        return false;
    var lowerCaseLetters = 0;
    var upperCaseLetters = 0;
    var digits = 0;
    for (var i = 0; i < password.length; i++)
    {
        if (password.charAt(i) >= '0' && password.charAt(i) <= '9')
            digits ++;
        else if (password.charAt(i) >= 'a' && password.charAt(i) <= 'z')
            lowerCaseLetters ++;
        else if (password.charAt(i) >= 'A' && password.charAt(i) <= 'Z')
            upperCaseLetters ++;
        else
            return false;
    }
    return digits > 0 && lowerCaseLetters > 0 && upperCaseLetters > 0;
}

protected void PrintTable(string connectionString)
{
    DataSet ds = new DataSet();
    SqlConnection connection = new SqlConnection(connectionString);
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = " SELECT dogName, age, breed, idNumber FROM TableOfDogs WHERE gender = 'זכר' ";
    cmd.Connection = connection;
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    adapter.Fill(ds) ;
    connection.Close();
    string resultStr = "<table>";
    resultStr += "<tr><th> שם הכלב </th><th>גיל</th><th> גזע </th><th> מספר זיהוי</th></tr>";
    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        resultStr += "<tr>";
        resultStr += "<td>" + dr["dogName"] + "</td>";
        resultStr += "<td>" + dr["age"] + "</td>";
        resultStr += "<td>" + dr["breed"] + "</td>";
        resultStr += "<td>" + dr["idNumber"] + "</td>";
        resultStr += "</tr>";
    }
    resultStr += "</table>";
    Response.Write (resultStr);
}

<tr><td>שוקו</td><td>6</td><td>אמסטף</td><td>1253</td></tr>
<tr><td>ספייקי</td><td>8</td><td>פינצ'ר</td><td>5436</td></tr>
<tr><td>לאסי</td><td>5</td><td>קולי</td><td>8564</td></tr>

protected void PrintTable(string connectionString)
{
    DataSet ds = new DataSet();
    SqlConnection connection = new SqlConnection(connectionString);
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = " SELECT dogName, age, breed, idNumber FROM TableOfDogs WHERE gender = 'זכר' ";
    cmd.Connection = connection;
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    adapter.Fill(ds) ;
    connection.Close();
    string resultStr = "<table>";
    resultStr += "<tr><th> שם הכלב </th><th>גיל</th><th> גזע </th><th> מספר זיהוי</th></tr>";
    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        resultStr += "<tr>";
        resultStr += "<td>" + dr["dogName"] + "</td>";
        resultStr += "<td>" + dr["age"] + "</td>";
        resultStr += "<td>" + dr["breed"] + "</td>";
        resultStr += "<td>" + dr["idNumber"] + "</td>";
        resultStr += "</tr>";
    }
    resultStr += "</table>";
    Response.Write (resultStr);
}

int age = (int)Session["age"];
bool wasSick = (bool)Session["wasSick"];
bool wasVaccinated = (bool)Session["wasVaccinated"];
if (wasSick || wasVaccinated)
    Response.Redirect("greenCard.aspx");
else if (age >= 16)
    Response.Redirect("getVaccine.aspx");
else
    Response.Redirect("covidInstructions.aspx");

int age = (int)Session["age"];
bool wasSick = (bool)Session["wasSick"];
bool wasVaccinated = (bool)Session["wasVaccinated"];
if (wasSick || wasVaccinated)
    Response.Redirect("greenCard.aspx");
else if (age >= 16)
    Response.Redirect("getVaccine.aspx");
else
    Response.Redirect("covidInstructions.aspx");

public int num;
protected void Page_Load(object sender, EventArgs e)
{
    if (Page.IsPostBack)
    {
        num = (int)Session["num"];
        num++;
    }
    else
        num = 0;
    Session["num"] = num;
}

public int num;
protected void Page_Load(object sender, EventArgs e)
{
    if (Page.IsPostBack)
    {
        num = (int)Session["num"];
        num++;
    }
    else
        num = 0;
    Session["num"] = num;
}

protected void Page_Load(object sender, EventArgs e)
{
    if (Session["Key"] == null || (int)Session["Key"] != 2)
        Response.Redirect("Login.aspx");
}

protected void Page_Load(object sender, EventArgs e)
{
    if (Session["Key"] == null || (int)Session["Key"] != 2)
        Response.Redirect("Login.aspx");
}

protected void Page_Load(object sender, EventArgs e)
{
    if (Session["firstlog"] == null)
    {
        Application.Lock();
        if (Application["myCount"] == null)
            Application["myCount"] = 0;
        Application["myCount"] = (int)Application["myCount"]+ 1;
        int x = (int)Application["myCount"];
        Application.UnLock();
        Session["firstlog"] = "true";
        if (x % 1000 == 0)
            Response.Write("ברוך הבא המשתמש ה־ " + x);
    }
}

protected void Page_Load(object sender, EventArgs e)
{
    if (Session["firstlog"] == null)
    {
        Application.Lock();
        if (Application["myCount"] == null)
            Application["myCount"] = 0;
        Application["myCount"] = (int)Application["myCount"]+ 1;
        int x = (int)Application["myCount"];
        Application.UnLock();
        Session["firstlog"] = "true";
        if (x % 1000 == 0)
            Response.Write("ברוך הבא המשתמש ה־ " + x);
    }
}