［ＩＴ资料文档］第九章 JDBC2003.pptVIP

* try { …… Connection con = DriverManager.getConnection( url, user, password ); con.setAutoCommit(false); stmt = con.createStatment(); //数据库更新操作1 stmt.executeUpdate(“update ACCOUNT set BALANCE=900 where ID=1”); //数据库更新操作2 stmt.executeUpdate(“update ACCOUNT set BALANCE=1100 where ID=2”); mit(); }catch(Exception e){ * try{ con.rollback(); }catch(Exception ex){ //处理异常 } }//处理异常 }finally{ try{ stmt.close(); con.close(); }catch(Exception ex){ //处理异常 …… } } * 7、调用存储过程(stored procedure) Java.sql.CallableStatement接口用于执行数据库中的stored procedure。Connection的prepareCall()方法创建一个CallableStatement对象。 例如sqlserver2000中pubs 数据库中的 jobs表的store procedure。 不带任何参数，无返回值，例如： create?procedure??showAll as? select?*?from?jobs * //获得连接 public??Connection?getConnection(){ ??Connection?con?=?null; ??try?{ ???Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); ???con?=?DriverManager.getConnection(jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs,sa,); ??}?catch?(Exception?e)?{ ???e.printStackTrace(); ??} ??return?con?; ?}  * //调用得到结果集的存储过程： public?void?getResultSet(){ ????????//获得连接 ????????Connection?con?=?this.getConnection(); ????????try?{ ????????????//showAll为存储过程名 ????????????java.sql.CallableStatement?cstm?=?con.prepareCall({call?showAll?}); ????????????ResultSet?rs?=?cstm.executeQuery(); ????????????while(rs.next()){ ????????????????//这里写逻辑代码。 ????????????????System.out.println(rs.getString(1)); ????????????} ????????????rs.close(); ????????????con.close(); ????????}?catch?(SQLException?e)?{ ????????????//?TODO?Auto-generated?catch?block ????????????e.printStackTrace(); ????????} * 带有输入输出参数的存储过程create?procedure?obtainJob_desc @outputParam?varchar(20)?output, @id??????????int as select?@outputParam?=?job_desc?from?jobs?where?job_id?=?@id? * //调用带有 输入 ,输出 参数的存储过程 public?void?getOutParameter(int?inParam){ ????????String?outParam; ????????Connection?con?=?this.getConnection(); ????????