Spring MVC 샘플소스

티스토리 뷰

Web/Spring / Mybatis

Spring MVC 샘플소스

부라더#수 2016. 9. 18. 21:06

** 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;
   }
   
   
}

저작자표시

공유하기 링크

페이스북
카카오스토리
트위터

공지사항

최근에 올라온 글

최근에 달린 댓글

Total

Today

Yesterday

링크

TAG more

« 2025/04 »
일	월	화	수	목	금	토
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30

글 보관함

내 블로그 - 관리자 홈 전환	`Q` `Q`
새 글 쓰기	`W` `W`

글 수정 (권한 있는 경우)	`E` `E`
댓글 영역으로 이동	`C` `C`

이 페이지의 URL 복사	`S` `S`
맨 위로 이동	`T` `T`
티스토리 홈 이동	`H` `H`
단축키 안내	`Shift` + `/` `⇧` + `/`

개발 신에게 보여줄 개발자 노트

티스토리 뷰

Spring MVC 샘플소스

티스토리툴바

단축키

내 블로그

블로그 게시글

모든 영역