Spring MVC 샘플소스

** GachonLine2.0v 프로젝트 Sample Source code (개인참고용)

"ManagementCurriculumController.java"

package com.myspring.gachon.admin.curriculum.controller; import javax.servlet.http.HttpServletRequest; import net.sf.json.JSONArray; import net.sf.json.JSONObject; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.ResponseBody; import com.myspring.gachon.admin.curriculum.service.ManagementCurriculumService; import com.myspring.gachon.admin.curriculum.vo.ManagementCurriculumVO; import com.myspring.gachon.common.code.CodeService; @Controller public class ManagementCurriculumController { @Autowired private ManagementCurriculumService ManagementCurriculumServiceImpl; @Autowired private CodeService CodeServiceimpl; @Autowired HttpServletRequest request; @RequestMapping(value = "/admin/manage_curriculum", method = RequestMethod.GET) public String manage_curriculum(Model model) { model.addAttribute("COMPLETE_DIVISION",JSONArray.fromObject(CodeServiceimpl.selectCodeDet("COMPLETE_DIVISION"))); model.addAttribute("MAJOR",JSONArray.fromObject(CodeServiceimpl.selectCodeDet("MAJOR"))); return "/admin/manage_curriculum/ManagementCurriculum"; } // selectCourseCurriculum_MST select @RequestMapping(value = "/admin/manage_curriculum/curriculumMST.json", method = RequestMethod.POST) @ResponseBody public JSONArray selectCurriculumMST(ManagementCurriculumVO vo) { System.out.println("*****Controller까지 넘어 온 major 값*******"+vo.getMajor()+"********"); System.out.println("*****Controller까지 넘어 온 year 값*******"+vo.getYear()+"********"); System.out.println("*****Controller까지 넘어 온 schoolYear 값*******"+vo.getSchoolYear()+"********"); return JSONArray.fromObject(ManagementCurriculumServiceImpl.selectCourseCurriculum_MST(vo)); } // insertCourseCurriculum_MST insert @RequestMapping(value = "/admin/manage_curriculum/curriculumMST.insert", method = RequestMethod.POST) @ResponseBody public JSONObject insertCurriculumMST(ManagementCurriculumVO vo){ return ManagementCurriculumServiceImpl.insertCourseCurriculum_MST(vo); } // updateCourseCurriculum_MST update @RequestMapping(value = "/admin/manage_curriculum/curriculumMST.update", method = RequestMethod.POST) @ResponseBody public JSONObject updateCurriculumMST(ManagementCurriculumVO vo){ return ManagementCurriculumServiceImpl.updateCourseCurriculum_MST(vo); } // deleteCourseCurriculum_MST delete @RequestMapping(value = "/admin/manage_curriculum/curriculumMST.delete", method = RequestMethod.POST) @ResponseBody public JSONObject deleteCurriculumMST(ManagementCurriculumVO vo){ return ManagementCurriculumServiceImpl.deleteCourseCurriculum_MST(vo); } }

"ManagementCurriculumDao.java"

package com.myspring.gachon.admin.curriculum.dao; import java.util.List; import net.sf.json.JSONObject; import com.myspring.gachon.admin.curriculum.vo.ManagementCurriculumVO; public interface ManagementCurriculumDao { // JSONObject selectCourseCurriculum_MST(ManagementCurriculumVO vo); List<ManagementCurriculumVO> selectCourseCurriculum_MST(ManagementCurriculumVO vo); JSONObject insertCourseCurriculum_MST(ManagementCurriculumVO vo); JSONObject updateCourseCurriculum_MST(ManagementCurriculumVO vo); JSONObject deleteCourseCurriculum_MST(ManagementCurriculumVO vo); }

"ManagementCurriculumDaoImpl.java"

package com.myspring.gachon.admin.curriculum.dao;
import java.util.List;
import org.apache.ibatis.mapping.SqlCommandType;
import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.myspring.common.exception.GachonDaoException;
import com.myspring.gachon.admin.curriculum.vo.ManagementCurriculumVO;
import net.sf.json.JSONObject;
@Repository
public class ManagementCurriculumDaoImpl implements ManagementCurriculumDao {
   @Autowired
   private SqlSession sqlSession;
   // end must be point .
   private static final String NS = "mapper.com.myspring.gachon.admin.curriculum.";
   
   @Override
   public List<ManagementCurriculumVO> selectCourseCurriculum_MST(ManagementCurriculumVO vo) {
      
      System.out.println("*****Dao까지 넘어 온 major 값*******"+vo.getMajor()+"********");
      System.out.println("*****Dao까지 넘어 온 year 값*******"+vo.getYear()+"********");
      System.out.println("*****Dao까지 넘어 온 schoolYear 값*******"+vo.getSchoolYear()+"********");
      
      return sqlSession.selectList(NS + "selectCourseCurriculum_MST", vo);
   }
// courseNum + courseName 을 같이 한 칼럼에 쓰는 구문 : JSONObject 활용
//   @Override
//   public JSONObject selectCourseCurriculum_MST(ManagementCurriculumVO vo) {
//      JSONObject jsonObject = new JSONObject();
//      JSONArray data = JSONArray.fromObject(sqlSession.selectList(NS + "selectCourseCurriculum_MST"));
//      for (int i = 0; i < data.size(); i++) {
//         JSONObject temp = new JSONObject();
//         temp = data.getJSONObject(i);
//         temp.put("courseNum", "[" + temp.get("courseNum") + "]\t" + temp.get("courseName"));
//         data.set(i, temp);
//      }
//      jsonObject.put("RESULT_CODE", data);
//      return jsonObject;
//   }
   @Override
   public JSONObject insertCourseCurriculum_MST(ManagementCurriculumVO vo) {
      return GachonDaoException.goQuery(sqlSession, SqlCommandType.INSERT, NS + "insertCourseCurriculum_MST", vo);
   }
   @Override
   public JSONObject updateCourseCurriculum_MST(ManagementCurriculumVO vo) {
      return GachonDaoException.goQuery(sqlSession, SqlCommandType.UPDATE, NS + "updateCourseCurriculum_MST", vo);
   }
   @Override
   public JSONObject deleteCourseCurriculum_MST(ManagementCurriculumVO vo) {
      return GachonDaoException.goQuery(sqlSession, SqlCommandType.DELETE, NS + "deleteCourseCurriculum_MST", vo);
   }
}

"ManagementCurriculumService.java"

package com.myspring.gachon.admin.curriculum.service;

import java.util.List;

import net.sf.json.JSONObject;

import com.myspring.gachon.admin.curriculum.vo.ManagementCurriculumVO;

public interface ManagementCurriculumService {

// JSONObject selectCourseCurriculum_MST(ManagementCurriculumVO vo);

List<ManagementCurriculumVO> selectCourseCurriculum_MST(ManagementCurriculumVO vo);

JSONObject insertCourseCurriculum_MST(ManagementCurriculumVO vo);

JSONObject updateCourseCurriculum_MST(ManagementCurriculumVO vo);

JSONObject deleteCourseCurriculum_MST(ManagementCurriculumVO vo);

}

"ManagementCurriculumServiceImpl.java"

package com.myspring.gachon.admin.curriculum.service;
import java.util.List;
import net.sf.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.myspring.gachon.admin.curriculum.dao.ManagementCurriculumDao;
import com.myspring.gachon.admin.curriculum.vo.ManagementCurriculumVO;
@Service
public class ManagementCurriculumServiceImpl implements ManagementCurriculumService {
   @Autowired
   private ManagementCurriculumDao managementcurriculumDao;
      
   @Override
   public List<ManagementCurriculumVO> selectCourseCurriculum_MST(ManagementCurriculumVO vo) {
      
      System.out.println("*****Service까지 넘어 온 major 값*******"+vo.getMajor()+"********");
      System.out.println("*****Service까지 넘어 온 year 값*******"+vo.getYear()+"********");
      System.out.println("*****Service까지 넘어 온 schoolYear 값*******"+vo.getSchoolYear()+"********");
      
      return managementcurriculumDao.selectCourseCurriculum_MST(vo);
   }
   
//   @Override
//   public JSONObject selectCourseCurriculum_MST(ManagementCurriculumVO vo) {
//      return managementcurriculumDao.selectCourseCurriculum_MST(vo);
//   }
   
   @Override
   public JSONObject insertCourseCurriculum_MST(ManagementCurriculumVO vo) {
      return managementcurriculumDao.insertCourseCurriculum_MST(vo);
   }
   
   @Override
   public JSONObject updateCourseCurriculum_MST(ManagementCurriculumVO vo) {
      return managementcurriculumDao.updateCourseCurriculum_MST(vo);
   }
   @Override
   public JSONObject deleteCourseCurriculum_MST(ManagementCurriculumVO vo) {
      return managementcurriculumDao.deleteCourseCurriculum_MST(vo);
   }
}


"ManagementCurriculumVO.java"

package com.myspring.gachon.admin.curriculum.vo;
import org.apache.ibatis.type.Alias;
@Alias(value = "ManagementCurriculumVO")
public class ManagementCurriculumVO {
   private String year;
   private String courseNum;
   private String courseName;
   private String major;
   private String major_nm;
   private String semester;
   private String completeDivision;
   private String completeDivision_nm;
   private Integer grade;
   private String schoolYear;
   private String crtUser;
   private String crtdt;
   private String updtUser;
   private String updtdt;
   
   public String getYear() {
      return year;
   }
   public void setYear(String year) {
      this.year = year;
   }
   public String getCourseNum() {
      return courseNum;
   }
   public void setCourseNum(String courseNum) {
      this.courseNum = courseNum;
   }
   public String getCourseName() {
      return courseName;
   }
   public void setCourseName(String courseName) {
      this.courseName = courseName;
   }
   public String getMajor() {
      return major;
   }
   public void setMajor(String major) {
      this.major = major;
   }
   public String getMajor_nm() {
      return major_nm;
   }
   public void setMajor_nm(String major_nm) {
      this.major_nm = major_nm;
   }
   public String getSemester() {
      return semester;
   }
   public void setSemester(String semester) {
      this.semester = semester;
   }
   public String getCompleteDivision() {
      return completeDivision;
   }
   public void setCompleteDivision(String completeDivision) {
      this.completeDivision = completeDivision;
   }
   public String getCompleteDivision_nm() {
      return completeDivision_nm;
   }
   public void setCompleteDivision_nm(String completeDivision_nm) {
      this.completeDivision_nm = completeDivision_nm;
   }
   public Integer getGrade() {
      return grade;
   }
   public void setGrade(Integer grade) {
      this.grade = grade;
   }
   public String getSchoolYear() {
      return schoolYear;
   }
   public void setSchoolYear(String schoolYear) {
      this.schoolYear = schoolYear;
   }
   public String getCrtUser() {
      return crtUser;
   }
   public void setCrtUser(String crtUser) {
      this.crtUser = crtUser;
   }
   public String getCrtdt() {
      return crtdt;
   }
   public void setCrtdt(String crtdt) {
      this.crtdt = crtdt;
   }
   public String getUpdtUser() {
      return updtUser;
   }
   public void setUpdtUser(String updtUser) {
      this.updtUser = updtUser;
   }
   public String getUpdtdt() {
      return updtdt;
   }
   public void setUpdtdt(String updtdt) {
      this.updtdt = updtdt;
   }
   
   
}