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