CREATE TABLE Test
(
`test_seq` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(45) NULL,
`title` VARCHAR(45) NULL,
PRIMARY KEY (test_seq)
);
INSERT INTO Test (name, title) VALUES ('name 02', 'title 02');
INSERT INTO Test (name, title) VALUES ('name 03', 'title 03');
INSERT INTO Test (name, title) VALUES ('name 04', 'title 04');
INSERT INTO Test (name, title) VALUES ('name 05', 'title 05');
INSERT INTO Test (name, title) VALUES ('name 06', 'title 06');
INSERT INTO Test (name, title) VALUES ('name 07', 'title 07');
INSERT INTO Test (name, title) VALUES ('name 08', 'title 08');
INSERT INTO Test (name, title) VALUES ('name 09', 'title 09');
INSERT INTO Test (name, title) VALUES ('name 10', 'title 10');
INSERT INTO Test (name, title) VALUES ('name 11', 'title 11');
INSERT INTO Test (name, title) VALUES ('name 12', 'title 12');
INSERT INTO Test (name, title) VALUES ('name 13', 'title 13');
INSERT INTO Test (name, title) VALUES ('name 14', 'title 14');
INSERT INTO Test (name, title) VALUES ('name 15', 'title 15');
Mapper폴더 -> 오른쪽마우스 -> New -> OtherWizards에 xml을 입력 -> MyBatis폴더안의 'MyBatis XML Mapper'클릭 -> Next 버튼 클릭
Mapper폴더 클릭 -> File name에 'TestMapper.xml' 입력 -> 'Finish'버튼 클릭
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.test.Mapper.TestMapper">
<select id="selectAllTest" resultType="com.test.Domain.Test">
SELECT * from test
</select>
<insert id = "insertTest" parameterType = "com.test.Domain.Test">
INSERT INTO Test (name, title) VALUES (#{name}, #{title})
</insert>
<update id = "updateTest" parameterType = "com.test.Domain.Test">
update test set name = #{name}, title = #{title} where test_seq = #{test_seq}
</update>
<delete id = "deleteTest" parameterType = "int">
delete from test where test_seq = #{test_seq}
</delete>
</mapper>
■ Service / TestService.java
package com.test.Service;
import java.util.List;
import javax.inject.Inject;
import org.springframework.stereotype.Service;
import com.test.Domain.Test;
import com.test.Mapper.TestMapper;
@Service
public class TestService {
@Inject
private TestMapper mapper;
public List<Test> selectAllTest() throws Exception{
return mapper.selectAllTest();
}
public void insertTest(Test test){
mapper.insertTest(test);
}
public void updateTest(Test test){
mapper.updateTest(test);
}
public void deleteTest(int test_seq){
mapper.deleteTest(test_seq);
}
}
■ Controller / HomeController.java
package com.test.Controller;
import java.util.List;
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 com.test.Domain.Test;
import com.test.Service.TestService;
/**
* Handles requests for the application home page.
*/
@Controller
public class HomeController {
@Autowired
private TestService service;
@RequestMapping(value = {"/","/home"}, method = RequestMethod.GET)
public String home(Model model) throws Exception{
List<Test> selectAllTest = service.selectAllTest();
model.addAttribute("test", selectAllTest);
return "home";
}
@RequestMapping("/insertTest.do")
public String insertTest(Test test) {
service.insertTest(test);
return "redirect:/";
}
@RequestMapping("/updateTest.do")
public String updateTest(Test test) {
service.updateTest(test);
return "redirect:/";
}
@RequestMapping("/deleteTest.do")
public String deleteTest(int test_seq) {
service.deleteTest(test_seq);
return "redirect:/";
}
}
<form action="${cpath}/insertTest.do" method="post">
<input type = "text" name = "name" placeholder = "추가할 이름을 입력하세요.">
<input type = "text" name = "title" placeholder = "추가할 제목을 입력하세요.">
<button type="submit">추가하기</button>
</form>
- Mapper/TestMapper.xml
<insert id = "insertTest" parameterType = "com.test.Domain.Test">
INSERT INTO Test (name, title) VALUES (#{name}, #{title})
</insert>
- Domain/Test.java
private int test_seq;
private String name;
private String title;
여기 insert부분만 가져와써요!!
home.jsp에서 input 태그안의 name 속성들의 값은, Domain/Test.java와 TestMapper.xml에있는 변수들에게 그대로 들어갑니다. 그러니, views안에 jsp부분에서 input 태그들의 name부분의 변수이름이 위와 동일한 지 확인해봐야겠지요?
