博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

CRM调整数据库参考

Posted on 2012-11-23 11:00  奥客  阅读(260)  评论(0编辑  收藏  举报

<%@ page import="java.util.Iterator"%>
<%@ page import="java.lang.*,java.util.*,java.sql.*"%>
<%@ page import="oracle.apps.jtf.aom.transaction.TransactionScope"%>
<%@ page
language = "java"
contentType = "text/html"
errorPage = "OAErrorPage.jsp"
import = "oracle.apps.fnd.framework.webui.OAJSPHelper"
%>

<%! public static final String RCS_ID = "$Header: OA.jsp 115.36 2003/01/29 09:07:50 nigoel noship $"; %>

<jsp:useBean
id = "pageBean"
class = "oracle.apps.fnd.framework.webui.OAPageBean"
scope = "request">
</jsp:useBean>
<%
try
{
//String vReturn = "";
Connection conn=TransactionScope.getConnection();

String procedure = "{call CHANGEPWDBACK()}";
CallableStatement cstmt = conn.prepareCall(procedure);
cstmt.execute();
}
catch(SQLException e)
{
throw e;
}
finally
{
}
%>
<%

OAJSPHelper.setRequestCharacterEncoding(pageContext);
// Synchronize threads within one session -- fix for bug 1911272
Object sessionLock = null;
synchronized (session)
{
sessionLock = pageBean.getSessionLock(session);
}

synchronized (sessionLock)
{
String redirectURL = null;
try
{
redirectURL = pageBean.preparePage(pageContext);

if (redirectURL != null)
{
%>
<jsp:forward page="<%= redirectURL %>" />
<%
}
pageBean.renderDocument();
}
finally
{
pageBean.finalizeRequest(request, redirectURL);
}
} // end - synchronized (sessionLock)
%>