mysql，sqlserver数据源连接

import java.io.InputStream; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; import javax.sql.DataSource; import org.apache.commons.dbcp.BasicDataSourceFactory; public class DBTools { private static DataSource dataSource = null; static{ InputStream input = null; Properties properties = new Properties(); try { input = DBTools.class.getResourceAsStream("DB.properties"); properties.load(input); if(dataSource == null){ dataSource = BasicDataSourceFactory.createDataSource(properties); } } catch (Exception e) { e.printStackTrace(); } } public static Connection getConnection() throws SQLException{ return dataSource.getConnection(); } public static void close(ResultSet rs, Statement stmt, Connection con){ try { if (rs != null) { rs.close(); } if (stmt != null) { stmt.close(); } if (con != null) { con.close(); } } catch (Exception e) { e.printStackTrace(); } } }