package com.dao;
import com.core.ConnDB;
import java.util.*;
import com.actionForm.BorrowForm;
import java.sql.*;
import com.actionForm.ReaderForm;
import com.actionForm.BookForm;
import java.util.Date;
public class BorrowDAO {
ConnDB conn = new ConnDB();
public int insert() {
String sql = "INSERT INTO tb_borrow (bookid) vlaues(1) ";
int ret = conn.executeUpdate(sql);
return ret;
}
//*****************************图书借阅******************************
public int insertBorrow(ReaderForm readerForm,BookForm bookForm,String operator){
//获取系统日期
Date dateU=new Date();
java.sql.Date date=new java.sql.Date(dateU.getTime());
String sql1="select t.days from tb_bookinfo b left join tb_booktype t on b.typeid=t.id where b.id="+bookForm.getId()+"";
ResultSet rs=conn.executeQuery(sql1);
int days=0;
try {
if (rs.next()) {
days = rs.getInt(1);
}
} catch (SQLException ex) {
}
//计算归还时间
String date_str=String.valueOf(date);
String dd = date_str.substring(8,10);
String DD = date_str.substring(0,8)+String.valueOf(Integer.parseInt(dd) + days);
java.sql.Date backTime= java.sql.Date.valueOf(DD);
String sql ="Insert into tb_borrow (readerid,bookid,borrowTime,backTime,operator) values("+readerForm.getId()+","+bookForm.getId()+",'"+date+"','"+backTime+"','"+operator+"')";
int falg = conn.executeUpdate(sql);
System.out.println("添加图书借阅信息的SQL:" + sql);
conn.close();
return falg;
}
//*************************************图书继借*********************************
public int renew(int id){
String sql0="SELECT bookid FROM tb_borrow WHERE id="+id+"";
ResultSet rs1=conn.executeQuery(sql0);
int flag=0;
try {
if (rs1.next()) {
//获取系统日期
Date dateU = new Date();
java.sql.Date date = new java.sql.Date(dateU.getTime());
String sql1 = "select t.days from tb_bookinfo b left join tb_booktype t on b.typeid=t.id where b.id=" +
rs1.getInt(1) + "";
ResultSet rs = conn.executeQuery(sql1);
int days = 0;
try {
if (rs.next()) {
days = rs.getInt(1);
}
} catch (SQLException ex) {
}
//计算归还时间
String date_str = String.valueOf(date);
String dd = date_str.substring(8, 10);
String DD = date_str.substring(0, 8) +
String.valueOf(Integer.parseInt(dd) + days);
java.sql.Date backTime = java.sql.Date.valueOf(DD);
String sql = "UPDATE tb_borrow SET backtime='" + backTime +
"' where id=" + id + "";
flag = conn.executeUpdate(sql);
}
} catch (NumberFormatException ex1) {
} catch (SQLException ex1) {
}
conn.close();
return flag;
}
//*************************************图书归还*********************************
public int back(int id,String operator){
String sql0="SELECT readerid,bookid FROM tb_borrow WHERE id="+id+"";
ResultSet rs1=conn.executeQuery(sql0);
int flag=0;
try {
if (rs1.next()) {
//获取系统日期
Date dateU = new Date();
java.sql.Date date = new java.sql.Date(dateU.getTime());
int readerid=rs1.getInt(1);
int bookid=rs1.getInt(2);
String sql1="INSERT INTO tb_giveback (readerid,bookid,backTime,operator) VALUES("+readerid+","+bookid+",'"+date+"','"+operator+"')";
int ret=conn.executeUpdate(sql1);
if(ret==1){
String sql2 = "UPDATE tb_borrow SET ifback=1 where id=" + id +
"";
flag = conn.executeUpdate(sql2);
}else{
flag=0;
}
}
} catch (NumberFormatException ex1) {
} catch (SQLException ex1) {
}
conn.close();
return flag;
}
//*****************************查询图书借阅信息************************
public Collection borrowinfo(String str){
String sql="select borr.*,book.bookname,book.price,pub.pubname,bs.name bookcasename,r.barcode from (select * from tb_borrow where ifback=0) as borr left join tb_bookinfo book on borr.bookid=book.id join tb_publishing pub on book.isbn=pub.isbn join tb_bookcase bs on book.bookcase=bs.id join tb_reader r on borr.readerid=r.id where r.barcode='"+str+"'";
ResultSet rs=conn.executeQuery(sql);
Collection coll=new ArrayList();
BorrowForm form=null;
try {
while (rs.next()) {
form = new BorrowForm();
form.setId(Integer.valueOf(rs.getInt(1)));
form.setBorrowTime(rs.getString(4));
form.setBackTime(rs.getString(5));
form.setBookName(rs.getString(8));
form.setPrice(Float.valueOf(rs.getFloat(9)));
form.setPubName(rs.getString(10));
form.setBookcaseName(rs.getString(11));
coll.add(form);
}
} catch (SQLException ex) {
System.out.println("借阅信息:"+ex.getMessage());
}
conn.close();
return coll;
}
//*************************到期提醒******************************************
public Collection bremind(){
Date dateU = new Date();
java.sql.Date date = new java.sql.Date(dateU.getTime());
String sql="select borr.borrowTime,borr.backTime,book.barcode,book.bookname,r.name readername,r.barcode readerbarcode from tb_borrow borr join tb_bookinfo book on book.id=borr.bookid join tb_reader r on r.id=borr.readerid where borr.backTime <='"+date+"'";
ResultSet rs=conn.executeQuery(sql);
System.out.println("到时提醒的SQL:"+sql);
Collection coll=new ArrayList();
BorrowForm form=null;
try {
while (rs.next()) {
form = new BorrowForm();
form.setBorrowTime(rs.getString(1));
form.setBackTime(rs.getString(2));
form.setBookBarcode(rs.getString(3));
form.setBookName(rs.getString(4));
form.setReaderName(rs.getString(5));
form.setReaderBarcode(rs.getString(6));
coll.add(form);
System.out.println("图书条形码:"+rs.getString(3));
}
} catch (SQLException ex) {
System.out.println(ex.getMessage());
}
conn.close();
return coll;
}
//*************************图书借阅查询******************************************
public Collection borrowQuery(String strif){
String sql="";
if(strif!="all" && strif!=null && strif!=""){
sql="select * from (select borr.borrowTime,borr.backTime,book.barcode,book.bookname,r.name readername,r.barcode readerbarcode,borr.ifback from tb_borrow borr join tb_bookinfo book on book.id=borr.bookid join tb_reader r on r.id=borr.readerid) as borr where borr."+strif+"";
}else{
sql="select * from (select borr.borrowTime,borr.backTime,book.barcode,book.bookname,r.name readername,r.barcode readerbarcode,borr.ifback from tb_borrow borr join tb_bookinfo book on book.id=borr.bookid join tb_reader r on r.id=borr.readerid) as borr";
}
ResultSet rs=conn.executeQuery(sql);
System.out.println("图书借阅查询的SQL:"+sql);
Collection coll=new ArrayList();
BorrowForm form=null;
try {
while (rs.next()) {
form = new BorrowForm();
form.se
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
图书馆管理系统由读者管理、图书管理、借阅、归还、续借、系统查询、排行榜、系统设置等管理模块组成,其规划功能模块如下: 读者管理 读者管理主要实现读者类型管理、读者档案管理等功能。 图书管理 图书管理主要实现图书类型设置、图书档案管理等功能。 借阅 借阅主要实现读者借阅图书功能。 续借 借阅主要实现读者续借图书功能。 归还 归还主要实现读者归还图书功能。 系统查询 系统查询主要实现图书档案查询、图书借阅查询、借阅到期提醒等功能。 排行榜 排行榜主要实现读者借阅排行榜、图书借阅排行榜等功能。 系统设置 系统设置主要实现图书馆信息、管理员添加、参数设置、书架设置、修改口令等功能。
资源推荐
资源详情
资源评论
收起资源包目录
图书馆管理系统课程设计全部源码(java工程) (190个子文件)
BorrowDAO.class 9KB
BookDAO.class 7KB
ManagerDAO.class 6KB
Borrow.class 6KB
Manager.class 6KB
Book.class 5KB
ReaderDAO.class 5KB
BorrowForm.class 5KB
Reader.class 5KB
ReaderType.class 4KB
BookForm.class 4KB
BookType.class 4KB
BookCase.class 4KB
ReaderTypeDAO.class 4KB
BookTypeDAO.class 4KB
ReaderForm.class 3KB
BookCaseDAO.class 3KB
Library.class 3KB
LibraryDAO.class 2KB
Parameter.class 2KB
ConnDB.class 2KB
Publishing.class 2KB
LibraryForm.class 2KB
ManagerForm.class 2KB
ParameterDAO.class 2KB
PublishingDAO.class 1KB
PublishingForm.class 1KB
ReaderTypeForm.class 1022B
BookTypeForm.class 1018B
ParameterForm.class 957B
ChStr.class 922B
BookCaseForm.class 811B
.classpath 583B
style.css 3KB
Thumbs.db 5KB
程序使用说明书.doc 43KB
tb_reader.frm 9KB
tb_bookinfo.frm 9KB
tb_library.frm 9KB
tb_borrow.frm 9KB
tb_purview.frm 9KB
tb_giveback.frm 9KB
tb_booktype.frm 8KB
tb_parameter.frm 8KB
tb_readertype.frm 8KB
tb_manager.frm 8KB
tb_publishing.frm 8KB
tb_bookcase.frm 8KB
logbg.GIF 97KB
item_over.gif 2KB
item_out.gif 2KB
queding.gif 1KB
bg.gif 985B
chongzhi.gif 329B
BorrowDAO.java 11KB
Borrow.java 10KB
ManagerDAO.java 8KB
Book.java 8KB
Manager.java 7KB
Reader.java 7KB
BookDAO.java 7KB
ReaderDAO.java 5KB
ReaderType.java 5KB
BookType.java 5KB
BookCase.java 5KB
BorrowForm.java 4KB
BookForm.java 3KB
ReaderForm.java 3KB
ReaderTypeDAO.java 3KB
BookCaseDAO.java 3KB
BookTypeDAO.java 3KB
Library.java 3KB
ConnDB.java 2KB
Parameter.java 2KB
LibraryDAO.java 2KB
LibraryForm.java 2KB
Publishing.java 2KB
ManagerForm.java 2KB
ParameterDAO.java 1KB
PublishingForm.java 979B
PublishingDAO.java 793B
ParameterForm.java 651B
ReaderTypeForm.java 650B
BookTypeForm.java 627B
ChStr.java 563B
BookCaseForm.java 493B
top3.jpg 106KB
down.jpg 46KB
top1.jpg 43KB
borrowBookSort.jpg 40KB
bookArchivesManager.jpg 36KB
readBorrow.jpg 36KB
bg.jpg 24KB
bgdown.jpg 21KB
top2.jpg 20KB
top6.jpg 20KB
top5.jpg 19KB
top4.jpg 19KB
bdown.jpg 18KB
menu.JS 9KB
共 190 条
- 1
- 2
宝宝要努力
- 粉丝: 175
- 资源: 14
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
前往页