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