What Java Programmer Must Know About J2EE and SQL DB

xiaoxiao2021-03-06  56

From http://blog.9cbs.net/yzhz

DB: According to the practice experience developed, combined with your own understanding of the database, I summed up as a Java developer, what extent should be grasped on the knowledge of the database. Of course, everyone's situation is different, these only represent my words.

1. Understand the basics of the database, including paradigms, SQL statements, such as creating (table, index), query, delete, update SQL statements, transactions, etc. 2. Understand the significance of JDBC's URL connection such as Oracle's JDBC URL connection string is: JDBC: Oracle: Thin: @ip: 1521: SID.

3, master the SQL statement. For example, flip pages, time comparison SQL statements we use the most. Give you a requirement you can immediately write a SQL statement.

4. Proficiency in using the JDBC class, know when to use the following functions. PreparedStatementexecutebatch

5. Master the necessary database optimization knowledge. The programmer is almost the same below the three points. (1) SQL statement needs to bind variables; (2) Establish the necessary index (when, what field recommendation index); (3) Optimization of SQL statements, the execution plan of the SQL statement will analyze the execution plan of the SQL statement.

PS: Interest to database performance optimization, the database used in the project is mainly mysql and oracle, and it feels that the optimization of both databases is very different.

J2EE: Summarize an excellent J2EE program developer should master the following knowledge: 1. Servlet includes session management using servlet context to access the RESource JSP technology Web layer mode: Service-to-worgate Patterns web application MVC Pattern Handling Errors in Web Applications Configuring Web Application Concurrent Access 2. Transaction Processing

3. Safety strategy

4. Demand Analysis Basic Architecture Design Method Creating a Use Case Diagram UML Figure 5. Basic Design Matters Master Pattern.Observer Pattern.Abstract Factory Pattern.Abstract Factory Pattern.

6. EJB Package and Deploy EJBCMP BMP Message-Driven Beanscmp BMP transaction Implementation Service Time Service Adopt STATELESS BEAN to implement the best practice of Webseriveejb architecture

7.J2ee J2EE's security architecture Implemented the Optimization of Inside Tier, Tier-to-Tier Communication in Fundamental Architectural Concepts and FIVE PRIMARY Concerns of ArchitectureJ2ee

8.java programming language syntax control statement data type exception thread I / Oneetworking

I think these knowledge points are more practical. I will encounter in the development of the actual project. Of course, I have some knowledge points I may not write in, I will continue to add according to the problems encountered in my project development.

转载请注明原文地址:https://www.9cbs.com/read-117784.html

New Post(0)