jdbc使用DataSource连接mysql,postgresql,oracle的代码

jdbc连接数据库，使用DataSource是推荐的方式

(jdbc驱动是当然要放进classpath里的,官网一般都有下载)

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

import org.postgresql.ds.PGSimpleDataSource;

import oracle.jdbc.pool.OracleDataSource;

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;

public class DBConnection {

	/**
	 * @param args
	 * @throws SQLException
	 */
	public static void main(String[] args) throws SQLException {
		// TODO Auto-generated method stub
		MysqlDataSource mysqlDataSource = new MysqlDataSource();
		// mysqlDataSource.setPassword("dev");
		// mysqlDataSource.setUser("dev");
		mysqlDataSource
				.setURL("jdbc:mysql://localhost/forJava?user=dev&password=dev");
		Connection conn = mysqlDataSource.getConnection();
		Statement stmt = conn.createStatement();
		stmt.executeUpdate(