阜阳升级单点JSP**

comqing · 发表于 2007-6-13 12:15:48

<%@ page contentType="text/html; charset=gb2312" %>
<jsp:useBean id="lSysServer" class="com.justep.BizWebApp.SysServerProvider" />
<%
String username = request.getParameter("username");
String password = request.getParameter("password");
boolean notNull = false;

if(username != null && password != null){
notNull = true;
}
%>
<HTML>
<HEAD>
<title>>X3 协同管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>

<BODY leftmargin="0" topmargin="0" scroll="no">
<%--<%=username%><br>
<%=password%><br>
<%=notNull%>
AuotLogon<br>
<%= lSysServer.getSysServerURL()%>--%>
<OBJECT  id = "BusinessX"
      classid="<%= lSysServer.getBXClassID()%>"
   codebase="<%= lSysServer.getBXCodebase()%>"
      width="100%"
      height="100%"
      align=center
      hspace=0
      vspace=0
>
</OBJECT>

<object id="WebBrowser" width=0 height=0 classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2">
</object>

<script ID="BusinessCloseEventHandler" language="javascript" FOR="BusinessX" EVENT="OnTerminate">
  WebBrowser.ExecWB(45,1); // close window
</script>

<script type="text/javascript">
var username = "<%=username%>";
var pwd = "<%=password%>";
  function BeforeClose()
  {
if(!BusinessX.TerminateQuery())
{
   event.returnValue = "";
}
  }

  document.title = BusinessX.DisplayName;
  BusinessX.ServerURL = "<%= lSysServer.getSysServerURL()%>"
  BusinessX.ShowSplash();
  BusinessX.UpdateVersion();
  BusinessX.Init();
  BusinessX.CloseSplash();
  <% if(notNull) { %>
  BusinessX.Logon(username,pwd);
  <% } %>
  BusinessX.Run("Biz:\\System\\Init.Func", "", "", "");
  document.body.onbeforeunload=BeforeClose;
  document.title = BusinessX.DisplayName;
</script>
</BODY>
</HTML>

lisb · 发表于 2007-6-13 13:37:10

String password = request.getParameter("password");
这里的密码是从url中传递过来的
例如：http://myweb:8081/logon.jsp?username=myuid&password=mypass
所以，我要这个之前的文件，就是调用1楼这个jsp的文件

lisb · 发表于 2007-6-13 13:38:46

如果你说的密码明文是指的这里的话，这不是升级能解决的，而是如何在jsp之间传递数据，而这种传递有两种，一种是上面的写法，另外一种是以form的形式提交，这样就不出现在url中了

comqing · 发表于 2007-6-13 14:01:39

1、生成同步部门的VIEW：
create or replace view hirisun.v_x3_dept_2_oid as
select 'true' state,'orcladmin' owner, c.fid deptid, c.fdisplayname deptname, f.fid parentid, f.fdisplayname parentname from scmsys.tdept c,scmsys.tdept f
where c.fparentguid = f.fguid and c.fkind = '.DPT'
2、生成用户的VIEW：
CREATE OR REPLACE VIEW HIRISUN.V_X3_USER_2_OID AS
SELECT s.fid userid,s.fdisplayname username,a.fvalue passwd,m.fvalue mobile,
d.fid deptid, d.fdisplayname department,f.fid paraentid,f.fdisplayname parentname
FROM scmsys.torgsystem s,
   (SELECT FGUID,FVALUE FROM scmsys.torgattribute WHERE FID = 'PASSWORD') a,
   (SELECT FGUID,FVALUE FROM scmsys.torgattribute WHERE lower(FID) = 'emobile') m,
   scmsys.tperson p,
   scmsys.tdept d,
   scmsys.tdept f
WHERE s.fguid = a.fguid(+)
   AND s.fguid = m.fguid(+)
   AND s.fkind = '.PSN'
   AND p.fguid = s.fguid
   AND d.fid = p.fdeptid
   AND d.fparentguid = f.fguid
ORDER BY userid

alang · 发表于 2007-6-13 14:15:33

这里用到了
组织机构系统表
组织机构属性表
部门表
人员表

这几个表的结构没有变化，只是在2800中密码作了加密，我们这次升级作了兼容性处理，密码没有加密，所以没有影响

comqing · 发表于 2007-6-13 14:41:33

这是实际传用户密码参数后JSP的情况，主要是加粗的部分需要明文写入，这部分如何不用明文：

<HTML>
<HEAD>
<title>>X3 协同管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>

<BODY leftmargin="0" topmargin="0" scroll="no">

<OBJECT  id = "BusinessX"
      classid="clsid:B557E10A-2EA2-46C9-8F5F-3A3C9D471AE9"
   codebase="BusinessX.CAB#version=3,0,6,2368"
      width="100%"
      height="100%"
      align=center
      hspace=0
      vspace=0
>
</OBJECT>

<object id="WebBrowser" width=0 height=0 classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2">
</object>

<script ID="BusinessCloseEventHandler" language="javascript" FOR="BusinessX" EVENT="OnTerminate">
  WebBrowser.ExecWB(45,1); // close window
</script>

<script type="text/javascript">
[B]var username = "ZHANGY";
var pwd = "wingking70";[/B] function BeforeClose()
  {
if(!BusinessX.TerminateQuery())
{
   event.returnValue = "";
}
  }

  document.title = BusinessX.DisplayName;
  BusinessX.ServerURL = "http://192.168.0.6:8081"
  BusinessX.ShowSplash();
  BusinessX.UpdateVersion();
  BusinessX.Init();
  BusinessX.CloseSplash();

  BusinessX.Logon(username,pwd);

  //BusinessX.Logon("zhangy","4321");
  BusinessX.Run("Biz:\\System\\Init.Func", "", "", "");
  document.body.onbeforeunload=BeforeClose;
  document.title = BusinessX.DisplayName;
</script>
</BODY>
</HTML>

alang · 发表于 2007-6-13 16:09:28

这个问题就要从jsp上面做文章了，我对jsp也不是非常熟悉，但是我印象以前看到过这样的，一时找不到

atiger · 发表于 2007-6-19 16:14:49

		自动登录	找回密码
密码			立即注册