jdbc 连接数据库、批量操作、事务（oracle、mysql）

 

 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.PreparedStatement;
 6 import java.sql.ResultSet;
 7 import java.sql.SQLException;
 8 
 9 public class JdbcUtil
10 {
11     public static final String USERNAME = "root";
12 
13     public static final String PASSWORD = "root";
14 
15     public static final String URL = "jdbc:oracle:thin:@192.168.2.1:1521:orcl";
16 
17     static
18     {
19         try
20         {
21             Class.forName("oracle.jdbc.driver.OracleDriver");
22         }
23         catch (ClassNotFoundException e)
24         {
25             e.printStackTrace();
26         }
27     }
28 
29     public static Connection getConnection()
30     {
31         Connection conn = null;
32         try
33         {
34             conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
35         }
36         catch (SQLException e)
37         {
38             e.printStackTrace();
39         }
40 
41         return conn;
42     }
43 
44     public static void closeConnection(ResultSet rs, PreparedStatement ps, Connection conn)
45     {
46         try
47         {
48             if (rs != null)
49             {
50                 rs.close();
51             }
52         }
53         catch (Exception e)
54         {
55             // TODO: handle exception
56         }
57         finally
58         {
59             try
60             {
61                 if (ps != null)
62                 {
63                     ps.close();
64                 }
65             }
66             catch (Exception e2)
67             {
68                 // TODO: handle exception
69             }
70             finally
71             {
72                 try
73                 {
74                     if (conn != null)
75                     {
76                         conn.close();
77                     }
78                 }
79                 catch (SQLException e)
80                 {
81                     e.printStackTrace();
82                 }
83             }
84 
85         }
86     }
87 }

<!--done-->

Java JDBC Thin Driver 连接 Oracle 三种方法说明 http://www.cnblogs.com/zhangliang0115/archive/2012/02/18/2357097.html

 

JDBC连接MySQL   http://www.cnblogs.com/cy163/archive/2008/08/22/1274413.html

JDBC批处理  http://blog.csdn.net/wfgeqgeq/article/details/6783930 

JDBC事务控制   http://blog.csdn.net/wfgeqgeq/article/details/6778777

 

JDBC事务与批量处理(转载)  http://junxiangzheng.iteye.com/blog/939762