jdbc事务处理代码

< %@page contentType="text/html;charset=gb2312"%>
< %@page import="java.sql.*"%>
<%!
String dbcon="sun.jdbc.odbc.JdbcOdbcDriver";
String dburl="jdbc:odbc:db";
Connection con=null;
Statement stmt=null;
%>
<%
   try
   {
   Class.forName(dbcon);
   }
   catch(Exception e)
   {
   out.println("数据库驱动出错!!!");
   }
   try
   {
   con=DriverManager.getConnection(dburl);
   }
   catch(Exception e)
   {
   out.println("数据库连接出错!!!");
   }
   try
   {
   stmt=con.createStatement();
   con.setAutoCommit(false);
   stmt.addBatch("INSERT INTO person (name,password,age) VALUES ('eric_1','zzzzzz',22)");
   stmt.addBatch("INSERT INTO person (name,password,age) VALUES ('eric_2','zzzzzz',22)");
   stmt.addBatch("INSERT INTO person (name,password,age) VALUES ('eric_3','zzzzzz',22)");
   stmt.addBatch("INSERT INTO person (name,password,age) VALUES ('eric_4','zzzzzz',22)");
   stmt.addBatch("INSERT INTO person (name,password,age) VALUES ('eric_5','zzzzzz',22)");
   stmt.addBatch("INSERT INTO person (name,password,age) VALUES ('eric_6','zzzzzz',22)");
   stmt.addBatch("INSERT INTO person (name,password,age) VALUES ('eric_7','zzzzzz',22)");
   stmt.addBatch("INSERT INTO person (name,password,age) VALUES ('eric_8','zzzzzz',22)");
   stmt.addBatch("INSERT INTO person (name,password,age) VALUES ('eric_9','zzzzzz',22)");
   }
   catch(Exception e)
   {
   out.println("数据库操作出错!!!");
   }
   try
   {
   stmt.executeBatch();
   con.commit();
   }
   catch(Exception e)
   {
   con.rollback();
   out.println("插入出错！！！");
   }
   try
   {
    stmt.close();
 con.close();
   }
   catch(Exception e)
   {
   out.println("数据库关闭错误");
   }
%>