MySQL associated query

Two tables Table A is A public curriculum with two fields, i.e. id and pro name. There are about five courses, and each of them should go to Table B is the association table of user and course reminders. It has four fields: ID, pro ID, user ID and tip time, which respectively represent ID, course ID, user ID and reminder class t ...

Posted by ReD_BeReT on Sun, 24 Nov 2019 11:09:53 -0800

Winform file upload

Recently, I have done a winform project to upload the attachments There are three types of project selection at the beginning 1. Use webservice and webapi to upload files 2. Directly saved in the database 3. Use shared directory + dos command   The first one is limited by file size and has a lot of design knowledge. The second one will put a lo ...

Posted by amsgwp on Sun, 24 Nov 2019 10:27:01 -0800

Index and view details of Mysql database

Index and view details of Mysql database The concept of index The index of a database is similar to that of a BookIn a book, you can quickly find the required information by using the catalog without reading the whole bookThe table of contents in the book is a list of words with page numbers containing each wordDatabase indexIn the database, ...

Posted by dyconsulting on Sun, 24 Nov 2019 07:02:30 -0800

Operation principle of MyBatis analysis

Provide an interface package com.ming.MyBatis; import com.ming.MyBatis.POJO.Role; import com.ming.MyBatis.POJO.Student; import com.ming.MyBatis.POJO.StudentCard; import org.apache.ibatis.annotations.Param; import java.util.List; import java.util.Map; public interface RoleMapper { /** * @param id * @return */ public Rol ...

Posted by geoffs on Sat, 23 Nov 2019 10:08:24 -0800

Go micro project practice one create user service

User service User service, providing login, registration, password modification and other functions. New service micro new shopping/user Finishing structure Add the model directory and repository directory, delete the default example folder in proto, and create the user folder. Development steps: 1. Define interface - > ...

Posted by proiek on Sat, 23 Nov 2019 09:31:55 -0800

About mysql database migration, the pit encountered by datetime

Migration database is often encountered in work.If you use phpmyadmin to import, you can solve the problem if the database is too small. If it is too large, it will be troublesome. Either it will time out or the file is too large to import.So I chose to use Navicat For Mysql to copy the database In this process, I often encounter a problem: ERR ...

Posted by dannyb785 on Sat, 23 Nov 2019 09:28:42 -0800

How to add and share the function of Youdao cloud notes to your app

Article synchronization from http://javaexception.com/archives/34 How to add and share the function of Youdao cloud notes to your app Question: An open source notebook project before Leanote In, a user feedback wants to add the function of sharing to Youdao cloud notes, so that they can share their millet notes or other Notepad contents to t ...

Posted by conker87 on Sat, 23 Nov 2019 09:06:22 -0800

MongoDB's processing of time: the difference between ISODate and our time zone is 8 hours

In mongoDB database, the time is saved as ISODate type, and orm relationship is mapped as java.util.Date type. The time saved is 8 hours earlier than that of us The original data is: Person [id=11188, name=doctorwho, age=888888,birth=2016-01-01 13:55:00] In MongoDB database: { "_id" : "11188", "_class" : "com.doct ...

Posted by jonnyw6969 on Sat, 23 Nov 2019 08:12:52 -0800

Build Linux:LAMP Environment

Setup of LAMP Environment Install DNS Server Install DNS Service yum install bind -y Configuration of DNS Create Forward Resolution For example, create a forward lookup zone named "lsy.com": Step 1: Create a lookup zone in the main configuration file/etc/named.conf. vim /etc/named.conf listen-on port 53{any ...

Posted by bulgin on Sat, 23 Nov 2019 00:46:29 -0800

Understand how to use JWT and you will be able to implement it with PHP

To implement JWT certification with php, let's first understand what JWT is.What is JWTJWT(json web token) is an open JSON-based standard implemented to pass declarations between network applications.JWT's declarations are typically used to transfer authenticated user identity information between identity providers and service providers in orde ...

Posted by _rhod on Fri, 22 Nov 2019 21:45:57 -0800