sql 查询.sql

一个图书馆的VB做的mis系统

use lib
go 

select * from books

select books_id as 书籍ID,b_name as 书名,b_author as 作者,b_type as 类型 ,b_isbn as ISBN,b_pub as 出版社,b_have as 在库否, b_address 存放位置,b_p_date as 出版日期,b_price as 价格, b_reg_date as 入库日期,b_text as 备注信息,b_oper as 操作员 from books


select * from borrow

select borrow_id as 借阅ID,br_u_name as 用户名,br_b_name as 书名,br_isbn as ISBN,br_price as 书籍价格,br_b_date as 借出日期,br_r_date as 应归还日期,br_text as 备注,br_oper as 操作员 from borrow


select * from users

select * from return_b

select * from admin


select   books_id as ID,b_name as 书名,b_author as 作者,b_type as 类型 ,b_isbn as ISBN,b_pub as 出版社,b_p_date as 出版日期,b_price as 价格, b_reg_date as 入库日期,b_have as 在库否, b_address 存放位置 from books

select borrow_id as 借阅ID,br_u_name as 用户名,br_b_name as 书名,br_isbn as ISBN,br_b_date as 借出日期,br_r_date as 应归还日期 from borrow


select  users_id as 用户ID,books_id as 书籍ID ,re_u_name as 用户姓名,re_b_name as 书名,re_isbn as ISBN,re_r_date as 归还日期   from return_b


select   books_id as ID,b_name as 书名,b_author as 作者,b_type as 类型 ,b_isbn as ISBN,b_pub as 出版社,b_p_date as 出版日期,b_price as 价格, b_reg_date as 入库日期,b_have as 在库否, b_address 存放位置 from books where b_name like '%c%'


select * from users
select   users_id as 用户ID,u_name as 姓名,u_sex as 性别,u_dep as 部门 ,u_phone as 联系电话, u_address as 联系地址,u_reg_date as 注册日期,u_text as 备注 from users

select * from return_b
select  users_id as 用户ID,books_id as 书籍ID ,re_u_name as 用户姓名,re_b_name as 书名,re_isbn as ISBN,re_price as 书籍价格,re_r_date as 归还日期 ,re_br_date as 借出日期  from return_b

select  users_id as 用户ID,books_id as 书籍ID ,re_u_name as 用户姓名,re_b_name as 书名,re_isbn as ISBN,re_price as 书籍价格,re_r_date as 归还日期 ,re_br_date as 借出日期  from return_b where (re_r_date-re_br_date)>30


select * from borrow
select borrow_id as 借阅ID,br_u_name as 用户名,br_b_name as 书名,br_isbn as ISBN,br_price as 书籍价格,br_b_date as 借出日期,br_r_date as 应归还日期,br_text as 备注 from borrow


select * from users
select   users_id as 用户ID,u_name as 姓名,u_sex as 性别,u_dep as 部门 ,u_phone as 联系电话, u_address as 联系地址,u_reg_date as 注册日期,u_text as 备注,u_oper as 操作员 from users

select   users_id as 用户ID,u_name as 姓名,u_sex as 性别,u_dep as 部门 ,u_phone as 联系电话, u_address as 联系地址,u_reg_date as 注册日期,u_text as 备注 from users where u_reg_date like  'XGY'


select * from admin
select   admin_id as 管理员ID,a_name as 姓名,a_pwd as 密码,a_type as 管理员类型, a_oper as 操作员 from admin