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

vb学生选课系统.zip

上传者： mengliao211 | 上传时间：2024/4/2 15:04:23 | 文件大小：1.74MB | 文件类型：zip
vb学生选课系统.zip
可以采用两种方法配置数据库：该系统登录初始账号为admin，初始密码为admin。
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－1.利用SQL语句创建数据库本例使用的后端数据库是Microsoft公司的SQLServer2000，需要配置数据库和并创建表格。
步骤如下：（1）打开SQLServer的企业管理器，并依次打开左边TreeView（树型视图）中的节点：【控制台根目录】-＞【MicrosoftSQLServers】-＞【SQLServer组】-＞【(Local)】-＞【数据库】。
（2）鼠标右键单击“数据库”节点，在弹出的菜单中选择“新建数据库”。
（3）在弹出的对话框中输入数据库名“stu”，单击“确认”按钮，数据库建立成功。
（4）关闭企业管理器，打开SQLServer查询分析器，选择stu数据库（若设置了SQLServer安全性，则还需要输入用户和密码登录到SQLServer）。
（5）在查询分析器中输入如下代码建立数据表结构。
可以直接导入“data”目录下的stu.sql文件运行。
①建立密码表USEstuIFEXISTS(SELECTnameFROMsysobjectsWHEREname='密码'ANDtype='U')DROPTABLE[密码]GoCREATETABLE[密码](用户名nvarchar(50)PRIMARYKEY,密码nvarchar(50),权限nvarchar(50))Go②建立studentinfo表USEstuIFEXISTS(SELECTnameFROMsysobjectsWHEREname='studentinfo'ANDtype='U')DROPTABLEstudentinfoGoCREATETABLEstudentinfo(snonvarchar(50)PRIMARYKEY,snamenvarchar(50),sexnvarchar(50),birthsmalldatetime,telnvarchar(50),addressnvarchar(50),mnvarchar(50),photoimage)Go③建立teacherinfo表USEstuIFEXISTS(SELECTnameFROMsysobjectsWHEREname='teacherinfo'ANDtype='U')DROPTABLEteacherinfoGoCREATETABLEteacherinfo(tnonvarchar(50)PRIMARYKEY,tnamenvarchar(50),titlenvarchar(50),telnvarchar(50),mntext)Go④建立courseinfo表USEstuIFEXISTS(SELECTnameFROMsysobjectsWHEREname='courseinfo'ANDtype='U')DROPTABLEcourseinfoGoCREATETABLEcourseinfo(cnonvarchar(50)PRIMARYKEY,cnamenvarchar(50),chournvarchar(50),creditnvarchar(50),mntext)Go⑤建立course_teacher表USEstuIFEXISTS(SELECTnameFROMsysobjectsWHEREname='course_teacher'ANDtype='U')DROPTABLEcourse_teacherGoCREATETABLEcourse_teacher(idint,cnonvarchar(50),tnonvarchar(50),mntext)Go⑥建立choice表USEstuIFEXISTS(SELECTnameFROMsysobjectsWHEREname='choice'ANDtype='U')DROPTABLEchoiceGoCREATETABLEchoice(idint,stunonvarchar(50),coursenonvarchar(50),teacherno 本软件ID:2717852

文件下载

资源详情

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

个人信息

|

一言

    • 相关资源标签

    热门下载

    最新下载