Analysis of the actual operation of the database SQL of Niuke network (1-10)

1. Find all information about the latest employee CREATE TABLE `employees` ( `emp_no` int(11) NOT NULL, `birth_date` date NOT NULL, `first_name` varchar(14) NOT NULL, `last_name` varchar(16) NOT NULL, `gender` char(1) NOT NULL, `hire_date` date NOT NULL, PRIMARY KEY (`emp_no`)); Solution: sort order by... Desc according to the entry time in re ...

Posted by Soumen on Tue, 07 Apr 2020 15:46:24 +0200

springboot uses logback to generate log files by date and size

Change from: https://www.ericgg.com/archives/3848.html The default log files of springboot will not be automatically divided by day, so the log files of the production environment are getting larger and larger, which is not conducive to troubleshooting. After checking a lot of data, the final configuration is as follows. The log files can be d ...

Posted by jklanka on Mon, 06 Apr 2020 10:22:10 +0200

sql automatic inspection and analysis tools: soar and soar web installation and use experience

In order to study whether sql automatic inspection and analysis tools are easy to use, I install and use soar and soar web locally. The preliminary experimental results are summarized as follows: 1. The installation is relatively cumbersome, especially the installation of dependency package of soar web, which involves the download and installat ...

Posted by ICEcoffee on Mon, 06 Apr 2020 03:09:13 +0200

[Seata microservice distributed transaction] 1. Seata server environment construction

Seata serve installation package Download the Seata Server package, all I have is version 0.9.0 https://github.com/seata/seata/releases wget https://github.com/seata/seata/releases/download/v0.9.0/seata-server-0.9.0.tar.gz Link: https://pan.baidu.com/s/1jlBwCEYM3hn7zQiSpwRijg password: 56vm After 0.9.0 of the official website, there is no ...

Posted by davespring on Mon, 06 Apr 2020 02:29:27 +0200

get and load queries in Hibernate Framework

Original link: http://www.yiidian.com/hibernate/hibernate-get-load.html 1. Demonstrate the basic use of get and load methods /** * Show basic object query * @author http://www.yiidian.com * */ public class Demo { /** * get()Method: query an object */ @Test public void test1(){ Session session = HibernateUtil.getSession(); Transa ...

Posted by NZ_Kiwis on Sun, 05 Apr 2020 22:37:01 +0200

[Swift 4.0] extended WCDB supports SQL statements

Preface wcdb has been in the pit for two months, which is still very good on the whole. For specific advantages, please refer to the documentation. Because the official specification does not support SQL, we have to write an extension to support it A kind of   statement Welcome to reprint, but please keep the original source of the article:) ...

Posted by bkanmani on Sun, 05 Apr 2020 22:12:30 +0200

JDBC basic CRUD and calling stored procedure of [add, delete, modify and query]

Preface CRUD operation on database has a certain history ① JDBC - > ② dbutils - > ③ jdbctemplate - > ④ - > hibernate - > ⑤ mybatis - > ⑥ JPA+SpringData So many dao layers are used to realize their own advantages and disadvantages, and to seek the best dao scheme of the project. But the framework will work, ...

Posted by MBK on Sat, 04 Apr 2020 19:25:28 +0200

[cache] use Redis cache in SpringBoot

I. Preface Select is the most frequently used in the database, and it is basically the same every time. update, delete and insert are not used as frequently as select, and they are basically different every time. In order to reduce the pressure of the database, it is necessary to use cache for select. In the past, Ehcache was ...

Posted by richardbotw on Fri, 03 Apr 2020 19:17:08 +0200

jdbc starts from scratch

One. Remember to build the connection foundation before getting the database 1. driver 2. connection 3. statement 4. resultSet //1 Class.forName(ConfigUtil.getValue("driver")); //2 Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/resource_integrate","root","root");//The three paramete ...

Posted by texmansru47 on Thu, 02 Apr 2020 11:59:01 +0200

The 100th blog post of Xiao Liu

Achieve [100 blog achievements] With the teacher's video, the interface has been written today, mainly including the user details page, which is called "riend" and "detail". posts friend circle article interface: // All under the user posts Interface router.get('/:id/post', (req, res) => { connect.query( 'se ...

Posted by crunchyfroggie on Thu, 02 Apr 2020 07:12:41 +0200