quilt code

[iBatis] iBatis (2) 본문

daily/파이썬

[iBatis] iBatis (2)

김뱅쇼 2023. 3. 21. 21:33

1. List (전체 리스트 출력)


1)MemList
: 전체 리스트 화면 출력 


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
package kr.co.aiai.web;
 
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
 
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
import kr.co.aiai.dao.MemDao;
import kr.co.aiai.model.MemVo;
 
@WebServlet("/mem_list")
public class MemList extends HttpServlet {
 
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        MemDao md = new MemDao();
        List<MemVo> list = md.selectList();
        request.setAttribute("list", list);
        
        
        
        RequestDispatcher rd = request.getRequestDispatcher("mem_list.jsp");
        rd.forward(request, response);
    }
}
cs

2) mem_list.jsp


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
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Jay</title>
<script type="text/javascript">
function fn_add() {
    location.href="mem_add?m_id=${mem.m_id}"
}
</script>
</head>
<body>
MEM_LIST<br/>
<table border="1px">
    <tr>
        <td>사번</td>    
        <td>이름</td>    
        <td>성별</td>    
        <td>주소</td>    
    </tr>
<c:forEach var="mem" items="${list}" varStatus="status">
    <tr>
        <td><a href="mem_detail?m_id=${mem.m_id}">${mem.m_id}</a></td>    
        <td>${mem.m_name}</td>    
        <td>${mem.tel}</td>    
        <td>${mem.email}</td>    
    </tr>
</c:forEach>    
 
    <tr>
        <td colspan="2">
            <input type="button" value="추가" onclick="fn_add()"/>
        </td>
    </tr>
</table>
</body>
</html>
cs

>>여기까지 실행한 경우 (데이터는 미리 들어가 있음)

2. Detail (클릭시 세부내용 출력) 

 
 

 

 

'daily > 파이썬' 카테고리의 다른 글

[python] crawl - selenium  (0) 2023.04.25
[python] flask  (0) 2023.04.24
[iBatis] iBatis (1)  (0) 2023.03.21
[파이썬] Day02  (0) 2023.03.15
[파이썬] Day01  (0) 2023.03.13