JDBCUtil

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCUtil {
 public static Connection getConnection() throws ClassNotFoundException, SQLException{
  Connection con=null;
  Class.forName("oracle.jdbc.driver.OracleDriver");
  con=DriverManager.getConnection("jdbc:oracle:thin:@10.64.10.31:1521:nanjing","nanjing","nanjing");
  con.setAutoCommit(false);
  return con;
 }
 
 public static void close(Connection con,Statement st){
  if(st!=null){
   try {
    st.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  if(con!=null){
   try {
    con.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
 }
 
 public static void close(Connection con,Statement st,ResultSet rs){
  if(rs!=null){
   try {
    rs.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  close(con,st);
 }
}