Course Details

Java + JSP + Servlet + Tomcat + Google Apps Engine
Image

Course Introduction 課程簡介

此課程內容相當豐富。課程主要教授學員Web及Apps的後台程式設計(Server side programming)及資料庫儲存(Database)等相關技術,

  • 學習Java程式語言及物件導向的觀念。
  • 學習MySQL 資料庫建構及關聯式觀念。
  • 學習如何使用Java建立網站後台程式,介紹JSP, Servlet, JavaBean, Tomcat等各種技術。
  • 學習如何由零開始利用JSP及MySQL去打造一個具備 CRUD (Create,Read,Update,Delete)功能的CMS (Content Management System)系統。
  • 學習如何利用JSP及MySQL去建立保安系統及上載檔案。
  • 學習如何使用JSP及Google Apps Engine 的雲端資料庫服務 DataStore去打造一個具備 CRUD (Create,Read,Update,Delete)功能的CMS (Content Management System)系統。
  • 學習如何使用JSP及Google Apps Engine 的雲端身份認證服務去建立保安系統。
  • 學習如何使用JSP及Google Apps Engine 的雲端電郵服務去發送電郵。

Java

Java是一種廣泛使用的電腦程式設計語言,擁有跨平台、物件導向、泛型程式設計的特性,廣泛應用於企業級Web應用開發和行動應用開發。

JSP/Servlet

JSP(JavaServer Pages)是一個類似PHP及ASP.NET 的後台程式語言,主要使用Java為語法基本。由於效能卓越,一般大公司的網站均以此運作而大型的 Web Applications 則以此為開發標準 。

MySQL

MySQL 是一個開放源碼的關聯式資料庫管理系統,MySQL在過去由於性能高、成本低、可靠性好,已經成為最流行的開源數據庫,因此被廣泛地應用在 Internet上的中小型網站中。

Google Apps Engine

是Google的公共雲端平台,它的基礎服務省卻了很多系統開發的時間, 例如雲端資料庫、雲端電郵、雲端保安服務等 , 開發人員只需利用這些現成的服務,便能快速打造出實用的程式。

Course Duration 課程時數

17 hrs 視像

Course Objective 課程目標

本課程目的是培訓學員掌握Java, JSP, Servlet及Google Apps Engine 等網頁後台設計技術,讓學員能設計出實用的網站資料庫系統 。

Entry Requirement 入學要求

報讀者無需任何程式設計背景,但對網頁程式設計及各種新技術有興趣請便可報讀

Course Features 課程特點

★ 解說詳細:循序漸進說明各種後台技術的使用方法。
★ 視像重溫:課程以視像形式教授,學員可在家重複觀看方便吸收。

Course Content 課程內容

課程預覽
TopicsDuration
Java JDK installation 03m:00s
Setup Environment Variables for Java 03m:18s
Write a Simple Java Program 05m:21s
Compile and Run the Java Program 08m:00s
Java Basics (Program Structure) 06m:43s
Java Basics (Variables) 12m:07s
Java Basics (Decision Making) 08m:09s
Java Basics (More Decision Making) 03m:44s
Java Basics (Looping) 10m:09s
Java Basics (Methods) 15m:09s
Java Basics (Array for Numbers) 12m:17s
Java Basics (Array for Strings) 09m:15s
Eclipse IDE Installation 03m:01s
Using Eclipse to Write a Simple Java Program 09m:39s
Setting Preferences for Eclipse 05m:03s
Java Class (Java Class Basic Structure) 06m:06s
Java Class (Instantiate the Java Class) 04m:30s
Java Class (Constructor Methods) 03m:59s
Java Class (Getter/Setter Methods) 04m:21s
Java Class (Auto Generate Methods) 02m:24s
Object-Oriented Concepts (Inheritance Basics) 02m:24s
Object-Oriented Concepts (Use of Inheritance) 07m:09s
Object-Oriented Concepts (Class with Inheritance) 04m:16s
Object-Oriented Concepts (Further Class Examples) 06m:57s
Object-Oriented Concepts (Array of Objects) 03m:31s
Object-Oriented Concepts (Abstract Class) 13m:31s
Object-Oriented Concepts (ArrayList) 08m:49s
Object-Oriented Concepts (Polymorphism) 05m:48s
Object-Oriented Concepts (Interface) 05m:53s
Object-Oriented Concepts (Use of Interface) 06m:28s
Object-Oriented Concepts (Further Interface Examples) 06m:55s
TopicsDuration
Tomcat Installation 11m:42s
Write a simple web page using HTML and JSP 04m:36s
Servlet generated behind JSP 03m:19s
Write a simple Java Servlet 12m:24s
Setup Environment Variables for Tomcat 03m:01s
Configure web.xml for Servlet 04m:39s
Setup Tomcat Runtime in Eclipse 03m:03s
Create a JSP using Eclipse 05m:06s
Create a Servlet using Eclipse 05m:27s
Example: Create a HTML Login Form 05m:42s
Example: Create a Servlet to verify Login 08m:28s
Example: Create a JSP to verify Login 05m:07s
TopicsDuration
MySQL Installation 06m:56s
Notepad++ Installation 01m:39s
Basic MySQL commands 06m:26s
Example- Create a School database and Student Table 08m:00s
Example- Different types of SELECT commands 04m:38s
Example- Create and Use of Primary Key Constraint 08m:30s
Example- Create Class Table and Make a 1-1 Relationship with Student Table 08m:26s
Example- Create Course and Enrollment Table to make M-N relationship with Student Table 11m:42s
Example- Joining Tables with Inner Join 09m:18s
Example- Joining Tables with Outer Join 04m:21s
Example- Create View as Virtual Table 04m:24s
Example- Update/Delete/Search Records 03m:46s
Configure the JDBC Driver for connecting Java to MySQL 05m:56s
Example- Testing the Java to MySQL connection 12m:39s
TopicsDuration
JSP and Servlet Overview Part 1 06m:38s
JSP and Servlet Overview Part 2 08m:27s
JSP and Servlet Overview Part 3 06m:01s
JSP and Servlet Overview Part 4 08m:49s
JSP and Servlet Overview Part 5 08m:52s
JSP Concept Testing - 1) Scripting Elements 10m:08s
JSP Concept Testing - 2) Directive Elements 09m:53s
JSP Concept Testing - 3) Action Elements and JavaBeans 19m:03s
JSP Concept Testing - 4) Implicit Objects Part 1 15m:24s
JSP Concept Testing - 5) Implicit Objects Part 2 16m:46s
JSP Concept Testing - 6) Implicit Objects Part 3 16m:11s
JSP Concept Testing -7) EL and JSTL 09m:22s
TopicsDuration
Build a Complete System - 1) Build up the MySQL database 11m:01s
Build a Complete System - 2) Create the Login Form 04m:42s
Build a Complete System - 3) Creating JavaBean for Login Form 04m:24s
Build a Complete System - 4) Using JavaBean to Check Login 04m:18s
Build a Complete System - 5) Modifying JavaBean to Support Database Login 14m:18s
Build a Complete System - 6) Create a DBConnection Class 04m:45s
Build a Complete System - 7) Refactoring LoginBean to use DBConnection Class 03m:50s
Build a Complete System - 8) Creating a Add New Student Form 07m:34s
Build a Complete System - 9) Creating a StudentBean to handle input data 04m:50s
Build a Complete System - 10) Creating a StudentDAO Class to manage Student Data 14m:03s
Build a Complete System - 11) Adding List Student Function to StudentDAO Class 12m:27s
Build a Complete System - 12) Creating a List Student Page using JSP 10m:54s
Build a Complete System - 13) Refactoring Codes to use Student ID 06m:53s
Build a Complete System - 14) Creating Pages to Show Student Details 15m:36s
Build a Complete System - 15) Creating Pages to Delete Student 10m:46s
Build a Complete System - 16) Creating Pages to Update Student (Part 1) 08m:53s
Build a Complete System - 17) Creating Pages to Update Student (Part 2) 10m:19s
Build a Complete System - 18) Creating Pages to Update Student (Part 3) 16m:01s
Build a Complete System - 19) Modifying Login Pages to Support Session 12m:40s
Build a Complete System - 20) Creating Logout Pages 04m:01s
Build a Complete System - 21) Deploying to Production Tomcat Server 05m:26s
TopicsDuration
Concept Testing - Creating File or Images Upload Form 10m:38s
Concept Testing - Creating the File or Images Upload BackEnd (Part 1) 08m:46s
Concept Testing - Creating the File or Images Upload BackEnd (Part 2) 10m:40s
Concept Testing - Creating the File or Images Upload BackEnd (Part 3) 08m:10s
System Enhancement - 1) Modifying Database to support Image Storage 03m:44s
System Enhancement - 2) Modifying Pages to allow upload Photo 04m:22s
System Enhancement - 3) Modifying JavaBean to support photo 01m:49s
System Enhancement - 4) Modifying BackEnd Pages to allow Photo upload 09m:00s
System Enhancement - 5) Modifying StudentDAO to support saving Image 04m:23s
System Enhancement - 6) Modifying Pages and StudentDAO to support listing Photo 06m:58s
System Enhancement - 7) Modifying Pages and StudentDAO to support updating photo (Part 1) 09m:30s
System Enhancement - 8) Modifying Pages and StudentDAO to support updating photo (Part 2) 08m:21s
TopicsDuration
Introduction to Cloud Computing 05m:17s
Open an Account in Google Apps Engine 08m:35s
Prepare the Development Environment and Tools 05m:01s
Installing all the tools for Local Development 11m:23s
Creating a Sample Hello World Project 10m:00s
Creating a Servlet for testing 08m:34s
TopicsDuration
Introducing Google Cloud Datastore 07m:17s
Creating a Project for testing Google Cloud Datastore 07m:02s
Creating an Entity and Saving to the Datastore 06m:05s
Testing the Schema Less Features of Entity 04m:30s
Testing the Key Features of Entity 08m:50s
Reading the Properties of an Entity using the Key 04m:33s
Updating and Deleting the Entity 05m:22s
List out all Entities in the Datastore 05m:11s
TopicsDuration
CRUD example (Creating the Student Entity using a Form) 08m:40s
CRUD example (List out the Student Entities) 09m:15s
CRUD example (Delete and Update Student Entities) 08m:42s
CRUD example (Delete and Update Student Entities) Part 2 08m:41s
TopicsDuration
Introducing Google Cloud User Service 06m:12s
Testing the Google Cloud User Service 08m:49s
Integrating User Service to DataStore 10m:30s
TopicsDuration
Prepare the Upload Image Input Form 05m:25s
Creating a Servlet for handing Image Upload 09m:07s
Creating a Servlet for handing Image Upload (Part 2) 06m:52s
Creating a JSP for showing the Image 09m:33s
TopicsDuration
Preparing the Send Mail Form 06m:12s
Creating the Servlet for sending Email 03m:51s
Finishing and Testing the Send Mail Service 09m:08s
TopicsDuration
Creating an Sign Up Registration Form 05m:07s
Creating the Sign Up Servlet and Task Queue 10m:07s

Navigation

Social Media

IT Design