springboot使用jdbcTemplate连接数据库

1.pom.xml:

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <groupId>com.example</groupId>

    <artifactId>spring-data_JpaAndJdbcTemplate</artifactId>

    <version>0.0.1-SNAPSHOT</version>

    <packaging>jar</packaging>

    <name>spring-mybatis</name>

    <description>Demo project for Spring Boot</description>

    <parent>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-parent</artifactId>

        <version>1.5.10.RELEASE</version>

        <relativePath/> <!-- lookup parent from repository -->

    </parent>

    <properties>

        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

        <java.version>1.8</java.version>

    </properties>

    <dependencies>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter</artifactId>

            <exclusions>

                <exclusion>

                    <groupId>org.springframework.boot</groupId>

                    <artifactId>spring-boot-starter-logging</artifactId>

                </exclusion>

            </exclusions>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-actuator</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-log4j</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-web</artifactId>

        </dependency>

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>5.1.21</version>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-data-jpa</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-test</artifactId>

            <scope>test</scope>

        </dependency>

    </dependencies>

    <build>

        <plugins>

            <plugin>

                <groupId>org.springframework.boot</groupId>

                <artifactId>spring-boot-maven-plugin</artifactId>

            </plugin>

        </plugins>

    </build>

</project>

2.application.properties:

spring.datasource.url=jdbc:mysql://localhost:3306/test

spring.datasource.username=root

spring.datasource.password=root

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

3.Student:

package com.example.springmybatis.entity;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.Id;

@Entity

public class Student {

    @Id

    @GeneratedValue

    private String name;

    @Column(nullable = true)

    private int age;

    @Column(nullable = true)

    private String address;

    private String collage;

    private String sex;

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

    public int getAge() {

        return age;

    }

    public void setAge(int age) {

        this.age = age;

    }

    public String getAddress() {

        return address;

    }

    public void setAddress(String address) {

        this.address = address;

    }

    public String getCollage() {

        return collage;

    }

    public void setCollage(String collage) {

        this.collage = collage;

    }

    public String getSex() {

        return sex;

    }

    public void setSex(String sex) {

        this.sex = sex;

    }

    @Override

    public String toString() {

        return "Student{" +

                "name='" + name + '\'' +

                ", age=" + age +

                ", address='" + address + '\'' +

                ", collage='" + collage + '\'' +

                ", sex='" + sex + '\'' +

                '}';

    }

}

4.UserService:

package com.example.springmybatis.service_jdbc;

import com.example.springmybatis.entity.Student;

public interface UserService {

    void create(String name, Integer age);

    void deleteByName(String name);

    Integer getAllUsers();

    void deleteAllUsers();

    Student select(String name, int age);

}

5.UserServiceImpl:

package com.example.springmybatis.service_jdbc;

import com.example.springmybatis.entity.Student;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.core.RowMapper;

import org.springframework.stereotype.Service;

import java.sql.ResultSet;

import java.sql.SQLException;

@Service

public class UserServiceImpl implements UserService {

    @Autowired

    private JdbcTemplate jdbcTemplate;

    @Override

    public void create(String name, Integer age) {

        jdbcTemplate.update("insert into student(NAME, AGE) values(?, ?)", name, age);

    }

    @Override

    public void deleteByName(String name) {

        jdbcTemplate.update("delete from student where NAME = ?", name);

    }

    @Override

    public Integer getAllUsers() {

        return jdbcTemplate.queryForObject("select count(1) from student", Integer.class);

    }

    @Override

    public void deleteAllUsers() {

        jdbcTemplate.update("delete from student");

    }

    @Override

    public Student select(String name, int age) {

        return jdbcTemplate.queryForObject("select name, age, address, collage, sex from student where NAME = ? and age = ?", new MyRowMapper(), name, age);

    }

    public class MyRowMapper implements RowMapper<Student> {

        @Override

        public Student mapRow(ResultSet resultSet, int i) throws SQLException {

            String name = resultSet.getString("name");

            int age = resultSet.getInt("age");

            String address = resultSet.getString("address");

            String collage = resultSet.getString("collage");

            String sex = resultSet.getString("sex");

            Student student = new Student();

            student.setName(name);

            student.setAddress(address);

            student.setAge(age);

            student.setCollage(collage);

            student.setSex(sex);

            return student;

        }

    }

}

6.UserController:

package com.example.springmybatis.Controller;

import com.example.springmybatis.entity.Student;

import com.example.springmybatis.service_jdbc.UserService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController

public class UserController {

    @Autowired

    private UserService userService;

/**

     * JdbcTemplate连接方式

     * @param name

     * @param age

     * @return

     * @throws Exception

     */

    @RequestMapping(value = "/jdbc", method = RequestMethod.GET)

    @ResponseBody

    public Student GetNameJdbc(@RequestParam(value = "name", defaultValue = "易中天") String name

                    , @RequestParam(value = "age", defaultValue = "55") int age)throws Exception{

        Student user = userService.select(name, age);

        return user;

    }

}

7.spring boot启动项：

 
package com.example.springmybatis;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication

public class SpringDataJpaAPP {

    public static void main(String[] args) {

        SpringApplication.run(SpringDataJpaAPP.class, args);

    }

}

8.sql:

 
CREATE TABLE `student` (

  `name` varchar(100) NOT NULL,

  `age` int(10) NOT NULL,

  `address` varchar(100) NOT NULL,

  `collage` varchar(100) NOT NULL,

  `sex` varchar(10) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8
 

最新文章

  1. JavaScript图表FusionCharts免费在线公开课，由印度原厂技术工程师主讲，10月13日发车
  2. 请求一个action，将图片的二进制字节字符串在视图页面以图片形式输出
  3. xcode 自定义Eclipse里边常用的快捷键
  4. Tomcat执行流程
  5. 解决多线程调用sql存储过程问题
  6. systemtap 列出所有linux 内核模块与相关函数1
  7. ViewHolder VS HolderView ?
  8. C#中英文混合字符串过长截断
  9. 合理的使用size_t可以提高程序的可移植性和代码的可读性，让你的程序更高效。
  10. listvew加载更多
  11. .NET跨平台实践：Linux .Net Core自宿主应用程序瘦身记
  12. MySQL优化原理
  13. Java Spring Boot VS .NetCore （十一）自定义标签 Java Tag Freemarker VS .NetCore Tag TagHelper
  14. extjs 解决使用store.sync()方法更新item有时不触发后台action的问题
  15. Android开源动画库nineoldandroids
  16. php定时回调接口
  17. adb 架构
  18. Maven+SSM框架项目实例——IDEA
  19. Table of Contents - Python 2.x
  20. 关于执行memcached报错问题

热门文章

  1. 10、二维数组的申请（test7.java）
  2. java 购物商城小项目训练
  3. c#引用本地dll发布后运行exe错误
  4. S3C2440 移植最新5.2linux内核
  5. Throughput Controller
  6. Ubuntu安装时出现“failed to load ldlinux.c32”
  7. java高并发系列 - 第31天：获取线程执行结果，这6种方法你都知道？
  8. Nacos（八）：Nacos持久化
  9. 随笔编号-06 MYSQL数据库相关知识合集
  10. ionic $state.go() 传参