An in-depth analysis of mybatis

Java mentions the persistence layer framework. I believe no one doesn't know the existence of mybatis. Compared with JDBC, it has a more capable (JDBC workload is large), and compared with Hibernate, it has a more flexible (although HQL is convenient, it is too inflexible). Today we are going into her world together. 1, Simple implementation o ...

Posted by Yucky on Sat, 30 May 2020 15:15:43 -0700

Data analysis | accurate data management based on smart tags

Source code: GitHub point here || GitEE point here 1, Scenario analysis 1. Scenario case Friends in the Internet industry must have known or heard of the following scenarios: Ali: thousands of thousands of faces, meaning different users use Ali related products feel different, for example, the recommended content of Alipay home page, and other ...

Posted by michaelnorth on Fri, 29 May 2020 19:00:49 -0700

Java combines query operations with connected databases (20.5.29)

IDEA Connect to MySQL Database Add MySQL database connector to project Using mysql-connector-java-8.0.15.jar as an example, add jar files to your project The JDBC-MySQL connector is now added successfully Create the appropriate connection Connect the corresponding class in the jar file try { ...

Posted by pellky on Fri, 29 May 2020 11:57:32 -0700

Spring08_ Pure annotation practice_ Support transaction version

For the source code of this tutorial, please visit: tutorial_demo In the previous tutorial, we used pure annotation and Apache Commons DbUtils to implement CRUD operation of single table, but the operation in this tutorial does not support transaction. In this tutorial, we changed it to transaction support version according to the existing kno ...

Posted by 3dron on Fri, 29 May 2020 04:21:38 -0700

Database optimization of MySQL

No matter what kind of service, its optimization is nothing more than from two aspects, the first is the optimization of hardware, the second is the optimization of the system and the service itself.1, Query the number of times to connect to the MySQL server mysql> show status like 'connections'; +---------------+-------+ | Variable_name | ...

Posted by tukon on Fri, 29 May 2020 04:14:48 -0700

[12c] role switching of DataGuard physical backup

In the Data Guard environment, there are two types of role switching for databases, Switchover and Failover. According to the name, the former is a normal role switching between the active and standby databases, which will not lose data; the latter is a Failover, which means that the primary database cannot continue to provide services, which m ...

Posted by frewuill on Wed, 27 May 2020 05:08:13 -0700

[12c] learn how to install Oracle Enterprise Manager Cloud Control 12c in detail

1 software environment Oracle Linux 6.9 Oracle Enterprise Manager Cloud Control 12.1.0.4 Oracle 11.2.0.3 2 software preparation 1) Download EM database template https://www.oracle.com/enterprise-manager/downloads/cloud-control-downloads.html 2) Download Oracle Enterprise Manager Cloud Control 12.1.0.4 https://www.oracle.com/enterprise- ...

Posted by jtravis on Wed, 27 May 2020 04:52:51 -0700

Design and implementation of self defined persistent layer framework

Traditional jdbc Code: package com; import java.sql.*; /** * @author liuyj * @Title: JdbcTest * @create 2020-05-27 17:31 * @ProjectName algorithm-Exercise * @Description: TODO */ public class JdbcTest { public static void main(String[] args) { Connection connection=null; PreparedStatement preparedStatement=null; ...

Posted by mraiur on Wed, 27 May 2020 04:46:12 -0700

Introduction to using MySQL's own tools

In MySQL, there are many powerful tools, such as mysql, mysqladmin, mysqldump, etc.1. mysql commandThe Mysql command is the most common command tool used to provide a command line interface for users to operate and manage MySQL servers.You can see how it's used in more detail through mysql --help.1) Grammar used for -e, -u, -p, -h, -P, and so ...

Posted by Spudgun on Tue, 26 May 2020 10:54:08 -0700

Oracle Query_Form Query

Previously, we detailed the changes and additions to Oracle. Today let's go on to learn more about Oracle's queries. Queries in Oracle are a big deal!!! Follow the steps of brilliant sir, move, move ~~   Small bag of knowledge Before that, let's talk about a little bit of Oracle commentary, which is very helpful for our development, oh!!! ...

Posted by boyakasha on Tue, 26 May 2020 10:43:55 -0700