Spring JDBC

package demo03;

import com.mchange.v2.c3p0.DriverManagerDataSource;
import demo02.JdbcUtilsDruid;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import javax.sql.DataSource;
import java.util.List;
import java.util.Map;

public class Demo01 {
    static JdbcTemplate jt = new JdbcTemplate(JdbcUtilsDruid.getDataSource());
    public static void main(String[] args) {
        update(12000,2);
        insert("大哥", 1);
        delete("nana");
        update(13000,3);
        search(2);
        searchAll();
        update(10000, 1);
        insert("白熊精", 8989);
        delete("白熊精");

        Map<String, Object> mp = jt.queryForMap("select * from account where id = ?", 1);
        System.out.println(mp);

        List<Map<String, Object>> lst = jt.queryForList("select * from account");
        for (Map<String, Object> mmp : lst) {
            System.out.println(mmp);
        }
        searchAll();
        searchAccount();
        searchObject();
    }
    public static void update(int row,int id){
        jt.update("update account set balance = ? where id = ?",row,id);
    }

    public static void insert(String name, int row) {
        jt.update("insert into account(name,balance)values(?,? )", name, row);
    }

    public static void delete(String name) {
        jt.update("delete from account where name =?",name);
    }

    public static void search(int id) {
        Map<String,Object> mp = jt.queryForMap("select * from account where id > ?", id);
        System.out.println(mp);
    }

    public static void searchAll() {
        List<Map<String, Object>> ls = jt.queryForList("select * from account");
        for (Map<String ,Object> mp : ls){
            System.out.println(mp);
        }
    }

    public static void searchAccount() {
        List<Account> lst = jt.query("select * from account", new BeanPropertyRowMapper<Account>(Account.class));
        for (Account act : lst) {
            System.out.println(act.toString());
        }
    }

    public static void searchObject() {
        double r = jt.queryForObject("select avg(balance) from account", Long.class);
        System.out.println(r);
    }
}

package demo03;

public class Account {
    private int id;
    private String name;
    private double balance;

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public double getBalance() {
        return balance;
    }

    public void setBalance(double balance) {
        this.balance = balance;
    }

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