Execute Sql statement in ABP

Because EFCore does not support direct execution of sql statements at present, there is no SqlQuery function to execute. There are three ways to execute Sql statement in ABP: 1.ExecuteSqlCommand2.FromSql3. Use RawSqlCommand, RelationalDataReader, DbDataReader to read 1. Use ExecuteSqlCommand to execute sql statement and retur ...

Added by Kifebear on Thu, 14 Nov 2019 18:06:13 +0200

Web backstage service development -- a simple select for database query

Article from Geek Forum Step 1: create module s and service s Execute the following command at the command line to create the module and service named Person. nest g module person nest g service person In this case, the directory named person will be generated automatically Step 2 create entity Create the file person.en ...

Added by Nytemare on Wed, 13 Nov 2019 19:53:28 +0200

Spark custom external data source

Background: sometimes we need to define an external data source and use spark sql to process it. There are two benefits: (1) after defining the external data source, it is very simple to use, and the software architecture is clear. It can be used directly through sql. (2) it is easy to divide modules into layers and build them up layer by lay ...

Added by kinaski on Tue, 12 Nov 2019 21:13:18 +0200

Java connects to SQL Server through JDBC

Download Microsoft JDBC Driver 4.0 for SQL Server Download here: http://www.microsoft.com/zh-cn/download/details.aspx?id=11774 1. Create a new folder on disk E, named sqljdbc 42, and copy sqljdbc 42.jar into it. Right click my computer properties advanced system settings environment variable, double-click the CLASSPATH variable (or select C ...

Added by franknu on Tue, 12 Nov 2019 19:53:02 +0200

ElasticSearch implements data paging (using bucket sort

es version at least 6.1 above Sentence: GET 76/sessions/_search { "size": 0, "query": { "bool": { "must": [ { "term": { "sid": { "value": "76e14832" } } }, { "range": { "v_ymd": { "format": "yyyy ...

Added by grumpy on Mon, 11 Nov 2019 22:48:06 +0200

Restapi-caching, akka-http cache

restapi serves as a hub for front-end and back-end interaction: in the face of a large number of front-end requests, you need to ensure timely responses.Using caching is an effective tool.We can cache the response of most front-end requests, especially those that require a lot of computation to obtain, which can greatly improve the response spe ...

Added by Fireglo on Mon, 11 Nov 2019 08:40:33 +0200

Summary on the use of datagrid in easyui

Recently, I took over a project with a relatively long implementation cycle. The foreground technology is easyUI. Now I need to modify a component, which is simply a selector. Due to the problem of code confidentiality, the figure of this page is not shown. The page selector is a text followed by a query icon, which is originally ...

Added by feddie1984 on Fri, 08 Nov 2019 23:27:28 +0200

Ubuntu 16.04 build oracle environment for golang development

Mirror version Search oracle on docker hub and find a xe 11 image. docker pull deepdiver/docker-oracle-xe-11g The image size is about 1G, and it is about 2.7GB after decompression. Function docker run -d -p 1522:22 -p 1521:1521 --name oracle deepdiver/docker-oracle-xe-11g Use the above command to run oracle. Wait about 1 minute, use ssh root ...

Added by greip on Fri, 08 Nov 2019 19:23:14 +0200

Failed to bind properties under 'spring.datasource' to javax.sql.DataSource

After checking on the Internet, I didn't find a solution to the problem, so after solving the problem, I sorted it out on the Internet to help my friends in need.   When spring boot integrates Druid, it introduces the data source of druid and configures the relevant configuration in the configuration file application.yml in ...

Added by hexguy on Thu, 07 Nov 2019 22:24:16 +0200

Hibernate Learning Notes 3 (HQL Query)

HQL statement In Hibernate, although simple primary key query statements can be generated directly by Hibernate using the API, complex query statements need our own handwriting. Hibernate provides us with an HQL statement to use. HQL is the abbreviation of Hibernate Query Language, HQL is a statement close to SQL, b ...

Added by PHPTOM on Thu, 07 Nov 2019 21:20:33 +0200