Tag: database

oracle database (oracel11 version)

1. Understanding of oracle database 1.Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system from Oracle Corporation. It is a product that has always been in the leading position in the database field. It can be said that the Oracle database system is currently a popular […]

AJAX dynamically obtains values from the database through manual splicing and dynamically splices the spliced JSON to the front-end page——AJAX

<!DOCTYPE html> <html lang=”en”> <head> <meta charset=”UTF-8″> <title>Title</title> </head> <body> <script type=”text/javascript”> window.onload = function () { document.getElementById(“show”).onclick = function () { var ajax = new XMLHttpRequest(); ajax.onreadystatechange = function () { if(ajax.readyState === 4) { if(ajax.status === 200) { var fromJava = ajax.responseText; var json = JSON.parse(fromJava); console.log(json); var html = “”; for (var […]

SpringBoot 2 ways to quickly implement sub-database and sub-table

This article is the third article in the series “Principles and Practice of ShardingSphere5. In code> environment, sub-database and table can be quickly realized through JAVA encoding and Yml configuration. 1. What is ShardingSphere? shardingsphere is an open source distributed relational database middleware and is the top-level project of Apache. Its predecessor was two independent […]

MATLAB connects to the MYSQL database and performs addition and deletion operations

I recently built an experiment management system. The new UI interface of matlab is relatively interactive and user-friendly. I am new to mysql and have never touched a database before, so I will make a record. 1. Environment installation 1. Make sure that matlab has database toolbox installed, which can be queried through the ver […]

HBase database design RowKey

Level 1: Financial RowKey Design Knowledge points 1.RowKey design principles: uniqueness principle, sorting principle, length principle (the shorter the better), hashing principle Programming requirements Follow the prompts and add code in the editor on the right to complete the following requirements: Design RowKey Complete query of a seller’s transaction records within a certain period of […]

mysq, comprehensive query of database

Record the comprehensive query of the database and review it to deepen your impression Creating a teaching database contains four basic tables: Teacher status table Teacher (Tno teacher number, TName teacher name, TDept teacher’s department); Basic course table Course (Cno course number, Cname course name, cpno prerequisite course number, Tno teacher number); Student status table […]

Nodejs operation cache database-Redis

Hi I’m Shendi Nodejs column Nodejs operation cache database-Redis In server-side development, cache database is also indispensable, which can improve program concurrency and facilitate subsequent expansion. Currently, the most commonly used one is Redis. Install dependencies Like the previous mysql, the most commonly used dependency of redis is redis npm install redis Depend on the […]

Use of Nodejs database-Mysql

Hi I’m Shendi Use of Nodejs database-Mysql Nodejs column The database is indispensable in the backend, and Nodejs naturally has libraries corresponding to the database to use. Mysql database can use the mysql library Install dependencies Execute the following command to install mysql dependencies npm install mysql Depend on the corresponding github address: https://github.com/mysqljs/mysql Introduce […]