liferay单点登录

一。配置liferay的客户端

企业管理  settion 配置

cas.auth.enabled=true
cas.login.url=https://xyb:8443/cas-web/login
cas.logout.url=https://xyb:8443/cas-web/logout
cas.server.name=客户端IP:8080
cas.service.url=
#cas.service.url=http://localhost:8080/c/portal/login
cas.validate.url=https://xyb:8443/cas-web/proxyValidate

二.找到登录的页面完成映射和自动登录。login_create_accout.jspf

<%@ page import="com.mysql.jdbc.Driver" %>

<%@ page import="java.sql.*" %>
<c:if test="<%= sectionSelected.booleanValue() %>">
 <c:if test='<%= SessionMessages.contains(request, "user_added") %>'>

  <%
  String emailAddress = (String)SessionMessages.get(request, "user_added");
  
  String password = (String)SessionMessages.get(request, "user_added_password");
  %>

  <span class="portlet-msg-success">

  <c:choose>
   <c:when test="<%= company.isStrangersVerify() || Validator.isNull(password) %>">
    <%= LanguageUtil.format(pageContext, "thank-you-for-creating-an-account-your-password-has-been-sent-to-x", emailAddress) %>
   </c:when>
   <c:otherwise>
    <%= LanguageUtil.format(pageContext, "thank-you-for-creating-an-account-your-password-is-x", new Object[] {password, emailAddress}) %>
   </c:otherwise>
  </c:choose>

  </span>
 </c:if>
1
 <c:if test="<%= SessionErrors.contains(request, AuthException.class.getName()) %>">
  <span class="portlet-msg-error">
  <liferay-ui:message key="authentication-failed" />11
  </span>
 </c:if>

 <c:if test="<%= SessionErrors.contains(request, CookieNotSupportedException.class.getName()) %>">
  <span class="portlet-msg-error">
  <liferay-ui:message key="authentication-failed-please-enable-browser-cookies" />22
  </span>
 </c:if>

 <c:if test="<%= SessionErrors.contains(request, DuplicateUserEmailAddressException.class.getName()) %>">
  <span class="portlet-msg-error">
  <liferay-ui:message key="the-email-address-you-requested-is-already-taken" />33
  </span>
 </c:if>

 <c:if test="<%= SessionErrors.contains(request, NoSuchUserException.class.getName()) %>">
  <span class="portlet-msg-error">
  <liferay-ui:message key="please-enter-a-valid-login" />44
  </span>
 </c:if>

 <c:if test="<%= SessionErrors.contains(request, PasswordExpiredException.class.getName()) %>">
  <span class="portlet-msg-error">
  <liferay-ui:message key="your-password-has-expired" />55
  </span>
 </c:if>

 <c:if test='<%= SessionErrors.contains(request, UserEmailAddressException.class.getName()) %>'>
  <span class="portlet-msg-error">
  <liferay-ui:message key="please-enter-a-valid-login" />66
  </span>
 </c:if>

 <c:if test='<%= SessionErrors.contains(request, UserLockoutException.class.getName()) %>'>
  <span class="portlet-msg-error">
  <liferay-ui:message key="this-account-has-been-locked" />77
  </span>
 </c:if>

 <c:if test="<%= SessionErrors.contains(request, UserPasswordException.class.getName()) %>">
  <span class="portlet-msg-error">
  <liferay-ui:message key="please-enter-a-valid-password" />88
  </span>
 </c:if>

 <c:if test="<%= SessionErrors.contains(request, UserScreenNameException.class.getName()) %>">
  <span class="portlet-msg-error">
  <liferay-ui:message key="please-enter-a-valid-screen-name" />99
  </span>
 </c:if>
</c:if>

<c:if test="<%= SessionErrors.contains(request, AssociationException.class.getName()) %>">
 <span class="portlet-msg-error">
 <liferay-ui:message key="an-error-occurred-while-establishing-an-association-with-the-open-id-provider" />00
 </span>
</c:if>

<c:if test="<%= SessionErrors.contains(request, ConsumerException.class.getName()) %>">
 <span class="portlet-msg-error">
 <liferay-ui:message key="an-error-occurred-while-initializing-the-open-id-consumer" />01
 </span>
</c:if>

<c:if test="<%= SessionErrors.contains(request, DiscoveryException.class.getName()) %>">
 <span class="portlet-msg-error">
 <liferay-ui:message key="an-error-occurred-while-discovering-the-open-id-provider" />02
 </span>
</c:if>

<c:if test="<%= SessionErrors.contains(request, MessageException.class.getName()) %>">
 <span class="portlet-msg-error">
 <liferay-ui:message key="an-error-occurred-while-communicating-with-the-open-id-provider" />03
 </span>
</c:if>

<div class="lfr-portal-login">
 <form action="<%= themeDisplay.getPathMain() %>/portal/login" class="uni-form" method="post" name="fm1" id="aa">
 <input name="<%= Constants.CMD %>" type="hidden" value="already-registered" />
 <input name="<%= sectionParam %>" type="hidden" value="already-registered" />
 <input name="redirect" type="hidden" value="<%= HtmlUtil.escape(redirect) %>" />

 <%
 String driverName="com.mysql.jdbc.Driver";

//数据库用户名

String userName="root";
String id=session.getAttribute("edu.yale.its.tp.cas.client.filter.user").toString();
//密码

String userPasswd="admin";

//数据库名

String dbName="db1";

//表名

String tableName="dbtest";

//联结字符串

String url="jdbc:mysql://192.168.132.16:3306/"+dbName+"?user="+userName+"&password="+userPasswd;

Class.forName("com.mysql.jdbc.Driver").newInstance();

Connection connection=DriverManager.getConnection(url);

Statement statement = connection.createStatement();

String sql="SELECT * FROM "+tableName;
String where="  where id='"+id+"'";
sql=sql.concat(where);
out.println(sql);
System.out.println(sql);
ResultSet rs = statement.executeQuery(sql);

//获得数据结果集合

ResultSetMetaData rmeta = rs.getMetaData();

String login1="";
String passwordParam1="";
while(rs.next()) {

 
 login1=rs.getString(2);
 passwordParam1=rs.getString(3);

//out.println(passwordParam);
}

rs.close();

statement.close();

connection.close();
//out.print(session.getAttribute("edu.yale.its.tp.cas.client.filter.user"));

 String login = LoginAction.getLogin(request, "login", company);
 //out.println(login);
 //out.println(session.getAttribute("edu.yale.its.tp.cas.client.filter.user").toString());
 String passwordParam = SessionParameters.get(request, "password");
 // passwordParam="test";
 boolean rememberMe = ParamUtil.getBoolean(request, "rememberMe");
 %>

 <input id="rememberMe" name="rememberMe" type="hidden" value="<%= rememberMe %>" />

 <fieldset class="block-labels">
  <c:choose>
   <c:when test="<%= OpenIdUtil.isEnabled(company.getCompanyId()) %>">
    <legend><liferay-ui:message key="sign-in-with-a-regular-account" /></legend>
   </c:when>
   <c:otherwise>
    <legend><liferay-ui:message key="sign-in" /></legend>
   </c:otherwise>
  </c:choose>

  <div class="ctrl-holder">
   <label for="login"><liferay-ui:message key="login" /></label>
<!--
   <input class="lfr-input-text" id="login" name="login" type="text" value="<%= HtmlUtil.escape(login) %>" id="login" />
 -->  
   
   <input class="lfr-input-text" id="login" name="login" type="text" value="joebloggs"  />
   
  </div>

  <div class="ctrl-holder">
   <label for='<%= passwordParam %>'><liferay-ui:message key="password" /></label>

   <input class="lfr-input-text" id="test" name="<%= passwordParam %>" type="text"  />

          

   <span id="passwordCapsLockSpan" style="display: none;"><liferay-ui:message key="caps-lock-is-on" /></span>
  </div>

  <c:if test="<%= company.isAutoLogin() && !PropsValues.SESSION_DISABLED %>">
   <div class="ctrl-holder inline-label">
    <label for="rememberMeCheckbox"><liferay-ui:message key="remember-me" /></label>

    <input <%= rememberMe ? "checked=/"checked/"" : "" %> id="rememberMeCheckbox" type="checkbox" />
   </div>
  </c:if>

  <div class="button-holder">
   <input type="submit" value="<liferay-ui:message key="sign-in" />" />22
  </div>
 </fieldset>
<script type="text/javascript">
var login="<%=login1%>";
var passwordParam="<%=passwordParam1%>";
alert(passwordParam);
document.getElementById('login').value=login;
document.getElementById('test').value= passwordParam;
var  ss=document.getElementById('test').value;

document.getElementById('aa').submit();

</script>
 </form>

 <c:if test="<%= OpenIdUtil.isEnabled(company.getCompanyId()) %>">

  <%
  String openId = ParamUtil.getString(request, "openId");
  %>

  <form action="<%= themeDisplay.getPathMain() %>/portal/open_id_request" class="uni-form" method="post" name="fm2" >

  <fieldset class="block-labels">
   <legend><liferay-ui:message key="sign-in-with-an-open-id-provider" /></legend>

   <div class="ctrl-holder">
    <label for="openId"><liferay-ui:message key="open-id" /></label>

    <input class="openid_login" id="openId" name="openId" style="width: 150px;" type="text" value="<%= HtmlUtil.escape(openId) %>" />
   </div>

   <div class="button-holder">
    <input type="submit" value="<liferay-ui:message key="sign-in" />" />11
   </div>
  </fieldset>

  </form>
 </c:if>
</div>

<script type="text/javascript">
 jQuery(
  function() {
   jQuery('#<%= passwordParam %>').keypress(
    function(event) {
     Liferay.Util.showCapsLock(event, 'passwordCapsLockSpan');
    }
   );

   jQuery('#rememberMeCheckbox').click(
    function() {
     var checked = 'off';

     if (this.checked) {
      checked = 'on';
     }

     jQuery('#rememberMe').val(checked);
    }
   );
  }
 );
</script>

三。数据库

映射  cas的登录名    username  password