本文介绍了使用vb.net在sqlserver中保存数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有3个表格

table1是tbl_members

table2是tbl_library

table3是tbl_borrowing



tbl_members hase this columns



idmebmer int autoincrement(主键)

name varchar

adress varchar

tel varchar

email varchar



tbl_library hase this columns

idbook int autoincrement(主键)

bookname varchar

bookauthor varchar

类别varchar



tbl_borrowing hase this columns



idmebmer int autoincrement(primary key)''此列来自tbl_members的外键''



idbook int autoincrement(外键)''这一列是来自tbl_library的外键''



data_checkoutbook varchar''时间用户从库中取出书籍的时间

data_retunbook varchar''的时间用户必须将图书归还图书馆



i cane保存表tbl_library和tbl_members中的数据但

如何保存日期tbl_borrowing为用户如何拿起一本书

用户只能拿一本书来支付



或者我如何构建一个数据库一个图书馆管理系统



对不起我的英文

解决方案

i have 3 tablese
table1 is tbl_members
table2 is tbl_library
table3 is tbl_borrowing

tbl_members hase this columns

idmebmer int autoincrement (primary key)
name varchar
adress varchar
tel varchar
email varchar

tbl_library hase this columns
idbook int autoincrement (primary key)
bookname varchar
bookauthor varchar
category varchar

tbl_borrowing hase this columns

idmebmer int autoincrement (primary key) ''this column is from foreign key from tbl_members ''

idbook int autoincrement (foreign key) ''this column is from foreign key from tbl_library''

data_checkoutbook varchar '' the time where the user hase pickup the book from the library
data_retunbook varchar ''the time where the user must return the book to the library

i cane save data in table tbl_library and tbl_members but
how ken i save the date in tbl_borrowing for the user how has pick up a book
the user can only one book pick up

or how to i construk a database for a library menagment system

sorry for my english

解决方案


这篇关于使用vb.net在sqlserver中保存数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-20 07:40
查看更多