Optimized Strategy of JDBC to Access Database
HU Jie-ping · Journal of Beijing Institute of Graphic Communication · 2006
The way of database access directly affects the performance of a network application system.In order to establish high performance of the network database application system,it needs to use the optimization database handling the method.The optimized database access,to enhance the network database application system is extremely important.The optimization must start from the connection,in view of the different application.It first must choose the appropriate connection model,take the small business as an example.It generally chooses Pattern 4,when it has a concrete connection,but it also may use the connection pond technology further to improve the connection performance.Next,when it carries on the data manipulation it also must use the PreparedStatemen,the storage procedure,as well as has optimized SQL and so on,in order to enhance the operating speed.Using PreparedStatement to process SQL also allows it to be able to greatly to enhance the efficiency of system,using the CallsableStatement object to carry out storage procedure in the database in Java,which also has very high efficiency.