JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Dear Classmates… this is my souvenir to you! …DISCLAIMER… You may refer to this document but at your own risk. The following notes are based on my personal account of the activities as they were given during the ADIS training. I may have skipped or misinterpreted some parts since I also have to perform the activities while trying to update this lecture notes. SMART ADIS PROGRAM (Application Developers’ Intro School) DAY 1: ☺ JJSale Faculty, DLS-CSB / SMIT Computer Applications Thank you SMART for this great opportunity! Introductions… 1. Benhur Ong, Dean, School of Management & Information Technology Welcome Remarks 2. Paolo Villaflores (pbvillaflores@smart.com .ph) SMART Welcome Remarks 3. Mrs. Mercado House Rules 4. Ronald Ramos SMART Trainor Closing Remarks a. Objectives i. SMART looks for possible employees ii. As an alternative employer other than international companies (Japanese, etc.) b. JAVA was selected for practical reasons c. Ronald Ramos (Introduction) i. Formerly from Accenture as IT Consultant (Chiacago) malungkot doon dahil di kasama ang pamilya ii. SMART as consultant iii. IT On Boarding Program – ADIS 1. TO EMPHASIS 2. TO SHORTEN ONBOARDING PROCESS (ORIENTATION) 3. AS COMMUNITY SERVICE iv. C as favorite language v. Basketball, Reading, Cooking, Downloading Anime and movies, Heroes TV Series, Eat Bulaga, 5. Venue 6. Seat Plan http://www.dls-csb.edu.ph Computer Laboratory 8 Ronald Ramos Rey JOJO Jay SMART ADIS Teacher Eugene Omar Toto John Tony Remy Paul Gary JJ ☺ Marilou Heart Christian Ferdie Jenny Em Cathy Al Marian © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 1 of 72 5/16/2008 JJSale’s Personally Recorded Notes: PARTICIPANTS: SMART ADIS (Application Developers’ Intro School) a. John Santillana i. DLS College of Saint Benilde Taft Avenue, Manila ii. Game Guru iii. Web Design and Development b. Rogelio Golez Toto i. Xavier University ii. From Zamboanga iii. Mechanical Engineer iv. Mathlab programming Math v. Basic, Pascal Programming Language vi. Chess Coach c. Omar Sarail i. Ateneo de Zamboanga University ii. Comp Eng, 2 years teaching iii. IT Programming iv. C, C++, Java in Data Structure d. Eugene Lemuele Tarrazona i. Ateneo de Zamboanga University ii. C++ for 4 years iii. Ice Age, Sponge Bob e. Jay Paig i. Holy Name University Tagbilaran ii. VB, Java, C Exposure f. Miguel Sarigumba Jojo i. Holy Name University Tagbilaran ii. C as favorite iii. TV Patrol g. Reynaldo Agunod Rey i. Holy Name University Tagbilaran ii. C, Pascal, Scripting Language h. Ferdie Natividad i. Polytechnic University of the Philippines ii. Hardware i. Paul Pajo III i. DLS College of Saint Benilde Taft Avenue, Manila ii. Computer Science at DLSU j. Gary Soriano Gary i. DLS College of Saint Benilde Taft Avenue, Manila ii. Web Design, Programming k. Joseph Jonathan Sale JJ i. DLS College of Saint Benilde Taft Avenue, Manila ii. Windows applications, SQL, VB, C++, C# , SAD iii. Primetime Kapamilya / Kapuso Shows at the province / Discovery iv. Nature tripping, movies © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 2 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) l. Marilou Novida i. Polytechnic University of the Philippines ii. Pascal, C, Java, WebPages iii. Reading iv. Jacky Chan / Jet Lee Movies m. Hearty Abadies Heart i. University San Carlos Cebu ii. Hardware iii. Reading, Music iv. Love Stories n. Christian Maderazo i. University San Carlos Cebu ii. Assembly, web o. Marian Sy Ian i. Siliman University Dumaguete ii. Turbo C iii. Song Praises, Piano player, Guitar iv. PBB, p. Allan Credo Al i. Siliman University Dumaguete ii. Accounting System iii. C iv. Basketball, NBA, Auto/Cars setup v. Heroes TV Series, Starwars, matrix q. Catherine Nuyad Cathy i. Cebu Institute of Technology ii. 4 years teaching iii. Java, Pascal, C, Foxpro iv. Novels, Window Shopping v. GMA r. Em Parac Em i. Cebu Institute of Technology ii. BS Statistics, MSCS iii. Pascal iv. JAVA as favorite v. Heroes vi. Matrix, Forest s. Jennelyn Coming Jenny i. Cebu Institute of Technology ii. C iii. Chess iv. Cartoon t. Remedios Ado Remy i. Polytechnic University of the Philippines ii. Zilog iii. Hardware Subjects © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 3 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) u. Antonio Velazco Tony i. Polytechnic University of the Philippines ii. DB programming iii. C, Pascal, Assembly iv. Music, Malling v. Kapamilya LECTURE: 1 min Downtime P100,000 cost (SMART Estimates) TECHNOLOGIES: Oracle SQL Database But MS Access will be used instead since it is the database currently installed in most computer laboratories. Adjustments will be experienced when doing the Segment activities since the binder makes use of Oracle SQL syntax. HTML & JSP Web Pages JAVA Application ARCHITECTURE: Windows XP O.S. instead of Red Hat 3.0, Apache Tomcat 5.0 to host websites resulting from the actvities Java Development Kit jdk1.6.0_01 (not lower than version 1.5) MS Access instead of Oracle DB Eclipse SDK COURSE FLOW: Concept overview Case Intro Case work Revalida Debrief (Role Play is suggested) Technology Review © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 4 of 72 5/16/2008 JJSale’s Personally Recorded Notes: Concept Buildup: SDLC SMART ADIS (Application Developers’ Intro School) Waterfall Model (for SMART) + Iterative (Programming Modules) Covers: Testing Doc Standards Security Change Mgt Materials (handouts) will be provided by SMART for each student free… Parts of the materials can be used by other subjects (anchor to) After this boot camp, trainees can be accepted as Interns in SMART (typical of new employees) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 5 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) DAY 2 ADIS Program Conducted at DLS-CSB Topic: Installation Procedure Based on the demonstration lecture of Sir Ronald Date: 5/6/08 Documented by: JJSale, Faculty (DLS-CSB Computer Applications program) Preferably install... 1. JDK 2. Tomcat ... Before installing Tomcat 5.0 and to avoid errors in compiling due to nature of 5.0 not able to pick up changes in Class Path and Java Home .... set the following user variables first… ... Right click My Computer --> Properties --> Advanced Tab --> Environment Variables --> (User Variables) New --> then type the following name: CLASSPATH value: c:\Program Files\Java\jdk1.6.0_01\lib ... (User Variables) New --> then type the following name: JAVA_HOME value: c:\Program Files\Java\jdk1.6.0_01 ... OK --> OK ! ... Used to run html or jsp pages found or hosted at this tomcat web server. ... Just accept defaults and use Admin and Blank passwords for students just to simplify instruction. ... to check if running ... start the tomcat service (see the start bar icon if in stop or play symbol) ...open your browser (ie or firefox) and type the url... http://localhost:8080/ to show the Apache Tomcat welcome page ... to try a website like mySite, ... create a folder mySite in C:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\ROOT\ ... paste your index or start html page in the folder... if not it will display the folder structure of mySite ... then type http://localhost:8080/mySite/ in your browser. CASE SENSITIVE ... to try adminstration of tomcat ... http://localhost:8080/admin/ ... Username: Admin … Password: blank (that is why students must just accept this default to avoid amnesia) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 6 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 3. Eclipse (EXE must be extracted using RAR whenever used, also… try to create a shortcut) ... Installing Eclipse ... Make sure WINRAR is used, if ordinary Windows rar is used, it will display weird problems. ... open the Eclipse package ... double click on Eclipse application ... Extract to your student or faculty designated folder ... Wait for the welcome screen... and that is it. ... New Project (for Dynamic websites) if Eclipse goes wrong... Restart your PC ... Select New Project ... Select Web (Wizard) --> Dynamic Web Project --> Click next ... Type the Project name: (the folder name & website name inside the workspace) example... Test ... target Runtime: --> New --> Apache --> Apache Tomcat 5.0 (no need to install J2EE, it is installed inside Tomcat) Next ... Tomcat Installation Directory: --> Browse --> C:\Program Files\Apache Software Foundation\Tomcat 5.0 OK ... JRE: --> jre.6.0_01 --> Finish ... Next --> Next until Finish ... Import Files (Webpages and pictures created outside Eclipse) using Eclipse Import Files.. DO NOT SIMPLY COPY TO THE FOLDER …MAKE SURE THAT THE WEBSITE IS PORTABLE! (opposed to drag and drop and forget the location) ... Click to expand the new project created ex. Test ... Right Click WebContent --> Import Files --> General --> File System (Double Click) --> (From Directory) Browse --> (find your Webpages) --> (Check the needed html/ jsp/ etc.. Files) --> Finish! (your files will be shown under the WEB-INF folder.) ... Running a Webpage in Eclipse (example, running the index.html page) ... Right click on the index.html file --> Run As --> Run on Server --> (make sure Tomcat v5.0 Server @ localhost is available) --> Next --> (Configured Projects is showing the Test project) --> Finish! (Your page must now show on the Eclipse Viewing Window) ... If error occurs due to PORTS conflict, STOP Tomcat © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 7 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) JSP Pages executed using a browser …Sample 1: Tomcat Hosted HTML data RUN THIS BY TYPING http://localhost:8080/mySite/data_entr y.html from the Web Browser! “If data needs to be passed to another form” Tomcat must be Started to aid in hosting the website (folder) pages DO NOT just double click this file to run the page or else, answer.jsp will just display the source code.

Input 2 Numbers

Number 1

Number 2

<%="Adding the 2 numbers..."%> <% String x = request.getParameter("n1"); String y = request.getParameter("n2"); int a = Integer.parseInt(x); int b = Integer.parseInt(y); %>

The answer is = <%=a+b%>

© Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 8 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) JSP Pages executed using a browser …Sample 2: Tomcat Hosted HTML data

Input Name

<%@page import="java.util.*" %> <% String s = request.getParameter("name1"); %>

Hello <%=s%>

Today's Date is <%= (new Date()).toString() %>

© Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 9 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) DAY 3 1. Setting the ODBC ... The Pets.mdb database ... To connect the ODBC to the MS Access database… …Start Menu Settings Control Panel Performance & Maintenance Administrative Tools Data Sources System DSN (Tab) Add (Select MS Access Driver) (Look for the Database) OK the required DSN Name associated with the actual program that will access the database) OK (Type until Finish! © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 10 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 11 of 72 5/16/2008 JJSale’s Personally Recorded Notes: 2. Sample html SMART ADIS (Application Developers’ Intro School) jsp interaction with database access <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*" %> <% Connection connection = null; String url = "jdbc:odbc:pets"; String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; Class.forName(driver); connection = DriverManager.getConnection(url); String sql = "select * from petInfo"; Statement s = null; ResultSet rs = null; s = connection.createStatement (ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); rs = s.executeQuery(sql); while (rs!=null && rs.next()) {%> <%}%> © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 12 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 3. Exercise 1 : Searching and Viewing Pet Data © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 13 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Enter Pet Name:

© Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 14 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 15 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*" %>

Pet Information

<%=rs.getString("PetID")%>

<%=rs.getString("PetName")%>

<% Connection connection = null; String url = "jdbc:odbc:pets"; String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; Class.forName(driver); connection = DriverManager.getConnection(url); String p = request.getParameter("petName"); String sql ="select * from petInfo where PetName like '%" + p + "%'"; Statement s = null; ResultSet rs = null; s = connection.createStatement (ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); rs = s.executeQuery(sql); %> <% while (rs!=null && rs.next()) {%> <%}%>

ID	Name	Type	Gender	Price
<%=rs.getString("PetID")%>	<%=rs.getString("PetName")%>	<%=rs.getString("PetType")%>	<%=rs.getString("PetGender")%>	<%=rs.getString("PetPrice")%>

Click here to search again © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 16 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 4. Segment 2 Plug-in for the Eclipse project ... Adding MyLib.jar Library Files to the myWeb Project to be used by Segment 2 exercises. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 17 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) ... To add a class folder in the WEB-INF where you can place classes. (and Delete Web App Libraries to remove a level; of abstraction and make the Class folder visible …. A quirky behavior of eclipse) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 18 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) ... To import the classes into the class folder in the WEB-INF that will be needed by Segment 2 Eclipse Project. …IF PROBLEMS are encountered later regarding slow loading of fetched data… try importing classes again! © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 19 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) ... To hide the Class folder again in the WEB-INF © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 20 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Take note that the Class folder in WEB-INF was again hidden… … Update the existing web.xml file by copying the code from the School Files\xml folder © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 21 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) ... To add webx files to the Web Content folder © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 22 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Take note that new JSP and HTML files have been added in the WebContent folder… ... To run webx files from the WebContent folder …Right click input_form.html Run on Server Apache Tomcat © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 23 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Make Sure that an ODBC DSN connection named adis was added to connect to this adis.mdb ... This is the database structure of the adis.mdb… © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 24 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) ... To run create the System DSN connection for this adis.mdb do the following… © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 25 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) ... To run webx files from the WebContent folder Input a valid Number ... If classes were properly added and Eclipse did not encounter DB related problem, you must see this… …Check the Test Script in Segment 2 to determine additional requirements. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 26 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) DAY 4 1. UNIT TESTING: Running Segment 2 Test Scripts on the myWeb Project …Check the Segment 2 Test Script to determine the testing requirements to be applied to the myWeb Project. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 27 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) … fill out the Segment 2 Test Script to document test results with the myWeb Project After performing the Test Scenario, type your Actual Findings, and Test Results (Passed/Failed). It is recommended that a second Test Run be conducted after FIXING the Failed Test Results to update previous findings, and until all Test Results have passed. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 28 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …After testing all scenarios… Fix the errors. Update a copy of the Segment 2 Test Script to document NEW test results. Updating copies of the test Results presents a way to track or refer to previous Test Script Results. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 29 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) TAKE NOTE: Students have the tendencies to complain about the class if error occurs. The Class was already compiled and given so it should not be the source of the problem. They must try to check the TARGET page of their erring webpage. i.e. Change to localhost… The Controller Class © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 30 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …Exporting the Eclipse myWeb Project to WAR and Hosting the it to Tomcat. You can choose any destination for the WAR file as long as you can remember where it is, preferably the Desktop. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 31 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …Deploying WAR files to Tomcat for Hosting. Open Tomcat Start Tomcat service Manager admin (default password) IE Browser type http://localhost:8080/ Tomcat Default name… so keep it as it is at least while learning about it. If the webpage above does not show… Go to Eclipse STOP Tomcat Server (Tomcat at localhost:8080 could not run when the Tomcat Sever in Eclipse has been Started) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 32 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Browse (find your WAR file) Open Deploy …Go to the WAR file to deploy section Browse for WAR © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 33 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Notice the addition of a new Application Path …myWeb NEW Site added! …Check if the myWeb site is available! It should display the webpage below. Type this URL! © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 34 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …USING ECLIPSE: If Subscriber Account is Valid …USING TOMCAT: If Subscriber Account is Valid © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 35 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) localhost:8080/myWeb) …CLUE!!! Errors to fix (find and replace 10.126.51.15:8080/web …CLUE!!! Additional Errors to fix (find and replace /web/controller /myWeb/controller) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 36 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Testing Overview (refer to the PowerPoint Presentation) The V Model Validation VS Verification Levels of Testing o Unit Testing Definition Test of an individual piece of the solution Segment 2 Simulation (minus QA’s Script)) Objective To ensure that the component correctly implements the design specification Common Mistake Testing the code …based on the specification! o Systems Acceptance testing Definition Test the interaction of related components (i.e. passing data from unit to unit) Objective To ensure the components function properly when integrated. Common Mistake Unit testing (not done properly) o User Acceptance Testing (lately, users are getting more involved in developing the project) Definition Concentrates on requirements and business processes, including workflow Objective Ensures that all requirements have been met Common Testing Activities Testing Environment Establish Test Environment (QA’s Work) Develop Test Approach (QA’s Work) Plan Test (QA’s Work) Prepare test (QA’s Work) Execute Test (Application Developer’s Work) Documentation Standards (refer to the PowerPoint Presentation) At the end of Segment 2 Students must pass the debugged JSP pages and updated Test Scripts. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 37 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) DISCLAIMER… Refer to this document at your own risk! DAY 5 SEGMENT 3 1. Discussion on Java Thanks Garry for updating the notes for Segment 3! …Garry Soriano is a faculty of DLS-CSB ☺ JJSale Faculty, DLS-CSB / SMIT Computer Applications 2. Model View Controller (MVC) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 38 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 3. Discussion on SQL (DML) On Slide 19… earlier versions of SQL had problems with regards to buffer size since most programming languages during the early years had fixed memory allocations for databases. Nowadays, buffer size is limitless. 4. How to Debug in Eclipse If the user would like to create a “breakpoint”… right-click on the gray bar at the side of the code editor. You are only allowed to create breakpoints for .jsp files only… you cannot create breakpoints for .HTML files. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 39 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Right click on the line of code that you want to debug… © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 40 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) When running the program in debig mode… instead of clicking “Run As” “Debug On Server” “Run as server”… select “Debug As” . © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 41 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Once you run the program in debug mode… you WILL encounter a message indicating that you are running the program in debug mode (i.e. Confirm Perspective Switch) Click on YES © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 42 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Once you click on YES… the Eclipse IDE will be divided into 5 sections namely: o Thread Views This window shows the active thread the script is running from. o Watch View This window shows the values of the variables/actions being passed during the breakpoint o Source Code View o Outline o Console Output © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 43 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) If the user would like to step into the next line(s) of code… click on Run from the main menu and select either from the following: Step Into, Step Over, or Step Return. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 44 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) SEGMENT 4 1. Creating the “Mediation” JAVA Project using Eclipse Open a Java Project in Eclipse (make sure to close other open projects to avoid unrelated errors) File New Project New project Java Project Project Name (type… Med) and Export Tab (make sure JRE System Library is available) Finish! Next Order © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 45 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …Import Segment 4 - case4 files © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 46 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …Check the imported java program and other associated files. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 47 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 2. Preparing the necessary Test Folders and Data Files …Prepare the necessary test folders Copy the following folders (These will be accessed by the Mediation1.java program) to Copy the backup .DAT file to this EMPTY folder... a new folder that you can remember ex. Case4 in Drive C: © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 48 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 3. Running the Java code …Run As Run …Supply the path as argument Type the path or location of the Test Folders … © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 49 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) Set Console Window visible to see view the program messages This prompt signifies that the .DAT in the INPUT folder was read into the .DAT of the OUTPUT Folder. To check the .DAT file content, try using a Text or Notepad Editor to open them. The folder is Now Empty (Based on requirements)… And the new data was ADDED to the .DAT file The Output file has been updated… © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 50 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 4. Answer the Test Script for Segment 4 and Submit! …Run As Run Copy © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 51 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) DAY 6 & 7 SEGMENT 5 (Covers Case 5 & 6 Codes + Segment 5 Test Script) 1. Using Access SQL to manage the DB… …Open the supplied database… adis.mdb (Since most do not have ORACLE) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 52 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) … Showing the MS Access SQL View in order to create/modify the database by running SQL Scripts… © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 53 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) … Creating the Database for Case 5 using SQL Scripts (Access will be used instead just to simplify the demo) CREATE TABLE SUBSCRIBER_INFO ( SI_NAME varchar(30), SI_MSISDN char(20), SI_IMSI char(20), SI_ACC_NUM char(20), SI_BIRTHDAY varchar2(6), SI_MAIDEN_NAME varchar(20), PRIMARY KEY (SI_IMSI) ); CREATE TABLE TRANSACTIONS ( TR_IMSI char(20), TR_TRANS_DATE char(14), TR_USAGE_TYPE char(5), TR_ID char(20), TR_COST decimal(10,2), PRIMARY KEY (TR_ID) ); CREATE TABLE MONTHLY_USAGES ( MU_ACC_NUM char(20), MU_TRANS_DATE char(6), MU_TRANS_NUM int, MU_COST decimal(10,2), PRIMARY KEY (MU_ACC_NUM,MU_TRANS_DATE) ); CREATE TABLE SUBS_INFO_TBL ( SUBS_NAME varchar(30), MSISDN char(20), IMSI char(20), ACC_NUM char(20), PRIMARY KEY (IMSI) ); CREATE TABLE TRANS_TBL ( IMSI char(20), TS char(14), UT char(5), TRANS_ID char(20), COST decimal(10,2), PRIMARY KEY (TRANS_ID) ); CREATE TABLE MU_TBL ( ACC_NUM char(20), TS char(6), TRANS_NUM int, COST decimal(10,2), PRIMARY KEY (ACC_NUM,TS) ); drop table subscriber_info; drop table transactions; drop table monthly_usages; drop table subs_info_tbl; drop table trans_tbl; drop table mu_tbl; quit DELETE FROM TRANS_TBL; DELETE FROM MU_TBL; INSERT INTO SUBS_INFO_TBL VALUES ('Ivan Remington Or','9196658862 ', '7412589631234567 ','0123456789987654321'); INSERT INTO SUBS_INFO_TBL VALUES ('Ivan Or','9214929896 ', '7418529637748596 ','98765432100123456789'); INSERT INTO SUBSCRIBER_INFO VALUES ('Ivan Remington Or','9196658862 ', '7412589631234567 ','0123456789987654321','021377','Remington' ); INSERT INTO SUBSCRIBER_INFO VALUES ('Ivan Or','9214929896 ', '7418529637748596 ','98765432100123456789', '031477','Joksla'); quit Please keep in mind that these SQL codes were designed to run in ORACLE. So you need to modify the codes to conform to MS Access SQL syntax before pasting each part in the MS SQL View Window and Running “!” them. Page 54 of 72 5/16/2008 © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) … Converting the ORACLE SQL Codes to MS Access SQL syntax in order to experience using SQL scripts. CREATE TABLE SUBSCRIBER_INFO_2 ( SI_NAME text(30), SI_MSISDN text(20), SI_IMSI text (20), Char data type is SI_ACC_NUM text (20), accepted in Access SI_BIRTHDAY number, SI_MAIDEN_NAME text (20), PRIMARY KEY (SI_IMSI) ); CREATE TABLE TRANSACTIONS_2 ( TR_IMSI text(20), TR_TRANS_DATE text(14), TR_USAGE_TYPE text(5), TR_ID text(20), TR_COST number, PRIMARY KEY (TR_ID) ); CREATE TABLE MONTHLY_USAGES_2 ( MU_ACC_NUM text(20), MU_TRANS_DATE text(6), MU_TRANS_NUM number, MU_COST number, PRIMARY KEY (MU_ACC_NUM, MU_TRANS_DATE) ); CREATE TABLE SUBS_INFO_TBL_2 ( SUBS_NAME text(30), MSISDN text(20), IMSI text(20), ACC_NUM text(20), PRIMARY KEY (IMSI) ); CREATE TABLE TRANS_TBL_2 ( IMSI text(20), TS text(14), UT text(5), TRANS_ID text(20), COST number, PRIMARY KEY (TRANS_ID) ); CREATE TABLE MU_TBL_2 ( ACC_NUM text(20), TS text(6), TRANS_NUM number, COST number, PRIMARY KEY (ACC_NUM,TS) ); drop table subscriber_info_2; drop table transactions_2; drop table monthly_usages_2; drop table subs_info_tbl_2; drop table trans_tbl_2; drop table mu_tbl_2; quit DELETE FROM TRANS_TBL_2; DELETE FROM MU_TBL_2; INSERT INTO SUBS_INFO_TBL_2 VALUES ('Ivan Remington Or','9196658862 ', '7412589631234567 ','0123456789987654321'); INSERT INTO SUBS_INFO_TBL_2 VALUES ('Ivan Or','9214929896 ', '7418529637748596 ','98765432100123456789'); INSERT INTO SUBSCRIBER_INFO_2 VALUES ('Ivan Remington Or','9196658862 ', '7412589631234567 ','0123456789987654321','021377','Remington' ); INSERT INTO SUBSCRIBER_INFO_2 VALUES ('Ivan Or','9214929896 ', '7418529637748596 ','98765432100123456789', '031477','Joksla'); quit Please keep in mind that these SQL codes were rewritten to conform to MS Access. Try copying each SQL statement into the MS SQL View Window and Running “!” it. A _2 was added on table names since some tables already exists in adis.mdb Page 55 of 72 © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) … Running the MS Access Database for Case 5 using SQL Scripts modified from ORACLE syntax (Try the rest of the SQL codes to create, insert, and drop tables. CREATE TABLE SUBSCRIBER_INFO_2 ( SI_NAME text(30), SI_MSISDN text(20), SI_IMSI text (20), SI_ACC_NUM text (20), SI_BIRTHDAY number, SI_MAIDEN_NAME text (20), PRIMARY KEY (SI_IMSI) ); CREATE TABLE TRANSACTIONS_2 ( TR_IMSI text(20), TR_TRANS_DATE text(14), TR_USAGE_TYPE text(5), TR_ID text(20), TR_COST number, PRIMARY KEY (TR_ID) ); CREATE TABLE MONTHLY USAGES 2 © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 56 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 2. Answer parts of the Test Script for Segment 5 that makes use of Case 5 files and codes demonstrated previously using ACCESS… (other parts using Case 6 files & codes) NOTE: Some requirements and SQL Statements will need your ingenuity to approximate or simulate some processes since if MS Access is used instead of ORACLE. (Example: Just VIEW the Table Design instead of using DESCRIBE since MS Access does not support that SQL command) … Open the test script for case5 and update a copy of the file. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 57 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 3. Continue answering the Test Script for Segment 5… …The Billing files on Case 6 must be loaded in the Med project under Eclipse. (To be able to answer the other parts that rely on Case 6 files & codes) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 58 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) DAY 8 SEGMENT 6 1. Setting up the environment for RMI (Remote Method Invocation) to allow objects in one JVM (Java Virtual Machine) execute methods of objects residing in another JVM. … Create a folder in C:\RMI and copy all the .JAVA files from Segment6\RMI Copy these files to a new folder C:\rmi … Set the User Environment Variable CLASSPATH by adding ;C:\rmi at the end of the existing path. Be careful not to change the existing class path since your applications installed in your PC might be using these paths. Example: C:\Program Files\Java\jdk1.6.0_01\;C:\Program Files\Java\jdk1.6.0_01\lib;C:\rmi © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 59 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …To make sure that the Java Compiler Works and no problems are encountered regarding file locations (Paths). (System Path allows windows to search for executable files in these paths) %SystemRoot%\system32;%SystemRoot%;%Sy stemRoot%\System32\Wbem;C:\Program Files\ATI Technologies\ATI.ACE\;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\ Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Progra m Files\Java\jdk1.6.0_01\bin The rest of the paths depend on your PC… DO NOT COPY this part. Just ADD the last line (path)! You can also set the path using a DOS Batch File but this means discussing DOS Concepts. …Trying the JAVAC compiler… © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 60 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …Lecture © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 61 of 72 5/16/2008 JJSale’s Personally Recorded Notes: …Review the java codes in C:\RMI based on Betty’s requirements… SMART ADIS (Application Developers’ Intro School) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 62 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …Compile all java programs using the javac compiler and running the compiled Mortgage program. Change Directory to c:\rmi Display the files in folder (/Wide) View the java code (in Notepad) Compile the Mortgage.java program Mortgage.class (JAVA is Case Sensitive) Run the compiled java program Run the compiled java program with parameters or argument values. NOTE: What can be done in class is to allow the students to retype the java classes and files in the PowerPoint presentation. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 63 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …Open another DOS Command Window and run the RMI Registry program (holds all names of remote objects… The server really holds the objects) that comes with the JAVA SDK . Start the RMI Registry program before running the Server.java program NOTE: If an error such as “The port is being used” occurs (PORT 1099 is rarely used, but in your case a program might be using it), just use another port you can conceive (Anything 4 digit value higher than 1099… ex: 8888). The client side program The previously compiled class of Mortgage.java The java program for Mortgage The computation logic The Payment Implementation code for Payment The server side program Payment and PaymentImpl will not run separately since they are used by the Server program Start the Server program for Betty’s Project © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 64 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) On a new Command Window … run the Client program (Since the two previous windows are tied up with running the Server and rmiregistry programs. Compile Client.java Run Client (.class) Run Client with values… Note that now, the remote interface, a remote object and a server are remotely hosted. RMI shines best in an environment where several transactions require or use the same things. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 65 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) 2. Setting Up Segment 6 Solution Files on your computer …Copy the related java files and folders of Case 7 and rmiserver to the c:\rmi folder © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 66 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …Compiling and Running the Solution files in 3 different Command Windows (or Java Virtual Machines) from c:\rmi The opened windows actually represent an example of how multiple JVMs are applied in practice. Window 1: Compile all java programs. Window 1: Run the RmiServer Class and open another window. Note… C> Prompt does not reappear… Window 2: You can start rmiregistry with or without the start command. rmiregistry holds the names of the objects that will be accessed by others. Window 3: Run the Mediation2 file and refer to the Test Script for updating. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 67 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) …Preparing the Test Scenario Folders (an example is given below to facilitate the process) Create the prescribed Directories needed by the Test Scenarios… and copy the required folders and .DAT file(s). © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 68 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) … Running the Mediation2 file from c:\rmi and applying it to the Segment 6 Test Script. Sample Run: (Scenario #1 Observation) Actual Result: The program can open the directory but… NO error message appears even if the required directory is empty. Test Result: Failed Sample Run: (Scenario #2 Observation) Actual Result: The program processes any .DAT file and therefore seems to lack the filename validation logic such that it accepts any .DAT filename found in the INPUT folder. Test Result: Failed To test the script scenarios: Create the CDR_********* folder in C:\rmi\ Copy the Count, Input, Output, Reject Folders If needed… Copy a sample .DAT file from existing source or bak (Case4, or Case7) into the Input Folder Then run the Mediation2 program using the Directory path as argument…. EXAMPLE: Java Mediation2 C:\rmi\CDR_20050 122 © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 69 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) DAY 9 SEGMENT 6 continues… …Complete Segment 6 Test Script (throughout the Morning Session). SEGMENT 7 (7a and 7b) … 1. Review PP Presentations & Perform Segment 7 Test Scripts Regression Testing (when new changes are introduced to a tested code, regression testing will be needed to make sure that the changes will work) applies to Unit Test, System Test. © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 70 of 72 5/16/2008 JJSale’s Personally Recorded Notes: Perform Segment 7a Test Scripts SMART ADIS (Application Developers’ Intro School) Perform Segment 7b Test Scripts © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 71 of 72 5/16/2008 JJSale’s Personally Recorded Notes: SMART ADIS (Application Developers’ Intro School) © Please ask Joseph Jonathan F. Sale’s permission if you intend to use this (jjfsale@yahoo.com). Page 72 of 72 5/16/2008 Filename: SMART ADIS PROGRAM JJSale's Notes Directory: C:\Documents and Settings\JJ\Desktop\ADIS Template: C:\Documents and Settings\JJ\Application Data\Microsoft\Templates\Normal.dot Title: SMART ADIS PROGRAM JJSale's Lecture Notes Subject: Author: Joseph Jonathan Sale Keywords: ADIS, SMART Comments: Creation Date: 5/6/2008 3:16:00 PM Change Number: 196 Last Saved On: 5/16/2008 12:16:00 AM Last Saved By: ITC Total Editing Time: 1,724 Minutes Last Printed On: 5/16/2008 12:24:00 AM As of Last Complete Printing Number of Pages: 72 Number of Words: 3,267 (approx.) Number of Characters: 18,626 (approx.)