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

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

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

1 importjava.sql.Connection;2 importjava.sql.ResultSet;3 importjava.sql.ResultSetMetaData;4 importjava.sql.SQLException;5 importjava.sql.Statement;6

7 importorg.postgresql.ds.PGSimpleDataSource;8

9 importoracle.jdbc.pool.OracleDataSource;10

11 importcom.mysql.jdbc.jdbc2.optional.MysqlDataSource;12

13 public classDBConnection {14

15 /**

16 *@paramargs17 *@throwsSQLException18 */

19 public static void main(String[] args) throwsSQLException {20 //TODO Auto-generated method stub

21 MysqlDataSource mysqlDataSource = newMysqlDataSource();22 //mysqlDataSource.setPassword("dev");23 //mysqlDataSource.setUser("dev");

24 mysqlDataSource25 .setURL("jdbc:mysql://localhost/forJava?user=dev&password=dev");26 Connection conn =mysqlDataSource.getConnection();27 Statement stmt =conn.createStatement();28 stmt.executeUpdate("create table if not exists web\n" + "(\n"

29 + " id int not null primary key,\n" + " name varchar(100),\n"

30 + " created timestamp,\n" + " content blob\n" + ");\n" + "");31 for (int i = 0; i < 1; i++) {32 stmt.executeUpdate("insert into web (name,c