C ා the reflection string is converted to entity class and used as parameter in the generic method

There is such a requirement in the work, there are N different reports, each report corresponds to a data source. Previously, SQL statistical method was used, and the statistical data was in memory. First, the entity corresponding to the data source was defined in. The statistical conditions are implemented by the expression of lamdba, and the ...

Posted on Sun, 09 Feb 2020 10:24:13 -0500 by shalinik

MyBatis - dynamic SQL

MyBatis dynamic SQL (as learning notes, please refer to: MyBatis reference) if <select id="findActiveBlogLike" resultType="Blog"> SELECT * FROM BLOG WHERE state = 'ACTIVE' <if test="title != null"> AND title like #{title} </if> <if test="author != null and author.name != null"> ...

Posted on Sat, 08 Feb 2020 10:15:46 -0500 by phpstuck

PTA 1028 census (explanation + code)

All the time ac can't pass, all the time out. Parsing: the first figure is to use the native API to convert strings into date comparison, but it's slow and time-out is serious, but it's fast to write and saves a lot of logic. If AC can't or time is not enough, I'm willing to write the first one. The sec ...

Posted on Sat, 08 Feb 2020 09:20:22 -0500 by 244863

Annotation configuration for MyBatis

In the past, MaBatis added, deleted and modified queries, associated mapping, dynamic SQL statements and other knowledge, all of which are configured through XML, so it is cumbersome to write a large number of XML configurations. Annotation is still simpler. It can be seen from chapter allocation. The f ...

Posted on Sat, 08 Feb 2020 05:30:16 -0500 by RedRasper

Basic use of MyBatis in SpringBoot

Create a new mappers folder under src/main/resources of the project, and copy UserMapper.xml to this folder! This UserMapper.xml is the file used to configure SQL statements! The root node of the XML file of this configuration SQL statement is to configure the namespace attribute in the root node. The v ...

Posted on Sat, 08 Feb 2020 05:13:27 -0500 by inquisitive

python3 connects to MySQL database and performs basic operations of adding, deleting, modifying and querying database

This is a detailed description of python connecting to the database. If you continue to use python to connect to the database, please see this template article python3 connection MySQL database template We need to install pymysql when python3 is connected to MySQL database pip install pymysql After ins ...

Posted on Fri, 07 Feb 2020 11:45:08 -0500 by EZbb

python+mysql hands-on small project (add, delete, change and check mobile phone information)

*mysql partI used the db1 database and built two tablesPhone meter -------- store phone informationuser table store account password*python section 1. Connect to the database (connection() function) #Get connection def connection(sql,para): coon=pymysql.connect(host='localhost', ...

Posted on Fri, 07 Feb 2020 11:37:10 -0500 by purtip3154

User rights management of Oracle

User rights management of Oracle 1, Oracle user management Oracle user refers to the user who can add, delete, modify, and query the database. It mainly includes: Super administrator, such as SYS; general administrator, such as SYSTEM; general user, such as SCOTT; big data user. The operations that ...

Posted on Fri, 07 Feb 2020 03:43:32 -0500 by nishanthc12

Handwritten Tomcat web server test online bank transfer system

1. introduction In the previous chapters, we have designed and completed the development of web server. Next, we developed a simple online banking transfer system to test the web server. Our development roles are WebApp developers. We named the web application bank. 2.mytomcat [preparations] Do you ...

Posted on Thu, 06 Feb 2020 04:06:52 -0500 by drexnefex

install.php reinstall vulnerability in PHP code audit

Preface: This set of php source code was sent to me by the teacher in the previous class, which contains a lot of conventional loopholes. I feel that it is very suitable for beginners to audit (my php chicken). Today's article is also audited before, and I feel that it has practical meaning, so I will ...

Posted on Thu, 06 Feb 2020 01:57:45 -0500 by postmanager