JDBC(Java Database Connectivity) Back
###Operation
| Step | Description | Code |
|---|---|---|
| 1 | 確定Url | String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Database" |
| 2 | 加載驅動 | Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); |
| 3 | 獲取鏈接 | Connection con = DriverManager.getConnection(url, username, password); |
| 4 | 創建語句 | Statement stat = con.createStatement(); |
| 5 | 執行sql | void stat.execute(String sql); |
int stat.executeUpdate(String sql); |
||
ResultSet stat.executeQuery(String sql); |
||
| 6 | 獲取結果 | while(rs.next()){String result = rs.getString("Column_name")} |
| 7 | 釋放資源 |
###Statement
-
####PreparedStatement 使用傳參的方式執行SQL
PreparedStatement p_stat = con.preparedStatement("update table set m = ? where x = ?;"); p_stat.setLong(1, 123456789); p_stat.setLong(2, 100000); p_stat.executeUpdate();
- ####CallableStatement
用於執行SQL存儲過程
###Transaction
```Java
boolean reserve = con.getAutoCommit();
con.setAutoCommit(false);
/* Transaction */
//do something
con.commit();
con.rollback(); //roll back to the checkpoint
con.setAutoCommit(reserve);