File name
Commit message
Commit date
File name
Commit message
Commit date
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;
}
}