Please enable JavaScript.

Coggle requires JavaScript to display documents.

Integro technology (IT knowledge (SQL tunning (writing sql (avoid using…

- - - - partition column key is subset of index keys
      - the frequency of select query is much greater than update, insert, delete query
    - - index key is unique
      - the number of delete, update, insert query is much greater than select query
    - - avoid using subquery --> use join
      - avoid use function on index column
      - avoid use not in, != , not between on index column because it make index column uneffective
      - avoid select all colums, just select the needed columns
      - use index when need to access less than 5% of the total number of the table
  - - - Model: maintaing the state (data) and the business logic of application
      - view: is responsible for display the data to the user
      - controller: handle the request from user(client), work with model to render the view with correct data, and response the view to user. It also can call some business logic to manipulate the state of model
    - - View: JSP
        
        struts tags
        
        html: text, option, file, select, form
        
        bean: write, message
        
        logic: equal, notequal, null, greathan...
        
        jsp tags
      - Controller
        
        Use ActionServlet to handle request
        
        config in web.xml and struts-config.xml
        
        mapping request by action path. Mapping result by path to jsp
        
        return new ActionForward(path, redirect) to foward the result page or Actionmapping to map name to path
      - Model
        
        Hibernate BO entity
        
        Logic business
    - - config
        
        web.xml
        
        declare dispacherServlet (spring-mvc)
        
        spring-mvc.xml
        
        component scan : auto
        
        controller: RequestMapping: to map the URI with request method, parameter to controller
      - View and Model
        
        ModelAndView: contain model and view. View contain path to the page (html or jsp)
      - Controller
        
        controller
        
        RequestMapping
        
        value, method, produres
        
        RequestParam
        
        RequestBody
      - Autowried
        
        Component: declare for the auto scan of spring can find and add to the context
        
        Reposity: the same component but it specially for DAO class, to hand Exception and delegate transaction management for Srping by anotation Transaction
        
        Service: the sam component, use for Service Class