鍦↗ava涓紝鎵嬪姩鎻愪氦浜嬪姟鍙互閫氳繃浠ヤ笅姝ラ瀹炵幇锛?br/>1. 鑾峰彇鏁版嵁搴撹繛鎺ュ璞★細浣跨敤JDBC鎴栬繛鎺ユ睜鑾峰彇鏁版嵁搴撹繛鎺ュ璞★紝濡俙Connection connection = DriverManager.getConnection(url, username, password);`
2. 璁剧疆鑷姩鎻愪氦涓篺alse锛氶粯璁ゆ儏鍐典笅锛孞DBC杩炴帴鏄嚜鍔ㄦ彁浜や簨鍔＄殑锛岄渶灏嗗叾璁剧疆涓烘墜鍔ㄦ彁浜わ紝濡俙connection.setAutoCommit(false);`
3. 鎵цSQL璇彞锛氫娇鐢╜Statement`鎴朻PreparedStatement`瀵硅薄鎵ц鏁版嵁搴撴搷浣滐紝濡俙statement.executeUpdate(sql);`
4. 鎻愪氦浜嬪姟锛氶€氳繃`commit`鏂规硶鎵嬪姩鎻愪氦浜嬪姟锛屽`connection.commit();`
5. 鎹曡幏寮傚父骞跺洖婊氫簨鍔★細濡傛灉鍙戠敓寮傚父锛屽彲浠ラ€氳繃`catch`鍧楁崟鑾峰紓甯革紝鐒跺悗璋冪敤`rollback`鏂规硶鍥炴粴浜嬪姟锛屽`connection.rollback();`
6. 鍏抽棴杩炴帴锛氬湪浜嬪姟鎻愪氦鎴栧洖婊氬悗锛屽叧闂暟鎹簱杩炴帴锛屽`connection.close();`
涓嬮潰鏄竴涓畬鏁寸殑绀轰緥锛?br/>

try {
聽聽聽聽//聽鑾峰彇鏁版嵁搴撹繛鎺ュ璞?/p>
聽聽聽聽Connection聽connection聽=聽DriverManager.getConnection(url,聽username,聽password);
聽聽聽聽//聽璁剧疆鑷姩鎻愪氦涓篺alse
聽聽聽聽connection.setAutoCommit(false);
聽聽聽聽
聽聽聽聽//聽鎵цSQL璇彞
聽聽聽聽Statement聽statement聽=聽connection.createStatement();
聽聽聽聽statement.executeUpdate(sql);
聽聽聽聽
聽聽聽聽//聽鎻愪氦浜嬪姟
聽聽聽聽connection.commit();
聽聽聽聽
聽聽聽聽//聽鍏抽棴杩炴帴
聽聽聽聽connection.close();
}聽catch聽(SQLException聽e)聽{
聽聽聽聽//聽鍙戠敓寮傚父鏃跺洖婊氫簨鍔?/p>
聽聽聽聽connection.rollback();
聽聽聽聽e.printStackTrace();
聽聽聽聽//聽鍏抽棴杩炴帴
聽聽聽聽connection.close();
}

娉ㄦ剰锛氬湪鎵嬪姩鎻愪氦浜嬪姟鏃讹紝闇€瑕佺‘淇濆湪鍙戠敓寮傚父鏃惰兘澶熸纭湴鍥炴粴浜嬪姟锛屽苟鍦ㄦ棤璁烘槸鍚﹀彂鐢熷紓甯搁兘鑳芥纭湴鍏抽棴鏁版嵁搴撹繛鎺ャ€?br/>