复旦大学：《Web应用基础》教学资源_课程样题（参考答案）

Answer 1. Choose the best answer (a, b, c or d) for each of the following questions. (1)d.(2)c.(3)a.(4)d.(5)c.(6)d.(⑦)b.(8)b.(9)d.(l0)d. (11)a.(12)c.(13)a.(14)b.(15)b.(16)d.(17)b.(18)c.(19)d.(20)a (21)c.(22)d.(23)c.(24)a.(25)c.(26)d.(27)c.(28)b.(29)d.(30)a 2. Question. ( 1)As a simplification, we might say that"GET"is basically for just getting(retrieving) data whereas"POST" may involve anything, like storing or updating data, or ordering a product, or sending E-mail The GET method appends name/value pairs to the URL. The length of a URL is limited, so this method only works if there are only a few parameters. The URL could be truncated if the form uses a large number of parameters, or if the parameters contain large amounts of data. Also parameters passed on the UrL are visible in the address field of the browser not the best place for password to be displayed The alternative to the GEt method is the POST method. This method packages the name/value pairs inside the body of the Http request which makes for a cleaner Url and imposes no size limitations on the forms output. It is also more secure (2)MVC: Model-View-Controller architecture REQUEST Http Browser Reponse JAVA SERVLET Controller Web Report Model Database Figure 1. mvc works with JSP The Model-View-Controller architecture works with JSP(Figure 1). In fact it makes the initial implementation a little easier to write. The controller object is master Servlet. Every request goes through the controller who retrieves the necessary model object. The model may interact with other business entities such as databases or JavaBean. The model object sends the output results back to the controller. The controller takes the results and places it inside the web browser session and forwards a redirect request to a particular Java Server Page The JSP, in the case, is the view (3)One way is to resize it out of existence by setting either the width or height to zero. You can lso clip the element to the top, bottom, left or right. You can also hide it by setting visibility to

Answer 1. Choose the best answer (a, b, c or d) for each of the following questions. (1) d. (2) c. (3) a. (4) d. (5) c. (6) d. (7) b. (8) b. (9) d. (10) d. (11) a. (12) c. (13) a. (14) b. (15) b. (16) d. (17) b. (18) c. (19) d. (20) a. (21) c. (22) d. (23) c. (24) a. (25) c. (26) d. (27) c. (28) b. (29) d. (30) a. 2. Question. (1) As a simplification, we might say that "GET" is basically for just getting (retrieving) data whereas "POST" may involve anything, like storing or updating data, or ordering a product, or sending E-mail. The GET method appends name/value pairs to the URL. The length of a URL is limited, so this method only works if there are only a few parameters. The URL could be truncated if the form uses a large number of parameters, or if the parameters contain large amounts of data. Also, parameters passed on the URL are visible in the address field of the browser not the best place for a password to be displayed. The alternative to the GET method is the POST method. This method packages the name/value pairs inside the body of the HTTP request, which makes for a cleaner URL and imposes no size limitations on the forms output. It is also more secure. (2) MVC: Model-View-Controller architecture. Figure 1. MVC works with JSP The Model-View-Controller architecture works with JSP (Figure 1). In fact it makes the initial implementation a little easier to write. The controller object is master Servlet. Every request goes through the controller who retrieves the necessary model object. The model may interact with other business entities such as databases or JavaBean. The model object sends the output results back to the controller. The controller takes the results and places it inside the web browser session and forwards a redirect request to a particular Java Server Page. The JSP, in the case, is the view. (3) One way is to resize it out of existence by setting either the width or height to zero. You can also clip the element to the top, bottom, left or right. You can also hide it by setting visibility to

hidden, or turn off the display. Finally, you can make it move off the page, or move another element in front of it (4)Fill in the blanks (a) Red (b)Teal (c) Purple (d) Gray (e)olive (5)SQL Sta (a)SELECT employee employee-name, works. salary FROM employee, works WHERE employee employee- or SELECT employee-name, salary FROM works (b)SELECT employee employee-name FROM employee, works, branch WhERE employee. city works city and works. branch-name= branch branch-name and employee employee-name works employee-name (c)selECT branch-name, COUNT()as numbers FROM works GROUP BY branch-name ORDER BY numbers DESC LIMit 1 (d) UPDATE employee SeT city ='Beijing'WhERE employee-name = Jones (e) UPDATE works SET salary salary *1. I WhERE salary * 1. 1 120000

hidden, or turn off the display. Finally, you can make it move off the page, or move another element in front of it. (4) Fill in the blanks (a) Red (b) Teal (c) Purple (d) Gray (e) Olive (5) SQL statements (a) SELECT employee.employee-name, works.salary FROM employee, works WHERE employee.employee- name = works.employee- name or SELECT employee-name, salary FROM works (b) SELECT employee.employee-name FROM employee, works, branch WHERE employee.city = works.city and works.branch-name = branch.branch-name and employee.employee-name = works.employee-name (c) SELECT branch-name, COUNT(*) as numbers FROM works GROUP BY branch-name ORDER BY numbers DESC LIMIT 1 (d) UPDATE employee SET city = 'Beijing' WHERE employee-name = 'Jones' (e) UPDATE works SET salary = salary * 1.1 WHERE salary * 1.1 '120000