Spring Boot Integrates MyBatis to Connect to Oracle Database

1. Spring Boot project adds MyBatis dependencies and Oracle drivers: <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>com.oracle</groupId> <a ...

Posted by mtimdog on Sat, 25 Jan 2020 08:22:24 -0800

Lesson 101 predefined super global array ① - principle analysis

Interface: <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="Generator" content="EditPlus®"> <meta name="Author" content=""> <meta name="Keywords" content=""> <meta name="Description" content=""> <title>Document</title> </he ...

Posted by mart on Sat, 25 Jan 2020 07:17:17 -0800

Server upgrade to centos8 site configuration - PHP and mysql upgrade from 5.6 to php7 and msyql8

linux centos8 installs php7 nginx1.4 mysql8, runs PHP website, configures each module from scratch Choice between CentOS7 and centOS8 At present, the default centos system version of major cloud servers in China is still 7. Currently, there is no centos supporting system. The default of foreign cloud server manufacturers is 8, such as vultr. P ...

Posted by matrixd on Fri, 24 Jan 2020 22:18:17 -0800

NOW() function in PHP

Is there a PHP function that returns the date and time in the same format as MySQL function NOW()? I know how to do this with date(), but I asked if there was a function for this only. For example, return: 2009-12-01 00:00:00 #1 building Use this feature: function getDatetimeNow() { $tz_object = new DateTimeZone('Brazil/Eas ...

Posted by gray8110 on Thu, 23 Jan 2020 06:14:37 -0800

MySQL - UPDATE query based on SELECT query

I need to check (from the same table) whether there is an association between two events based on date and time. One set of data will contain the end date time of some events, and the other set of data will contain the start date time of other events. If the first event completes before the second, then I want to link them. So far, I ...

Posted by coppercoins on Wed, 22 Jan 2020 07:36:43 -0800

Implementation of mariadb galera cluster based on docker

Environment configuration: Node name IP address node01 192.168.10.207 node02 192.168.10.167 Basic environment configuration: Remove firewalld yum remove firewalld -y Turn off selinux sudo vim /etc/selinux/config Modify the following: SELINUX=disabled Install iptables services and ...

Posted by versatilewt on Wed, 22 Jan 2020 01:00:27 -0800

Continue my login module development I

1. In the module in django, create the user class UserInfo(models.Model): name = models.CharField(max_length=20) email = models.CharField(max_length=50) power = models.IntegerField() phone = models.CharField(max_length=20) country = models.CharField(max_length=10) city = models.C ...

Posted by MathewByrne on Wed, 22 Jan 2020 00:57:09 -0800

Database for Go Web Programming

Summary A database is used to store data.As long as it's not a toy project, a database is needed for each project.MySQL is still the most used. PostgreSQL Use is also growing rapidly. In Web development, databases are also required.This article describes how to operate a database in Go Language based on MySQL.This article assumes that you alrea ...

Posted by sri.sjc on Tue, 21 Jan 2020 14:59:48 -0800

Using jar to connect and operate MySQL database

Why use database If you want to ask where the data comes from, it may be that no matter where Xiaobai has been working for many years, he will say in unison, of course, database. So why use database? Extract: database is a "record keeping system" (the definition emphasizes that database is a ...

Posted by jimmyo on Mon, 20 Jan 2020 23:18:55 -0800

Springboot+mybatis project - automatically create DaoMapper class and mapper.xml through database table and entity class

Recently, I practiced the springboot project, and found that the implementation of mapper.xml and DaoMapper interface class methods of mybatis framework is too arduous. Although it improves the flexibility, when there are too many tables, it is very tiring to write this part alone, so I found out how ...

Posted by ebgames56 on Mon, 20 Jan 2020 07:40:03 -0800