openfire集成用户信息

具体配置文件如下:

<?xml version="1.0" encoding="UTF-8"?>

<!--
    This file stores bootstrap properties needed by Openfire.
    Property names must be in the format: "prop.name.is.blah=value"
    That will be stored as:
        <prop>
            <name>
                <is>
                    <blah>value</blah>
                </is>
            </name>
        </prop>

    Most properties are stored in the Openfire database. A
 property viewer and editor is included in the admin console.
-->
<!-- root element, all properties must be under this element -->
<jive> 
  <adminConsole> 
    <!-- Disable either port by setting the value to -1 -->  
    <port>9090</port>  
    <securePort>9091</securePort> 
  </adminConsole>  
  <admin> 
    <authorizedUsernames>liwei, admin</authorizedUsernames> 
  </admin>  
  <locale>zh_CN</locale>  
  <provider> 
    <auth> 
      <className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className> 
    </auth>  
    <user> 
      <className>org.jivesoftware.openfire.user.JDBCUserProvider</className> 
    </user>  
    <group> 
      <className>org.jivesoftware.openfire.group.JDBCGroupProvider</className> 
    </group> 
  </provider>  
  <jdbcProvider> //需要集成系统的数据库;
    <driver>com.mysql.jdbc.Driver</driver>  
    <connectionString>jdbc:mysql://localhost:3306/test?user=root&amp;password=root</connectionString> 
  </jdbcProvider>  
  <jdbcAuthProvider> 
    <passwordSQL>SELECT password FROM user_account WHERE Username=?</passwordSQL>  
    <passwordType>plain</passwordType> 
  </jdbcAuthProvider>  
  <jdbcUserProvider> //集成用户
    <loadUserSQL>SELECT name,email FROM user_account WHERE Username=?</loadUserSQL>  
    <userCountSQL>SELECT COUNT(*) FROM user_account</userCountSQL>  
    <allUsersSQL>SELECT username FROM user_account</allUsersSQL>  
    <searchSQL>SELECT username FROM user_account WHERE</searchSQL>  
    <usernameField>Username</usernameField>  
    <nameField>name</nameField>  
    <emailField>email</emailField> 
  </jdbcUserProvider> //------------ 
  <connectionProvider> 
    <className>org.jivesoftware.database.DefaultConnectionProvider</className> 
  </connectionProvider>  
  <database> 
    <defaultProvider> 
      <driver>com.mysql.jdbc.Driver</driver>  
      <serverURL>jdbc:mysql://localhost:3306/openfire</serverURL>  
      <username>root</username>  
      <password>root</password>  
      <testSQL>select 1</testSQL>  
      <testBeforeUse>true</testBeforeUse>  
      <testAfterUse>true</testAfterUse>  
      <minConnections>5</minConnections>  
      <maxConnections>15</maxConnections>  
      <connectionTimeout>1.0</connectionTimeout> 
    </defaultProvider> 
  </database>  
  <!-- Fin configuration  -->  
  <setup>true</setup>  
  <log> 
    <debug> 
      <enabled>true</enabled> 
    </debug> 
  </log> 
</jive>