Apache FtpServer Spring3 整合

配置运行成功，以备遗忘。

Spring 配置当中加入

<import resource="applicationFTP.xml"/>

在Spring配置同级目录创建  applicationFTP.xml

<?xml version="1.0" encoding="UTF-8"?>
<server xmlns="http://mina.apache.org/ftpserver/spring/v1"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:beans="http://www.springframework.org/schema/beans" 
    xsi:schemaLocation="http://mina.apache.org/ftpserver/spring/v1 
    http://mina.apache.org/ftpserver/ftpserver-1.0.xsd
    http://www.springframework.org/schema/beans
    "
    id="ftpServers"     
    max-logins="500"
    anon-enabled="false"
    max-anon-logins="123"
    max-login-failures="124"
    login-failure-delay="125">
    
    
	<listeners>
		<nio-listener name="default" port="2121">
			<ssl>
				<keystore file="./res/ftpserver.jks" password="password" />
			</ssl>
		</nio-listener>
	</listeners>
	
	<db-user-manager>
		<data-source>
			<beans:bean class="org.apache.commons.dbcp.BasicDataSource">
				<beans:property name="driverClassName" value="${dbcp_jdbc.driverClassName}" />
		        <beans:property name="url" value="${dbcp_jdbc.url}" />
		        <beans:property name="username" value="${dbcp_jdbc.username}" />
		        <beans:property name="password" value="${dbcp_jdbc.password}" />
		        <beans:property name="maxActive" value="${dbcp_cpool.maxActive}" />
		        <beans:property name="poolPreparedStatements" value="true" />
		        <beans:property name="minEvictableIdleTimeMillis" value="5" />
		        <beans:property name="minIdle" value="2" />
		        <beans:property name="initialSize" value="3" />
		        <beans:property name="testOnBorrow" value="true" />
		        <beans:property name="testWhileIdle" value="true" />
		        <beans:property name="testOnReturn" value="true" />
		        <beans:property name="removeAbandoned" value="true" />
		        <beans:property name="removeAbandonedTimeout" value="300" />
			</beans:bean>
		</data-source>
		<insert-user>INSERT INTO FTP_USER (userid, userpassword,
			homedirectory, enableflag, writepermission, idletime, uploadrate,
			downloadrate) VALUES ('{userid}', '{userpassword}',
			'{homedirectory}','{enableflag}',
			'{writepermission}', {idletime}, {uploadrate},{downloadrate})</insert-user>
		<update-user>UPDATE FTP_USER SET
			userpassword='{userpassword}',homedirectory=
			'{homedirectory}',enableflag={enableflag},writepermission={writepermission},idletime={idletime}
			,uploadrate={uploadrate},downloadrate={downloadrate}
			WHERE userid='{userid}'
		</update-user>
		<delete-user>DELETE FROM FTP_USER WHERE userid = '{userid}'</delete-user>
		<select-user>SELECT userid, userpassword, homedirectory,
			enableflag, writepermission, idletime, maxloginnumber,maxloginperip,uploadrate,
			downloadrate
			FROM FTP_USER WHERE userid = '{userid}'</select-user>
		<select-all-users>SELECT userid FROM FTP_USER ORDER BY userid</select-all-users>
		<is-admin>SELECT userid FROM FTP_USER WHERE userid='{userid}' AND
			userid='admin'
		</is-admin>
		<authenticate>SELECT userpassword from FTP_USER WHERE
			userid='{userid}'</authenticate>
	</db-user-manager>
</server>