package com.yanek.test;

import java.sql.*;

import javax.naming.*;
import javax.sql.*;

/**
 * 数据库工具类
 * 1，查找DataSource获取数据库连接
 * 2，释放连接资源
 */
public class DBHandle {
    /**
     * 获取数据库连接
     * 1，初始化上下文环境Context
     * 2，在Context中查找DataSource，名字预先给定，这里为：“java:comp/env/jdbc/bbs”
     * 3，如果DataSource不为空，就从DataSource中取出一个连接
     */
    public synchronized static Connection getConn() throws Exception {
        Connection conn = null;

        return conn;
    }
    /**
     * 释放连接相关资源，请注意相关次序
     * 1，先释放结果集
     * 2，再释放语句句柄
     * 3，最后释放连接
     */
    public static void closeResource(Statement st, ResultSet rs, Connection cnn) {
        try {
            if (rs != null) {
                rs.close();
            }
        }
        catch (Exception es) {
            es.printStackTrace();
        }
        try {
            if (st != null) {
                st.close();
            }
        }
        catch (Exception es) {
            es.printStackTrace();
        }
        try {
            if (cnn != null) {
                cnn.close();
                cnn = null;
            }
        }
        catch (Exception es) {
            es.printStackTrace();
        }
    }

    /**
     * 使用DriverManager获取数据库连接
     */
    public static Connection getConnection() throws Exception {
        String driver = "com.mysql.jdbc.Driver";
        String urlString = "jdbc:mysql://localhost/test";
        String user = "root";
        String pwd = "root";
        Class.forName(driver);
        Connection cnn = DriverManager.getConnection(urlString, user, pwd);
        return cnn;
    }

   
   
 public static void main(String[] args) {

 

   try {
    System.out.println("conn:" + DBHandle.getConnection());
   } catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }

 }
}

 

 

 

package com.yanek.test;

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

/**
 * 数据库工具类 1，查找DataSource获取数据库连接 2，释放连接资源
 */
public class DBSource {

 public static Connection getConnection(final String poolName)
   throws SQLException {
  try {
   return DriverManager.getConnection(poolName);
  } catch (Exception e) {

   return null;
  }
 }

 /**
  * 释放连接相关资源，请注意相关次序 1，先释放结果集 2，再释放语句句柄 3，最后释放连接
  */
 public static void closeResource(Statement st, ResultSet rs, Connection cnn) {
  try {
   if (rs != null) {
    rs.close();
   }
  } catch (Exception es) {
   es.printStackTrace();
  }
  try {
   if (st != null) {
    st.close();
   }
  } catch (Exception es) {
   es.printStackTrace();
  }
  try {
   if (cnn != null) {
    cnn.close();
    cnn = null;
   }
  } catch (Exception es) {
   es.printStackTrace();
  }
 }

 /**
  * 使用DriverManager获取数据库连接
  */
 public static Connection getConnection() throws Exception {
  String driver = "com.mysql.jdbc.Driver";
  String urlString = "jdbc:mysql://localhost/test";
  String user = "root";
  String pwd = "root";
  Class.forName(driver);
  Connection cnn = DriverManager.getConnection(urlString, user, pwd);
  return cnn;
 }

 public static void main(String[] args) {

  try {
   System.out.println("conn:" + DBSource.getConnection());
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

 }
}