Java Surface question finishing 2

An article

1.Mybatis and Hibernate page fetch number implementation, one-time fetch?

MyBatis is divided into: memory paging (false paging) through the cursor interception;

Physical paging;

Mysql:limit 5, 10;

SQL Server:top

Oracle:rownum

2.html request process, briefly describe a complete request process. Strus and Springmvc differences

Action uses struts in xwork mode

Action Annotation Form

3. Efficient SQL writing note the database table index amount principle, deadlock reason and how to avoid

where+ conditions and GROUP BY * have + condition difference: where filter record condition, having filter grouping condition

4. High concurrency, high efficiency for insert operation

Locking concept Lock: optimistic lock; Based on the database version, it is determined that only the current modified version > current version will operate.

Pessimistic lock; the lock mechanism that relies on the database. Hibernate in Query.setlockmode: (None,write,read,upgrade)

Sync Lock synchronized:

5. Value delivery and address delivery

Value passing: The underlying data type: int, char,float, etc. are passed by value

Pass: Class such as String, etc.

6. Spring Features and applications

IOC:

Aop:

7. Return the Jason data type when the interface is written

Many-to-one and Many-to-many configuration in 8.Hibernate

Two articles

1.Ajax request call, request parameter

Head ("Content-type:application/json");

${function () {

$.ajax ({type: "Get",

URL: "Data.json",

DataType: "JSON",

Success:function (data) {

}})

};

2. Structural data

(1). Traverse HashMap:

(2). Delete duplicate data points in ArrayList, common exceptions

(3). In the integer array, find out the number of K, consider the complexity of space

(4). Bubble sort, insert sort brief

(5). Single-linked list operation

3. Computer network

1). TCP Three-time handshake, why two-time handshake can not

2). The difference between TCP IP and HTTP IP and its connection.

4. Operating system

1). The difference between a process and a thread:

2). 10 commands for common operating systems:

3). Performance tuning from the server side:

Java Surface question finishing 2