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只能连续插入两条数据,插入多条要批量么?
不会,感觉不会那么奇怪的。帮你顶一下。
看看是
在C++程序中通过mysql的C API直接连接数据库,当把中文插入mysql的时候,就变成乱码了.
还有就是使用load把文本文件导入mysql数据库,无论文本文件是ANSI编码还是utf8编码,导入之后都是乱码。
其中mysq的编码格式 ......
如何把MySQL置于只读(不使用read_only变量:http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_read_only)?
现在有一个迁移程序。我打算过了迁移日之后,就程序依然可用,但是保持只 ......
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 ......