updateunorderoption.jsp

来自「运输模块代码」· JSP 代码 · 共 42 行

<%--
  Created by IntelliJ IDEA.
  User: jtgao
  Date: 2006-5-19
  Time: 11:25:35
  To change this template use File | Settings | File Templates.//
--%>
<%@page contentType="text/html;charset=GBK"%>

<%@ include file="/IncludeBeginMD.jsp"%>
<%
	boolean isUpdOk = false;

    String sWorkno = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Worksno"));
    String sStatus = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Status"));

    //Update the table ord_item
    String sSql = "update ord_item set Status='"+sStatus+"' where Worksno='"+sWorkno+"' ";
    //out.println(sSql);

    try{
        Sqlca.executeSQL(sSql);
        isUpdOk=true;
    }   catch (Exception e) {
        e.printStackTrace();
        out.println(e.toString());
        isUpdOk = false;
    }

    //out.println(isUpdOk);




    //isEmpty = !rs.next();
%>
<script language=javascript>
    alert("处理完毕。");
    self.returnValue = "<%=isUpdOk%>";
	self.close();
</script>
<%@ include file="/IncludeEnd.jsp"%>