Hibernate Notes (Mapping Embeddable Components)

assembly They don't have their own identifiers, their primary key is that the entity they belong to has a mapped database identifier, and the embedded components have a separate life cycle: when they save their own entity instance, they also save the component instance, when their own entity instance is deleted, they also delete the component i ...

Posted by biggieuk on Tue, 21 May 2019 12:56:46 -0700

Optir_mode parameter of Oracle optimizer

Optir_mode parameter _optimizer_mode is an optimizer parameter of oracle 11g. It can affect the behavior of the optimizer in some cases, and it is a detail parameter that can not be ignored. SQL> show parameter optimizer; optimizer_capture_sql_plan_baselines boolean FALSE optimizer_dynamic_sampling integer 2optimizer_features_enable string ...

Posted by b on Mon, 20 May 2019 16:15:29 -0700

Classic Exercise Questions for SQL Database

Interview Questions and Answers in SQL Database (50 Examples) Student(S#Sname, Sage, Ssex Student Table S#Student ID Sname: Student name Sage: Student age Ssex: Student gender Course(C#,Cname,T#Curriculum schedule C#Course Number Cname: Course title T#Teacher number SC(S#,C#score) S#Student ID C#Course Number score: achievement Teacher(T#Tea ...

Posted by JayNak on Mon, 20 May 2019 14:36:26 -0700

Examples of transactions and transfers

1. What is a transaction? One thing has n components, which either succeed at the same time or fail at the same time. It's about putting n constituent units into one transaction. 2.mysql transactions Default transaction: An sql statement is a transaction, which opens and commits the transaction by default Manual transactions:1) Open a trans ...

Posted by Aaron_Escobar on Mon, 20 May 2019 11:57:29 -0700

MongoDB Learning (I) Common MongoDB Commands

1. Create a database Create grammar: use DATABASE_NAME If the database does not exist, create the database, otherwise switch to the specified database. Create yyf_mongodb database, db displays the current database > use yyf_mongodb switched to db yyf_mongodb > db yyf_mongodb If you want to view all databases, you can use the s ...

Posted by itandme on Mon, 20 May 2019 11:32:52 -0700

Database design (three relationships between tables)

There are generally three relationships between tables: one-to-one, one-to-many and many-to-many.   The following three relationships explain the thinking and thinking process of database design. (1) One-to-one relationship For example, the following table holds information about people, men and women, and requires that all couples ...

Posted by drkstr on Sun, 19 May 2019 20:36:53 -0700

Usage of merge into in oracle

In the form of merge into: MERGE INTO [target-table] A USING [source-table sql] B ON([conditional expression] and [...]...)   WHEN MATCHED THEN       [UPDATE sql]   WHEN NOT MATCHED THEN       [INSERT sql]   Function: To judge whether table B and table A meet the conditions of ON, if they are satisfied, ...

Posted by thipse_rahul on Sun, 19 May 2019 19:32:28 -0700

CXF Realizes Remote Call

Introduction to Apache CXF Apache CXF = Celtix + Xfire Holding multiple protocols SOAP1.1,1.2 XML/HTTP CORBA (Common Object Request Broker Architecture Common Object Request Broker Architecture, WS used in early languages). C,c++,C#) And it can be quickly and seamlessly integrated with Spring Flexible deployment: It can run on Tomcat, Jbo ...

Posted by jwoo on Sun, 19 May 2019 15:15:00 -0700

Python 3 crawls Douban Film and saves it to MySQL database

48 lines of code for Python 3 to crawl the Douban Film RankingsThe code is based on Python 3 and the class libraries used are: Caption text requests: Get page content and reference documents by forging request headers or setting up proxies, etc.Beautiful Soup: parsing pages, extracting data, referencing documentsPyMySQL: The version of Python 3 ...

Posted by gobbles on Sun, 19 May 2019 10:29:38 -0700

$. ajax and java background to achieve user login function

The $.ajax code: <script src="../js/jquery.mobile-1.4.5.min.js"></script> <script language="javascript"> function login(loginform){//Input form parameters if(loginform.username.value==""){ //Verify that the username is empty alert("Please enter the user name!");loginform.username.focus();return false; } ...

Posted by kutyadog on Sat, 18 May 2019 19:41:00 -0700