数据库插入操作成功，更新操作失败,该如何解决

2012-02-07

数据库插入操作成功，更新操作失败Java code!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//

数据库插入操作成功，更新操作失败

Java code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" <% request.setCharacterEncoding("gb2312"); %><%@ page contentType = "text/html; charset=gb2312" %><%@ page language="java" import="java.sql.*"%><%@ page language="java" import="java.text.*"%><%@ page language="java" import="java.util.*"%><jsp:useBean id="ConnDBSQLite" scope="page" class="bean.DBsqlite"/><jsp:useBean id="select" scope="page" class="bean.select"/><jsp:useBean id="delect" scope="page" class="bean.delect"/><jsp:useBean id="SI" scope="session" class="bean.StockIn"/><html>  <head><meta http-equiv="Content-type" content="text/html; charset=gb2312" />  <title>入库操作</title>  </head><body topmargin="80"> <%String name ="";if(!session.isNew()){//    response.setContentType( "text/html; charset=gb2312");    name=(String)session.getAttribute("username");    if(name==null)        name="";}    String aa=request.getParameter("StockInNumber");    int Si_Number = Integer.parseInt(aa);    String date=new SimpleDateFormat("yyyy.MM.dd").format(Calendar.getInstance().getTime());    String SIName=SI.getSIName();        String SIPrice=SI.getSIPrice();    int Si_Price = Integer.parseInt(SIPrice);    int Si_Money = Si_Number*Si_Price;    String SIMoney = Integer.toString(Si_Money);    String SISupName=SI.getSISupName();    String SIstorehouse=SI.getSIstorehouse();String sql="insert into StockIn(SiId,SiName,SiNumber,SiPrice,SiSupName,Sistorehouse,SiUser,SiTime,SiMoney)    VALUES(NULL,'"+SIName+"','"+Si_Number+"','"+SIPrice+"','"+SISupName+"','"+SIstorehouse+"','"+name+"','"+date+"','"+SIMoney+"') ";    ConnDBSQLite.executeUpdate(sql);%>        <div align=center>        <font size=5 color=red>        商品入库表        </font>         </div>        <br><br><br>    <table align=center  border width=1000>            <tr>                <th>商品名</th>                <th>进货数量</th>                                <th>进货价格</th>                <th>供应商</th>                <th>仓库</th>                <th>操作员</th>                <th>时间</th>                <th>进货金额</th>            <tr>    <td align=center>    <%=SIName%>    </td>    <td align=center>    <%=Si_Number%>    </td>    <td align=center>￥ <%=SIPrice%>    </td>    <td align=center><%=SISupName%>    </td>    <td align=center><%=SIstorehouse%>    </td>    <td align=center><%=name%>    </td>    <td align=center><%= date%>    </td>    <td align=center>￥ <%= SIMoney%>    </td>    </table><%                String siname=new String(SIName.getBytes("ISO-8859-1"),"gb2312");                String upstno = "UPDATE stock SET StockNumber=5 where StockName=' "+siname+" ' ";                delect.executeUpdate(upstno);    %><script LANGUAGE='javascript'>alert("商品"+'<%=SIName%>'+"入库成功");</script>    </table></body></html>

上面插入数据到表StockIn成功
结果更新库存表时stock出现问题，不报错，但是没有更新。
显然是
<%
String siname=new String(SIName.getBytes("ISO-8859-1"),"gb2312");

String upstno = "UPDATE stock SET StockNumber=5 where StockName=' "+siname+" ' ";

delect.executeUpdate(upstno);

%>
这个代码没有执行，上面SET StockNumber=5是拿来测试的

[解决办法]
ConnDBSQLite.executeUpdate(sql);

ConnDBSQLite可以

delect.executeUpdate(upstno);
delect不可以，问题出现在delect.为什么不用一个连接

热点排行

Apache

数据库插入操作成功，更新操作失败,该如何解决