updstatus.jsp

运输模块代码

<%--
  Created by IntelliJ IDEA.
  User: jtgao
  Date: 2006-5-22
  Time: 21:01:35
  To change this template use File | Settings | File Templates.//
--%>
<%@page contentType="text/html;charset=GBK"%>
<%@ include file="/IncludeBeginMD.jsp"%>
<%
//out.println(sWorksno);
    //修改表 ord_item 中的 字段STATUS='CM' 为'IP'
    boolean isUpdOk = false;
    String sWorksno = DataConvert.toRealString(iPostChange,request.getParameter("Worksno"));
    //Update the table ord_item
    String sSql = "update ord_item set Status='IP' where Worksno='"+sWorksno+"'";
    //out.println(sSql);

    try{
        Sqlca.executeSQL(sSql);
        isUpdOk=true;
    }   catch (Exception e) {
        e.printStackTrace();
        out.println(e.toString());
        isUpdOk = false;
    }
%>
<script language=javascript>

    self.returnValue = "<%=isUpdOk%>";
	self.close();
</script>
<%@ include file="/IncludeEnd.jsp"%>