Application of design pattern in the JDBC programming

Low coupling and high cohesion has been a major principle in structural programming, especially in database systems. The high coupling between the client-end and sub systems will cause frequent data interaction, which leads to frequent database processing objects creating. This will eventually bring sally and efficiency issues to the system. In this paper we discussed the combining design model of Facade pattern and singleton pattern in database system design. The combination helps to lower the database system complexity, simplify user interface design and improve the efficiency for both developing and operating. The application system designed with this combined model has cleaner structure, higher code reusability, and is easier to extend. The idea could be easily applied to all kinds of database based software design.