springboot +mybatis +druid 连接达梦数据库

DMTest前言：达梦数据库作为国产数据库的佼佼者，今天尝试利用springboot +mybatis +druid来测试一下达梦数据库在java开发，特别是现在的利用框架来进行快速开发中的效果。目录DMTest介绍软件架构代码展示crud展示介绍利用springboot +mybatis +druid 连接国产达梦数据库软件架构软件架构说明代码展示编写实体类，对应数据库的类。package co

Frank_xx

5058人浏览 · 2021-07-19 17:26:31

Frank_xx · 2021-07-19 17:26:31 发布

DMTest

前言：达梦数据库作为国产数据库的佼佼者，今天尝试利用springboot +mybatis +druid来测试一下达梦数据库在java开发，特别是现在的利用框架来进行快速开发中的效果。

介绍

利用springboot +mybatis +druid 连接国产达梦数据库

软件架构

软件架构说明
在这里插入图片描述

代码展示

首先导入对应的依赖。
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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.5.2</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.sise.fxl</groupId>
	<artifactId>TestDM</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>TestDM</name>
	<description>Demo project for Spring Boot</description>
	<properties>
		<java.version>1.8</java.version>
	</properties>
	<dependencies>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.2.0</version>
		</dependency>
		
		<!-- https://mvnrepository.com/artifact/com.dameng/Dm8JdbcDriver18 -->
<dependency>
    <groupId>com.dameng</groupId>
    <artifactId>Dm8JdbcDriver18</artifactId>
    <version>8.1.1.49</version>
</dependency>
		
		
		
 	<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

编写实体类，对应数据库的类。

package com.sise.entity;

public class User {
	
	
	private int id;
    private String name;
    private String birthday;
    private String notes;
 
    public String getBirthday() {
		return birthday;
	}

	public void setBirthday(String birthday) {
		this.birthday = birthday;
	}

	public String getNotes() {
		return notes;
	}

	public void setNotes(String notes) {
		this.notes = notes;
	}

	
    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;
    }
}

编写mapper 里面主要是对数据库的一些crud操作。

package com.sise.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.sise.entity.User;

@Mapper
public interface ConformityMapper {
	User selectById();
	@Select("select * from \"TESTDB\".\"t_student\"")
	public List<User> getAllUser();
	
	
	//查询
	@Select("select * from \"TESTDB\".\"t_student\" where \"id\"= #{id}")
	public List<User> getUsers(@Param("id") int id);
	
	//插入
	@Insert("insert into \"TESTDB\".\"t_student\" values (#{id},#{name},#{birthday},#{notes});commit;")
	public void saveUser(@Param("id") int id,@Param("name") String  name,@Param("birthday") String  birthday,@Param("notes") String  notes);
	
	//删除
	@Delete("delete from \"TESTDB\".\"t_student\" where \"id\"='1001'")
	public void deleteUser();
	
	//更新
	@Update("update \"TESTDB\".\"t_student\" set \"name\"='ketene' where \"id\"='1007'")
	public void  updateUser();
	
}

在controller里面写上对应的映射操作

package com.sise.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.sise.entity.User;
import com.sise.mapper.ConformityMapper;

@RestController
public class UserController {
	@Autowired
	ConformityMapper conformityMapper;
	
	@RequestMapping("/test/all")
	public List<User> getAllUser(){
		return conformityMapper.getAllUser();
	}
	
	
	
	@RequestMapping("/test/{id}") //查询
	public List<User> getUsers(@PathVariable("id")int id){
//		System.out.println("查询");
//		User user = new User();s  
//		user.setId(1002);
		return conformityMapper.getUsers(id);
	    }
	
	@RequestMapping("/testinsert")
	public String saveUser() {
		User user = new User();
		user.setId(1007);
		user.setName("jelly");
		user.setBirthday("1999-8-6");
		user.setNotes("NULL");
		conformityMapper.saveUser(user.getId(),user.getName(),user.getBirthday(),user.getNotes());
		return "insert success!!!!";
	}
	
	@RequestMapping("/testdelete")
	public String deleteUser() {
		conformityMapper.deleteUser();
		return "delete success!!!!";
	}
	
	@RequestMapping("/testupdate")
	public String updateUser() {
		conformityMapper.updateUser();
		return "updateUser success!!!!";
	}
	
}