<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*,java.io.*"%>
<%@ page import="com.mingri.dbconn.DBResult"%>
<jsp:useBean id="rst" scope="page" class="com.mingri.dbconn.DBResult"/>
<jsp:useBean id="calendar" scope="page" class="com.mingri.showtime.CalendarBean"/>
<%
request.setCharacterEncoding("gb2312");//解决表单提交中的中文乱码问题
//获取表单数据
String jc=(String)session.getAttribute("jc"); String spname=(String)session.getAttribute("spname");
String gg=(String)session.getAttribute("gg"); String xsid=(String)session.getAttribute("xsph");
String bz=(String)session.getAttribute("bz");
String cd=(String)session.getAttribute("cd"); String spid=(String)session.getAttribute("spid");
String dw=(String)session.getAttribute("dw");
String sl=(String)request.getParameter("sl"); String czy=(String)request.getParameter("czy");
String je=(String)request.getParameter("je"); String jsr=(String)request.getParameter("jsr");
String dj=(String)request.getParameter("dj"); String xsdate=(String)request.getParameter("xsdate");
String ys=(String)request.getParameter("ys"); String jsfs=(String)request.getParameter("jsfs");
String ss=(String)request.getParameter("ss"); String ws=(String)request.getParameter("ws");
String xskhname=(String)request.getParameter("xskhname");
String whether="";
if(ws.equals("0")){
whether="是";
}else{
whether="否";
}
%>
<% //保存销售信息
String xsSql="insert into tb_sell values('"+xsid+"','"+spid+"','"+spname+"',"+
"'"+jc+"','"+cd+"','"+gg+"','"+bz+"','"+dw+"',"+dj+",'"+sl+"',"+je+","+
"'"+xskhname+"','"+xsdate+"','"+czy+"','"+jsr+"','"+jsfs+"')";
//保存销售票号信息
String xsphSql="insert into tb_sellph values('"+xsid+"','"+sl+"',"+ys+","+ss+","+
""+ws+",'"+xskhname+"','"+xsdate+"','"+czy+"','"+jsr+"','"+jsfs+"','"+whether+"')";
//销售记账
String xsjzSql="insert into tb_selljz values('CK','"+xsid+"','"+xskhname+"','"+ys+"','"+ws+"','"+xsdate+"','"+czy+"','"+jsr+"')"; //更新库存信息
//String rkkcSql="update tb_kucun set kcsl=kcsl-"+sl+",dj="+dj+","+
//"kcje=(kcsl+"+sl+")*"+dj+" where id='"+spid+"'";
String rkkcSql="update tb_kucun set kcsl=kcsl-"+sl+","+
"kcje=(kcsl-"+sl+")* dj where id='"+spid+"'"; rst.getResult(rkkcSql);rst.getResult(xsSql);rst.getResult(xsphSql);rst.getResult(xsjzSql);
out.println("<script language='javascript'>alert('商品销售操作成功');window.location.href='spxs.jsp';</script>");
%>
这个是小弟的程序,前面的rst.getResult 执行都没有错误,但是rst.getResult(xsjzSql)已经执行了,但是表中却没有插入,也找不到原因,有那个厉害的能帮忙下
public ResultSet getResult(String sql) {
try {
Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY
,ResultSet.HOLD_CURSORS_OVER_COMMIT);
ResultSet rs = stmt.executeQuery(sql);
return rs;
} catch (Exception e) {
}
return null;
}
是不是这样就好了??