34,838
社区成员
发帖
与我相关
我的任务
分享把服务器上文件夹的图片路径导入到数据库
我服务器的文件夹中有大量图片,我想把图片路径,名称等导如到数据库中.不知道该怎么办!请高手指点
...全文
请发表友善的回复…
发表回复
仙道彰 2009-07-29
- 打赏
- 举报
[Quote=引用 8 楼 guguda2008 的回复:]
引用 7 楼 yanguoliusheng 的回复:
SQL codeCREATETABLE TB(IDINTIDENTITY(1,1),IMGVARCHAR(50))DECLARE@iintDECLARE@namevarchar(50)Set@i=1WHILE@i <10BEGINSet@i=@i+1select@name='../img/'+convert(varchar(20),getdate(),112)+CAST(@iASvarchar(10))+'.jpg'insertinto TBvalues(@name)ENDSELECT*FROM TB/*ID IMG
----------- --------------------------------------------------
1 ../img/200907282.jpg
2 ../img/200907283.jpg
3 ../img/200907284.jpg
4 ../img/200907285.jpg
5 ../img/200907286.jpg
6 ../img/200907287.jpg
7 ../img/200907288.jpg
8 ../img/200907289.jpg
9 ../img/2009072810.jpg
(9 行受影响)*/
正解
[/Quote]
他都得十分
引用 7 楼 yanguoliusheng 的回复:
SQL codeCREATETABLE TB(IDINTIDENTITY(1,1),IMGVARCHAR(50))DECLARE@iintDECLARE@namevarchar(50)Set@i=1WHILE@i <10BEGINSet@i=@i+1select@name='../img/'+convert(varchar(20),getdate(),112)+CAST(@iASvarchar(10))+'.jpg'insertinto TBvalues(@name)ENDSELECT*FROM TB/*ID IMG
----------- --------------------------------------------------
1 ../img/200907282.jpg
2 ../img/200907283.jpg
3 ../img/200907284.jpg
4 ../img/200907285.jpg
5 ../img/200907286.jpg
6 ../img/200907287.jpg
7 ../img/200907288.jpg
8 ../img/200907289.jpg
9 ../img/2009072810.jpg
(9 行受影响)*/
正解
[/Quote]
他都得十分
FeelTouch Labs 2009-07-29
- 打赏
- 举报
解决了,谢谢YanGuoLiuSheng,guguda2008,fwacky!
fwacky 2009-07-29
- 打赏
- 举报
update 你的表名 set 字段= @name where id = @i
fwacky 2009-07-29
- 打赏
- 举报
DECLARE @i int
DECLARE @name varchar(50)
Set @i = 1
WHILE @i < 图片的个数
BEGIN
select @name='../img/'+ RIGHT('000'+CAST(@i AS varchar(10)),3)+'.jpg'
update 你的表名 set 字段= @name where id = @i
Set @i =@i +1
end
fwacky 2009-07-29
- 打赏
- 举报
DECLARE @i int
DECLARE @name varchar(50)
Set @i = 1
WHILE @i < 图片的个数
BEGIN
select @name='../img/'+ RIGHT('000'+CAST(@i AS varchar(10)),3)+'.jpg'
update 你的表名 set 字段= @name
Set @i =@i +1
end
================
../img/001.jpg
../img/002.jpg
../img/003.jpg
../img/004.jpg
../img/005.jpg
../img/006.jpg
../img/007.jpg
../img/008.jpg
../img/009.jpg
../img/010.jpg
../img/011.jpg
../img/012.jpg
../img/013.jpg
../img/014.jpg
--测试成功！
仙道彰 2009-07-29
- 打赏
- 举报
--滚动条看着真不舒服
IF OBJECT_ID('TB') IS NOT NULL
DROP TABLE TB
GO
CREATE TABLE TB(ID INT IDENTITY(1,1),IMG VARCHAR(50))
GO
DECLARE @i int
DECLARE @name varchar(50)
Set @i = 1
WHILE @i < 15
BEGIN
select @name='../img/'
+convert(varchar(20),getdate(), 112)
+ RIGHT('000'+CAST(@i AS varchar(10)),3)
+'.jpg'
insert into TB values(@name)
Set @i =@i +1
END
GO
SELECT * FROM TB仙道彰 2009-07-29
- 打赏
- 举报
IF OBJECT_ID('TB') IS NOT NULL
DROP TABLE TB
GO
CREATE TABLE TB(ID INT IDENTITY(1,1),IMG VARCHAR(50))
GO
DECLARE @i int
DECLARE @name varchar(50)
Set @i = 1
WHILE @i < 15
BEGIN
select @name='../img/'+convert(varchar(20),getdate(), 112) + RIGHT('000'+CAST(@i AS varchar(10)),3)+'.jpg'
insert into TB values(@name)
Set @i =@i +1
END
GO
SELECT * FROM TB
/*ID IMG
----------- --------------------------------------------------
1 ../img/20090729001.jpg
2 ../img/20090729002.jpg
3 ../img/20090729003.jpg
4 ../img/20090729004.jpg
5 ../img/20090729005.jpg
6 ../img/20090729006.jpg
7 ../img/20090729007.jpg
8 ../img/20090729008.jpg
9 ../img/20090729009.jpg
10 ../img/20090729010.jpg
11 ../img/20090729011.jpg
12 ../img/20090729012.jpg
13 ../img/20090729013.jpg
14 ../img/20090729014.jpg
(14 行受影响)
*/FeelTouch Labs 2009-07-29
- 打赏
- 举报
楼上的我在插入过程中,遇到了个小问题就是按照7,8楼说的,插入的编号是1 2 3...,但是我的图片的标号是001 002 003 ...089.请问这应该怎么改一下上面的语句
FeelTouch Labs 2009-07-29
- 打赏
- 举报
谢谢你们的回答,我试试!
guguda2008 2009-07-29
- 打赏
- 举报
[Quote=引用 17 楼 yanguoliusheng 的回复:]
引用 8 楼 guguda2008 的回复:
引用 7 楼 yanguoliusheng 的回复:
SQL codeCREATETABLE TB(IDINTIDENTITY(1,1),IMGVARCHAR(50))DECLARE@iintDECLARE@namevarchar(50)Set@i=1WHILE@i <10BEGINSet@i=@i+1select@name='../img/'+convert(varchar(20),getdate(),112)+CAST(@iASvarchar(10))+'.jpg'insertinto TBvalues(@name)ENDSELECT*FROM TB/*ID IMG
----------- --------------------------------------------------
1 ../img/200907282.jpg
2 ../img/200907283.jpg
3 ../img/200907284.jpg
4 ../img/200907285.jpg
5 ../img/200907286.jpg
6 ../img/200907287.jpg
7 ../img/200907288.jpg
8 ../img/200907289.jpg
9 ../img/2009072810.jpg
(9 行受影响)*/
正解
他都得十分
[/Quote]
有时正确的方向比努力更重要 - -
BTW：我也很费解
引用 8 楼 guguda2008 的回复:
引用 7 楼 yanguoliusheng 的回复:
SQL codeCREATETABLE TB(IDINTIDENTITY(1,1),IMGVARCHAR(50))DECLARE@iintDECLARE@namevarchar(50)Set@i=1WHILE@i <10BEGINSet@i=@i+1select@name='../img/'+convert(varchar(20),getdate(),112)+CAST(@iASvarchar(10))+'.jpg'insertinto TBvalues(@name)ENDSELECT*FROM TB/*ID IMG
----------- --------------------------------------------------
1 ../img/200907282.jpg
2 ../img/200907283.jpg
3 ../img/200907284.jpg
4 ../img/200907285.jpg
5 ../img/200907286.jpg
6 ../img/200907287.jpg
7 ../img/200907288.jpg
8 ../img/200907289.jpg
9 ../img/2009072810.jpg
(9 行受影响)*/
正解
他都得十分
[/Quote]
有时正确的方向比努力更重要 - -
BTW：我也很费解
guguda2008 2009-07-28
- 打赏
- 举报
[Quote=引用 7 楼 yanguoliusheng 的回复:]
SQL codeCREATETABLE TB(IDINTIDENTITY(1,1),IMGVARCHAR(50))DECLARE@iintDECLARE@namevarchar(50)Set@i=1WHILE@i<10BEGINSet@i=@i+1select@name='../img/'+convert(varchar(20),getdate(),112)+CAST(@iASvarchar(10))+'.jpg'insertinto TBvalues(@name)ENDSELECT*FROM TB/*ID IMG
----------- --------------------------------------------------
1 ../img/200907282.jpg
2 ../img/200907283.jpg
3 ../img/200907284.jpg
4 ../img/200907285.jpg
5 ../img/200907286.jpg
6 ../img/200907287.jpg
7 ../img/200907288.jpg
8 ../img/200907289.jpg
9 ../img/2009072810.jpg
(9 行受影响)*/
[/Quote]
正解
SQL codeCREATETABLE TB(IDINTIDENTITY(1,1),IMGVARCHAR(50))DECLARE@iintDECLARE@namevarchar(50)Set@i=1WHILE@i<10BEGINSet@i=@i+1select@name='../img/'+convert(varchar(20),getdate(),112)+CAST(@iASvarchar(10))+'.jpg'insertinto TBvalues(@name)ENDSELECT*FROM TB/*ID IMG
----------- --------------------------------------------------
1 ../img/200907282.jpg
2 ../img/200907283.jpg
3 ../img/200907284.jpg
4 ../img/200907285.jpg
5 ../img/200907286.jpg
6 ../img/200907287.jpg
7 ../img/200907288.jpg
8 ../img/200907289.jpg
9 ../img/2009072810.jpg
(9 行受影响)*/
[/Quote]
正解
仙道彰 2009-07-28
- 打赏
- 举报
CREATE TABLE TB(ID INT IDENTITY(1,1),IMG VARCHAR(50))
DECLARE @i int
DECLARE @name varchar(50)
Set @i = 1
WHILE @i < 10
BEGIN
Set @i =@i +1
select @name='../img/'+convert(varchar(20),getdate(), 112) + CAST(@i AS varchar(10))+'.jpg'
insert into TB values(@name)
END
SELECT * FROM TB
/*ID IMG
----------- --------------------------------------------------
1 ../img/200907282.jpg
2 ../img/200907283.jpg
3 ../img/200907284.jpg
4 ../img/200907285.jpg
5 ../img/200907286.jpg
6 ../img/200907287.jpg
7 ../img/200907288.jpg
8 ../img/200907289.jpg
9 ../img/2009072810.jpg
(9 行受影响)
*/仙道彰 2009-07-28
- 打赏
- 举报
--假如你的地址这么有规律
CREATE TABLE TB(ID INT IDENTITY(1,1),IMG VARCHAR(50))
DECLARE @i int
DECLARE @name varchar(50)
Set @i = 1
WHILE @i < 1000
BEGIN
Set @i =@i +1
select @name='../img'convert(varchar(20),getdate(), 112) + CAST(@i AS varchar(10))+'.jpg'
insert into TB values(@name)
END 
--小F-- 2009-07-28
- 打赏
- 举报
支持用文本格式存放图片的目录。
ChinaJiaBing 2009-07-28
- 打赏
- 举报
在数据表设一个字符型字段,把图片目录插入进去...
FeelTouch Labs 2009-07-28
- 打赏
- 举报
很有规律!
仙道彰 2009-07-28
- 打赏
- 举报
你的图片名称有规律没？
FeelTouch Labs 2009-07-28
- 打赏
- 举报
我等着,在线交流!
