spring JdbcTemplate操作数据库 详解在spring中使用JdbcTemplate操作数据库的几种方式

  <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.2.7.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>5.2.7.RELEASE</version>
    </dependency>

package com.jdbcTemplate.bean;

public class Account {
  private String name;
  private Double money;

  public String getName() {
    return name;
  }

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

  public Double getMoney() {
    return money;
  }

  public void setMoney(Double money) {
    this.money = money;
  }

  @Override
  public String toString() {
    return "Account{" +
        "name='" + name + '\'' +
        ", money=" + money +
        '}';
  }
}

    //创建数据源对象
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUrl("jdbc:mysql://localhost:3306/think");
    ds.setUsername("root");
    ds.setPassword("");
    //创建jdbcTemplate对象
    JdbcTemplate jt = new JdbcTemplate();
    //执行操作（插入操作）
    jt.setDataSource(ds);
    jt.execute("insert into account(name,money)value('EVA',50000)");

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:p="http://www.springframework.org/schema/p"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd">
<!--    //配置数据源-->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
      <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
      <property name="url" value="jdbc:mysql://localhost:3306/think"/>
      <property name="username" value="root"/>
      <property name="password" value=""/>
    </bean>
<!--  //配置jdbcTemplate-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
      <property name="dataSource" ref="dataSource"/>
    </bean>

 //二、使用配置操作数据库
    //1、获取容器
    ApplicationContext ac = new ClassPathXmlApplicationContext("beans5.xml");
    //2、获取对象
    JdbcTemplate jt = ac.getBean("jdbcTemplate",JdbcTemplate.class);
    //、执行操作
//    jt.execute("insert into account(name,money)value ('Alice',2000)");
    //保存
    //jt.update("insert into account(name,money)value (?,?)","Eden",100);
    //更新
    // jt.update("update account set money=?,name=? where name=?",1000,"Kiroto","Eden");
    //删除
    //jt.update("delete from account where name =? and money =?","Kiroto",1000);
    //查找
    List<Account> list = jt.query("select * from account where name =?",new BeanPropertyRowMapper<Account>(Account.class),"Eden");
    System.out.println(list.isEmpty()?"没有查找结果":list.get(0));

package com.jdbcTemplate.test;

import com.jdbcTemplate.bean.Account;

public interface Template {

  Account find(String name);

  int update(Account account);

  int delete(Account account);

  int add(Account account);
}

package com.jdbcTemplate.test;

import com.jdbcTemplate.bean.Account;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;

public class TemplateDAO implements Template {
  private JdbcTemplate jdbcTemplate;

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

  public Account find(String name) {//查找
    List<Account> list = jdbcTemplate.query("select * from account where name=?",
        new BeanPropertyRowMapper<Account>(Account.class),name);
    return list.isEmpty()?null:list.get(0);
  }

  public int update(Account account) {//更新

    return jdbcTemplate.update("update account set money=? where name=?",
        account.getMoney(),account.getName());
  }

  public int delete(Account account) {//删除

    return jdbcTemplate.update("delete from account where name =?",account.getName());
  }

  public int add(Account account) {//添加
    return jdbcTemplate.update("insert into account(name ,money)value (?,?)",account.getName(),account.getMoney());
  }
}

<!--  配置账户的持久层-->
  <bean id="templateDAO" class="com.jdbcTemplate.test.TemplateDAO">
    <property name="jdbcTemplate" ref="jdbcTemplate"/>
  </bean>

import com.jdbcTemplate.bean.Account;
import com.jdbcTemplate.test.Template;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class mytest {
  public static void main(String[] args) {
    ApplicationContext ac = new ClassPathXmlApplicationContext("beans6.xml");
    Template tp = ac.getBean("templateDAO",Template.class);//注意对比方法二的不同
    Account account = tp.find("Lily");
    System.out.println(account.toString());

  }
}