<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<style type="text/css">
#menu:link {color: black; text-decoration: none;}
#menu:visited {color: blue; text-decoration: none;}
#menu:hover {color: green; text-decoration: underline;}
#menu:active {color: gray; text-decoration: none;}
</style>
</head>
<body>
*** 메인화면 ***<br>
<a href="/Chapter06_DynamicSpringMaven/user/userInsertForm.do" id="menu">1. 입력 </a><br>
<a href="/Chapter06_DynamicSpringMaven/user/userSelect.do" id="menu">2. 출력 </a><br>
<a href="/Chapter06_DynamicSpringMaven/user/userUpdateInput.do" id="menu">3. 수정 </a><br>
<a href="/Chapter06_DynamicSpringMaven/user/userDeleteInput.do" id="menu">4. 삭제 </a>
</body>
</html>
/////////////////////////////////////////
package com.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import com.bean.UserDTO;
import com.dao.UserDAO;
//@Controller
@RequestMapping("/user")
@Component
public class UserControlloer {
@Autowired
private UserDAO userDAO;
//http://localhost:9090/Chapter06_DynamicSpringMaven/main/index.do
@RequestMapping(value="/index.do", method = RequestMethod.GET) // get방식
public String index() {
return "/main/index";
}
@RequestMapping(value="/userInsertForm.do", method = RequestMethod.GET) // get방식
public String userInsertForm() {
return "/user/userInsertForm";
}
@RequestMapping(value="/userInsert.do", method = RequestMethod.POST) // post방식
public String userInsert(@ModelAttribute UserDTO userDTO) {
// DB
userDAO.userInsert(userDTO);
return "/user/userInsert";
}
@RequestMapping(value="/userSelect.do", method = RequestMethod.GET) // get방식
public String userSelect(Model model) {
//DB
List<UserDTO> list = userDAO.getUserList();
model.addAttribute("list",list);
return "/user/userSelect";
}
@RequestMapping(value="/userUpdateInput.do", method = RequestMethod.GET) // get방식
public String userUpdateInput() {
return "/user/userUpdateInput";
}
@RequestMapping(value="/userUpdateForm.do", method = RequestMethod.GET) // get방식
public String userUpdateForm(@RequestParam String id, Model model) {
//DB
UserDTO userDTO = userDAO.getUser(id);
model.addAttribute("userDTO", userDTO);
return "/user/userUpdateForm";
}
@RequestMapping(value="/userUpdate.do", method = RequestMethod.POST) //
public String userUpdate(@ModelAttribute UserDTO userDTO) {
userDAO.userUpdate(userDTO);
return "/user/userUpdate";
}
@RequestMapping(value="/userDeleteInput.do", method = RequestMethod.GET) // get방식
public String userDeleteInput() {
return "/user/userDeleteInput";
}
@RequestMapping(value="/userDelete.do", method = RequestMethod.GET) //
public String userDelete(@RequestParam String id) {
userDAO.userDelete(id);
return "/user/userDelete";
}
@RequestMapping(value="/checkId.do", method = RequestMethod.POST) //
public @ResponseBody String checkId(@RequestParam String id) {
if(id.equals(""))
return "empty";
//DB
UserDTO userDTO = userDAO.getUser(id);
if(userDTO==null) return "non_exist";
else return "exist";
}
}
////////////////////////////////////
package com.dao;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;
import com.bean.UserDTO;
@Component
@Transactional
public class UserDAOMybatis implements UserDAO {
@Autowired
private SqlSession sqlSession;
@Override
public void userInsert(UserDTO userDTO) {
sqlSession.insert("userSQL.userInsert",userDTO);
}
@Override
public List<UserDTO> getUserList() {
return sqlSession.selectList("userSQL.getUserList");
}
@Override
public UserDTO getUser(String id) {
return sqlSession.selectOne("userSQL.getUser", id);
}
@Override
public void userUpdate(UserDTO userDTO) {
sqlSession.update("userSQL.userUpdate",userDTO);
}
@Override
public void userDelete(String id) {
sqlSession.delete("userSQL.userDelete",id);
}
}
'JAVA 개발 공부 정보' 카테고리의 다른 글
JAVA-SQL (0) | 2018.03.14 |
---|---|
[JAVA] JSON - Jackson Databind (0) | 2018.02.26 |
[java-note] [jQuery/제이쿼리] 개념, 연습문제 (0) | 2018.02.26 |
[java-note] Chapter06_1 get-> post 방식 변경 & 한글깨짐 보완 (0) | 2018.02.22 |
[java-note] fmt태그 사용하고 소수점 제외방법 #.## 사용 (0) | 2018.02.22 |