180 likes | 333 Views
CTEC2404 Internet Software Development. Module information. Using structured data (XML/ MySQL ) and Java Server Pages ( JSP ) to generate web pages dynamically under a client-server architecture. CTEC2404 Internet Software Development Staff. Ian Smith ims@dmu.ac.uk GH 5.14
E N D
Module information Using structured data(XML/MySQL) and Java Server Pages (JSP) to generate web pages dynamically under a client-serverarchitecture
CTEC2404 Internet Software DevelopmentStaff Ian Smith ims@dmu.ac.uk GH 5.14 Brian Kiely bkiely@dmu.ac.uk GH 6.73 Tugrul Essendal the@dmu.ac.uk GH 5.20 Dawn Johnston dawn@dmu.ac.uk GH 5.58
CTEC2404 - Learning, teaching and assessment • Learning/Teaching • 1 x 1hr lecture • Slides available on Blackboard • Watch as slideshow - animated • 1 x 2hr Laboratory • Very important – key learning activity • Content based on previous week's lecture • Incremental development – keep on top • Continue in own time – continuous learning
CTEC2404 - Learning, teaching and assessment Assessment • 100% Coursework - (self selected pairs lab based) • Individual contributions to the work • Assessed by viva/demonstration in labs • Two assignments – both JSPclient-server based • Equally weighted • Developing dynamic web based applications • Term 1 XML structured data • Term 2 mySQL structured data
CTEC2404 – Resources - notes • Lecture, Lab and CW materials on • Blackboard and • L drive – L:\J3T\10-11\CTEC2404 • Booklets - available at first lab • Grey (Setup – Lab and PC) Labs weeks 1, 2 • Orange (JSTL and XML) Lectures and Labs • Gold (JSP/JSTL) Reference • Red (JSP and MySQL) Term 2
CTEC2404 – Resources - software • Downloads for home set up - L:/J3T/10-11 • Servers Tomcat, mySQL, • Secure FTP SSH Secure (file transfer and shell) • JPadPro • This is now free from • http://www.modelworks.com/downloads.html • Download version 6.5 then follow the link below the table to free licenses - get the right one
XML document (as a text file) eg xml-filename.xml Stylesheet document (as a text file) eg c:import xsl-filename.xsl requested page processing page request processTransformation.jsp c:import x:transform creates the output tree here. response This is serialised into a character stream as the response to the user. Basic software architecture term 1 <x:transform ... /> an XML Orangebooklet page 3-4
AssumptionsWe assume you know how to • create an XHTML page with forms, tables, lists etc (see next slide too) • write SQL commands to modify a database • Create tables with keys • Retrieve data • Add data • Delete data • Update data
Assumed knowledge and skills • Well-formed HTML • Obeys the rules of XML including: • matching start/end tags, (matching case) • no interleaving of elements, • one root element, (html) • attribute values in matching quotes (single or double), • empty element has closing tag <br /> • etc. • Can be checked (val.jsp – on local pc or server) • XHTML • HTML following rules of XML • Basic SQL – term 2 • Constructing TABLES • SELECT … • INSERT • DELETE
! database files XML, XHTML, JSP,XSLT Class files Client-Server relationship generic configuration Web Server (e.g tomcat) Web Client Browser (e.g. firefox) http request http response Database server (e.g.mySQL) term 2 Development Environment (e.g JPadPro) edit
XML, XHTML, JSP,XSLT Class files Client-Server relationship – term 1 generic configuration port 8080 Web server (tomcat) Browser Web client (e.g. firefox) http request http response Development Environment (JPadPro) edit
XML, XHTML, JSP,XSLT Class files j3t - localhost server in any PC Lab localhost lab pc Lab configuration Development environment port 8080 Web server (tomcat) Browser Web client (e.g. firefox) http request http response Development Environment (JPadPro) c:\user edit h:\j3t\webappfolder
XML, XHTML, JSP,XSLT Class files j3t - localhostserver – home PC localhost home pc port 8080 Web server (tomcat) Browser Web client (e.g. firefox) http request http response Development Environment (JPadPro) edit C:\j3t\webappfolder
XML, XHTML, XML, XHTML, JSP,XSLT JSP,XSLT Class files Class files j3t – faculty network servers localhost jsp.t10.tech.dmu.ac.uk lab pc port 8080 Web server (tomcat) Browser Web client (e.g. firefox) http request http response Development Environment (JPadPro) c:\user edit edit Secure ftp transfer h:\j3t\webappfolder h:\j3t\webappfolder
Week 1 Labs • Create h:\j3t folder • Copy build.xml and build.properties from the L: drive into h:\j3t • Edit build.properties to use your passwords • Run ANT script to set up folder structure • Test the system - web and database servers • Use Secure Shell to access the jsp server