Spring- JdbcTemplate(CRUD)

1.1 项目目录

​

1.2 代码示例

账户实体类

package cn.guardwhy.domain;
/**
 * 账户实体类
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Account {
    private Integer id;
    private String name;
    private Float money;
}

测试代码

package cn.guardwhy.jdbc;

import cn.guardwhy.domain.Account;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

/**
 * spring JdbcTemplate实现完整CRUD操作
 */
public class JdbcTemplateCRUD {
    public static void main(String[] args) {
        // 1.加载spring配置文件,创建spring IOC容器
        ApplicationContext context = new ClassPathXmlApplicationContext("classpath:bean.xml");
        // 2.从spring IOC容器中,获取JdbcTemplate
        JdbcTemplate jdbcTemplate = (JdbcTemplate) context.getBean("jdbcTemplate");
        // 3.查询多行
        List<Account> list = jdbcTemplate.query("select id,name,money from account", new RowMapper<Account>() {
            @Override
            public Account mapRow(ResultSet rs, int index) throws SQLException {
                // 创建账户对象
                Account account = new Account();
                account.setId(rs.getInt("id"));
                account.setName(rs.getString("name"));
                account.setMoney(rs.getFloat("money"));
                return account;
            }
        });
        // 4.打印结果集
        for(Account account:list){
            System.out.println(account);
        }
        // 5.查询一行一列
        System.out.println("查询一行一列-------");
        Integer accountNum = jdbcTemplate.queryForObject("select count(*) from account", Integer.class);
        System.out.println("当前账户数量:" + accountNum);
    }
}

执行结果

1.3 自定义RowMapper

package cn.guardwhy.resources;

import cn.guardwhy.domain.Account;
import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;


public class AccountRowMapper implements RowMapper<Account> {
    /**
     * 结果集映射的方法：
     *      结果集中的每一行记录，都会调用一次该方法
     */
    public Account mapRow(ResultSet rs, int index) throws SQLException{
        // 创建账户对象
        Account account = new Account();
        account.setId(rs.getInt("id"));
        account.setName(rs.getString("name"));
        account.setMoney(rs.getFloat("money"));
        return account;
    }
}

1.4 测试代码

package cn.guardwhy.jdbc;

import cn.guardwhy.domain.Account;
import cn.guardwhy.resources.AccountRowMapper;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import java.util.List;

/**
 * spring JdbcTemplate实现完整CRUD操作
 */
public class JdbcTemplateCRUD {
    public static void main(String[] args) {
        // 1.加载spring配置文件,创建spring IOC容器
        ApplicationContext context = new ClassPathXmlApplicationContext("classpath:bean.xml");
        // 2.从spring IOC容器中,获取JdbcTemplate
        JdbcTemplate jdbcTemplate = (JdbcTemplate) context.getBean("jdbcTemplate");
        // 3.使用自定义的RowMapper
        List<Account> list = jdbcTemplate.query("select * from account", new AccountRowMapper());

        // 4.打印结果集
        for(Account account:list){
            System.out.println(account);
        }
        // 5.查询一行一列
        System.out.println("查询一行一列-------");
        Integer accountNum = jdbcTemplate.queryForObject("select count(*) from account", Integer.class);
        System.out.println("当前账户数量:" + accountNum);
    }
}

1.5 执行结果

​