Login case (black horse) - simple login case using druid database connection pool, JdbcTemplate technology and Servlet

catalog User login case requirements Development steps: 1. Create project, configuration file and import jar package. 2. Write logged in login.html Page. 3. Create the database userlogin and the table user. 4. Create a package com.qgl . 'domain'. Create an entity class user. The entity class user c ...

Posted by irish21 on Sun, 28 Jun 2020 17:55:56 -0700

BaseModel based on ActiveAndroid framework

brief introduction Based on the ActiveAndroid framework, the Self-encapsulated BaseModel class, and some other operation classes simply need to inherit from BaseModel to have a method of database operation, which is very convenient to use. On how to use ActiveAndroid, I wrote in another of my blogs: http://blog.csdn.n ...

Posted by Misticx on Sun, 28 Jun 2020 09:56:14 -0700

Short link service practice

Article catalog Business scenario Practice mode The first way The second way code implementation Function extension Distributed high availability other target Realize the change from ordinary website to short website reference resources:Design short URL system How are short links designed? Get ...

Posted by smarlowe on Sat, 27 Jun 2020 21:53:43 -0700

After using Python for so long, these funny and practical libraries don't even know

As mentioned in the previous article, Python is simple and efficient because it has rich functions that can be used immediately. Recently, I read some technical articles of Github and found some interesting and practical Python libraries. It's a feeling that I'm too late to meet each other. Today, I wil ...

Posted by harvey on Sat, 27 Jun 2020 21:09:40 -0700

[open source]. Net uses ORM to access Shenzhou general database (Shentong)

preface Tianjin Shenzhou General Data Technology Co., Ltd. (hereinafter referred to as "Shenzhou general company") is subordinate to China Aerospace Science and Technology Corporation (CASC). Is engaged in the domestic database, big data solutions and data mining analysis product research and development of professional companies. The ...

Posted by cbailster on Sat, 27 Jun 2020 17:55:00 -0700

FreeSql uses ToTreeList/AsTreeCte to query infinite level classification table

On infinite class The first option: Recursion algorithm is also the most frequently used, and most open source programs do the same, but generally only use four levels of classification. The database structure design of this algorithm is the simplest. A field ID and a field FID (parent id) in the category table. In this way, we can judge the up ...

Posted by jwoo on Sat, 27 Jun 2020 17:13:04 -0700

Production environment database backup scheme

1, Introduction After the product goes online, our data is very important. It's not allowed to be lost. We should be well prepared. If one day is hacked or deleted maliciously, it will crash. So we need to do full backup and incremental backup for our online database regularly. For example, make incre ...

Posted by lauxanh on Sat, 27 Jun 2020 01:35:14 -0700

Spring Security's remomberme automatic login

Automatic login is a mechanism that saves the user's login information in the cookie of the user's browser. When the user visits next time, it automatically realizes the verification and establishes the login state. Spring Security provides two very good types of Tokens: Hash algorithm encrypts user's necessary login information and generates ...

Posted by exec1 on Sat, 27 Jun 2020 01:18:49 -0700

Triggers and views in MySQL

The keyword "delimiter" is used to declare the delimiter of SQL statement and tell mysql interpreter whether the command has ended and whether mysql can be executed. By default, delimiter is a semicolon;. In the command line client, if a line of commands ends with a semicolon, mysql will execu ...

Posted by danielrs1 on Fri, 26 Jun 2020 18:30:09 -0700

SQL Base Notebook 2 View Stored Procedure

  View CREATE/ALTER/DROP VIEW ViewName as SELECT(...) You can continue to create a view based on it, that is, you can place the previously created view as a table name in the select statement of the new view Format data using views (that is, reassemble and stitch fields) CREATE VIEW View_player_team AS SELECT CONCAT(player_name, '(' , t ...

Posted by Izzy1979 on Fri, 26 Jun 2020 09:58:46 -0700