Experience in learning ssm framework

1) mysql: Let’s talk about the database first. In the early stage of using the database, you only need to master additions, deletions, modifications, queries, and the relationship between tables. Also try to understand paging and so on

Some, I personally think mysql is more flexible than sqlserver. The following is the paging statement of mysql. The meaning after limit is to start from the 101st piece of data and display 10

data. See It's very concise when it comes up

SELECT COUNT(*) FROM foo WHERE b = 1;
 
SELECT a FROM foo WHERE b = 1 LIMIT 100,10;

Then let's look at the paging statements of sqlserver, all kinds of nesting, it's a big head!

select  * from (
select row_number()over(order by tempcolumn)temprownumber,*
from (select top 10 tempcolumn=0,* from table1)t
)tt
where temprownumber>5

(If you have the ability, you can learn about distributed databases..)

2) mybatis: As a persistence layer, it has just become popular. In fact, it and Hibernate have their own advantages and disadvantages. Hibernate is almost fully automatic. , all configuration

files are basically automatically generated after configuring the connection, which is suitable for rapid development, but it will load all the data and is not flexible enough. The on-demand loading, semi-automatic, and flexible features of mybatis are becoming more and more popular. The premise is that the foundation of the database should not be too bad. You need to do a lot of mapping of relationships between tables in the mapper. Write all the sql

operation statements. In short, there is a lot of room for programmers to play, mainly including configuration files and mapping files!

3) Spring: Spring is really a great container, open to all rivers. There are two configuration methods for Spring: annotation and xml. The configuration file of mybatis can be

through

<context:component-scan base-package="包"/>

Hand over SqlSessionFactory and all classes as beans to Spring management,

Then inject them into dao in the form of annotations, and Spring MVC scans them

4) Spring MVC: MVC mode The business logic layer is an almost must-have model for development nowadays. There are not many advantages to mention

5JSP: The front end uses JSP with JSTL and EL expressions, and the code will be posted later

The above is the detailed content of Experience in learning ssm framework. For more information, please follow other related articles on the PHP Chinese website!