1. Introduction
a. Programs commonly used to write websites:
java、ASP.NET (VB.net / C#)、PHP、Python、Ruby on Rails。
b. JAVA's MVC contains two kinds: Strus、Spring。
c. Web program execution process:
1. JAVA：
JSP --> compiled by Tomcat into .java --> recompiled into .class -->
stored in "C:\Program Files\Apache Software Foundation\Tomcat 7.0\work\Catalina\localhost"
2..NET：After writing the program, it will be compiled into .dll.
d. Static & Dynamic Pages:
1. Apache: Only static web pages can be processed. To handle dynamic web pages, you must pair them with other plugins, such as Tomcat.
2. IIS: It can directly handle ASP dynamic web pages, but if you want to use ASP.net, you must install the .NET framework.
2. Outline
a. SQL server
b. SQL syntax
c. Design database
d. HTML5 + CSS
e. AJAX application practices：
1. Verify that the account whether is duplicated：After pressing OK, the background is first passed to a check page, which is connected to the DB to check whether the account is duplicated and then passed back to the first page. If there is a duplicate, the user remains on the original page. If not, go to the next page.
2.Linked pull-down window：Japan --> Tokyo ..., or New Zealand -->Auckland ...
3. Install MS SQL server 2008 Express
MS SQL server 2008 express is divided into three download versions by function。We use the 2nd one here for practice.
1. Express with Advanced Services Free, with the database, GUI interface management tools, and reporting features
2. Express with Tools Free, with a database and GUI interface management tools.
3. Express Free, only database core, no GUI interface management tool.
Please go to Microsoft official website to download：
按此下載 MS SQL express 2008 with tools (249.5 MB)
按此下載 Microsoft® SQL Server® 2008 Express with Advanced Services (560.1 MB)
PS 1: Now the newest version is available, MS SQL 2017 on-premises
Download MS SQL 2017 on-premises
PS 2: If you like MS SQL 2016 click the link below to download
Download MS SQL 2016 SP2
PS 3：Editions and supported features of SQL Server 2017 Please refer to Microsoft's official website, click on the link below.
Editions and supported features of SQL Server 2017
PS 4：SQL Server express 2012
Download Center Microsoft® SQL Server® 2012 Express
No comments:
Post a Comment