jdbc连接如何正确释放（How to release the JDBC connection）.docVIP

jdbc连接如何正确释放（How to release the JDBC connection） Yesterday I encountered difficult problems of JDBC in writing the program links off is not complete, leading to the continuous occupation of connection pool links continue to be occupied, refresh the page several times, finally took over connection pool, a natural studying data or wrong. Ive been doing this for a long time, so I didnt solve the problem until I got off work. I used to have this problem when I was writing a program. So today, when I go to work and look for information on the Internet, I find a well written article, although it is a bit of a metaphor But its really well written. Respect for the original, the following article reprinted from: JAVAEYE software development exchange community Did you clean it? OK, wipe it off? Are you sure its cleaned? Javas try-finally provides us with an opportunity to ensure that an action is performed. A try-finally structure, as long as the try block starts executing, the code inside the finally block is guaranteed to execute once and only once. For example, as you go to the toilet, as long as once you start pulling out, we ensure that in any case, diarrhea is good, fart is certainly worth mentioning, eventually you wiped his ass out of the bathroom. With try-finally, we can ensure that our critical resources are cleaned up on time and in the most unexpected programs. One of the most common applications is JDBCs Connection, Statement, ResultSet, and so on. But I was recently surprised to find that there are people who dont know how to properly clean up resources, even some Java veterans. Take an example: Void, f () { Connection conn =...; Statement stmt = conn.createStatement (); ResultSet RSET =...; ... } Typical JDBC program. But it is also typical of bare buttocks, which smells like a typical example of LAN stepping out of the toilet. Hey, did you wipe your ass? Some dude I dont mind, I spoke: JDBC driver/ I /garbage collector application server will handle. This is