Impact of using OpenSessionInViewFilter

Test controller method: @ResponseBody @RequestMapping(value = "/testFlush/json", produces = SystemHWUtil.RESPONSE_CONTENTTYPE_JSON_UTF) public String json2(Model model, HttpServletRequest request, HttpServletResponse response , int id) { // Session session=this.houseEvaluateDao.getSessionFactory().getCurrentSession( ...

Posted on Sat, 04 Apr 2020 03:32:01 -0700 by konigwolf

Java annotation (Java advanced)

Mind mapping 1. Notes overview What is Annotation: what is Annotation: Annotation annotation is a code level specification. It is a feature introduced by JDK 1.5 and later, which is at the same level as class, interface and enumeration Role of annotation: mainly used to replace XML and properties configuration files 2. Notes provided by ...

Posted on Sat, 04 Apr 2020 02:19:33 -0700 by moltenice

Setting the validity period of user password in Postgresql

Test environment: Server 192.168.137.222 highgodb v4.1.1 corresponds to PostgreSQL V9.5 Client 192.168.137.220 1) Create a test user at the highgo user of host 192.168.137.222 and set the password Expiration: [highgo@hgdb01 ~]$ psql psql (4.1.1) PSQL: Release 4.1.1 Connected to: HighGo Database V4.1 Enterprise Ed ...

Posted on Fri, 03 Apr 2020 17:55:50 -0700 by harrymanjan

windows installation Sphinx 3.0.1 (Chinese search)

The introduction of sphinx is not much, please check the document directly 1. Download the latest version of sphinx from the spinx official website. Address: http://www.sphinxsearch.com/ 2. Create a new data and log directory 3. Create a new sphinx.conf configuration file and put it in bin directory For inform ...

Posted on Fri, 03 Apr 2020 07:02:08 -0700 by tonymontana

Under what circumstances does a varchar int query index?

In fact, many developers who have worked for several years sometimes feel dizzy. Here is a test with specific examples. 1. Preparations Prepare two tables for subsequent tests. Table 1: Create table test1 with 3 columns, where id is the primary key (int), c_no is int, has index, and c_2 is a common field /*Create table test1 */ create table t ...

Posted on Fri, 03 Apr 2020 02:02:54 -0700 by JesperBisgaard

Zhimeng calls all columns (unlimited column output)

Share 2 ways to get all columns of Zhimeng (unlimited column output) The first method of custom function recursion For simple style users in the front end, add at the bottom of include/extend.func.php /** * Take out all categories * @param int $channel channel ID * @return string * call{dede:global.getall ...

Posted on Thu, 02 Apr 2020 21:00:39 -0700 by hastishah

SQL server queries the tables and fields of a specific value in the whole database

In recent days, business departments need to use a report in the old SAP B1 system. However, since the report does not add time conditions, once the query is started, the B1 system will exit abnormally. Because the SQL corresponding to the report exists in the database, you want to find the SQL of the report, and then add time conditions to the ...

Posted on Thu, 02 Apr 2020 20:35:23 -0700 by drfate

Solve the ORA-12505 problem of Oracle 11g

   Today, when using SQL Developer, it can't connect, and an ORA-12505 error is reported, but SQLPLUS can connect. Check the service name. If it is OracleServiceORCL, the SID should be orcl, but it still cannot be connected with the SID. The solution is as follows: 1. Open the directory of the database instance ...

Posted on Thu, 02 Apr 2020 17:32:44 -0700 by shezz

The effect of data table flags on query performance

The influence of flag bits on query performance. The example database uses PostgreSQL drop table if exists test; drop function if exists gen_random_zh(int,int); drop function if exists get_next_index(tweights[]); drop type if exists tweights; /************************************************************************ ...

Posted on Thu, 02 Apr 2020 14:22:01 -0700 by HaXoRL33T

C ා basic knowledge series - 6 brief introduction to lambda expression and Linq

Preface C's lambda and Linq can be said to be a bright spot. C's lambda is everywhere. Linq also plays an important role in data query. So what is Linq? Linq is the abbreviation of language integrated query, which can perform structured query operations on local object collections or remote data sources. So what is lambda? Well, in short, it's ...

Posted on Thu, 02 Apr 2020 09:17:02 -0700 by Teen0724