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只能连续插入两条数据，插入多条要批量么？
不会，感觉不会那么奇怪的。帮你顶一下。
看看是
相关问答：
请问下能不能再windows下定期清空mysql一个表中的全部数据，用PHP实现！
谢谢各位了
就比如一个星期清空一次
比如每个星期六零点清空一次！
谢谢了
计划任务...php....sql...truncate....OK
你就这接在页� ......
我是新手，初学MYSQL，有很多不懂，望赐教！！
比如说我新建一个MYSQL数据库USER 数据库中有表LIST
然后我在VC中新建一个MFC对话框工程，然后我怎么样才能用VC获得数据库中表的数据？
希望给出具体的操作� ......
String SQL="insert into 学生信息表 values(StudentNumber,StudentName,StudentAge)";其中StudentNumber,StudentName,StudentAge都是变量。这样写不对……到底该咋写啊
万分感谢！
String SQL=&q ......
表
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
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 ......
