kingmxj 发表于 2013-2-7 18:54:15

批量添加数据库

http://www.51.la/report/1_main.asp?id=1统计流量的网页
http://blog.sina.com.cn/s/blog_59befbb60100ab01.html   spring定时网页

select count(*) from APPLY_OPEN a where to_char(a.add_date,'yyyy-MM-dd') = (select to_char
(sysdate,'yyyy-MM-dd') from dual)

select count(*) from APPLY_OPEN a where to_char(a.add_date,'yyyy-MM') = (select to_char
(sysdate,'yyyy-MM') from dual)

select count(*) from APPLY_OPEN a where to_char(a.add_date,'yyyy') = (select to_char
(sysdate,'yyyy') from dual)



Session session = sessionFactory.openSession();
   Transaction tx = session.beginTransaction();   
   for ( int i=0; i<100000; i++ ) {
    Customer customer = new Customer(.....);
    session.save(customer);
    if ( i % 20 == 0 ) {
      //20,与JDBC批量设置相同
       //将本批插入的对象立即写入数据库并释放内存
      session.flush();
       session.clear();
    }
}
   
tx.commit();
session.close();
页: [1]
查看完整版本: 批量添加数据库