Java连接基础数据库

DRIVER;
//Mysql   com.mysql.jdbc.Driver
//oracle  oracle.jdbc.driver.OracleDriver
URL;
//Mysql   jdbc:mysql://127.0.0.1:3306/dbName
//oracle  jdbc:oracle:thin:@127.0.0.1:1521:dbName
USERNAME;
PASSWORD;

基本连接操作

Class.forName(Driver);
Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
SQL;
PreparedStatement stmt = conn.prepareStatement(SQL);
//执行查询
ResultSet rs = stmt.executeQuery();
while(rs.next()) {
	rs.getString();
}
//执行修改
stmt.executeUpdate();

使用DbUtils操作数据库

<dependency>
   <groupId>commons-dbutils</groupId>
    <artifactId>commons-dbutils</artifactId>
    <version>1.6</version>
</dependency>
················································
QueryRunner QUERY_RUNNER = new QueryRunner();
//执行查询，通过DbUtils提供的多种Handler，实现返回不同的查询结果
QUERY_RUNNER.query(conn, SQL, new MapListHandler(), params);
//执行修改
QUERY_RUNNER.update(conn, SQL, params);

使用数据库连接池DBCP

<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-dbcp2</artifactId>
    <version>2.0.1</version>
</dependency>
················································
DATA_SOURCE = new BasicDataSource();
DATA_SOURCE.setDriverClassName(DRIVER);
DATA_SOURCE.setUrl(URL);
DATA_SOURCE.setUsername(USERNAME);
DATA_SOURCE.setPassword(PASSWORD);