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