Struts上传问题,请高手帮忙,谢谢!
我有一个系统,原来是在MySql下,能实现上传,后来我转换成SqlServer2000,就不能上传了,为什么?
MySql中表的定义如下:
1
CREATE TABLE `admin` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`ZH` varchar(20) NOT NULL,
`PASSWORD` varchar(15) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2
CREATE TABLE `client` (
`ZH` varchar(20) NOT NULL,
`UPASSWORD` varchar(15) NOT NULL,
`XM` varchar(40) default NULL,
`XB` varchar(4) default NULL,
`MAIL` varchar(50) default NULL,
`PHONE` varchar(20) default NULL,
`QQ` varchar(15) default NULL,
`DESCRIPTION` varchar(100) default NULL,
`IFPUBLIC` int(11) NOT NULL,
PRIMARY KEY (`ZH`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3
CREATE TABLE `clientfile` (
`ZH` varchar(20) NOT NULL,
`FILENAME` varchar(100) NOT NULL,
`FILESIZE` float NOT NULL,
`UPLOADTIME` datetime NOT NULL,
`IFPUBLIC` int(10) unsigned default NULL,
PRIMARY KEY (`ZH`,`FILENAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4
CREATE TABLE `clientfilespace` (
`ZH` varchar(20) NOT NULL,
`FILESPACE` float NOT NULL,
`FILEEXIST` float NOT NULL,
`FILECOUNT` int(10) unsigned NOT NULL,
PRIMARY KEY (`ZH`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
5
CREATE TABLE `clientmessage` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`ZH` varchar(20) NOT NULL,
`FRIENDZH` varchar(20) NOT NULL,
`CONTENT` varchar(100) NOT NULL,
`SENDTIME` datetime default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
6
CREATE TABLE `clientremind` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`ZH` varchar(20) NOT NULL,
`THEME` varchar(20) NOT NULL,
`CONTENT` varchar(100) NOT NULL,
`MAKEDATE` datetime default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-----------
SqlServer2000
1
CREATE TABLE [dbo].[admin] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ZH] [varchar] (50)