?? employeedao.java
字號:
package com.ibm.dw.spring2;
import java.util.List;
import org.springframework.orm.jpa.support.JpaDaoSupport;
public class EmployeeDAO extends JpaDaoSupport implements EmployeeService {
public Employee findById(long id) {
return getJpaTemplate().find(Employee.class, id);
}
public List<Employee> findAll() {
return getJpaTemplate().find("select e from Employee e order by e.empno");
}
public List<Employee> findByEmployeeNumber(String empno) {
return getJpaTemplate().find("select e from Employee e where e.empno = ?1", empno);
}
public List<Employee> findByAddressStreetName(String street) {
return getJpaTemplate().find("select e from Employee e where e.addr.street = ?1", street);
}
public List<Employee> findByEmployeeFirstNameLike(String firstName) {
return getJpaTemplate().find("select e from Employee e where e.firstName like ?1", firstName);
}
public List<Employee> findEmployeeWithSalaryOver(double sal) {
return getJpaTemplate().find("select e from Employee e where e.salary > ?1", sal);
}
public List<Employee> findEmployeeWithCommissionOver(double comm) {
return getJpaTemplate().find("select e from Employee e where e.commission > ?1", comm);
}
public Employee save(Employee emp) {
getJpaTemplate().persist(emp);
return emp;
}
public Employee update(Employee emp) {
return getJpaTemplate().merge(emp);
}
public void delete(Employee emp) {
getJpaTemplate().remove(emp);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -