달력

22025  이전 다음

  • 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

CRUD-example(reward)

Legend 개발자/Spring 2017. 11. 2. 15:26
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
package com.lat.beans;
 
public class Reward {
    private long project_num;
    private long reward_num;
    private String name;
    private long price;
    private String item;
    private long min;
    
    public long getProject_num() {
        return project_num;
    }
    public void setProject_num(long project_num) {
        this.project_num = project_num;
    }
    public long getReward_num() {
        return reward_num;
    }
    public void setReward_num(long reward_num) {
        this.reward_num = reward_num;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public long getPrice() {
        return price;
    }
    public void setPrice(long price) {
        this.price = price;
    }
    public String getItem() {
        return item;
    }
    public void setItem(String item) {
        this.item = item;
    }
    public long getMin() {
        return min;
    }
    public void setMin(long min) {
        this.min = min;
    }
    
}
 
 cs

 

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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
package com.lat.controller;
 
import java.util.List;
 
import javax.servlet.http.HttpServletRequest;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;
 
import com.lat.beans.Reward;
import com.lat.dao.RewardDAOService;
 
@Controller
public class RewardController {
    @Autowired
    private RewardDAOService rewardDAOService;
    
    @RequestMapping(value="/reward/listReward")
    public ModelAndView list(HttpServletRequest request){
        List<Reward> list=rewardDAOService.listReward();
        return new ModelAndView("reward/listReward","list",list);
    }
    
    @RequestMapping(value="/reward/insertReward")
    public ModelAndView insertReward(HttpServletRequest request){
        return new ModelAndView("reward/insertReward");
    }
    
    @RequestMapping(value="/reward/insert", method=RequestMethod.POST)
    public String listReward(HttpServletRequest request){
        String project_num=request.getParameter("project_num");//숫자
        String reward_num=request.getParameter("reward_num");//숫자
        String name=request.getParameter("name");
        String price=request.getParameter("price");//숫자
        String item=request.getParameter("item");
        String min=request.getParameter("min");//숫자
        Reward reward=new Reward();
        reward.setProject_num(Long.parseLong(project_num));
        reward.setReward_num(Long.parseLong(reward_num));
        reward.setName(name);
        reward.setPrice(Long.parseLong(price));
        reward.setItem(item);
        reward.setMin(Long.parseLong(min));
        rewardDAOService.insertReward(reward);
        return "redirect:listReward";
    }
    
    @RequestMapping(value="/reward/detailReward", method=RequestMethod.GET)
    public ModelAndView detailReward(HttpServletRequest request){
        String project_num=request.getParameter("project_num");
        String reward_num=request.getParameter("reward_num");
        Reward reward=new Reward();
        reward.setProject_num(Long.parseLong(project_num));
        reward.setReward_num(Long.parseLong(reward_num));
        ModelAndView result= new ModelAndView();
        Reward rewardRlt=rewardDAOService.detailReward(reward);
        result.addObject("reward",rewardRlt);
        result.setViewName("reward/detailReward");
        return result;
    }
    
    @RequestMapping(value="/reward/update")
    public String update(HttpServletRequest request){
    String project_numVal=request.getParameter("project_num");
    long project_num=0;
    if(project_numVal!=null) project_num=Long.parseLong(project_numVal);
    String reward_numVal=request.getParameter("reward_num");//숫자
    long reward_num=0;
    if(reward_numVal!=null) reward_num=Long.parseLong(reward_numVal);
    String name=request.getParameter("name");
    String priceVal=request.getParameter("price");//숫자
    long price=0;
    if(priceVal!=null) price=Long.parseLong(priceVal);
    String item=request.getParameter("item");
    String minVal=request.getParameter("min");//숫자
    long min=0;
    if(minVal!=null) min=Long.parseLong(minVal);
    Reward reward=new Reward();
    reward.setProject_num(project_num);
    reward.setReward_num(reward_num);
    reward.setName(name);
    reward.setPrice(price);
    reward.setItem(item);
    reward.setMin(min);
    rewardDAOService.updateReward(reward);
    return "redirect:listReward";
    }
    
    @RequestMapping(value="/reward/updateReward", method=RequestMethod.POST)
    public ModelAndView updateReward(HttpServletRequest request){
        String project_num=request.getParameter("project_num");
        String reward_num=request.getParameter("reward_num");
        Reward reward=new Reward();
        reward.setProject_num(Long.parseLong(project_num));
        reward.setReward_num(Long.parseLong(reward_num));
        Reward rewardRlt=rewardDAOService.detailReward(reward);
        ModelAndView view=new ModelAndView("reward/insertReward");
        view.addObject("reward",rewardRlt);
        return view;
    }
    
    @RequestMapping(value="/reward/delete", method=RequestMethod.POST)
    public String deleteReward(HttpServletRequest request){
        String project_num=request.getParameter("project_num");
        String reward_num=request.getParameter("reward_num");
        Reward reward=new Reward();
        reward.setProject_num(Long.parseLong(project_num));
        reward.setReward_num(Long.parseLong(reward_num));
        rewardDAOService.deleteReward(reward);
        return "redirect:listReward";
    }
    
}
 
 cs

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
package com.lat.dao;
 
import java.util.List;
 
import com.lat.beans.Reward;
 
public interface RewardDAO {
    public List<Reward> listReward();
    public void insertReward(Reward reward);
    public Reward detailReward(Reward reward);
    public void updateReward(Reward reward);
    public void deleteReward(Reward reward);
}
 
 cs

 

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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
package com.lat.dao;
 
import java.util.List;
 
import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
 
import com.lat.beans.Reward;
 
@Repository
public class RewardDAOService implements RewardDAO{
 
    @Autowired
    private SqlSession sqlSession;
 
 
    @Override
    public void insertReward(Reward reward) {
        // TODO Auto-generated method stub
        RewardMapper rewardMapper=sqlSession.getMapper(RewardMapper.class);
        rewardMapper.insertReward(reward);
    }
 
    @Override
    public List<Reward> listReward() {
        // TODO Auto-generated method stub
        RewardMapper rewardMapper=sqlSession.getMapper(RewardMapper.class);
        return rewardMapper.listReward();
    }
    @Override
    public Reward detailReward(Reward reward) {
        // TODO Auto-generated method stub
        RewardMapper rewardMapper=sqlSession.getMapper(RewardMapper.class);
        return rewardMapper.detailReward(reward);
    }
 
    @Override
    public void updateReward(Reward reward) {
        // TODO Auto-generated method stub
        RewardMapper rewardMapper=sqlSession.getMapper(RewardMapper.class);
        rewardMapper.updateReward(reward);
    }
 
    @Override
    public void deleteReward(Reward reward) {
        // TODO Auto-generated method stub
        RewardMapper rewardMapper=sqlSession.getMapper(RewardMapper.class);
        rewardMapper.deleteReward(reward);
    }
 
}
 
 cs

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
package com.lat.dao;
 
import java.util.List;
 
import com.lat.beans.Reward;
 
public interface RewardMapper {
 
    public List<Reward> listReward();
    public void insertReward(Reward reward);
    public Reward detailReward(Reward reward);
    public void updateReward(Reward reward);
    public void deleteReward(Reward reward);
 
}
 
 cs

 

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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<?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.lat.dao.RewardMapper">
    <resultMap type="Reward" id="rewardMap">
        <result property="project_num" column="PROJECT_NUM"/>
        <result property="reward_num" column="REWARD_NUM"/>
        <result property="name" column="NAME"/>
        <result property="price" column="PRICE"/>
        <result property="item" column="ITEM"/>
        <result property="min" column="MIN"/>
    </resultMap>
    
    <select id="listReward" resultMap="rewardMap">
        select * from reward
    </select>
    
    <insert id="insertReward" parameterType="com.lat.beans.Reward">
        insert into reward(project_num, reward_num, name, price, item, min)
        values(#{project_num}, #{reward_num}, #{name}, #{price}, #{item}, #{min})
    </insert>
    
    <select id="detailReward" parameterType="com.lat.beans.Reward" resultType="com.lat.beans.Reward">
        select * from reward
        where project_num=#{project_num} and reward_num=#{reward_num}
    </select>
    
    <update id="updateReward" parameterType="com.lat.beans.Reward">
        update reward set 
         name=#{name}
        ,price=#{price}
        ,item=#{item}        
        ,min=#{min}
        where project_num=#{project_num}
          and reward_num=#{reward_num}
    </update>
    
    <delete id="deleteReward" parameterType="com.lat.beans.Reward">
        delete from reward
        where project_num=#{project_num}
          and reward_num=#{reward_num}
    </delete>
</mapper>
 
 cs

 

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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import="com.lat.beans.Reward"%>
<%@ page import="java.util.*"%>
<!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=EUC-KR">
<title>detailReward</title>
</head>
<body>
Reward상세보기
<%
    Reward reward=(Reward)request.getAttribute("reward");
    if(reward==null) reward=new Reward();
%>
<table border="1">
    <tr>
        <th>project_num</th>
        <th>reward_num</th>
        <th>name</th>
        <th>price</th>
        <th>item</th>
        <th>min</th>
    </tr>
    <tr>
        <td><%=reward.getProject_num()%></td>
        <td><%=reward.getReward_num()%></td>
        <td><%=reward.getName()%></td>
        <td><%=reward.getPrice()%></td>
        <td><%=reward.getItem()%></td>
        <td><%=reward.getMin()%></td>
    </tr>
    <tr>
        <td colspan="6">
            <form method="post" action="updateReward">
                <input type="hidden" name="project_num" value="<%=reward.getProject_num() %>"/>
                <input type="hidden" name="reward_num" value="<%=reward.getReward_num() %>"/>
                <input type="submit" value="수정"/>
            </form>    
            <form method="post" action="delete">
                <input type="hidden" name="project_num" value="<%=reward.getProject_num() %>"/>
                <input type="hidden" name="reward_num" value="<%=reward.getReward_num() %>"/>
                <input type="submit" value="삭제"/>
            </form>    
        </td>
    </tr>
</table>
</body>
</html>
 
 cs

 

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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import="com.lat.beans.Reward"%>
<%@ page import="java.util.*"%>
<!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=EUC-KR">
<title>insertReward</title>
</head>
<body>
<%
    Reward reward=(Reward)request.getAttribute("reward");
    if(reward==null) reward=new Reward();
%>
<form method="post"
<% if(reward.getProject_num()==0){%>
action="insert"
<% }else{%>
action="update"
<% }%>
>
    <table border="1">
        <tr>
            <td>Project_num</td>
            <td colspan="2">
            <% if(reward.getProject_num()==0){%>
            <input type="text" name="project_num" value="<%=reward.getProject_num() %>"/>
            <% }else{%>
            <input type="hidden" name="project_num" value="<%=reward.getProject_num() %>"/>
                <%=reward.getProject_num()%>
            <% }%>
            </td>
        </tr>
        <tr>
            <td>Reward_num</td>
            <td colspan="2">
            <% if(reward.getReward_num()==0){%>
            <input type="text" name="reward_num" value="<%=reward.getReward_num() %>"/>
            <% }else{%>
            <input type="hidden" name="reward_num" value="<%=reward.getReward_num() %>"/>
                <%=reward.getReward_num()%>
            <% }%>
            </td>
        </tr>
        <tr>
            <td>name</td>
            <td colspan="2"><input type="text" name="name" value="<%=reward.getName()==null?"":reward.getName() %>"/></td>
        </tr>
        <tr>
            <td>price</td> 
            <td colspan="2"><input type="text" name="price" value="<%=reward.getPrice()==0?"":reward.getPrice() %>"/></td>
        </tr>
        <tr>
            <td>item</td>
            <td colspan="2"><input type="text" name="item" value="<%=reward.getItem()==null?"":reward.getItem() %>"/></td>
        </tr>
        <tr>
            <td>min</td>
            <td colspan="2"><input type="text" name="min" value="<%=reward.getMin()==0?"":reward.getMin() %>"/></td>
        </tr>
        <tr>
            <td>
            <%if(reward.getProject_num()==0){%>
                <input type="submit" value="등록"/>
            <%}else{%>
                <input type="submit" value="수정"/>
            <%}%>
                <input type="reset" value="취소"/>
            </td>
            <td>
                <a href="listReward">
                    <input type="button" value="뒤로가기"/>
                </a>
            </td>
            
        </tr>
    </table>
</form>
</body>
</html>
 cs

 

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
31
32
33
34
35
36
37
38
39
40
41
42
43
<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!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=EUC-KR">
<title>listReward</title>
</head>
<body>
    <table border="1">
        <tr>
            <th>project_num</th>
            <th>reward_num</th>
            <th>name</th>
            <th>price</th>
            <th>item</th>
            <th>min</th>
        </tr>
    <c:forEach var="reward" items="${list}">
        <tr>
            <td>
                <a href="detailReward?project_num=${reward.project_num}&reward_num=${reward.reward_num}">
                    ${reward.project_num}
                </a>
            </td>
            <td>${reward.reward_num}</td>
            <td>${reward.name}</td>
            <td>${reward.price}</td>
            <td>${reward.item}</td>
            <td>${reward.min}</td>
        </tr>
    </c:forEach>
        <tr>
            <td colspan="6">
                <a href="insertReward">
                    <input type="button" value="insert"/>
                </a>
            </td>
        </tr>
    </table>
</body>
</html>
 cs

'Legend 개발자 > Spring' 카테고리의 다른 글

CRUD-example(Projectr_AttachFile)  (0) 2017.11.03
CRUD-example(Member_AttachFile)  (0) 2017.11.03
CRUD-example(Exam_AttachFile)  (0) 2017.11.03
CRUD-example(investment)  (0) 2017.11.02
CRUD  (0) 2017.11.02
Posted by 전설의아이
|

티스토리툴바