封装 JDBC 工具类-普通版

package com.utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
/**
* jdbc工具类
* @author neusoft
*
*/
public class JdbcUtil {
   private static String driver="com.mysql.jdbc.Driver";
   private static String url="jdbc:mysql://localhost:3306/cars?useUnicode=true&characterEncoding=utf-8";
   private static String username="root";
   private static String password="root";
   //静态代码块初始化且只执行一次
   static {
      try {
         Class.forName(driver);
         
      } catch (ClassNotFoundException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      }
   }
   //获取Connection
   public static Connection getConnection() {
      Connection connection=null;
      try {
         connection=DriverManager.getConnection(url,username,password);
      } catch (SQLException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      }
      return connection;
   }
   //关闭Statement
   public static void closeStatement(Statement statement) {
      if(statement!=null) {
         try {
            statement.close();
         } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
         }
      }
   }
   //关闭Connection
   public static void closeConnection(Connection connection) {
      if(connection!=null) {
         try {
            connection.close();
         } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
         }
      }
   }
   //关闭资源
   public static void closeResource(Statement statement,Connection connection) {
      JdbcUtil.closeStatement(statement);
      JdbcUtil.closeConnection(connection);
   }

}