Spring JDBC---jdbcTemplate数据写入

jdbcTemplate.update()方法可实现数据写入操作

package com.spring.jdbc.dao;

import com.spring.jdbc.entity.Employee;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

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

public class EmployeeDao {
    private JdbcTemplate jdbcTemplate;

    public Employee findById(Integer eno){
        String sql = "select * from employee where eno = ?";
        //jdbcTemplate.queryForObject()查询单条数据
        Employee employee = jdbcTemplate.queryForObject(sql,new Object[]{eno},new BeanPropertyRowMapper<Employee>(Employee.class));
        return employee;
    }

    public List<Employee> findByDname(String dname){
        String sql = "select * from employee where dname = ?";
        //jdbcTemplate.query()查询复合数据
        List<Employee> list = jdbcTemplate.query(sql, new Object[]{dname}, new BeanPropertyRowMapper<Employee>(Employee.class));
        return list;
    }

    public List<Map<String, Object>> findMapByDname(String dname){
        String sql = "select eno as empno,salary as s from employee where dname = ?";
        //无法进行实体类映射，使用jdbcTemplate.queryForList()保存查询结果数据,结果封装成map对象
        List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql, new Object[]{dname});
        return maps;
    }

    public void insert(Employee employee){
        String sql = "insert into employee(eno,ename,salary,dname,hiredate) value(?,?,?,?,?)";
        jdbcTemplate.update(sql, new Object[]{
                employee.getEno(), employee.getEname(), employee.getSalary(),
                employee.getDname(), employee.getHiredate()
        });
    }

    public int update(Employee employee){
        String sql = "update employee " +
                "set ename=?,salary=?,dname=?,hiredate=? " +
                "where eno = ?";
        int count = jdbcTemplate.update(sql, new Object[]{
                employee.getEname(), employee.getSalary(), employee.getDname(),
                employee.getHiredate(), employee.getEno()
        });
        return count;
    }

    public int delete(Integer eno){
        String sql = "delete from employee where eno = ?";
        return jdbcTemplate.update(sql, new Object[]{eno});
    }

    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
}

@Test
public void testInsert(){
    Employee employee = new Employee();
    employee.setEno(8888);
    employee.setEname("赵柳");
    employee.setSalary(6666f);
    employee.setDname("研发部");
    employee.setHiredate(new Date());
    employeeDao.insert(employee);
}
@Test
public void testUpdate(){
    Employee employee = employeeDao.findById(8888);
    employee.setSalary(employee.getSalary()+1000);
    int count = employeeDao.update(employee);
    System.out.println("本次更新" + count + "条数据");
}
@Test
public void testDelete(){
    int count = employeeDao.delete(8888);
    System.out.println("本次删除" + count + "条数据");
}