Statement st = conn.createStatement();
sql = "INSERT INTO ClassRoom VALUES('" +
RoomSequence + "','" +
CampusRegion + "','" +
RoomBuilding + "','" +
RoomId + "','" +
Capacity + "','" +
MultiFlag + "','');";
//执行sql语句
st.executeUpdate(sql);
//同时插入插入当天教室使用情况表(ClassRoomUsage)
for (int j = 1; j <= 5; j++ )
{
sql = "INSERT INTO ClassRoomUsage VALUES(null,'"
+ RoomSequence + "','1','1','" + j + "','0',null,'0',b'0');";
//执行sql语句
st.executeUpdate(sql);
}
为啥第一条sql语句可以执行,第二条却不能执行呢??我用的java,jdbc连接mysql,第二条语句我用System.out.println(sql);输出一下,然后再拷贝到数据库直接执行却可以执行,不知道为啥,另外我把后面的5次循环sql语句换成st.addBatch(sql);循环添加5次,然后在循环体下面执行st.executeBatch();也是不能执行,唯独for循环之前的那条sql语句可以执行,求高手帮小弟看下
ps:不是数据库外键约束的原因,我前面已经把外键约束SET FOREIGN_KEY_CHECKS = 0;暂时关了,
sql = "INSERT INTO ClassRoom VALUES('" +
RoomSequence + "','" +
CampusRegion + "','" +
RoomBuilding + "','" +
RoomId + "','" +
Capacity + "','" +
MultiFlag + "','');";
//执行sql语句
st.executeUpdate(sql);
//同时插入插入当天教室使用情况表(ClassRoomUsage)
for (int j = 1; j <= 5; j++ )
{
sql = "INSERT INTO ClassRoomUsage VALUES(null,'"
+ RoomSequence + "','1','1','" + j + "','0',null,'0',b'0');";
//执行sql语句
st.executeUpdate(sql);
}
为啥第一条sql语句可以执行,第二条却不能执行呢??我用的java,jdbc连接mysql,第二条语句我用System.out.println(sql);输出一下,然后再拷贝到数据库直接执行却可以执行,不知道为啥,另外我把后面的5次循环sql语句换成st.addBatch(sql);循环添加5次,然后在循环体下面执行st.executeBatch();也是不能执行,唯独for循环之前的那条sql语句可以执行,求高手帮小弟看下
ps:不是数据库外键约束的原因,我前面已经把外键约束SET FOREIGN_KEY_CHECKS = 0;暂时关了,
+ RoomSequence + "','1','1','" + j + "','0',null,'0',b'0');";//这里 b'0' 是什么,感觉不正常啊?
for (int j = 1; j <= 5; j++ )
{
Statement st = conn.createStatement();
sql = "INSERT INTO ClassRoomUsage VALUES(null,'"
+ RoomSequence + "','1','1','" + j + "','0',null,'0',b'0');";
//执行sql语句
st.executeUpdate(sql);
}