Spring 부서목록 (select 만 있음)

Framework/Spring

by H_Develop 2022. 9. 13. 17:59

DeptController.java

package controller;

import java.util.List;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import dao.DeptDAO;
import vo.DeptVO;

@Controller
public class DeptController {
	DeptDAO dept_dao;
    
    public DeptController(DeptDAO dept_dao) {
    	System.out.println("DeptController 가동 !");
        this.dept_dao = dept_dao;
    }
    @RequestMapping(value={"/", "/list.do"})
    public String list(Model model) {
    	List<DeptVO> lsit = dept_dao.select();
        model.addAttribute("m_list",list);
        return "/WEB-INF/views/dept/dept_list.jsp";
    }
    @RequestMapping("/list.do")
    public String insert(Model model) {
    	List<DeptVO> list = dept_dao.select();
        model.addAttribute("m_list",list);
        return "/WEB-INF/views/dept/dept_list.jsp";
    }
}

DeptDAO.java

package dao;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import vo.DeptVO;

public class DeptDAO {
	SqlSession sqlSession;
    
    public DeptDAO (SqlSession sqlSession) {
    	this.sqlSession = sqlSession;
    }
 	public void setSqlSession(SqlSession sqlSession) {
    	this.sqlSession = sqlSession;
    }
    public List<DeptVO> select() {
    	List<DeptVO> list = sqlSession.selectList("dept.dept_list");
        return list;
    }
}

DeptVO.java

package vo;

public class DeptVO {
	private int deptno;
	private String dname, loc;
	
	public int getDeptno() {
		return deptno;
	}
	public void setDeptno(int deptno) {
		this.deptno = deptno;
	}
	public String getDname() {
		return dname;
	}
	public void setDname(String dname) {
		this.dname = dname;
	}
	public String getLoc() {
		return loc;
	}
	public void setLoc(String loc) {
		this.loc = loc;
	}
	
}

dept_list.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!-- scriptlib 안쓰려고 위에 짧은 코드로 작성 -->
<!DOCTYPE html>
<html>
<head>
<meta charset="EUC-KR">
<title>Insert title here</title>
</head>
<body>
	부서목록 <br>
	<table border="1">
		<tr>
			<th>부서번호</th>
			<th>부서이름</th>
			<th>부서위치</th>
		</tr>
	
		<c:forEach var="vo" items="${ m_list }">
			<tr>
				<td>${vo.deptno}</td> <!-- getDeptno를 가져오는 것이다 DAO가 아님 -->
				<td>${vo.dname}</td>
				<td>${vo.loc}</td>
			</tr>
		</c:forEach>
	</table>	
</body>
</html>

'Framework > Spring' 카테고리의 다른 글

controller @RequestBody, @RequestParam, @ModelAttribute 차이 (0)	2022.11.28
Spring Controller 에서 Jsp 값 넘기기 (0)	2022.11.14
Spring visit 방명록 (0)	2022.09.13
Spring ( select, delete ) (0)	2022.09.13
Spring 부서목록 코드 (0)	2022.09.07