Using IDEA to connect database to generate entity class and customize Groovy script file
Introduction: Now 2019, there are many plug-ins or editors that support the automatic generation of data entity classes based on data tables, such as IDEA, MyBatis code generation tools, etc. This article describes how to use IDEA groovy script file to generate JPA annotated entity classes.Reference link: Intellij IDEA Generates Annotated Entit ...
Posted by Vex on Mon, 26 Aug 2019 01:33:39 -0700
Oracle Flex ASM and Flex Cluster
Oracle Flex ASM and Flex Cluster
Oracle RAC 12c introduces two new concepts:
Central nodes: Like previous versions, they are interconnected through private networks and have direct access to shared storage. These nodes have direct access to Oracle Cluster Registry (OCR) and Voting Disk (VD).
Leaf nodes: These nodes are lightweight nodes that ...
Posted by briant on Wed, 21 Aug 2019 07:20:19 -0700
Framework by springboot to simplify 80% of code
Catalog
Project introduction
Environment Setup
development tool
development environment
Tool Installation
system architecture
Start Project
Open Source Location
springboot does many default encapsulations based on spring and mvc.The benefits of doing so greatly fac ...
Posted by hrosas on Sun, 18 Aug 2019 19:56:50 -0700
Django 2.2 with Oracle 11g to resolve version conflict
The last time we used Django 2.2 and Oracle 11g, there was a version conflict during migrate, and finally Upgrade Oracle to 12c to solve the problem
So can we solve this conflict in other ways? Think of a solution and practice it:
Using Django 2.2 t ...
Posted by PBD817 on Sat, 17 Aug 2019 05:16:59 -0700
Record a production on-line problem
Yesterday the project came online, and after verification, I took a deep breath and went online perfectly without any problems.However, half an hour later, I received an alert from the Operations and Maintenance Team that several ports of a serve ...
Posted by Pavel_Nedved on Thu, 15 Aug 2019 20:27:06 -0700
Ali doesn't let MySQL multi-table Join? I want it!
Links to the original text: https://mp.weixin.qq.com/s?__biz=MzUzMTA2NTU2Ng==&mid=2247487444&idx=1&sn=5325b3e29504162cd9c882c2c7f0e1d7&chksm=fa497065cd3ef973e229966f3c9c612cca8526d7201790e773ede29b9a855d27eb6d86449776&mpshare=1&scene=23&srcid=&sharer_sharetime=1565145500644&sharer_s
...
Posted by seanpaulcail on Thu, 15 Aug 2019 05:37:27 -0700
The Use of Oracle PLSQL Cursors and Cursor Variables
Reference article: https://www.cnblogs.com/huyong/archive/2011/05/04/2036377.html
In PL/SQL programs, cursors are often used to handle transactions with multiple rows of records.
There are four steps to use: define, open, extract, and close.
Example:
09:52:04 SCOTT@std1> DECLARE
09:52:07 2 CURSOR c_cursor
09:52:07 3 IS SELECT e ...
Posted by vitch2002 on Tue, 13 Aug 2019 03:51:11 -0700
Design and Implementation of Enterprise Office System
Design and Implementation of Enterprise Office System
Design and implementation of enterprise office system
Design and implementation of enterprise office system
Design and implementation of Enterprise Office System SQL Server database creation statement
Design and Implementation of Enterp ...
Posted by nightkarnation on Sat, 10 Aug 2019 05:13:49 -0700
User Interface Analysis and Design (SSD4) Experiment 2
Take Assessment: Exercise 2
1. Demand analysis
(1) Description of displaying the contents of selected UAR components
When the user enters a valid list number of UAR components and clicks the Display button, the application will display the description of the component content in the Output Text Box.
...
Posted by pyro3k on Sat, 03 Aug 2019 05:34:19 -0700
Some syntax of SqlServer stored procedures and functions (part difference from oracle)
Judgment statement
The value of select is passed to a variable
IF(@v_count <> 0)
BEGIN
SELECT @v_team_id=team_id FROM TABLE T WHERE T.column=1;
END
ELSE
BEGIN
SET@v_team_name='nothing';
END
Multi-line to one-line
https://www.cnblogs.com/CreateMyself/p/9058380.htmloracle:listagg
SELECT STUFF((SELECT '/' + T. ...
Posted by ciaranmg on Thu, 25 Jul 2019 22:41:15 -0700