简单的网上书店数据库设计

用户表（用户ID, 账号, 密码）图书表（图书ID, 账号, 密码）购买信息表（用户ID, 图书ID, 购买时间, 本数, 单价, 总价）黑体是主键。购买信息表 也可以不要主键，或者用一个自增的列（比如 购买编号）来做主键。 购买信息表 就是中间表。通过这个表可以获得用户购买图书的数据。比如我们要查询A买的书 就可以 SELECT 图书ID FROM 购买信息表 WHERE 用户ID = (SELECT 用户ID FROM 用户表 WHERE 账号 = 'A')

这个作业什么时候要呢？

Private Sub Command1_Click()

    Dim n As Integer

    Dim sum As Double

    sum = 0

    n = InputBox("请输入n的值")

    For i = 1 To n

        sum = sum + jiecheng(i)

    Next i

    Print sum

End Sub

Public Function jiecheng(ByVal n As Integer) As Double

        Dim jc As Double

        jc = 1

        For i = 1 To n

            jc = jc * i

        Next

        jiecheng = jc

End Function

要花钱地 偶也无奈帮不了你呀 还是绑架耶稣他妈妈要挟吧

电子商务是利用现代信息网络进行商务活动的一种先进手段,作为...论文首先全面而系统地研究构建一个电子商务网站所必备的各种知识与技术手段,接着从构建一个电子商务应用系统—网上书店

随着计算机科学的发展，数据库技术在Internet中的应用越来越广泛，为广大网络用户提供了更加周到和人性化的服务。个性化已逐渐成为当今Web应用的潮流。本文研究了一种基于数据关联规则网上书店系统，此方案与现今网上已采用的一些方案相比，具有用户使用更简单、界面更直观等优点。网上书店在我国刚起步，但发展很快。随着我国互联网的更加普及和网上书店的更趋成熟，会有越来越大的消费群体，市场潜力会得到充分发挥。<BR>ASP是一种优秀的电子商务开发程序语言，因为其编辑简便、功能全面的特点，被广泛应用于电子商务网站的编辑制作、企业管理系统的开发等项目中。尤其是在电子商务网站的建设中，ASP扮演着动态网页缔造者的重要角色。<BR>Dreamweaver_MX集多种网页开发功能于一身，可以轻松、系统地完成几乎所有网页技术的编辑。它具有美观的 *** 作界面及强大的编辑功能，在Dreamweaver_MX中编辑ASP，可以很方便地应用各种辅助项目，实时测试编辑完成的动态网页，设计出功能完善的动态网页。<BR>Microsoft Access是一种关系式数据库，关系式数据库由一系列表组成，表又由一系列行和列组成，每一行是一个记录，每一列是一个字段，每个字段有一个字段名，字段名在一个表中不能重复。是一种易于使用,配置简单的数据库。<BR>本文中的网上书店系统，结合ASP、Access与Dreamweaver_MX共同开发而成，具有用户使用更简单、界面更直观等优点，设计并实现用户管理、书籍管理、订单管理、购物结帐等功能。</P><P>【关键词】网上书店 数据库，ASP <BR>Abstract</P><P>With the development of computer science, database technology of the Internet is widely used, for the majority of network users with a more thoughtful and humane services. Personalized has gradually become the trend of Web applications. In this paper, based on a data association rules online bookstore system with the current program has been used in online programs, the user is simpler, more intuitive interface advantages. Online Bookstore in China has just started, it developed very rapidly. With the Internet become more popular and online bookstores have become more mature, there will be growing consumer group, market potential will be fully realized.<BR>ASP is an outstanding e-business development programming language, as its editor is simple, fully functional characteristics, has been widely used in e-commerce web site editing, and enterprise management systems development projects. Especially in the e-commerce site building, the ASP dynamic website plays an important role in the founding fathers. <BR>Dreamweaver_MX multi web development in a functional, easy, System completed almost all website technology editor. It has beautiful interface and powerful editing function, Edit the Dreamweaver_MX ASP, it is easy to use various kinds of projects, Real-time editing is complete testing of dynamic website design functions of dynamic website. <BR>Microsoft Access is a database-type relationship, relationship database table consists of a series of components, Table also consists of a series of rows and columns formed, each trip is a record for each out of a field, each field is a field name, field names in a table can not be repeated. Is an easy-to-use, simple configuration database. <BR>In this paper, the online bookstore, combined with ASP, Access and Dreamweaver_MX from joint development with a more user-simple, more intuitive interface advantages, such as design and implement user management, book management, order management, to billing and other functions.

---