SpringBoot实例②springboot+jdbcTemplate小例子实现增删查改

首先参照之前的教程新建springboot项目。

然后。数据库建表。

CREATE TABLE `user_0601` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `age` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

实体类

package com.cxl.entity;

public class User {
    private Integer id;
    private String name;
    private Integer age;

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

    public User() {
    }

    public User(Integer id, String name, Integer age) {
        this.id = id;
        this.name = name;
        this.age = age;
    }

    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 Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }
}

package com.cxl.service;

public interface UserService {

    /**
     * 新增一个用户
     * @param name
     * @param age
     */
    void create(String name, Integer age);

    /**
     * 根据name删除一个用户高
     * @param name
     */
    void deleteByName(String name);

    /**
     * 获取用户总量
     */
    Integer getAllUsers();

    /**
     * 删除所有用户
     */
    void deleteAllUsers();

}

package com.cxl.service.impl;

import com.cxl.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private JdbcTemplate jdbcTemplate;
    @Override
    public void create(String name, Integer age) {
        String sql = "insert into user_0601(name ,age) value (?,?)";
        jdbcTemplate.update(sql,name,age);
    }

    @Override
    public void deleteByName(String name) {
        String sql = "delete from user_0601 where name = ?";
        jdbcTemplate.update(sql,name);
    }

    @Override
    public Integer getAllUsers() {
        String sql = "select count(1) from user_0601";
        return jdbcTemplate.queryForObject(sql,Integer.class);
    }

    @Override
    public void deleteAllUsers() {
        String sql = "delete from user_0601";
        jdbcTemplate.update(sql);
    }
}

application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/cxltest2
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

待修改

未完待续...