SpringStudy/EmpDao.java at main · makerspaceSiwoo/SpringStudy · GitHub

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
package com.spring.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.spring.dto.Emp;

@Mapper
public interface EmpDao {

	List<Emp> searchEmp(@Param("job") String job, @Param("ename") String ename);

	@Select("select * from emp")
	List<Emp> searchAll();

	@Select("select * from emp where deptno=#{deptno}")
	List<Emp> showEmp(@Param("deptno") int deptno);

	@Select("select * from emp where ename=#{ename}")
	Emp selectEmp(@Param("ename")String ename);


}