//加載數(shù)據(jù)庫(kù)驅(qū)動(dòng)
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//連接數(shù)據(jù)庫(kù)
String url = "jdbc:sqlserver://localhost:1433;databasename=example";
String username = "username";
String password = "password";
Connection conn = DriverManager.getConnection(url, username, password);
//創(chuàng)建Statement對(duì)象
Statement statement = conn.createStatement();
//查詢(xún)并處理結(jié)果集
String query = "SELECT * FROM table";
ResultSet rs = statement.executeQuery(query);
while (rs.next()) {
  //處理查詢(xún)結(jié)果
}
//釋放資源
rs.close();
statement.close();
conn.close();

<c3p0-config>
  <default-config>
    <property name="driverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
    <property name="jdbcUrl">jdbc:sqlserver://localhost:1433;databasename=example</property>
    <property name="user">username</property>
    <property name="password">password</property>
    <property name="acquireIncrement">5</property>
    <property name="initialPoolSize">10</property>
    <property name="minPoolSize">5</property>
    <property name="maxPoolSize">20</property>
    <property name="maxStatements">100</property>
    <property name="numHelperThreads">5</property>
  </default-config>
</c3p0-config>

Connection conn = DriverManager.getConnection(url, username, password);
conn.setAutoCommit(false); //關(guān)閉自動(dòng)提交
Statement statement = conn.createStatement();
try {
  statement.executeUpdate("INSERT INTO table (column1, column2) VALUES (value1, value2)");
  statement.executeUpdate("INSERT INTO table (column1, column2) VALUES (value3, value4)");
  conn.commit(); //提交事務(wù)
} catch (SQLException e) {
  conn.rollback(); //回滾事務(wù)
} finally {
  statement.close();
  conn.close();
}

//關(guān)閉自動(dòng)提交
conn.setAutoCommit(false);
//創(chuàng)建Statement對(duì)象
Statement statement = conn.createStatement();
//添加批處理語(yǔ)句
statement.addBatch("INSERT INTO table (column1, column2) VALUES (value1, value2)");
statement.addBatch("INSERT INTO table (column1, column2) VALUES (value3, value4)");
//執(zhí)行批處理并提交
statement.executeBatch();
conn.commit();

String query = "SELECT * FROM table WHERE column1=?";
PreparedStatement ps = conn.prepareStatement(query);
ps.setString(1, "value");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
  //處理查詢(xún)結(jié)果
}
rs.close();
ps.close();

CREATE INDEX index_name ON table (column1, column2);