查询数据库 [英] query regarding database

查看:81
本文介绍了查询数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我想在数据库中存储一个带有CV(字格式)的名称。还想在diff页面上检索它。任何人都可以用完整的代码帮助我。

Urgent.thank you

I want to store a name with his CV(in word format) in the database.And also want to retrieve it on a diff page.Can any one help me with complete code.
Its Urgent.thank you

推荐答案

如前所述,这不是它的工作原理 - 如果你想要完整的代码,那么你需要去像vWorker这样的地方.com并支付它。但请注意,你得到你所支付的费用:支付花生,买猴子......



如前所述,这并不紧急 - 在10,215,594中这个网站的成员,只有一个在他的待办事项清单中。强调紧迫感只是意味着你以前不会为此烦恼,或者你只是粗鲁。



所以:你做什么?

你需要坐下来考虑你的任务。

你不想将他的简历存放在一个名字上,原因有几个。

1)可能会有许多同名的人。例如,如果他有一个共同的姓氏,几乎可以保证你的网站上会有一个同名的人。所以你需要做的第一件事就是实现会员资格 [< a href =http://msdn.microsoft.com/en-us/library/yh26yfzy(v=vs.98).aspx\"target =_ blanktitle =New Window> ^ ] so everyopne可以有一个独特的登录。

2)然后,你需要将他的个人信息存储在他的登录名下:他的名字,也许还有一些联系方式。例如,电子邮件或移动电话。他居住的地区可能是相关的。

3)然后你不想存储他的简历。我有几个简历,它们集中在不同的方向 - 都是绝对正确的,但专注于不同的材料,市场领域和技能。我怀疑很多人都是一样的。并且每一个都有修订版本,我存储所有旧版本以防万一我需要它们(或者我接到一个带有旧版本的人的电话 - 我需要知道他们在看什么)。而且我不会随机发送它们 - 它们是经过精心定位的。



您需要做的就是取决于您,以及您的网站使用的是什么应该有:没有一个单一的答案,但你需要找到很多问题,并在你开始设计解决方案之前自己回答。
As has been mentioned, that isn't how it works here - if you want complete code, then you need to go to somewhere like vWorker.com and pay for it. But be aware that you get what you pay for: pay peanuts, get monkeys...

As has also been mentioned, this is not urgent - out of the 10,215,594 members of this site, only one has it in his to-do list. Stressing urgency just implies you couldn't be bothered to do it before, or you are just rude.

So: what do you do?
You need to sit down and think about your task.
You don't want to store "his CV" against a name, for several reasons.
1) There are likely to be a number of people with the same name. If he has a common surname for example, it is almost guaranteed that there will be someone with the same name on your site already. So the first thing you need to do is implement Membership[^] so everyopne can have a unique log in.
2) Then, you need to store his personal details against his login: his name, and probably some way of contacting him. Email, for example, or mobile. The area in which he lives will probably be relevant.
3) Then you don't want to store "his CV". I have several CVs, which are focussed in different directions - all absolutely true, but concentrating on different material, market sector, and skills. I suspect than many people are the same. And every one of those has a revision status, and I store all old versions in case I need them (or I get a call from someone with an "old" version - I need to know what they are looking at). And I don't send them out randomly - they are carefully targeted.

Exactly what you need to do is going to depend on you, and what use your site is supposed to have: there is no one single answer, but there are a lot of questions that you need to find, and answer yourself before you can even start to design a solution.


http://chiragrdarji.wordpress.com/2007/08 / 31 / stored-and-retrieval-docpdfxls-files-in-sql-server / [ ^ ]


基本上有两个存储CV的选项(我想你知道如何存储名称......):

  • 在数据库中只存储Word文档的文件路径
You have basically two options for storing the CV (I suppose you know how to store the name...):
  • Store just the file path of the Word document, in the database.
  • Stor将Word文档内容作为 BLOB [ ^ ]。
  • Store the Word document content as a BLOB[^] in the database.


这篇关于查询数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆