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(