JDBC.md

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);