ASP创建ACCESS表或添加字段 |
创建一张空表: vgQ0Ma http://www.numino.net Sql="Create TABLE [表名]" 856LEe http://www.numino.net 创建一张有字段的表: dmF15d http://www.numino.net Sql="Create TABLE [表名]([字段名1] MEMO NOT NULL, [字段名2] MEMO, [字段名3] COUNTER NOT NULL, [字段名4] DATETIME, [字段名5] TEXT(200), [字段名6] TEXT(200)) rNgw9l http://www.numino.net 字段类型: axo0zT http://www.numino.net 2 : "SmallInt", // 整型 X862zH http://www.numino.net 3 : "Int", // 长整型 QUZOv4 http://www.numino.net 4 : "Real", // 单精度型 7iEbZa http://www.numino.net 5 : "Float", // 双精度型 Y0c1k9 http://www.numino.net 6 : "Money", // 货币 36B1b9 http://www.numino.net 7 : "DateTime", // 日期时间 646m2V http://www.numino.net 11 : "Bit", // 是否 4GG819 http://www.numino.net 13 : "TimeStamp", Sv8WIi http://www.numino.net 17 : "TinyInt", // 字节 Mc0Kow http://www.numino.net 72 : "UniqueIdentifier", // 同步复制 ID lfI54x http://www.numino.net 128 : "Binary", qj2xxt http://www.numino.net 129 : "Char", 2ApjIv http://www.numino.net 130 : "NChar", g5b8jm http://www.numino.net 131 : "Decimal", // 小数 QtbeSy http://www.numino.net 133 : "DateTime", 4wX5Me http://www.numino.net 135 : "SmallDateTime", 8uOJ0x http://www.numino.net 200 : "VarChar", Txa9rJ http://www.numino.net 201 : "Text", nrqSYN http://www.numino.net 202 : "VarChar", // 文本 1JqbDG http://www.numino.net 203 : "Text", // 备注 J3yNr7 http://www.numino.net 204 : "Binary", // 二进制 GGwigK http://www.numino.net 205 : "Image" // OLE 对象 XO47jA http://www.numino.net 以下字段为无编码字段(NChar、NVarchar、NText型) 45Ltes http://www.numino.net 8,128,130,202,203,204,205 es582a http://www.numino.net 以下字段为按当前系统内码编码的字段(Asp中可用CodePage=936纠正为gb2312内码) gHAtbf http://www.numino.net 129,200,201 yiP8I4 http://www.numino.net 在现有的表中增加字段: 8iE64e http://www.numino.net Sql="alter table [表名] add column [字段名] varchar(200)" TqnEcK http://www.numino.net 修改字段类型: nMv657 http://www.numino.net Sql="alter table [表名] Alter COLUMN 字段名] varchar(50)" NAk1Y9 http://www.numino.net 删除表: 45ij52 http://www.numino.net Sql="Drop table [表名]" IDn2U0 http://www.numino.net 删除字段: BRC7VZ http://www.numino.net sql="alter table [表名] drop [字段名]" y05cnJ http://www.numino.net 修改字段:Alter TABLE [表名] Alter COLUMN [字段名] 类型(大小) NULL 8Najhc http://www.numino.net 新建约束:Alter TABLE [表名] ADD CONSTRAINT 约束名 CHECK ([约束字段] <= '2007-1-1') eJXSMm http://www.numino.net 删除约束:Alter TABLE [表名] Drop CONSTRAINT 约束名 rNd49M http://www.numino.net 新建默认值:Alter TABLE [表名] ADD CONSTRAINT 默认值名 DEFAULT 'Gziu.CoM' FOR [字段名] MUVeI4 http://www.numino.net 删除默认值:Alter TABLE [表名] Drop CONSTRAINT 默认值名 RmTq0c http://www.numino.net ======================================= 46Pw59 http://www.numino.net conn.open connstr 5tSjEE http://www.numino.net sql="alter table [tablename] add hehe char(20)" jNh255 http://www.numino.net conn.execute(sql) nLHtQq http://www.numino.net response.write("添加成功") Rde663 http://www.numino.net ACCESS新建数据库和表还不简单,有了表字段初始化就更简单 0alw8z http://www.numino.net ======================================= wBd69y http://www.numino.net <% h75H4Z http://www.numino.net session("tablen")="news" 7bG1k1 http://www.numino.net 'news是已存在的表名 lSKRX8 http://www.numino.net session("fieldsn")="c" 18MInQ http://www.numino.net '要添加的字段名 tN3uyx http://www.numino.net connectionstring="provider=microsoft.jet.oledb.4.0;data source="&server.MapPath("data/qq.mdb") RtVULo http://www.numino.net set conn=server.createobject("adodb.connection") g6W85H http://www.numino.net conn.OPEN connectionstring 040EiQ http://www.numino.net jhsql = " Alter Table "&session("tablen")&" add column "&session("fieldsn")&" real " 4nGECn http://www.numino.net conn.execute(jhsql) wqPjgM http://www.numino.net %> m8g08U http://www.numino.net ================================ qvxYMi http://www.numino.net 生成数据表,添加字段,其中id字段为自动增加,测试通过~~ Zl8eg1 http://www.numino.net Sub GenAutoIncrementFld() 7ql0ZR http://www.numino.net set cn=server.CreateObject("ADODB.Connection") wVSiVX http://www.numino.net set clx=server.CreateObject("ADOX.Column") 4u0NK5 http://www.numino.net set cat=server.CreateObject("ADOX.Catalog") OUoFf7 http://www.numino.net set tblnam=server.CreateObject("ADOX.Table") tvdFEJ http://www.numino.net mD2o4d http://www.numino.net cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\网站制作\asp操作mdb\db\test.mdb" HQ45SK http://www.numino.net Set cat.ActiveConnection = cn r2nt9U http://www.numino.net tblnam.Name = "Test" qMug6N http://www.numino.net clx.ParentCatalog = cat rYZEIS http://www.numino.net ZXYg8P http://www.numino.net clx.Type = 3 4w7poU http://www.numino.net clx.Name = "Id" nZp71C http://www.numino.net clx.Properties("AutoIncrement") = true 1TbIWa http://www.numino.net tblnam.Columns.Append clx R4Ucxg http://www.numino.net tblnam.Columns.Append "DataField",130,20 QblTa5 http://www.numino.net cat.Tables.Append tblnam KJSi1B http://www.numino.net Set clx = Nothing L36lUB http://www.numino.net Set cat = Nothing z5GOmg http://www.numino.net cn.Close 8K778O http://www.numino.net Set cn = Nothing CavRoM http://www.numino.net End Sub X9lw9K http://www.numino.net call GenAutoIncrementFld jf8Gj4 http://www.numino.net =================================== 9Qu5oL http://www.numino.net 字段类型对应数值 12u55a http://www.numino.net ''---- DataTypeEnum Values ---- ZTsX6e http://www.numino.net Const adEmpty = 0 NlUj22 http://www.numino.net Const adTinyInt = 16 J23693 http://www.numino.net Const adSmallInt = 2 EReAYx http://www.numino.net Const adInteger = 3 xH33Du http://www.numino.net Const adBigInt = 20 PUbMT9 http://www.numino.net Const adUnsignedTinyInt = 17 93uuT9 http://www.numino.net Const adUnsignedSmallInt = 18 X89HZH http://www.numino.net Const adUnsignedInt = 19 Wpi6Z2 http://www.numino.net Const adUnsignedBigInt = 21 Q8ZC6l http://www.numino.net Const adSingle = 4 r9YJRP http://www.numino.net Const adDouble = 5 08b1ZO http://www.numino.net Const adCurrency = 6 r60JOA http://www.numino.net Const adDecimal = 14 VF6uds http://www.numino.net Const adNumeric = 131 zcw6A7 http://www.numino.net Const adBoolean = 11 D3lirk http://www.numino.net Const adError = 10 m1G27T http://www.numino.net Const adUserDefined = 132 40O00Z http://www.numino.net Const adVariant = 12 sGh9it http://www.numino.net Const adIDispatch = 9 Xz9u12 http://www.numino.net Const adIUnknown = 13 Ff1tEA http://www.numino.net Const adGUID = 72 Fi285b http://www.numino.net Const adDate = 7 nmQVZO http://www.numino.net Const adDBDate = 133 x6ZmhS http://www.numino.net Const adDBTime = 134 rsTnp0 http://www.numino.net Const adDBTimeStamp = 135 9R2jef http://www.numino.net Const adBSTR = 8 Fawl68 http://www.numino.net Const adChar = 129 en6kST http://www.numino.net Const adVarChar = 200 HQr1yW http://www.numino.net Const adLongVarChar = 201 3uwKI4 http://www.numino.net Const adWChar = 130 3yfGiA http://www.numino.net Const adVarWChar = 202 uz9zi0 http://www.numino.net Const adLongVarWChar = 203 e50Wp2 http://www.numino.net Const adBinary = 128 PLq78R http://www.numino.net Const adVarBinary = 204 2ktw45 http://www.numino.net Const adLongVarBinary = 205 Pyf50N http://www.numino.net Const adChapter = 136 OK1gO4 http://www.numino.net Const adFileTime = 64 qY1nOM http://www.numino.net Const adPropVariant = 138 m6B6no http://www.numino.net Const adVarNumeric = 139 zyq73V http://www.numino.net Const adArray = &H2000
|
|