Programmer Group

Introduction to Portal.MVC The project is based on MVC4+EF, with the basic functions of role, authority, user center and account (login, registration, password modification, password retrieval, etc.). Open source projects for reference nopcommerce This is an MVC project of e-commerce architecture. I simplified it. Before that, it was ...

1. introduction When there is a large amount of data in a table, it is natural for us to think of splitting the table into many small tables. When we execute the query, we go to each small table to query. Finally, we summarize the data set and return it to the caller to speed up the query. For example, the order table and inventory table of e-c ...

Programs generally have development environment, test environment and online environment. The basis of program running in these environments is generally different. For example, in a program with data source access, embedded database may be used in development, and independent mysql may be used in the test environment. After the program is offi ...

[TOC] MySQL Create Capable Database Architecture Notes Database Monitoring Content to monitor Monitor the availability of a database: instead of just monitoring the existence of a database process, connect to the database over the network and determine if it is available Monitor database performance: QPS TPS, Number of concurrent threads, inn ...

uncategorized SQLException; SQL state [99999]; error code [17004]; invalid column type Error phenomenon Invalid column type: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor ; uncategorized SQLException; SQL state [99999]; error code [17004]; Invalid column type: getTimestamp not implemented for class oracle.jdbc.driv ...

1, SELECT clause /* Basic query: select * from Table name [where condition]; select Field list from table name [where condition]; Extended query, 5 clauses of select statement: (1)where where Condition is used to filter out the qualified records (rows) from the table (2)group by (3)having (4)order by (5)limit These five clauses can appea ...

Window function is often used in work and often asked in interview. Do you know the implementation principle behind it? Starting from the problems encountered in a business, this paper discusses the data flow principle of window function in hsql, and gives a solution to this problem at the end of the article. ​   1, Business background Fi ...

1. background PostgreSQL's HA schemes are generally based on its native stream replication technology, supporting synchronous replication and asynchronous replication modes.Although the synchronous replication mode can ensure the data is not lost to the greatest extent, it usually needs to deploy at least three machines to ensure that there ar ...

Development environment: ubuntu-17.10.1-desktop-amd64 Download link: https://www.ubuntu.com/download/desktop 1. Install mysql through apt get sudo apt-get install mysql-server mysql-client Note: my ubuntu-16 version can't be installed, so I can't find the corresponding website, so we can update the software source through ...

Preface Only a bare head can make it stronger. The text has been included in my GitHub selected articles. Welcome to Star: https://github.com/ZhongFuCheng3y/3y I don't know if you have written JDBC in your work. I went to a small company as an intern in my junior year. JDBC is used in it, but it encapsulates several tool classes. When ...