/*==============================================================*/
/* Table: tb_admin */
/*==============================================================*/
create table tb_admin (
ID nvarchar(12) not null,
pwd nvarchar(12) not null,
preview nvarchar(4) not null,
constraint PK_TB_ADMIN primary key (ID)
)
/*==============================================================*/
/* Table: tb_book */
/*==============================================================*/
create table tb_book (
ISBN nvarchar(13) not null,
classId nvarchar(4) not null,
typeId nvarchar(4) not null,
bookName nvarchar(40) not null,
writer nvarchar(20) not null,
publisher nvarchar(20) not null,
translator nvarchar(10) null,
publishDate datetime not null,
price money not null,
avialableDays nvarchar(3) not null,
condition nvarchar(1) not null,
counter nvarchar(6) not null,
boolInfo nvarchar(80) null,
collectDate datetime not null,
constraint PK_TB_BOOK primary key (ISBN)
)
/*==============================================================*/
/* Table: tb_class */
/*==============================================================*/
create table tb_class (
classId nvarchar(4) not null,
className nvarchar(20) not null,
constraint PK_TB_CLASS primary key (classId)
)
/*==============================================================*/
/* Table: tb_lent */
/*==============================================================*/
create table tb_lent (
ISBN nvarchar(13) not null,
userId nvarchar(13) null,
borrowDate datetime null,
returnDate datetime null,
ID nvarchar(12) null,
constraint PK_TB_LENT primary key (ISBN)
)
/*==============================================================*/
/* Table: tb_type */
/*==============================================================*/
create table tb_type (
typeId nvarchar(4) not null,
classId nvarchar(4) null,
typeName nvarchar(20) null,
constraint PK_TB_TYPE primary key (typeId)
)
/*==============================================================*/
/* Table: tb_user */
/*==============================================================*/
create table tb_user (
userId nvarchar(13) not null,
username nvarchar(12) null,
pwd nvarchar(12) null,
sex nvarchar(2) null,
birthday datetime null,
faculty nvarchar(24) null,
class nvarchar(24) null,
loginDate datetime null,
pic nvarchar(13) null,
money money null,
bookNo nchar(2) null,
lentDays nchar(3) null,
constraint PK_TB_USER primary key (userId)
)
经典的java，sql图书管理系统 （147个子文件） 
Dao.class 10KB AddUser.class 8KB MainFrame.class 7KB BookBorrow.class 6KB AddBook.class 6KB DeleAdmin.class 5KB AddAdmin.class 5KB DeleUser.class 4KB DeleBook.class 4KB BookReturn.class 4KB AddType.class 4KB Login.class 3KB BookBorrow$2.class 3KB user.class 3KB BookBorrow$1.class 2KB AddUser$2.class 2KB AddBook$1.class 2KB DeleUser$1.class 2KB BookReturn$1.class 2KB DeleBook$1.class 2KB Book.class 2KB DeleAdmin$2.class 2KB BookBorrow$4.class 2KB AddUser$3.class 2KB AddUser$1.class 2KB AddAdmin$1.class 2KB Login$3.class 1KB DeleAdmin$1.class 1KB AddBook$2.class 1KB BookBorrow$3.class 1KB AddType$1.class 1KB BookReturn$2.class 1KB Return.class 1KB DeleBook$2.class 1KB DeleUser$2.class 1KB Login$1.class 947B AddUser$1$1.class 920B MainFrame$BookBorrowAction.class 876B MainFrame$BookReturnAction.class 876B Admin.class 874B MainFrame$DeleAdminAction.class 870B MainFrame$AddAdminAction.class 864B MainFrame$DeleUserAction.class 864B MainFrame$DeleBookAction.class 864B MainFrame$AddUserAction.class 858B MainFrame$AddBookAction.class 858B MainFrame$AddTypeAction.class 858B Item.class 765B BookType.class 719B BookReturn$3.class 693B AddAdmin$2.class 684B DeleBook$3.class 681B DeleUser$3.class 681B AddUser$4.class 675B AddType$2.class 675B AddBook$3.class 675B Login$2.class 673B .classpath 317B Thumbs.db 123KB Thumbs.db 6KB
Java系统编程文档.doc 449KB Java项目总结.doc 55KB
msbase.jar 294KB mssqlserver.jar 67KB msutil.jar 63KB AddUser.java 13KB MainFrame.java 11KB BookBorrow.java 11KB Dao.java 11KB AddBook.java 8KB DeleUser.java 7KB DeleBook.java 6KB BookReturn.java 6KB AddAdmin.java 5KB DeleAdmin.java 5KB Login.java 4KB AddType.java 4KB user.java 2KB Book.java 1KB Return.java 692B Admin.java 463B BookType.java 369B Item.java 355B
login副本.jpg 84KB library.jpg 45KB Javalogo.jpg 2KB library_Log.LDF 1024KB library_Data.MDF 1.13MB
1621086.png 68KB dele_over.png 46KB 05_over.png 45KB 04_over.png 45KB 07_over.png 45KB 08_over.png 45KB sele_over.png 45KB search_over.png 45KB dele.png 45KB borrow_over.png 45KB 05.png 45KB 04.png 45KB共 147 条
- 1
- 2
- 1
- 2
- 3
- 4
前往页