index

1. Getting started

   • Oracle Database 11g Express Edition
   • Spring framework
   • Config File
   • OpenWeatherMap

2. Tutorial

   • Authentication
     • singin
     • signup
     • find id/passwd
     • edit account info
   • Main
     • main_page
     • Chat
     • Weather & Position
   • Post
     • create post
     • display post

3. Error report

   • 403 error

1. Getting Started

1. Oracle Database 11g Express Edition
2. Spring frame work servlet.context

   <beans:bean id="dataSource"   //DB 계정 및 패스워드 설정
    	class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    	<beans:property name="driverClassName"
    		value="oracle.jdbc.OracleDriver" />
    	<beans:property name="url"
    		value="jdbc:oracle:thin:@localhost:1521:XE" />
    	<beans:property name="username" value="USERNAME" />
    	<beans:property name="password" value="PASSWORD" />
    </beans:bean>
   
   <websocket:handlers>   //웹소켓 매핑명 지정
    	<websocket:mapping path="/chat"
    		handler="myHandler" />
    </websocket:handlers>
   

3. Config File 설정파일에서는 Database정보와 서버

   #### Oracle DB Info ####
   db.driver=oracle.jdbc.driver.OracleDriver
   db.url=jdbc:oracle:thin:@localhost:1521:orcl
   db.username=USERNAME
   db.password=PASSWORD
   
   #### File Path ####
   path.image=http://SERVER IP ADDRESS/traveler/resources/images
   #### Server IP Address Info ####
   ip.address=IPADDRESS
   ip.portNo=PORT#
   
   #### openWeather App Key info ####
   OpenWeather.appkey=APPKEY
   

4. OpenWeatherMap

2. Config File

3. tutorial

1. Authentication

   • signin

   • signup

   • find id/passwd

   • edit account info

2. Main
   • main page
   • chat
   • weather & Map
3. Post
   • create post
   • display post

3. Error report

1. 403 error