东北大学：某学院计算机科学与技术专业《Web开发与应用》课程教学大纲

Web开发与应用月教学大纲WebApplicationDevelopment Subject Syllabus一，课程信息SubjectInformation课程编号：开课学期：63100213015SemesterSubject ID课程分类：所属课群：专业教育PA专业基础MFCategorySection总学时/周：课程学分：348/10Credit PointsTotal Hours/Weeks理论学时：实验学时：408LECT. HoursEXP. HoursPBL学时:实践学时/周：04PBL HoursPRAC.Hours/Weeks东北大学悉尼智能科技学院开课学院：Sydney Smart适用专业：CST/CECollegeTechnology CollegeStreamNortheasternUniversity课程模式：课程属性：选修Elective互认EQVPatternMode中方课程协调人：王军伟成绩记载方式：百分制MarksNEU CoordinatorWan JunweiResult Type先修课程：无noneRequisites英文参考教材：Web Application Development:Basic Concepts.Greg HeilemanENTextbooks中文参考教材JSP实用教程（第四版），清华大学出版社，2020CN Textbooks教学资源：http://www.tup.com.cn/upload/books/kj/087694-01.rarResources课程负责人(撰写人)提交日期：2/27/2023Subject DirectorSubmitted Date任课教师(含负责人)：王军伟戴庆天Taught byWan Junwei Dai Qingtian审核人：批准人：韩鹏史闻博Checked byApproved by批准日期：2/27/2023Approved Date1 / 15

1 / 15 Web 开发与应用 教学大纲 Web Application Development Subject Syllabus 一、课程信息 Subject Information 课程编号: Subject ID 3100213015 开课学期: Semester 6 课程分类: Category 专业教育 PA 所属课群: Section 专业基础 MF 课程学分: Credit Points 3 总学时/周: Total Hours/Weeks 48/10 理论学时: LECT. Hours 40 实验学时: EXP. Hours 8 PBL 学时: PBL Hours 0 实践学时/周: PRAC. Hours/Weeks 4 开课学院: College 东北大学 悉尼智能科技学院 Sydney Smart Technology College Northeastern University 适用专业: Stream CST/CE 课程属性: Pattern 选修 Elective 课程模式: Mode 互认 EQV 中方课程协调人: NEU Coordinator 王军伟 Wan Junwei 成绩记载方式: Result Type 百分制 Marks 先修课程: Requisites 无 none 英文参考教材: EN Textbooks Web Application Development: Basic Concepts. Greg Heileman 中文参考教材: CN Textbooks JSP 实用教程（第四版），清华大学出版社，2020 教学资源: Resources http://www.tup.com.cn/upload/books/kj/087694-01.rar 课程负责人(撰写人): Subject Director 提交日期: Submitted Date 2/27/2023 任课教师(含负责人): Taught by 王军伟 戴庆天 Wan Junwei Dai Qingtian 审核人: Checked by 韩鹏 批准人: Approved by 史闻博 批准日期: Approved Date 2/27/2023

二、教学目标SubjectLearningObjectives(SLOs)注：毕业要求及指标点可参照悉尼学院本科生培养方案，可根据实际情况增减行数Note: GA and index can be referred from undergraduate program in SSTC website. Please add/reduce lines based on subjectweb开发与应用是将数据库技术与J2EE结合的最新技术，是计算机科学实践性很强的课程。通过该门课程的学习，使学生掌握Web应用编程基础、JSP、Servlet、JDBC连接、Java连接池、基于数据库的设计及应用、Struts及Hibermate技术等方面的理论和实践应用知识。整体目标：Web application development is the latest technologythat combinesOverall Objectivedatabase technology with J2EE. It is a practical course of computerscience. Through the study of this course, students can master thetheoreticalandpracticalapplicationknowledgeof webapplicationprogrammingfoundation,JSP,servlet,JDBCconnection,Javaconnectionpool,databasebased designand application,strutsandHibernate technology, etc..掌握利用JSP开发Web应用程序的核心思想和基本方法。1-1Understand the core idea and basic method of usingJSP todevelopwebapplication掌握JSP语言基础知识与编程的必备知识和工具。1-2Masterthe basicknowledgeof JSP language andthe necessary（1）专业目标：knowledgeand tools ofprogrammingProfessional Ability掌握JSP语言的基本语法、JSP内置对象、文件操作及JDBC、JavaBean、Servlet1-3Master the basic syntax of JSP language, JSP built-in objects,fileoperation andJDBC,JavaBean, servlet,掌握Html、CSS、JavaScript。1-4Learntheknowledgeof Html,CsS,JavaScript.培养学生的编程思维和实际动手能力，以及创新能力。2-1Cultivate students' programming thinking and practical ability,as well as innovation ability（2）德育目标：能够在多学科背景下的团队中承担个体、团队成员以及负责Essential Quality人的角色。2-2Beabletoplaythe roleof individual,team member and leaderin a multidisciplinary team课程教学目标与毕业要求的对应关系MatrixofGA&SLOs毕业要求GA指标点GAIndex教学目标SLOs指标点5-1：掌握解决复杂计算机系统工5、掌握计算机软硬件系统知程问题的基础理论知识；识，包括计算机系统、数据库系统、人机交互、算法与指标点5-2：具备计算机科学与技术专业1-1, 1-3, 1-4, 2-1复杂性、程序设计语言、网所需的设计/开发技能，能够设计针对复络与计算、软件工程等。杂计算机工程问题的解决方案，设计满足特定需求的软硬件系统：GA5.Master the knowledge2 / 15

2 / 15 二、教学目标 Subject Learning Objectives (SLOs) 注：毕业要求及指标点可参照悉尼学院本科生培养方案，可根据实际情况增减行数 Note: GA and index can be referred from undergraduate program in SSTC website. Please add/reduce lines based on subject. 整体目标: Overall Objective web 开发与应用是将数据库技术与 J2EE 结合的最新技术，是计算 机科学实践性很强的课程。通过该门课程的学习，使学生掌握 Web 应用编程基础、JSP、Servlet、JDBC 连接、Java 连接池、基于数 据库的设计及应用、Struts 及 Hibernate 技术等方面的理论和实践 应用知识。 Web application development is the latest technology that combines database technology with J2EE. It is a practical course of computer science. Through the study of this course, students can master the theoretical and practical application knowledge of web application programming foundation, JSP, servlet, JDBC connection, Java connection pool, database based design and application, struts and Hibernate technology, etc. （1）专业目标: Professional Ability 1-1 掌握利用 JSP 开发 Web 应用程序的核心思想和基本方 法。 Understand the core idea and basic method of using JSP to develop web application. 1-2 掌握 JSP 语言基础知识与编程的必备知识和工具。 Master the basic knowledge of JSP language and the necessary knowledge and tools of programming. 1-3 掌握 JSP 语言的基本语法、JSP 内置对象、文件操作及 JDBC、JavaBean、Servlet。 Master the basic syntax of JSP language, JSP built-in objects, file operation and JDBC, JavaBean, servlet;. 1-4 掌握 Html、CSS、JavaScript。 Learn the knowledge of Html, CSS, JavaScript. （2）德育目标: Essential Quality 2-1 培养学生的编程思维和实际动手能力，以及创新能力。 Cultivate students' programming thinking and practical ability, as well as innovation ability. 2-2 能够在多学科背景下的团队中承担个体、团队成员以及负责 人的角色。 Be able to play the role of individual, team member and leader in a multidisciplinary team 课程教学目标与毕业要求的对应关系 Matrix of GA & SLOs 毕业要求 GA 指标点 GA Index 教学目标 SLOs 5、掌握计算机软硬件系统知 识，包括计算机系统、数据 库系统、人机交互、算法与 复杂性、程序设计语言、网 络与计算、软件工程等。 GA5. Master the knowledge 指标点 5-1：掌握解决复杂计算机系统工 程问题的基础理论知识； 指标点 5-2：具备计算机科学与技术专业 所需的设计/开发技能，能够设计针对复 杂计算机工程问题的解决方案，设计满 足特定需求的软硬件系统； 1-1, 1-3, 1-4，2-1

of computersoftwareand指标点5-3：能够综合运用理论和技术手hardwaresystem, including段解决计算机领域中的实际问题：computersystem,database指标点5-4：培养具有一定创新意识的工system,human-computer程人才。algorithmandinteraction,5-1:Masterthebasictheoreticalprogrammingcomplexity,knowledgeof solving complex computerlanguage,networkandsystem engineering problems;softwarecomputing,5-2:Master the basic theoretical knowledgeengineering,etc.of solving complex computer systemengineering problems; Have the design /development skills required by computerscience and technology,be able to designsolutionsforcomplexcomputerengineering problems, and design softwareand hardware systems to meet specificneeds;5-3: Be able to solve practical problems inthe field of computer by means of theoryand technology,5-4: Cultivating engineering talents with acertain sense of innovation指标点6-1：结合计算机学科的基本原理和专业知识，设计实验进行探索和分析讨论，并优化实验技术与工程方案：6-1:Combined with the basic principles6、具有计算机应用系统的分1-2, 2-1and professional knowledge of computer析、设计、开发、实施和项science, the experiment is designed for目管理的能力。具有综合运exploration, analysis and discussion, and用所学科学理论和技术手段yandtheexperimentaltechnology分析并解决工程问题的能engineering scheme are optimized;力。指标点6-2：掌握本专业的工程实践中涉GA6. Have the abilitylof及的重要工程技术指标，研究达到指标computer application system的工程技术途径，analysis, design, development,指标点6-3：熟悉计算机项目管理手段implementation and project方法，具有一定的组织管理能力、较强management. Have the ability的表达能力和人际交往能力。toanalyzeand1 solve1-4,2-1,2-2gproblemsbyengineering6-2:Master the important engineeringusing scientific theoryandtechnical indexes involved in thetechnical meansengineering practice of the major, andstudy the engineering technical ways toachieve the indexes;6-3:Familiarwithcomputerprojectwithamanagement means,methods,3/15

3 / 15 of computer software and hardware system, including computer system, database system, human-computer interaction, algorithm and complexity, programming language, network and computing, software engineering, etc. 指标点 5-3：能够综合运用理论和技术手 段解决计算机领域中的实际问题； 指标点 5-4：培养具有一定创新意识的工 程人才。 5-1: Master the basic theoretical knowledge of solving complex computer system engineering problems; 5-2:Master the basic theoretical knowledge of solving complex computer system engineering problems; Have the design / development skills required by computer science and technology, be able to design solutions for complex computer engineering problems, and design software and hardware systems to meet specific needs; 5-3: Be able to solve practical problems in the field of computer by means of theory and technology; 5-4: Cultivating engineering talents with a certain sense of innovation. 6、具有计算机应用系统的分 析、设计、开发、实施和项 目管理的能力。具有综合运 用所学科学理论和技术手段 分析并解决工程问题的能 力。 GA6. Have the ability of computer application system analysis, design, development, implementation and project management. Have the ability to analyze and solve engineering problems by using scientific theory and technical means. 指标点 6-1：结合计算机学科的基本原理 和专业知识，设计实验进行探索和分析 讨论，并优化实验技术与工程方案； 6-1: Combined with the basic principles and professional knowledge of computer science, the experiment is designed for exploration, analysis and discussion, and the experimental technology and engineering scheme are optimized; 1-2，2-1 指标点 6-2：掌握本专业的工程实践中涉 及的重要工程技术指标，研究达到指标 的工程技术途径; 指标点 6-3：熟悉计算机项目管理手段、 方法，具有一定的组织管理能力、较强 的表达能力和人际交往能力。 6-2: Master the important engineering technical indexes involved in the engineering practice of the major, and study the engineering technical ways to achieve the indexes; 6-3: Familiar with computer project management means, methods, with a 1-4，2-1，2-2

certainorganizationandmanagementability,strongexpression ability andinterpersonal skills指标点9-1：具有一定的组织管理能力、较强的表达能力和人际交往能力。指标点9-2：能够理解团队合作对于项目9、具有良好的团队协作意的意义，积极在团队中发挥作用、体现识、组织管理能力和社会适能力。应能力。9-1 : Have certainorganization and2-2GA9. Have a good sense ofmanagement ability,strongexpressionteamwork,organizationalability and interpersonal skillsmanagement ability and social9-2: Be able to understand the significanceadaptabilityof teamwork for the project, and activelyplay a role in the team and reflect theability三、教学内容Content(Topics)注：以中英文填写，各部分内容的表格可根据实际知识单元数量进行复制、扩展或缩减Note: Filled in both CN and EN, extend or reduce based on the actual numbers of knowledge unit(1)理论教学 Lecture1-1知识单元序号：支撑教学目标：11-2SLOs SupportedKnowledge Unit No1-4知识单元名称JSP简介Unit TitleIntroduction of JSP什么是JSPWhat is JSP安装配置JSP运行环境Install andconfigureJSPrunningenvironment知识点：JSP页面Knowledge DeliveryJSP pageJSP运行原理JSP running principleHTML与JavaScriptHTML and JavaScript了解：Html的发展历程；RecognizeThe development of HTML;学习目标：理解：JSP运行原理Learning ObjectivesUnderstandJSP running principle掌握：Html标签、Form表单、Css语法、JavaScript语法。MasterHtml,Form,Css,JavaScript4 / 15

4 / 15 certain organization and management ability, strong expression ability and interpersonal skills. 9、具有良好的团队协作意 识、组织管理能力和社会适 应能力。 GA9. Have a good sense of teamwork, organizational management ability and social adaptability. 指标点 9-1：具有一定的组织管理能力、 较强的表达能力和人际交往能力。 指标点 9-2：能够理解团队合作对于项目 的意义，积极在团队中发挥作用、体现 能力。 9-1 ： Have certain organization and management ability, strong expression ability and interpersonal skills. 9-2：Be able to understand the significance of teamwork for the project, and actively play a role in the team and reflect the ability. 2-2 三、教学内容 Content (Topics) 注：以中英文填写，各部分内容的表格可根据实际知识单元数量进行复制、扩展或缩减 Note: Filled in both CN and EN, extend or reduce based on the actual numbers of knowledge unit (1) 理论教学 Lecture 知识单元序号: Knowledge Unit No. 1 支撑教学目标: SLOs Supported 1-1 1-2 1-4 知识单元名称 Unit Title JSP 简介 Introduction of JSP 知识点: Knowledge Delivery 什么是 JSP What is JSP 安装配置 JSP 运行环境 Install and configure JSP running environment JSP 页面 JSP page JSP 运行原理 JSP running principle HTML 与 JavaScript HTML and JavaScript 学习目标: Learning Objectives 了解: Recognize Html 的发展历程； The development of HTML; 理解: Understand JSP 运行原理 JSP running principle 掌握: Master Html 标签、Form 表单、Css 语法、JavaScript 语法。 Html, Form, Css, JavaScript

2-1德育目标2-1Moral Objectives建立JSP开发环境重点：EstablishJSPdevelopment environment编写第一个JSP程序Key PointsStart programming难点：建立JSP开发环境Focal pointsEstablishJSPdevelopmentenvironment1-2知识单元序号支撑教学目标：21-3Knowledge Unit No.SLOs Supported知识单元名称JSP语法Unit TitleJSP syntaxJSP页面的基本结构Thebasic structure of JSP page声明变量和定义方法Declaring variables and defining function知识点：Java程序片与Java表达式Knowledge DeliveryJava program slices and Java expressionsJSP的注释Comments on JSPJSP的指令标记与动作标记Instruction tag and action tag of JSP了解:JSP的注释RecognizeComments on JSPJSP页面的基本结构理解：Thebasic structureof JSPpage学习目标：Understand声明变量和定义方法Learning ObjectivesDeclaring variables and defining functionJava程序片与Java表达式掌握：Java program slices and Java expressionsMasterJSP的指令标记与动作标记Instruction tag and action tag of JSP德育目标2-12-2Moral ObjectivesJava程序片与Java表达式重点：Java program slices and Java expressionsKey PointsJSP的指令标记与动作标记Instruction tag and action tag of JSP难点：JSP的指令标记与动作标记Focal pointsInstruction tag and action tag of JSP知识单元序号：1-2支撑教学目标：3Knowledge Unit N1-3SLOs Supported0.5 /15

5 / 15 德育目标 Moral Objectives 2-1 2-1 重点: Key Points 建立 JSP 开发环境 Establish JSP development environment 编写第一个 JSP 程序 Start programming 难点: Focal points 建立 JSP 开发环境 Establish JSP development environment 知识单元序号: Knowledge Unit No. 2 支撑教学目标: SLOs Supported 1-2 1-3 知识单元名称 Unit Title JSP 语法 JSP syntax 知识点: Knowledge Delivery JSP 页面的基本结构 The basic structure of JSP page 声明变量和定义方法 Declaring variables and defining function Java 程序片与 Java 表达式 Java program slices and Java expressions JSP 的注释 Comments on JSP JSP 的指令标记与动作标记 Instruction tag and action tag of JSP 学习目标: Learning Objectives 了解: Recognize JSP 的注释 Comments on JSP 理解: Understand JSP 页面的基本结构 The basic structure of JSP page 声明变量和定义方法 Declaring variables and defining function 掌握: Master Java 程序片与 Java 表达式 Java program slices and Java expressions JSP 的指令标记与动作标记 Instruction tag and action tag of JSP 德育目标 Moral Objectives 2-1 2-2 重点: Key Points Java 程序片与 Java 表达式 Java program slices and Java expressions JSP 的指令标记与动作标记 Instruction tag and action tag of JSP 难点: Focal points JSP 的指令标记与动作标记 Instruction tag and action tag of JSP 知识单元序号: Knowledge Unit N o. 3 支撑教学目标: SLOs Supported 1-2 1-3

知识单元名称JSP的内置对象Unit TitleBuilt in objects of JSPRequest对象RequestResponse对象Response知识点：Session对象SessionKnowledge DeliveryApplication对象ApplicationOut对象OutSession对象、Application对象和Out对象的用法理解：学习目标：UsingtheobjectsofSession.ApplicationandOutUnderstandLearning Objectives掌握：Request对象、Response对象的用法MasterUsing the objects of Request and Response德育目标2-1Moral Objectives2-2Request对象、Response对象的用法重点：Key PointsUsing the objects of Request and ResponseRequest对象、Response对象的用法难点：Focal pointsUsingtheobjectsof RequestandResponse1-1知识单元序号：支撑教学目标：41-3Knowledge Unit No.SLOs Supported1-4知识单元名称JSP与JavaBeanUnit TitleJSP and JavaBean编写和使用JavaBeanProgramming andusing JavaBeans获取和修改Bean属性Getting andmodifyingbeanpropertiesBean的辅助类知识点：Auxiliaryclass of beanKnowledge DeliveryJSP与Bean结合的简单例子AsimpleexampleofJSP combinedwithbean6 / 15

6 / 15 知识单元名称 Unit Title JSP 的内置对象 Built in objects of JSP 知识点: Knowledge Delivery Request 对象 Request Response 对象 Response Session 对象 Session Application 对象 Application Out 对象 Out 学习目标: Learning Objectives 理解: Understand Session 对象、Application 对象和 Out 对象的用法 Using the objects of Session, Application and Out. 掌握: Master Request 对象、Response 对象的用法 Using the objects of Request and Response. 德育目标 Moral Objectives 2-1 2-2 重点: Key Points Request 对象、Response 对象的用法 Using the objects of Request and Response. 难点: Focal points Request 对象、Response 对象的用法 Using the objects of Request and Response. 知识单元序号: Knowledge Unit No. 4 支撑教学目标: SLOs Supported 1-1 1-3 1-4 知识单元名称 Unit Title JSP 与 JavaBean JSP and JavaBean 知识点: Knowledge Delivery 编写和使用 JavaBean Programming and using JavaBeans 获取和修改 Bean 属性 Getting and modifying bean properties Bean 的辅助类 Auxiliary class of bean JSP 与 Bean 结合的简单例子 A simple example of JSP combined with bean

了解:Bean的辅助类RecognizeAuxiliary class of bean理解：JSP与Bean结合的简单例子学习目标：UnderstandAsimpleexampleof JSPcombinedwithbeanLearning Objectives编写和使用JavaBean掌握：Programming and using JavaBeansMaster获取和修改Bean属性Getting and modifying bean properties德育目标 2-12-2Moral Objectives编写和使用JavaBean重点：ProgrammingandusingJavaBeans获取和修改Bean属性Key PointsGetting and modifying bean properties难点：Bean的辅助类Focal pointsAuxiliary class of bean1-1知识单元序号支撑教学目标：51-3Knowledge Unit No.SLOs Supported知识单元名称Java Servlet基础Unit TitleBasic of Java ServletServlet的部署、创建和运行Deployment, creation and operation of ServletServlet的工作原理Workingprincipleof Servlet通过JSP页面访问Servlet知识点：Accessing servlet through JSP pageKnowledge Deliverydoget和dopost方法Doget and dopost methods重定向和转发SendRedirect and forward使用SessionUsing Session重定向和转发了解：SendRedirect and forward使用SessionRecognizeUsing Session通过JSP页面访问Servlet理解：学习目标：Accessing servlet through JSP pageLearning ObjectivesUnderstanddoget和dopost方法Doget and dopost methodsServlet的部署、创建和运行掌握：Deployment, creation and operation of ServletMasterServlet的工作原理Working principle of Servlet7/15

7 / 15 学习目标: Learning Objectives 了解: Recognize Bean 的辅助类 Auxiliary class of bean 理解: Understand JSP 与 Bean 结合的简单例子 A simple example of JSP combined with bean 掌握: Master 编写和使用 JavaBean Programming and using JavaBeans 获取和修改 Bean 属性 Getting and modifying bean properties 德育目标 Moral Objectives 2-1 2-2 重点: Key Points 编写和使用 JavaBean Programming and using JavaBeans 获取和修改 Bean 属性 Getting and modifying bean properties 难点: Focal points Bean 的辅助类 Auxiliary class of bean 知识单元序号: Knowledge Unit No. 5 支撑教学目标: SLOs Supported 1-1 1-3 知识单元名称 Unit Title Java Servlet 基础 Basic of Java Servlet 知识点: Knowledge Delivery Servlet 的部署、创建和运行 Deployment, creation and operation of Servlet Servlet 的工作原理 Working principle of Servlet 通过 JSP 页面访问 Servlet Accessing servlet through JSP page doget 和 dopost 方法 Doget and dopost methods 重定向和转发 SendRedirect and forward 使用 Session Using Session 学习目标: Learning Objectives 了解: Recognize 重定向和转发 SendRedirect and forward 使用 Session Using Session 理解: Understand 通过 JSP 页面访问 Servlet Accessing servlet through JSP page doget 和 dopost 方法 Doget and dopost methods 掌握: Master Servlet 的部署、创建和运行 Deployment, creation and operation of Servlet Servlet 的工作原理 Working principle of Servlet

德育目标 2-12-2Moral ObjectivesServlet 的部署、创建和运行重点：Deployment, creation and operation of ServletKey PointsServlet的工作原理Working principle of Servlet重定向和转发难点：SendRedirect and forwardFocal pointsdoget和dopost方法Doget and dopost methods1-1知识单元序号：支撑教学目标：61-3Knowledge Unit No.SLOs Supported知识单元名称MVC模式Unit TitleMVC modeMVC模式介绍Introduction of MVC modeJSP中的MVC模式MVC mode in JSP知识点：模型的生命周期与视图更新Knowledge DeliveryModel life cycle and view updatingMVC模式的简单实例simple example of MVCpattern了解：JSP中的MVC模式RecognizeMVCmodeinJSP学习目标：理解：模型的生命周期与视图更新Learning ObjectivesUnderstandModel life cycle andviewupdating掌握：JSP中的MVC模式MasterMVCmodeinJSP德育目标 2-12-2Moral Objectives重点：JSP中的MVC模式Key PointsMVC mode in JSPJSP中的MVC模式难点：MVC mode in JSPFocal points模型的生命周期与视图更新Model life cycle and view updating1-1知识单元序号：支撑教学目标：71-3Knowledge Unit No.SLOs SupportedJSP中使用数据库知识单元名称Unit TitleUsing database in JSP知识点：MySQL数据库管理系统Knowledge DeliveryMysqldatabasemanagementsystem8/15

8 / 15 德育目标 Moral Objectives 2-1 2-2 重点: Key Points Servlet 的部署、创建和运行 Deployment, creation and operation of Servlet Servlet 的工作原理 Working principle of Servlet 难点: Focal points 重定向和转发 SendRedirect and forward doget 和 dopost 方法 Doget and dopost methods 知识单元序号: Knowledge Unit No. 6 支撑教学目标: SLOs Supported 1-1 1-3 知识单元名称 Unit Title MVC 模式 MVC mode 知识点: Knowledge Delivery MVC 模式介绍 Introduction of MVC mode JSP 中的 MVC 模式 MVC mode in JSP 模型的生命周期与视图更新 Model life cycle and view updating MVC 模式的简单实例 simple example of MVC pattern 学习目标: Learning Objectives 了解: Recognize JSP 中的 MVC 模式 MVC mode in JSP 理解: Understand 模型的生命周期与视图更新 Model life cycle and view updating 掌握: Master JSP 中的 MVC 模式 MVC mode in JSP 德育目标 Moral Objectives 2-1 2-2 重点: Key Points JSP 中的 MVC 模式 MVC mode in JSP 难点: Focal points JSP 中的 MVC 模式 MVC mode in JSP 模型的生命周期与视图更新 Model life cycle and view updating 知识单元序号: Knowledge Unit No. 7 支撑教学目标: SLOs Supported 1-1 1-3 知识单元名称 Unit Title JSP 中使用数据库 Using database in JSP 知识点: Knowledge Delivery MySQL 数据库管理系统 Mysql database management system

查询、更新、添加与删除记录Query, update, add and delete records用结果集操作数据库中的表Using result settooperatetables indatabase预处理语句和事务Preprocessing statementsand transactions标准化考试训练Standardized examination training预处理语句和事务了解：Preprocessing statements and transactions标准化考试训练RecognizeStandardized examination training理解：用结果集操作数据库中的表学习目标：UnderstandUsing result set to operate tables in databaseLearning ObjectivesJSP中使用数据库Usingdatabase in JSP掌握：查询、更新、添加与删除记录MasterQuery,update, add and deleterecords查询、更新、添加与删除记录Query, update, add and delete records德育目标 2-12-2Moral ObjectivesJSP中使用数据库Using database in JSP重点：查询、更新、添加与删除记录Key PointsQuery,update,addanddelete records查询、更新、添加与删除记录Query, update, add and delete records难点：Query, update, add and delete recordsFocal points查询、更新、添加与删除记录知识单元序号：支撑教学目标：1-181-3Knowledge Unit No.SLOs Supported知识单元名称JSP中的文件操作Unit TitleFile operation in JSPFile类Class FileRandomAccessFile类Class RandomAccessFile知识点：文件上传Knowledge DeliveryUpload File文件下载Download File9/15

9 / 15 查询、更新、添加与删除记录 Query, update, add and delete records 用结果集操作数据库中的表 Using result set to operate tables in database 预处理语句和事务 Preprocessing statements and transactions 标准化考试训练 Standardized examination training 学习目标: Learning Objectives 了解: Recognize 预处理语句和事务 Preprocessing statements and transactions 标准化考试训练 Standardized examination training 理解: Understand 用结果集操作数据库中的表 Using result set to operate tables in database 掌握: Master JSP 中使用数据库 Using database in JSP 查询、更新、添加与删除记录 Query, update, add and delete records 查询、更新、添加与删除记录 Query, update, add and delete records 德育目标 Moral Objectives 2-1 2-2 重点: Key Points JSP 中使用数据库 Using database in JSP 查询、更新、添加与删除记录 Query, update, add and delete records 查询、更新、添加与删除记录 Query, update, add and delete records 难点: Focal points Query, update, add and delete records 查询、更新、添加与删除记录 知识单元序号: Knowledge Unit No. 8 支撑教学目标: SLOs Supported 1-1 1-3 知识单元名称 Unit Title JSP 中的文件操作 File operation in JSP 知识点: Knowledge Delivery File 类 Class File RandomAccessFile 类 Class RandomAccessFile 文件上传 Upload File 文件下载 Download File

了解:RandomAccessFile类RecognizeClass RandomAccessFile文件上传学习目标：理解：Upload File文件下载UnderstandLearning ObjectivesDownload File掌握：File类MasterClass File德育目标2-12-2Moral Objectives重点：File类Key PointsClass File难点：RandomAccessFile类Focal pointsClass RandomAccessFile(2）实验教学Experiments注：可根据实际情况增减行数。实验类型可分为验证性、设计性、综合性，实验性质可分为选做、必做Note: Please add/reduce lines based on subject. The Type contains Verify, Design, and Comprehensive, while the Pattemcontains Required and Elective序号实验性质实验项目名称学时每组人数实验类型No.HoursMPG*ExperimentTopicTypePattern基本开发工具的应用设计性必做211Theprimaryuseof EclipseIDE(JavaDesignElecEEIDE)设计性必做Request对象的使用221DesignElecThe usage of Request object API必做JDBC和Servlet的应用设计性213DesignElecApplicationofJDBCand Servlet运用SSH框架编写简单程序设计性必做214UsingSSHframeworktoeditaElecDesignsimpleJSPprogram总计Total8+MPG: Members per group实验项目序号支撑教学目标：11-1 、1-2Experiment NoSLOs Supported每组成员：指导教师：1戴庆天TutorMembers per Group实验名称基本开发工具的应用Experiment TitleThe primary use ofEclipse IDE(Java EE IDE)掌握eclipsej2ee)开发环境。建立一个web工程，配置好tomcat服实验内容：务器，将工程部署在服务器上并启动服务。ContentBuilding web projects via Eclipse IDE(JavaEE IDE), mastering10/15

10 / 15 学习目标: Learning Objectives 了解: Recognize RandomAccessFile 类 Class RandomAccessFile 理解: Understand 文件上传 Upload File 文件下载 Download File 掌握: Master File 类 Class File 德育目标 Moral Objectives 2-1 2-2 重点: Key Points File 类 Class File 难点: Focal points RandomAccessFile 类 Class RandomAccessFile (2) 实验教学 Experiments 注：可根据实际情况增减行数。实验类型可分为验证性、设计性、综合性，实验性质可分为选做、必做。 Note: Please add/reduce lines based on subject. The Type contains Verify, Design, and Comprehensive, while the Pattern contains Required and Elective 序号 No. 实验项目名称 Experiment Topic 学时 Hours 每组人数 MPG* 实验类型 Type 实验性质 Pattern 1 基本开发工具的应用 The primary use of Eclipse IDE(Java EE IDE) 2 1 设计性 Design 必做 Elec 2 Request 对象的使用 The usage of Request object API. 2 1 设计性 Design 必做 Elec 3 JDBC 和 Servlet 的应用 Application of JDBC and Servlet 2 1 设计性 Design 必做 Elec 4 运用 SSH 框架编写简单程序 Using SSH framework to edit a simple JSP program. 2 1 设计性 Design 必做 Elec 总计 Total 8 *MPG: Members per group 实验项目序号: Experiment No. 1 支撑教学目标: SLOs Supported 1-1 、1-2 每组成员: Members per Group 1 指导教师: Tutor 戴庆天 实验名称: Experiment Title 基本开发工具的应用 The primary use of Eclipse IDE(Java EE IDE) 实验内容: Content 掌握 eclipse(j2ee)开发环境。建立一个 web 工程，配置好 tomcat 服 务器，将工程部署在服务器上并启动服务。 Building web projects via Eclipse IDE(JavaEE IDE), mastering