TreeviewCopyright © aleen42 all right reserved, powered by aleen42

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

boolean reserve = con.getAutoCommit();
con.setAutoCommit(false);

/* Transaction */
//do something
con.commit();
con.rollback();    //roll back to the checkpoint

con.setAutoCommit(reserve);
Empty Comments
Sign in GitHub

As the plugin is integrated with a code management system like GitLab or GitHub, you may have to auth with your account before leaving comments around this article.

Notice: This plugin has used Cookie to store your token with an expiration.