2019 fall semester Advanced Objective Programming term project

• Connection DB by JDBC
• Read CSV File and input at DB
• Calculate AirData to CAI
• Send select by ymDate of DB data
• When you have no data, you can retrieve it from website.(http://cleanair.seoul.go.kr/air_pollution.htm?method=period)

• First time you should install MYSQL.
• You must include the external API in the resource directory of your JAVA Build path
• DB does't have a sever.
• I make this program assuming the DB server is open. So I recommend opening the server. And link with server.

• mysql-connector-java-8.0.18.jar
• mail-1.4.7.jar

• Filed | Type | Null | Key | Default | Extra
• ymDate varchar(8) No PRI NULL
• loc_name varchar(20) No PRI NULL
• no2p decimal(4,3) YES NULL
• o3p decimal(4,3) YES NULL
• cop decimal(2,1) YES NULL
• so2p decimal(4,3) YES NULL
• pm10 decimal(4) YES NULL
• pm25 decimal(4) YES NULL