程序代码：

public static void main(String[] args) throws SQLException {
        Connection con = null;
  
        TimeSpan ts = new TimeSpan();
        ts.SetStartTime();
        try
        {
      
            Class.forName("org.sqlite.JDBC");
            con = DriverManager.getConnection("jdbc:sqlite:"+filename);
            con.setAutoCommit(false);
            //Statement stm = con.createStatement();
      
      
      
            PreparedStatement prep = con.prepareStatement("insert into book (Name,author,Price) values(?,?,?);");
      
            for(int i=1;i<10001;i++)
            {
                prep.setString(1, "BookName"+i);
                prep.setString(2, "Writer"+i);
                prep.setInt(3, i);
                prep.addBatch();
            }
            //prep.executeUpdate();
            //con.setAutoCommit(false);
            prep.executeBatch();
            ();
            con.setAutoCommit(true);
            /*
            prep.setString(1, "水浒传");
            prep.setString(2, "施耐庵");
            prep.setInt(3, 89);
  
      
            */
            ts.SetEndTime();
      
            ts.GetSpanTime();
        /*    con.setAutoCommit(true);
            Statement stm = con.createStatement();
            ResultSet rs = stm.executeQuery("select * from book");
            while(rs.next())
            {
                System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4));
            }
      
      
        */
      
        }
        catch(Exception e)
        {
            try
            {
                con.rollback();
            }
            catch (SQLException ex)
            {
          
                ex.printStackTrace();
            }
            System.out.println(e.getMessage());
            System.out.println(e.toString());
        }
        finally
        {
            try
            {
                con.close();
            }
            catch (SQLException e)
            {
          
                e.printStackTrace();
            }
        }
    }