JDBCTemplate--执行DML语句

黑马程序员

JDBCTemplate–执行DML语句

• 注意定义实体类用封装类型
  
  
  

package cn.itcast.domain;

public class Employee {
    private Integer id;
    private String name;
    private Double account;

    public Employee() {
    }

    public Employee(Integer id, String name, Double account) {
        this.id = id;
        this.name = name;
        this.account = account;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Double getAccount(double account) {
        return this.account;
    }

    public void setAccount(Double account) {
        this.account = account;
    }

    @Override
    public String toString() {
        return "Employee{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", account=" + account +
                '}';
    }
}

package cn.itcast.jdbctemplate;

import cn.itcast.dataSource.utils.JDBCUtils_druid;
import cn.itcast.domain.Employee;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

public class JdbcTemplateDemo2 {

    public static void main(String[] args) {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(JDBCUtils_druid.getDataSource());
        String sql="update employee set account = ? where id = ?";
        int update = jdbcTemplate.update(sql, 100000, 1);
        System.out.println(update+"条数据修改成功");
        System.out.println("******************************************");
        String sql2="insert into employee values (?,?,?)";
        int update1 = jdbcTemplate.update(sql2, 3, "王五", 5000);
        System.out.println(update1+"条数据添加成功");
        System.out.println("******************************************");
        String sql2_1="delete from employee where id = ?";
        int update1_1 = jdbcTemplate.update(sql2_1, 3);
        System.out.println(update1_1+"条数据删除成功");
        System.out.println("******************************************");
        String sql3="select * from employee where id=?";
        Map<String, Object> stringObjectMap = jdbcTemplate.queryForMap(sql3, 1);
        Set<Map.Entry<String, Object>> entries = stringObjectMap.entrySet();
        for (Map.Entry<String, Object> entry : entries) {
            System.out.println(entry.getKey()+"--->"+entry.getValue());
        }
        System.out.println("******************************************");
        String sql4="select * from employee";
        List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql4);
        Iterator<Map<String, Object>> iterator = maps.iterator();
        while (iterator.hasNext()){
            Map<String, Object> next = iterator.next();
            Set<Map.Entry<String, Object>> entries1 = next.entrySet();
            for (Map.Entry<String, Object> stringObjectEntry : entries1) {
                System.out.println(stringObjectEntry.getKey()+"--->"+stringObjectEntry.getValue());
            }
        }
        System.out.println("******************************************");
        List<Employee> list = jdbcTemplate.query(sql4, new RowMapper<Employee>() {
            @Override
            public Employee mapRow(ResultSet resultSet, int i) throws SQLException {
                int id = resultSet.getInt("id");
                String name = resultSet.getString("name");
                double account = resultSet.getDouble("account");

                Employee employee = new Employee();
                employee.setId(id);
                employee.setName(name);
                employee.getAccount(account);

                return employee;
            }
        });
        for (Employee employee : list) {
            System.out.println(employee);
        }
        System.out.println("******************************************");
        List<Employee> employeeList = jdbcTemplate.query(sql4, new BeanPropertyRowMapper<Employee>(Employee.class));
        for (Employee employee : employeeList) {
            System.out.println(employee);
        }
        System.out.println("******************************************");
        String sql5="select count(id) from employee";
        Long aLong = jdbcTemplate.queryForObject(sql5, Long.class);
        System.out.println("一共存在数据"+aLong+"条");



    }
}