The function of implementing database table data movement in the timer, Exception in thread "Timer-0" isexist java.lang.NullPointerException timer error.

1  Packagecom.shawnway.trade.marketdata.constants;2 Importjava.sql.SQLException;3 ImportJava.util.Calendar;4 Importjava.util.Date;5 ImportJava.util.Timer;6 ImportJava.util.TimerTask;7 8 ImportJavax.persistence.EntityManager;9 ImportJavax.persistence.PersistenceContext;Ten  One ImportOrg.slf4j.Logger; A Importorg.slf4j.LoggerFactory; - Importorg.springframework.beans.factory.annotation.Autowired; - Importorg.springframework.stereotype.Component; the Importorg.springframework.web.bind.annotation.RequestMapping; - ImportOrg.springframework.web.bind.annotation.RequestMethod; - ImportOrg.springframework.web.bind.annotation.ResponseBody; -  + ImportCom.shawnway.trade.marketdata.services.ChartService; -  + @Component A  Public classTimerconfig { at @Autowired -         PrivateChartservice Chartservice; - @PersistenceContext -         PrivateEntitymanager em; -          Publictimerconfig (Chartservice CT) {//key resolves null pointer error, -Chartservice=CT; in         } -       //timer.scheduleatfixedrate (timertask task,date firsttime,long period) to       //daily 24:00:00 to perform migration operations +      Public voidinit () { -Calendar Calendar =calendar.getinstance (); theCalendar.set (Calendar.hour_of_day, 15);//Control Time *Calendar.set (Calendar.minute, 3);//Control Points $Calendar.set (Calendar.second, 0);//Control secondsPanax Notoginseng       -Date time =Calendar.gettime ();  the       +Timer timer =NewTimer (); ATimer.scheduleatfixedrate (NewTimerTask () { the         +            Public voidrun () { -SYSTEM.OUT.PRINTLN ("Processor starts running"); $                $             Try { - movestablemes (); -}Catch(SQLException e) { the                 //TODO auto-generated Catch block - e.printstacktrace ();Wuyi             } the           } -}, time, 1000 * 60 * 60 * 24);//This setting will delay the execution of the daily fixed Wu     } -@RequestMapping (value = "/move/movestablemes", method =requestmethod.get) About @ResponseBody $      Public  voidMovestablemes ()throwssqlexception{ -         //first, determine if the storage table exists, and if it exists, transfer the data -         //If it does not exist, create the storage data table before transferring the data -         //The situation temporarily stores the table. (temporary tables are used to hold data for the current day.) ) ACalendar C =calendar.getinstance (); +         intYear=C.get (c.year); the         intMonth=c.get (C.month) +1; -         intToday =C.get (c.day_of_month); $String tbname= ""; the         if(month<=9)  theTbname= "Market_data_candlechart_" +integer.tostring (year) + "0" +integer.tostring (month);//the name of the database the         Else  theTbname= "Market_data_candlechart_" +integer.tostring (year) +integer.tostring (month);//the name of the database -String tempertb= "Market_data_candlechart";//table name where temporary information is stored inSystem.out.println ("performed to Isexist"); the         BooleanFlag=chartservice.isexist (Tbname);//determine if the corresponding database exists theSystem.out.println ("Isexist End"); About         if(flag) {//if it already exists, you can insert data from the temporary table directly into the corresponding table . theCHARTSERVICE.MOVEMESTOOLDTB (TBNAME,TEMPERTB);//move the data in the staging table to a table with the Tbname name.  the}Else{ theCHARTSERVICE.CREATETEMPERTB (Tbname);//If it does not exist, you need to create a table with the corresponding name first +CHARTSERVICE.MOVEMESTOOLDTB (TBNAME,TEMPERTB);//move the data in the staging table to a table with the Tbname name.  -         } the         //after the data has been transferred, the data of the temporary table is cleanedBayi CHARTSERVICE.DELETTEMPERTB (TEMPERTB); the     } the      -}

1  PackageCom.shawnway.trade.marketdata;2 3 4 5 Importjava.io.FileNotFoundException;6 7 ImportOrg.apache.catalina.Server;8 ImportOrg.apache.catalina.Service;9 ImportOrg.apache.catalina.connector.Connector;Ten ImportOrg.apache.catalina.valves.RemoteIpValve; One Importorg.springframework.beans.factory.annotation.Autowired; A Importorg.springframework.boot.SpringApplication; - Importorg.springframework.boot.autoconfigure.SpringBootApplication; - ImportOrg.springframework.boot.context.embedded.ConfigurableEmbeddedServletContainer; the ImportOrg.springframework.boot.context.embedded.EmbeddedServletContainerCustomizer; - ImportOrg.springframework.boot.context.embedded.tomcat.TomcatConnectorCustomizer; - Importorg.springframework.boot.context.embedded.tomcat.TomcatEmbeddedServletContainerFactory; - ImportOrg.springframework.context.annotation.Bean; + ImportOrg.springframework.context.annotation.PropertySource; - Importorg.springframework.core.env.Environment; +  A ImportCom.shawnway.trade.marketdata.constants.SystemConfig; at ImportCom.shawnway.trade.marketdata.constants.TimerConfig; - ImportCom.shawnway.trade.marketdata.core.collect.MarketDataCollectHandler; - ImportCom.shawnway.trade.marketdata.core.ctp.CTPApiHandler; - ImportCom.shawnway.trade.marketdata.core.ctp.CTPGatewayProxy; - ImportCom.shawnway.trade.marketdata.core.ctp.CTPMarketDataHandler; - ImportCom.shawnway.trade.marketdata.core.ctp.CTPZeroMQHandler; in ImportCom.shawnway.trade.marketdata.core.es.EsMarketDataHandler; - ImportCom.shawnway.trade.marketdata.core.es.EsunnyApiHandler; to ImportCom.shawnway.trade.marketdata.core.es.EsunnyGatewayProxy; + ImportCom.shawnway.trade.marketdata.core.sp.SharppointApiHandler; - ImportCom.shawnway.trade.marketdata.core.sp.SharppointGatewayProxy; the ImportCom.shawnway.trade.marketdata.core.sp.SpMarketDataHandler; * ImportCom.shawnway.trade.marketdata.services.ChartService; $ ImportCom.shawnway.trade.marketdata.services.MapContainer;Panax Notoginseng  -@PropertySource ({"File:${config.dir}/config/web.properties" }) the @SpringBootApplication +  Public classApplicationlauncher { A @Autowired the     PrivateEnvironment env; + @Autowired -     PrivateChartservice Chartservice; $      $@Bean (name = {"Timerconfig"}, Initmethod = "Init") -      Publictimerconfig Timerconfig () { -System.out.println ("Timerconfig has begun to run ~"); the         return NewTimerconfig (Chartservice);//

Chartservice passed in to resolve null pointer errors

 -  } Wuyi  Public Static voidMain (string[] args)throwsException { theSystem.setproperty ("Config.dir", System.getproperty ("User.dir"));  - FinalString dir = system.getproperty ("Config.dir");  WuSystem.setproperty ("Logging.config", dir + "/config/logging.xml");  -Springapplication.run (Applicationlauncher.class, args);  About  }  $}

The function of implementing database table data movement in the timer, Exception in thread "Timer-0" isexist java.lang.NullPointerException timer error.