易截截图软件、单文件、免安装、纯绿色、仅160KB

MySQL连续插入

public String initOrder(User user) {
int sId = user.getId();
for (int i = 1; i <= 4; i++) {
System.out.println(i);
if (user.getId() % 5 == 0) {
orderDao.create(new Order(new OrderId(sId, i), 9999, 16));
} else {
orderDao.create(new Order(new OrderId(sId, i), sId / 5 * 5, 4));
}
}
return SUCCESS;
}
中插入应该执行4次,但是在打印了3后就wait了,如下
1
Hibernate: select order0_.s_id as s1_1_, order0_.q as q1_, order0_.r_id as r3_1_, order0_.no as no1_ from beer_game.order order0_ where order0_.s_id=?
Hibernate: select order0_.s_id as s1_1_, order0_.q as q1_, order0_.r_id as r3_1_, order0_.no as no1_ from beer_game.order order0_ where order0_.q=?
Hibernate: insert into beer_game.order (r_id, no, s_id, q) values (?, ?, ?, ?)
2
Hibernate: select order0_.s_id as s1_1_, order0_.q as q1_, order0_.r_id as r3_1_, order0_.no as no1_ from beer_game.order order0_ where order0_.s_id=?
Hibernate: select order0_.s_id as s1_1_, order0_.q as q1_, order0_.r_id as r3_1_, order0_.no as no1_ from beer_game.order order0_ where order0_.q=?
Hibernate: insert into beer_game.order (r_id, no, s_id, q) values (?, ?, ?, ?)
3
后面就没了,
页面上也是等待。但是把for循环改成2次(for(int i=1;i <=2;i++))却可以。
难道MySQL只能连续插入两条数据,插入多条要批量么?

不会,感觉不会那么奇怪的。帮你顶一下。

看看是


相关问答:

mysql数据库 - Java / Java相关

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......

mysql中文乱码 - 其他数据库开发 / MySQL/Postgresql

在C++程序中通过mysql的C API直接连接数据库,当把中文插入mysql的时候,就变成乱码了.
还有就是使用load把文本文件导入mysql数据库,无论文本文件是ANSI编码还是utf8编码,导入之后都是乱码。
其中mysq的编码格式 ......

如何使用MySQL - MS-SQL Server / 基础类

刚刚接触MySQL,不知道该如何去查看数据,插入数据,创建数据库、表,用哪为前辈能指教一二?

MySQL 5.1参考手册

引用
兄弟你会结贴吗?
mysql 参考手册

baidu

MySQL官方文档 http://dev.mysql.com/doc ......

如何把MySQL置于只读(不使用read_only变量)?

如何把MySQL置于只读(不使用read_only变量:http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_read_only)?
现在有一个迁移程序。我打算过了迁移日之后,就程序依然可用,但是保持只 ......

mysql连接被频繁中断

100215 9:55:47 [Warning] Aborted connection 247 to db: 'gases' user: 'root' host: 'localhost' (Got an error reading communication packets)
100215 9:55:47 [Warning] Aborted connection 257 to db: 'ga ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号