02.Apache FtpServer使用数据库管理用户

最新推荐文章于 2020-09-29 23:20:55 发布

weixin_30621711

最新推荐文章于 2020-09-29 23:20:55 发布

阅读量85

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/LiZhiW/p/4794450.html

本文详细介绍如何使用 Apache FTPServer 1.0.6 版本通过 MySQL 数据库进行用户管理配置，包括创建数据库表、修改配置文件、添加依赖 jar 包及启动服务等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.创建数据库及表

使用\apache-ftpserver-1.0.6\res\ftp-db.sql建表，内容如下：

CREATE TABLE FTP_USER (
userid VARCHAR(64) NOT NULL PRIMARY KEY,
userpassword VARCHAR(64),
homedirectory VARCHAR(128) NOT NULL,
enableflag BOOLEAN DEFAULT TRUE,
writepermission BOOLEAN DEFAULT FALSE,
idletime INT DEFAULT 0,
uploadrate INT DEFAULT 0,
downloadrate INT DEFAULT 0,
maxloginnumber INT DEFAULT 0,
maxloginperip INT DEFAULT 0
);

新建用户： insert into FTP_USER values("wch","123456","./res/home",1,0,0,0,0,0,0);

2.修改ftpd-typical.xml

修改 \apache-ftpserver-1.0.6\res\conf\ftpd-typical.xml，注意xml命名空间部分：

<?xml version="1.0" encoding="UTF-8"?>
<serverxmlns="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://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://mina.apache.org/ftpserver/spring/v1
http://mina.apache.org/ftpserver/ftpserver-1.0.xsd"
id="myServer">
<listeners>

<nio-listenername="default"port="2121">
<ssl>
<keystorefile="./res/ftpserver.jks"password="password"/>
</ssl>
</nio-listener>
</listeners>



<db-user-managerencrypt-passwords="clear">

<data-source>
<beans:beanclass="org.apache.commons.dbcp.BasicDataSource">
<beans:propertyname="driverClassName"value="com.mysql.jdbc.Driver"/>
<beans:propertyname="url"value="jdbc:mysql://127.0.0.1/webframe"/>
<beans:propertyname="username"value="root"/>
<beans:propertyname="password"value="wch"/>
</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, uploadrate, downloadrate,
maxloginnumber, maxloginperip 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>