홈 컨트롤러 복습용

이름, 영어,영어,수학 입력받고 출력,수정,삭제,검색하는거
Spring으로 만듦.

그거 홈 컨트롤러 코드임
복습용

package com.ezen.Day4;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.text.DateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Locale;

import javax.servlet.http.HttpServletRequest;

import org.apache.ibatis.session.SqlSession;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
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;


@Controller
public class HomeController {
	
	@Autowired
	SqlSession sqlSession;//논리적으로 DB연결
	
	@RequestMapping(value = "/in")
	public String aa1()
	{
		return "in";
	}
	
	@RequestMapping(value = "/save", method = RequestMethod.POST)
	public String aa2(HttpServletRequest request) throws IOException
	{
		request.setCharacterEncoding("utf-8");
		String name=request.getParameter("name");
		String tel=request.getParameter("tel");
		Service ss= sqlSession.getMapper(Service.class);
		ss.insert(name,tel);
		
		return "in";
	}
	
	@RequestMapping(value = "/out")
	public String aa3(Model mo) 
	{
		Service ss= sqlSession.getMapper(Service.class);
		ArrayList<MybaDTO> list= ss.out();
		
		mo.addAttribute("list",list);
		return "out";
	}
	//==============================================================================
	
	@RequestMapping(value = "/scorein")
	public String bb1()
	{
		return "scorein";
	}
	
	@RequestMapping(value = "/scoresave")
	public String bb2(HttpServletRequest request) throws IOException
	{
		request.setCharacterEncoding("utf-8");
		String name=request.getParameter("name");
		int kor=Integer.parseInt(request.getParameter("kor"));
		int eng=Integer.parseInt(request.getParameter("eng"));
		int mat=Integer.parseInt(request.getParameter("mat"));
		int tot=kor+eng+mat;
		int avg=tot/3;
		Service ss= sqlSession.getMapper(Service.class);
		ss.scorein(name,kor,eng,mat,tot,avg);
		
		return "scorein";
	}
	
	@RequestMapping(value = "/scoreout")
	public String bb3(Model mo) 
	{
		Service ss= sqlSession.getMapper(Service.class);
		ArrayList<ScoreDTO> list=ss.scoreout();
		mo.addAttribute("list", list);
		return "scoreout";
	}
	
	@RequestMapping(value = "/scoredel")
	public String bb4(HttpServletRequest request) 
	{
		String name=request.getParameter("name");
		Service ss= sqlSession.getMapper(Service.class);
		ss.scoredel(name);
		
		return "redirect:scoreout";
	}
	
	@RequestMapping(value = "/scoremod")
	public String bb5(HttpServletRequest request, Model mo) 
	{
		String name=request.getParameter("name");
		Service ss= sqlSession.getMapper(Service.class);
		ScoreDTO dto= ss.scoremod(name);
		mo.addAttribute("dto",dto);
		
		return "scoremodify";
	}
	
	@RequestMapping(value = "/scoremodify2")
	public String bb6(HttpServletRequest request, Model mo) throws IOException 
	{
		request.setCharacterEncoding("utf-8");
		String name=request.getParameter("name");
		int kor=Integer.parseInt(request.getParameter("kor"));
		int eng=Integer.parseInt(request.getParameter("eng"));
		int mat=Integer.parseInt(request.getParameter("mat"));
		int tot=kor+eng+mat;
		int avg=tot/3;
		Service ss= sqlSession.getMapper(Service.class);
		ss.scoremodify2(name,kor,eng,mat,tot,avg);
		
		return "redirect:scoreout";
		
	}
	
	@RequestMapping(value = "/search", method = RequestMethod.POST)
	public String bb7(HttpServletRequest request,Model mo) throws IOException
	{
		request.setCharacterEncoding("utf-8");
		String sname=request.getParameter("sname");
		String svalue=request.getParameter("svalue");
		Service ss=sqlSession.getMapper(Service.class);
		ArrayList<ScoreDTO> list=null;
		if(sname.equals("name"))
		{
			list=ss.nsearch(svalue);
		}
		else if(sname.equals("kor"))
		{
			list=ss.ksearch(svalue);
		}
			
		mo.addAttribute("list",list);
		
		return "scoreout";
	}
	
	/*
	

	@RequestMapping(value = "/infoin")
	public String cc1() 
	{
		return "infoin";
	}
	
	@RequestMapping(value = "/infosave")
	public String cc2(HttpServletRequest request) 
	{
		String id=request.getParameter("id");
		String pw=request.getParameter("pw");
		String sb=request.getParameter("sb");
		String tel=request.getParameter("tel");
		
		Service ss= sqlSession.getMapper(Service.class);
		ss.infoin(id,pw,sb,tel);
		
		return "infoin";
	}
	
	@RequestMapping(value = "/infoout")
	public String cc3(Model mo) 
	{
		Service ss= sqlSession.getMapper(Service.class);
		ArrayList<InfoDTO> list=ss.infoout();
		mo.addAttribute("list",list);
		return "infoout";
	}
	
	*/
}

그리고 아래는 sdao
DAO그 쿼리문 쓰는거,,실행시키는 코드?임 암튼 그럼

<?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.ezen.Day4.Service">
	<insert id="scorein">
		insert into mybascore values(#{param1}, #{param2}, #{param3}, #{param4}, #{param5}, #{param6})
	</insert>
	
	<select id="scoreout" resultType="com.ezen.Day4.ScoreDTO">
		select * from mybascore
	</select>
	
	<delete id="scoredel" >
	 delete from mybascore where name = #{param1}
	</delete>
	
	<select id="scoremod" resultType="com.ezen.Day4.ScoreDTO">
		select * from mybascore where name= #{param1}
	</select>
	
	<update id="scoremodify2">
		update mybascore set  kor=#{param2}, eng=#{param3}, mat=#{param4}, tot=#{param5}, avg=#{param6} where name=#{param1}
	</update>
	
	<select id="nsearch" resultType="com.ezen.Day4.ScoreDTO">
		select * from mybascore where name like '%'||#{param1}||'%'
	</select>
	
	<select id="ksearch" resultType="com.ezen.Day4.ScoreDTO">
		select * from mybascore where kor=#{kor}
	</select>
	
</mapper>

눈에 익힐라구