package yxy.timer.tool;

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

import javax.sql.DataSource;

public class DBUtil 
{
    private  static  DataSource dataSource;

    //获得连接
    public static Connection getConnection(String datesource) throws SQLException
    {
    	dataSource =  (DataSource) SpringFactory.getObject(datesource);
    	return dataSource.getConnection();
    }
    
    
    //关闭数据库连接
    public static void close(ResultSet rs,Statement st,Connection conn){
    	
        if(rs!=null){ try {  
            rs.close();  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }finally{  
            if(st!=null){  
                try {  
                    st.close();  
                } catch (SQLException e) {  
                    e.printStackTrace();  
                }finally{  
                    if(conn!=null){  
                        try {  
                            conn.close();  
                        } catch (SQLException e) {  
                            e.printStackTrace();  
                        }  
                    }  
                }  
            }  
        }  
        }
    }   
}