云存储PC端数据库设计

云存储PC端数据库设计目录创建数据库文件分享表用户表配置文件2创建数据库3项目使用MySQL数据库创建swift数据库：CREATEDATABASEswift;用户表4名类型长度允许空值主键idint11否主键usernamevarchar255否realnamevarchar255否emailvarchar255否passwordvarchar255否joindatevarchar255是lastdatevarchar255是capacityint11是表名：t_user5用户表CREATETABLE`t_user`(`id`int(11)NOTNULLAUTO_INCREMENT,`username`varchar(255)NOTNULL,`realname`varchar(255)NOTNULL,`email`varchar(255)NOTNULL,`password`varchar(255)NOTNULL,`joindate`varchar(255)DEFAULTNULL,`lastdate`varchar(255)DEFAULTNULL,`capacity`int(11)DEFAULT'1024',PRIMARYKEY(`id`)USINGBTREE)ENGINE=InnoDBAUTO_INCREMENT=5DEFAULTCHARSET=utf8ROW_FORMAT=COMPACT;6文件分享表名类型长度允许空值主键idint11否主键useridint11是filenamevarchar255是filepathvarchar255是typeint11是httpvarchar255是pwdvarchar255是isdirvarchar255是filelengthvarchar255是datavarchar255是表名：t_sharefile7文件分享表CREATETABLE`t_sharefile`(`id`int(11)NOTNULLAUTO_INCREMENT,`userid`int(11)DEFAULTNULL,`filename`varchar(255)DEFAULTNULL,`filepath`varchar(255)DEFAULTNULL,`type`int(11)DEFAULTNULL,`http`varchar(255)DEFAULTNULL,`pwd`varchar(255)DEFAULTNULL,`isdir`varchar(255)DEFAULTNULL,`filelength`varchar(255)DEFAULTNULL,`data`varchar(255)DEFAULTNULL,8文件分享表PRIMARYKEY(`id`)USINGBTREE,KEY`shareuserid`(`userid`)USINGBTREE,CONSTRAINT`shareuserid`FOREIGNKEY(`userid`)REFERENCES`t_user`(`id`)ONDELETECASCADE)ENGINE=InnoDBAUTO_INCREMENT=4DEFAULTCHARSET=utf8ROW_FORMAT=COMPACT;9配置文件src目录下新建perties，配置MySql的Url、用户名和密码jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/swift?useUnicode=true&characterEncoding=UTF-8jdbc.username=rootjdbc.password=12345610配置文件<?xmlversion="1.0"encoding="UTF-8"?><beansxmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:tx="/schema/tx"xmlns:aop="/schema/aop"xmlns:context="/schema/context"

xmlns:p="/schema/p"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans-3.0.xsd/schema/tx/schema/tx/spring-tx-3.0.xsd/schema/context/schema/context/spring-context-3.0.xsd/schema/aop/schema/aop/spring-aop-3.0.xsd">service.xml11配置文件<!--扫描com.dhl.service包下所有标注@Service的服务组件-->

<context:component-scanbase-package=".sict.cloud.storage.service"/><beanid="transactionManager“

class="org.springframework.orm.hibernate3.HibernateTransactionManager"

p:sessionFactory-ref="sessionFactory"/>service.xml12配置文件<!--使用强大的切点表达式语言轻松定义目标方法--><aop:config>

<!--通过aop定义事务增强切面--><aop:pointcutid="serviceMethod"

expression="execution(*.sict.cloud.storage.service.*Service.*(..))"/>

<!--引用事务增强--><aop:advisorpointcut-ref="serviceMethod"advice-ref="txAdvice"/>

</aop:config><!--事务增强--><tx:adviceid="txAdvice"transaction-manager="transactionManag