批处理语句:

批处理语句:

<%@page contentType="text/html;charset=gb2312"%> <%@page import="java.sql.*"%> <%        //定义数据库驱动程序        String dbdriver="sun.jdbc.odbc.JdbcOdbcDriver";        //定义数据库连接地址        String url="jdbc:odbc:mldn";        //定义数据库连接对象,用于操作数据库        Connection con=null;        //定义Statement对象,用于操作数据库        Statement stmt =null;        String sql=null;        ResultSet rs=null;        try        {               Class.forName(dbdriver);                      con =DriverManager.getConnection(url);                                           stmt=con.createStatement();                      con.setAutoCommit(false);//不上它进行提交                      //sql="select id,name,password,age from person";                      stmt.addBatch("insert into person (name,password,age) values('a','az',23)");                      stmt.addBatch("insert into person (name,password,age) values('b','bz',21)");                      stmt.addBatch("insert into person (name,password,age) values('e','ez',23)");                      stmt.addBatch("insert into person (name,password,age) values('d','dz',21)");;                      //执行批处理                      stmt.executeBatch();                      //提交事务,真正向数据库插入数据                      con.commit();          }        catch(Exception ex)        {               //发生了异常,将数据进行回滚               try               {                      con.rollback();               }               catch(Exception ee)               {                      out.println("数据操回滚失败");               }                      }               try        {                             stmt.close();               con.close();        }        catch(Exception e)        {               out.println("关闭失败");        } %>