String hw_ids=request.getParameter("hw_id");
String counts=request.getParameter("count");
String hw_cashs=request.getParameter("hw_cash");
hw_name=request.getParameter("hw_name");
sql="select * from book where hw_id='"+hw_ids+"' and user_name='"+user_name+"' and book_check=false";
rs=mdb.executeQuery(sql);
if(!rs.next())
{
sql="insert into book(hw_id,user_name,book_count,hw_name,hw_cash)";
sql=sql+"values('"+hw_ids+"','"+user_name+"','"+counts+"','"+hw_name+"','"+hw_cashs+"')";
mdb.executeInsert(sql);
}
为什么不能向MYSQL数据库插入数据呢
String counts=request.getParameter("count");
String hw_cashs=request.getParameter("hw_cash");
hw_name=request.getParameter("hw_name");
sql="select * from book where hw_id='"+hw_ids+"' and user_name='"+user_name+"' and book_check=false";
rs=mdb.executeQuery(sql);
if(!rs.next())
{
sql="insert into book(hw_id,user_name,book_count,hw_name,hw_cash)";
sql=sql+"values('"+hw_ids+"','"+user_name+"','"+counts+"','"+hw_name+"','"+hw_cashs+"')";
mdb.executeInsert(sql);
}
为什么不能向MYSQL数据库插入数据呢
另外报错了没?
是否用到了事物没有提交?
1.rs.next()为true,即存在记录,if未执行。
2.insert的sql不对
3.字段类型不对。
具体抛什么异常么?
其次的话在insert后 加上commit看看