File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
package egovframework.migration.web;
import java.util.Map;
import javax.annotation.Resource;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import egovframework.migration.service.MariaMigrationService;
@Controller
public class MariaMigrationController {
@Resource(name = "MariaMigrationService")
private MariaMigrationService mariaMigrationService;
@RequestMapping(value="/maria/migration.do")
public String mariaTestPage(ModelMap model) throws Exception{
int selectKcdfBasicCount = mariaMigrationService.selectKcdfBasicCount();
mariaMigrationService.kcdfMigration();
/*List<OrcaleTestVO> list = orcalTestDAO.selectOracleBasicList();*/
mariaMigrationService.selectOracleBasicList();
int selectMariaBasicCount = mariaMigrationService.selectMariaBasicCount();
int selectOraclePublishCount = mariaMigrationService.selectOraclePublishCount();
int selectMariaPublishCount = mariaMigrationService.selectMariaPublishCount();
int selectOracleFileCount = mariaMigrationService.selectOracleFileCount();
int selectMariaFileCount = mariaMigrationService.selectMariaFileCount();
int selectOracleResrvationCount = mariaMigrationService.selectOracleResrvationCount();
int selectMariaResrvationCount = mariaMigrationService.selectMariaResrvationCount();
/*model.addAttribute("selectOracleBasicCount", selectOracleBasicCount );
model.addAttribute("selectMariaBasicCount", selectMariaBasicCount );
model.addAttribute("selectOraclePublishCount", selectOraclePublishCount );
model.addAttribute("selectMariaPublishCount", selectMariaPublishCount );
model.addAttribute("selectOracleFileCount", selectOracleFileCount );
model.addAttribute("selectMariaFileCount", selectMariaFileCount );
model.addAttribute("selectOracleResrvationCount", selectOracleResrvationCount );
model.addAttribute("selectMariaResrvationCount", selectMariaResrvationCount );*/
return "test/oracle/TestOracle";
}
@RequestMapping(value="/maria/dataBaseAjax.do")
public ModelAndView mariaDataBaseAjax(@RequestParam Map<String, Object> commandMap){
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
String type = (String) commandMap.get("type");
System.out.println("type : " + type);
if(type =="basic" || type.equals("basic")){
mariaMigrationService.selectOracleBasicList();
}else if(type =="Publish" || type.equals("Publish")){
mariaMigrationService.selectOraclePublishList();
}else if(type =="file" || type.equals("file")){
mariaMigrationService.selectOracleFileList();
}else if(type =="Resrvation" || type.equals("Resrvation")){
mariaMigrationService.selectOracleResrvationList();
}
modelAndView.addObject("result", "TEST");
return modelAndView;
}
}