Porting the st7789 screen driver to Allwinner XR806

Foreword I am very glad to have the opportunity to participate in the “Free Trial” Allwinner XR806 Wi-Fi + BLE development board trial event equipped with ARM Technology STAR-MC1 held by Jishu Community. I became interested in Quanzhi’s MCU chips last year, but I never had the opportunity to get in touch with them. When […]

c# Import excel into sqlite

nuget needs to be loaded EPPlus.Core ExcelDataReader ExcelDataReader.DataSet //Extensions that need to be quoted using ExcelDataReader; using ExcelPackage = OfficeOpenXml.ExcelPackage; public static void CreateZhouPianChaTable() {<!– –> string tbname = “zhou_pian_cha1”; //Determine whether the table exists bool isExist = TableIsExist(tbname); if (!isExist) {<!– –> SQLiteConnection db = ConnectToDatabase(SqLite1); _sql = $”create table {<!– –>tbname} (ID integer […]

Detailed process of pure front-end export to Excel (including export by column + table with style + table merge + table nested table + two sheets in Chinese and English)

1. Foreword The vue project is a pure front-end export to Excel. The data structure array contains arrays to export Excel according to the required columns. Using the xlsx-populate plug-in, the exported Excel file: with borders, first column merging, nested tables, and Chinese generation respectively. and english two worksheets. The effect of exporting the table […]

Assignment 2: App portal page design and development

1. Function Based on the main page framework of WeChat in Assignment 1, recycleview is used to implement the list on the “Discover” page. After clicking, you can also jump to a new page. 2. Design process 1. Page design The discovery page has many news titles that can be scrolled up and down. The […]

Three-party HTTP interface call: POST&GET (supports HTTPS)

1. POST request 1.HTTP tool class import org.apache.http.HttpEntity; import org.apache.http.NameValuePair; import org.apache.http.client.entity.UrlEncodedFormEntity; import org.apache.http.client.methods.CloseableHttpResponse; import org.apache.http.client.methods.HttpGet; import org.apache.http.client.methods.HttpPost; import org.apache.http.client.methods.HttpUriRequest; import org.apache.http.conn.ssl.SSLConnectionSocketFactory; import org.apache.http.conn.ssl.TrustStrategy; import org.apache.http.entity.StringEntity; import org.apache.http.impl.client.CloseableHttpClient; import org.apache.http.impl.client.HttpClients; import org.apache.http.message.BasicNameValuePair; import org.apache.http.ssl.SSLContextBuilder; import org.apache.http.util.EntityUtils; import javax.net.ssl.HostnameVerifier; import javax.net.ssl.SSLContext; import javax.net.ssl.SSLSession; import java.io.IOException; import java.io.UnsupportedEncodingException; import java.security.GeneralSecurityException; import java.security.cert.CertificateException; import java.security.cert.X509Certificate; import java.util.ArrayList; import […]

Python divides the training data set and test data set from the Labelme data set by category and proportion

Python divides the training data set and test data set from the Labelme data set according to categories and proportions Preface Prerequisites Related introduction lab environment Split the training data set and test data set from the Labelme data set by category and proportion Code Output results Foreword Due to my limited level, errors and […]

Easypoi map method imports data, List<Map<String, String>> Date item data is empty (null) solution

Directory Preface Solution Foreword When using easypoi map to parse an excel file, if the data format of a certain column in the file is date type, then this tool cannot read it, because its source code reads a certain column in date format, and the data must be a string type, it will handle […]

Java tool class for reading and writing excel supports multiple Sheets

1. What is POI POI’s full name is PoorObfuscation Implementation. It is an open source project of Apache components that can read and write a series of Microsoft Office office software. The POI version corresponding to the examples in this article is 3.9. 2. Generate Excel tool class package org.zhao.component; import org.apache.commons.collections4.CollectionUtils; import org.apache.commons.collections4.MapUtils; import […]

Shader light probe support in Unity

Article directory Preface 1. Where and how to use light probes 1. Application scenarios of light probes 2. We build an identical environment in Unity according to the above conditions. 3. Create light probes 2. Implement support for light probes in our own Shader 1. Use the commonly used cginc 2. In v2f, prepare the […]