首页 开发技术 其它 vb学生选课系统.zip

vb学生选课系统.zip

上传者： mengliao211 | 上传时间： 2019-12-21 20:18:48 | 文件大小： 1.74MB | 文件类型： zip
可以采用两种方法配置数据库： 该系统登录初始账号为admin，初始密码为admin。 －－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－ 1.利用SQL语句创建数据库 本例使用的后端数据库是Microsoft公司的SQL Server2000，需要配置数据库和并创建表格。 步骤如下： （1）打开SQL Server的企业管理器，并依次打开左边TreeView（树型视图）中的节点：【控制台根目录】->【Microsoft SQL Servers】->【SQL Server组】->【(Local)】->【数据库】。 （2）鼠标右键单击“数据库”节点，在弹出的菜单中选择“新建数据库”。 （3）在弹出的对话框中输入数据库名“stu”，单击“确认”按钮，数据库建立成功。 （4）关闭企业管理器，打开SQL Server查询分析器，选择stu数据库（若设置了SQL Server安全性，则还需要输入用户和密码登录到SQL Server）。 （5）在查询分析器中输入如下代码建立数据表结构。 可以直接导入“data”目录下的stu.sql文件运行。 ① 建立密码表 USE stu IF EXISTS (SELECT name FROM sysobjects WHERE name = '密码' AND type = 'U') DROP TABLE [密码] Go CREATE TABLE [密码]( 用户名 nvarchar (50) PRIMARY KEY, 密码 nvarchar (50) , 权限 nvarchar (50) ) Go ② 建立studentinfo表 USE stu IF EXISTS (SELECT name FROM sysobjects WHERE name = 'studentinfo' AND type = 'U') DROP TABLE studentinfo Go CREATE TABLE studentinfo( sno nvarchar (50) PRIMARY KEY, sname nvarchar (50) , sex nvarchar (50) , birth smalldatetime , tel nvarchar (50) , address nvarchar (50) , m nvarchar (50) , photo image ) Go ③ 建立teacherinfo表 USE stu IF EXISTS (SELECT name FROM sysobjects WHERE name = 'teacherinfo' AND type = 'U') DROP TABLE teacherinfo Go CREATE TABLE teacherinfo( tno nvarchar (50) PRIMARY KEY, tname nvarchar (50) , title nvarchar (50) , tel nvarchar (50) , m ntext) Go ④ 建立courseinfo表 USE stu IF EXISTS (SELECT name FROM sysobjects WHERE name = 'courseinfo' AND type = 'U') DROP TABLE courseinfo Go CREATE TABLE courseinfo( cno nvarchar (50) PRIMARY KEY, cname nvarchar (50) , chour nvarchar (50) , credit nvarchar (50) , m ntext ) Go ⑤ 建立course_teacher表 USE stu IF EXISTS (SELECT name FROM sysobjects WHERE name = 'course_teacher' AND type = 'U') DROP TABLE course_teacher Go CREATE TABLE course_teacher( id int, cno nvarchar (50) , tno nvarchar (50) , m ntext ) Go ⑥ 建立choice表 USE stu IF EXISTS (SELECT name FROM sysobjects WHERE name = 'choice' AND type = 'U') DROP TABLE choice Go CREATE TABLE choice( id int, stuno nvarchar (50) , courseno nvarchar (50) , teacherno

文件下载

资源详情

[{"title":"（ 66 个子文件 1.74MB ） vb学生选课系统.zip","children":[{"title":"学生选课系统","children":[{"title":"ico","children":[{"title":"153.jpg <span style='color:#111;'> 31.17KB </span>","children":null,"spread":false},{"title":"mac017.jpg <span style='color:#111;'> 143.61KB </span>","children":null,"spread":false},{"title":"abc.bmp <span style='color:#111;'> 2.17MB </span>","children":null,"spread":false},{"title":"logo.jpg <span style='color:#111;'> 160.78KB </span>","children":null,"spread":false},{"title":"53.ICO <span style='color:#111;'> 7.60KB </span>","children":null,"spread":false},{"title":"148.jpg <span style='color:#111;'> 31.18KB </span>","children":null,"spread":false},{"title":"122.jpg <span style='color:#111;'> 93.28KB </span>","children":null,"spread":false},{"title":"26.ICO <span style='color:#111;'> 9.90KB </span>","children":null,"spread":false}],"spread":true},{"title":"load_frm.frx <span style='color:#111;'> 53.16KB </span>","children":null,"spread":false},{"title":"student_frm.frm <span style='color:#111;'> 41.03KB </span>","children":null,"spread":false},{"title":"report_frm.frx <span style='color:#111;'> 8.83KB </span>","children":null,"spread":false},{"title":"teacher_frm.frx <span style='color:#111;'> 46.32KB </span>","children":null,"spread":false},{"title":"courseteacher_frm.frx <span style='color:#111;'> 56B </span>","children":null,"spread":false},{"title":"addstu_frm.frm <span style='color:#111;'> 12.02KB </span>","children":null,"spread":false},{"title":"login_frm.frm <span style='color:#111;'> 7.11KB </span>","children":null,"spread":false},{"title":"ado_object.frm <span style='color:#111;'> 27.89KB </span>","children":null,"spread":false},{"title":"student_frm.log <span style='color:#111;'> 362B </span>","children":null,"spread":false},{"title":"s_choice_frm.frx <span style='color:#111;'> 46.32KB </span>","children":null,"spread":false},{"title":"DataReport2.dsx <span style='color:#111;'> 31B </span>","children":null,"spread":false},{"title":"teacher_frm.frm <span style='color:#111;'> 29.95KB </span>","children":null,"spread":false},{"title":"user_frm.frx <span style='color:#111;'> 84B </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 193B </span>","children":null,"spread":false},{"title":"teacher1_frm.frx <span style='color:#111;'> 143.62KB </span>","children":null,"spread":false},{"title":"teacher1_frm.frm <span style='color:#111;'> 34.42KB </span>","children":null,"spread":false},{"title":"frmuser.frx <span style='color:#111;'> 84B </span>","children":null,"spread":false},{"title":"chart_frm.frx <span style='color:#111;'> 8.83KB </span>","children":null,"spread":false},{"title":"addstu_frm.frx <span style='color:#111;'> 143B </span>","children":null,"spread":false},{"title":"t_choice_frm.frx <span style='color:#111;'> 46.32KB </span>","children":null,"spread":false},{"title":"pass_frm.frm <span style='color:#111;'> 5.65KB </span>","children":null,"spread":false},{"title":"DataReport1.Dsr <span style='color:#111;'> 8.61KB </span>","children":null,"spread":false},{"title":"DataReport1.dsx <span style='color:#111;'> 31B </span>","children":null,"spread":false},{"title":"DataEnvironment1.log <span style='color:#111;'> 167B </span>","children":null,"spread":false},{"title":"About_frm.frm <span style='color:#111;'> 9.25KB </span>","children":null,"spread":false},{"title":"Module1.bas <span style='color:#111;'> 2.53KB </span>","children":null,"spread":false},{"title":"MDIForm1.frx <span style='color:#111;'> 139.13KB </span>","children":null,"spread":false},{"title":"student_frm.frx <span style='color:#111;'> 248B </span>","children":null,"spread":false},{"title":"选课系统.vbp <span style='color:#111;'> 2.38KB </span>","children":null,"spread":false},{"title":"query_frm.frm <span style='color:#111;'> 26.41KB </span>","children":null,"spread":false},{"title":"DataReport1.DCA <span style='color:#111;'> 46.71KB </span>","children":null,"spread":false},{"title":"s_choice_frm.frm <span style='color:#111;'> 14.01KB </span>","children":null,"spread":false},{"title":"course_frm.log <span style='color:#111;'> 69B </span>","children":null,"spread":false},{"title":"load_frm.frm <span style='color:#111;'> 3.10KB </span>","children":null,"spread":false},{"title":"chart_frm.log <span style='color:#111;'> 100B </span>","children":null,"spread":false},{"title":"chart_frm.frm <span style='color:#111;'> 1.30KB </span>","children":null,"spread":false},{"title":"About_frm.frx <span style='color:#111;'> 778B </span>","children":null,"spread":false},{"title":"选课系统说明.txt <span style='color:#111;'> 2.98KB </span>","children":null,"spread":false},{"title":"course_frm.frm <span style='color:#111;'> 32.68KB </span>","children":null,"spread":false},{"title":"MDIForm1.frm <span style='color:#111;'> 8.83KB </span>","children":null,"spread":false},{"title":"login_frm.frx <span style='color:#111;'> 92.64KB </span>","children":null,"spread":false},{"title":"DataReport2.Dsr <span style='color:#111;'> 6.76KB </span>","children":null,"spread":false},{"title":"pass_frm.frx <span style='color:#111;'> 25.13KB </span>","children":null,"spread":false},{"title":"ImageFunc.bas <span style='color:#111;'> 2.50KB </span>","children":null,"spread":false},{"title":"frmuser.frm <span style='color:#111;'> 28.00KB </span>","children":null,"spread":false},{"title":"DataEnvironment1.Dsr <span style='color:#111;'> 3.58KB </span>","children":null,"spread":false},{"title":"data","children":[{"title":"stu.sql <span style='color:#111;'> 7.81KB </span>","children":null,"spread":false},{"title":"stu.mdb <span style='color:#111;'> 576.00KB </span>","children":null,"spread":false},{"title":"student_Log.LDF <span style='color:#111;'> 1024.00KB </span>","children":null,"spread":false},{"title":"student_Data.MDF <span style='color:#111;'> 1.56MB </span>","children":null,"spread":false}],"spread":false},{"title":"query_frm.frx <span style='color:#111;'> 46.32KB </span>","children":null,"spread":false},{"title":"选课系统.vbw <span style='color:#111;'> 345B </span>","children":null,"spread":false},{"title":"t_choice_frm.frm <span style='color:#111;'> 11.96KB </span>","children":null,"spread":false},{"title":"course_frm.frx <span style='color:#111;'> 46.32KB </span>","children":null,"spread":false},{"title":"DataReport2.DCA <span style='color:#111;'> 46.43KB </span>","children":null,"spread":false},{"title":"DataEnvironment1.DCA <span style='color:#111;'> 3.99KB </span>","children":null,"spread":false},{"title":"choice_frm.frx <span style='color:#111;'> 84B </span>","children":null,"spread":false},{"title":"teacher1_frm.log <span style='color:#111;'> 69B </span>","children":null,"spread":false}],"spread":false}],"spread":true}]

评论信息

  • weixin_44048170 :
    很好用用用用
    2018-12-16
  • sinat_26398225 :
    还可以吧，就是简单了点儿
    2015-06-02
  • liang149432145 :
    软件，很好，数据库差一点
    2014-06-25
  • ahaikh :
    下载后,VBP文件无法加载，浪费分数和时间了
    2014-03-08
  • Mr_xxx :
    下载后,VBP文件无法加载，浪费分数和时间了
    2014-02-27

其他资源

免责申明

【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明

个人信息

下载历史

相关资源标签

热门下载

最新下载