i.Framev3.13LabSheetPart110January2020NCSPte.Ltd.5AngMoKioStreet62,NCSHub,Singapore569141Tel:(65)65568000Fax:(65)65567000©2008NCSPte.Ltd.i.Framev.3.13LabSheet10January2020NCSConfidentialCopyright©2008NCSPteLtd,AllRightsReservedPage2of32CONTACTINFORMATIONForinformationaboutiConnectTM,pleasecontact:ChiefArchitectOfficeNCSPte.Ltd.5AngMoKioStreet62,NCSHub,Singapore569141Website::iconnect-supp@ncs.com.sgTel:(65)65568000Fax:(65)65567000i.Framev.3.13LabSheet10January2020NCSConfidentialCopyright©2008NCSPteLtd,AllRightsReservedPage3of32TABLEOFCONTENTS1SoftwareInstallation....................................................................................................................41.1InstallingJ2SESDK...................................................................................................................51.2InstallingMaven2.......................................................................................................................81.3ConfigureMaven2LocalSettings..............................................................................................91.4InstallingEclipse......................................................................................................................121.5ConfiguringEclipse..................................................................................................................131.6InstallingMySQL......................................................................................................................171.7InstallingSQLYog....................................................................................................................25i.Framev.3.13LabSheet10January2020NCSConfidentialCopyright©2008NCSPteLtd,AllRightsReservedPage4of321SoftwareInstallationTable1-1liststhethird-partysoftwarepackagesweneedtoinstallbeforewecancarryouttheexercisesinthislab.Table1-2liststhepackagesandfilesweneedfordoingtheexercisesinthislab.NoSoftwareVersionInstallationFile1J2SESDK1.5.0_16jdk-1_5_0_16-windows-i586-p.exeiConnectv3.12.1iscompatiblewithJDK1.5andlater.2Eclipseiconnecteclipse-iconnect-win32.zipThiseclipsebundleisbasedonEclipseJEEEuropadistributionwithadditionsofSubversionclient(subclipse),SpringIDEandEasyShell.3Maven22.0.8apache-maven-2.0.8.zip4MySQL5.0.67MySQLDatabaseInstallationCommunityedition5SQLYog7.11MySQLGUIClientCommunityeditionTable1-1Third-partysoftwarepackagestobeinstalledNoPackage/FileVersionFileName1iConnectStarterPackage3.13iConnect-Starter-Package-v3.13.zipTable1-2Packages/FilesfromiConnectv3.13ThesecomponentsarelocatedinC:\iconnect\installers,andthefollowingsub-sectionswillprovideastepbystepguideonhowtoinstallthesecomponents.i.Framev.3.13LabSheet10January2020NCSConfidentialCopyright©2008NCSPteLtd,AllRightsReservedPage5of321.1InstallingJ2SESDK1.RuntheJ2SESDKinstallationprogrambydouble-clickingonthejdk-1_5_0_16-windows-i586-p.exefile.ThelicenseagreementfortheJ2SESDKwillbeshown.RefertoFigure1-1下方.Figure1-1J2SESDKLicenseAgreement2.Clickon“Iacceptthetermsinthelicenseagreement”.3.Clickon“Next”.“CustomSetup”screenwillbeshown.RefertoFigure1-2下方.i.Framev.3.13LabSheet10January2020NCSConfidentialCopyright©2008NCSPteLtd,AllRightsReservedPage6of32Figure1-2J2SESDKCustomSetup4.Clickon“Next”tocontinue.Note:TheJ2SESDKwillbeinstalledtoC:\ProgramFiles\Java\jdk-1.5.0_16.“Progress”screenwillbeshown.RefertoFigure1-3下方.i.Framev.3.13LabSheet10January2020NCSConfidentialCopyright©2008NCSPteLtd,AllRightsReservedPage7of32Figure1-3J2SESDKInstallation–Progress5.Uponcompletion,“J2SEDevelopmentKit5.0Update15-Complete”screenwillbeshown.RefertoFigure1-4下方.Figure1-4J2SESDKInstallationCompleted6.Clickon“Finish”tocompletetheinstallation.7.Goto“Start”“ControlPanel”.8.Doubleclickon“System”.9.Clickonthe“Advanced”tab.10.Clickon“EnvironmentVariables”.11.Underthe“SystemVariables”section,clickon“New”toenteranewvariable.Figure1-5J2SESDKCreateJAVA_HOMEvariable12.EnterthevariablenameandvalueasshowninFigure1-5above.i.Framev.3.13LabSheet10January2020NCSConfidentialCopyright©2008NCSPteLtd,AllRightsReservedPage8of321.2InstallingMaven21.Extractapache-maven-2.0.8-bin.ziptoC:\2.Goto“Start”“ControlPanel”3.Doubleclickon“System”4.Clickon“AdvancedTab”5.Clickon“EnvironmentVariables”6.Underthe“SystemVariables”section,clickon“New”toenteranewvariable.Figure1-6CreateM2_HOMEvariable7.Click“OK”8.Selectvariable“PATH”forexistingvariablelistandclick“Edit”Figure1-7Appendmaven2bintosystem’spath9.Append“;%M2_HOME%\bin”tocurrentvariablevalueasshowinthefigureabove.IMPORTANT:Ifyoucouldn’tfind“PATH”variablefromthelist,createanewoneandsetthevalueto“%PATH%;%M2_HOME%\bin”10.Verifyifmaveninstallationwasdonesuccessfullybyexecuting“mvn--version”innewopenedcommandconsole.Figure1-8VerifyMaven2Installationi.Framev.3.13LabSheet10January2020NCSConfidentialCopyright©2008NCSPteLtd,AllRightsReservedPage9of321.3ConfigureMaven2LocalSettingsEachmaven2installationbydefaultwillbeusingdefaultconfigurationlocatedinMAVEN_HOME/conf/settings.xml.However,usersareallow