package com.wsy.dao;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;
import com.wsy.model.Back;
import com.wsy.model.BookInfo;
import com.wsy.model.BookType;
import com.wsy.model.Borrow;
import com.wsy.model.Operater;
import com.wsy.model.Order;
import com.wsy.model.OrderAndBookInfo;
import com.wsy.model.Reader;
import com.wsy.model.user;
public class Dao {
protected static String dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
protected static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;"
+ "DatabaseName=db_library;SelectMethod=Cursor";
protected static String dbUser = "sa";
protected static String dbPwd = "";
protected static String second = null;
private static Connection conn = null;
private Dao() {
try {
if (conn == null) {
Class.forName(dbClassName).newInstance();
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
}
else
return;
} catch (Exception ee) {
ee.printStackTrace();
}
}
private static ResultSet executeQuery(String sql) {
try {
if(conn==null)
new Dao();
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
return null;
} finally {
}
}
private static int executeUpdate(String sql) {
try {
if(conn==null)
new Dao();
return conn.createStatement().executeUpdate(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
//if(e.getMessage().equals("[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]DELETE 语句与 COLUMN REFERENCE 约束 'FK_TB_BORRO_REFERENCE_TB_BOOKI' 冲突。该冲突发生于数据库 'db_library',表 'tb_borrow', column 'bookISBN'。"))
return -1;
} finally {
}
}
public static void close() {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn = null;
}
}
/*
* 管理员登录方法
*/
public static Operater check(String name, String password) {
int i = 0;
Operater operater=new Operater();
String sql = "select * from tb_operator where name='" + name
+ "' and password='" + password + "'and admin=1";
ResultSet rs = Dao.executeQuery(sql);
try {
while (rs.next()) {
String names = rs.getString(1);
operater.setId(rs.getString("id"));
operater.setName(rs.getString("name"));
operater.setGrade(rs.getString("admin"));
operater.setPassword(rs.getString("password"));
if (names != null) {
i = 1;
}
}
} catch (Exception e) {
e.printStackTrace();
}
Dao.close();
return operater;
}
/*
* 查询类别方法
*/
public static List selectBookCategory() {
List list=new ArrayList();
String sql = "select * from tb_bookType";
ResultSet rs = Dao.executeQuery(sql);
try {
while (rs.next()) {
BookType bookType=new BookType();
bookType.setId(rs.getString("id"));
bookType.setTypeName(rs.getString("typeName"));
bookType.setDays(rs.getString("days"));
bookType.setFk(rs.getString("fk"));
list.add(bookType);
}
} catch (Exception e) {
e.printStackTrace();
}
Dao.close();
return list;
}
public static List selectBookCategory(String bookType) {
List list=new ArrayList();
String sql = "select days from tb_bookType where typeName='"+bookType+"'";
ResultSet rs = Dao.executeQuery(sql);
try {
while (rs.next()) {
BookType type=new BookType();
type.setDays(rs.getString("days"));
list.add(type);
}
} catch (Exception e) {
e.printStackTrace();
}
Dao.close();
return list;
}
/*
* 图书类别表相关操作
*
*/
public static int InsertBookType(String bookTypeName,String days,Double fk){
int i=0;
try{
String sql="insert into tb_bookType(typeName,days,fk) values('"+bookTypeName+"','"+days+"',"+fk+")";
i=Dao.executeUpdate(sql);
}catch(Exception e){
e.printStackTrace();
}
return i;
}
public static int UpdatebookType(String id,String typeName,String days,String fk){
int i=0;
try{
String sql="update tb_bookType set typeName='"+typeName+"',days='"+days+"',fk='"+fk+"' where id='"+id+"'";
//System.out.println(sql);
i=Dao.executeUpdate(sql);
}catch(Exception e){
e.printStackTrace();
}
Dao.close();
return i;
}
// public static int DelbookType(String id){
// int i=0;
// try{
// String sql="delete from tb_bookType where id='"+id+"'";
// //System.out.println(sql);
// i=Dao.executeUpdate(sql);
// }catch(Exception e){
// e.printStackTrace();
// }
// Dao.close();
// return i;
// }
public static List selectBookTypeFk(String bookType) {//取每种书超过规定时间罚款金额
List list=new ArrayList();
String sql = "select * from tb_bookType where typeName='"+bookType+"'";
ResultSet rs = Dao.executeQuery(sql);
try {
while (rs.next()) {
BookType type=new BookType();
type.setFk(rs.getString("fk"));
type.setDays(rs.getString("days"));
list.add(type);
}
} catch (Exception e) {
e.printStackTrace();
}
Dao.close();
return list;
}
/*
* 图书信息表相关操作
*/
/*
* 插入图书信息方法
*/
public static int Insertbook(String ISBN,String typeId,String bookname,String writer,String translator,String publisher,Date date,Double price){
int i=0;
try{
String sql="insert into tb_bookInfo(ISBN,typeId,bookname,writer,translator,publisher,date,price) values('"+ISBN+"','"+typeId+"','"+bookname+"','"+writer+"','"+translator+"','"+publisher+"','"+date+"',"+price+")";
//System.out.println(sql);
i=Dao.executeUpdate(sql);
}catch(Exception e){
System.out.println(e.getMessage());
}
Dao.close();
return i;
}
/*
* 查询图书相关信息
*
*/
public static List selectBookInfo() {
List list=new ArrayList();
String sql = "select * from tb_bookInfo";
ResultSet rs = Dao.executeQuery(sql);
try {
while (rs.next()) {
BookInfo bookinfo=new BookInfo();
bookinfo.setISBN(rs.getString("ISBN"));
bookinfo.setTypeid(rs.getString("typeid"));
bookinfo.setBookname(rs.getString("bookname"));
bookinfo.setWriter(rs.getString("writer"));
bookinfo.setTranslator(rs.getString("translator"));
bookinfo.setPublisher(rs.getString("publisher"));
bookinfo.setDate(rs.getDate("date"));
bookinfo.setPrice(rs.getDouble("price"));
list.add(bookinfo);
}
} catch (Exception e) {
e.printStackTrace();
}
Dao.close();
return list;
}
public static List selectBookInfo(String ISBN) {
List list=new ArrayList();
String sql = "select * from tb_bookInfo where ISBN='"+ISBN+"'";
ResultSet rs = Dao.executeQuery(sql);
try {
while (rs.next()) {
BookInfo bookinfo=new BookInfo();
bookinfo.setISBN(rs.getString("ISBN"));
bookinfo.setTypeid(rs.getString("typeid"));
bookinfo.setBookname(rs.getString("bookname"));
bookinfo.setWriter(rs.getString("writer"));
bookinfo.setTranslator(rs.getString("translator"));
bookinfo.setPublisher(rs.getString("publisher"));
bookinfo.setDate(rs.getDate("date"));
bookinfo.setPrice(rs.getDouble("price"));
list.add(bookinfo);
}
} catch (Exception e) {
e.printStackTrace();
}
Dao.close();
return list;
}
/*
* 修改图书信息方法
*/
public static int Updatebook(String ISBN,String typeId,String bookname,String writer,String translator,String publisher,Date date,Double price){
int i=0;
try{
String sql="update tb_bookInfo set ISBN='"+ISBN+"',typeId='"+typeId+"',bookname='"+bookname+"',writer='"+writer+"',translator='"+translator+"',publisher='"+publisher+"',date='"+date+"',price="+price+" where ISBN='"+ISBN+"
没有合适的资源?快使用搜索试试~ 我知道了~
Library_manage_system_JAVA.rar_图书馆_图书馆管理系统
共213个文件
class:112个
jpg:52个
java:31个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 23 浏览量
2022-09-23
07:50:55
上传
评论
收藏 3.37MB RAR 举报
温馨提示
系统介绍 图书馆管理系统是图书馆管理工作中不可缺少的部分,它对于图书馆的管理者和使用者都非常重要,所以图书馆管理系统应该为管理者与读者提供充足的信息和快捷的数据处理手段,但长期以来,人们使用传统的人工方式或性能较低的图书馆管理系统管理图书馆的日常事务,操作流程比较繁琐。一个成功的图书馆管理系统应提供快速的图书信息检索功能、快捷的图书借阅、归还流程。从读者与图书馆管理员的角度出发,本着以读者借书、还书快捷、方便的原则,本系统具有以下特点:  确保系统具有良好的系统性能,友好的用户界面。  较高的处理效率,便于使用和维护。  采用成熟技术开发,使系统具有较高的技术水平和较长的生命周期。  系统尽可能简化图书馆管理员的重复工作,提高工作效率。  简化数据查询、统计难度。
资源详情
资源评论
资源推荐
收起资源包目录
Library_manage_system_JAVA.rar_图书馆_图书馆管理系统 (213个子文件)
Dao.class 20KB
ReaderModiAndDelIFrame.class 10KB
BookModiAndDelIFrame.class 9KB
BookBorrowIFrame.class 8KB
newBookCheckIFrame.class 8KB
BookBackIFrame.class 8KB
newBookOrderIFrame.class 8KB
UserModiAndDelIFrame.class 7KB
ReaderAddIFrame.class 7KB
BookAddIFrame.class 7KB
Library.class 6KB
BookTypeModiAndDelIFrame.class 6KB
BookSearchIFrame.class 6KB
UserAddIFrame.class 5KB
GengGaiMiMa.class 5KB
BookLoginIFrame.class 4KB
ReaderModiAndDelIFrame$ModiButtonListener.class 4KB
BookModiAndDelIFrame$addBookActionListener.class 4KB
BookTypeAddIFrame.class 4KB
ReaderAddIFrame$ButtonAddListener.class 4KB
UserModiAndDelIFrame$3.class 3KB
BookBorrowIFrame$bookISBNListenerlostFocus.class 3KB
MenuActions.class 3KB
BookAddIFrame$addBookActionListener.class 3KB
OrderAndBookInfo.class 3KB
UserAddIFrame$1.class 3KB
BookBackIFrame$TableListener.class 3KB
newBookOrderIFrame$ButtonAddLisenter.class 3KB
Reader.class 3KB
newBookOrderIFrame$ISBNListenerlostFocus.class 2KB
BookTypeModiAndDelIFrame$ButtonAddListener.class 2KB
BookBorrowIFrame$ISBNListenerlostFocus.class 2KB
newBookCheckIFrame$CheckActionListener.class 2KB
newBookOrderIFrame$ISBNListener.class 2KB
ReaderModiAndDelIFrame$TableListener.class 2KB
newBookCheckIFrame$TableListener.class 2KB
ReaderModiAndDelIFrame$DelButtonListener.class 2KB
BookBorrowIFrame$BorrowActionListener.class 2KB
UserModiAndDelIFrame$1.class 2KB
BookModiAndDelIFrame$TableListener.class 2KB
BookSearchIFrame$1.class 2KB
Back.class 2KB
user.class 2KB
BookInfo.class 2KB
BookTypeAddIFrame$1.class 2KB
BookBackIFrame$BookBackActionListener.class 2KB
UserModiAndDelIFrame$4.class 2KB
BookBorrowIFrame$ClearActionListener.class 2KB
GengGaiMiMa$1.class 2KB
BookLoginIFrame$BookLoginAction.class 2KB
Borrow.class 2KB
Library$1.class 2KB
BookTypeModiAndDelIFrame$TableListener.class 2KB
Order.class 2KB
MenuActions$ReaderModiAction.class 1KB
MenuActions$CheckAndAcceptNewBookAction.class 1KB
MenuActions$ReaderAddAction.class 1KB
MenuActions$UserModiAction.class 1KB
MenuActions$BookTypeModiAction.class 1KB
MenuActions$BookTypeAddAction.class 1KB
MenuActions$BookSearchAction.class 1KB
MenuActions$BoodOrderAction.class 1KB
MenuActions$BorrowAction.class 1KB
MenuActions$GiveBackAction.class 1KB
MenuActions$BookModiAction.class 1KB
MenuActions$PasswordModiAction.class 1KB
MenuActions$UserAddAction.class 1KB
MenuActions$BookAddAction.class 1KB
BookBorrowIFrame$TimeActionListener.class 1KB
BookBackIFrame$TimeActionListener.class 1KB
MapPz.class 1KB
ReaderModiAndDelIFrame$KeepmoneyListener.class 1KB
BookAddIFrame$ISBNFocusListener.class 1KB
BookLoginIFrame$BookResetAction.class 1KB
ReaderAddIFrame$1.class 1KB
newBookCheckIFrame$DateListener.class 1KB
newBookOrderIFrame$DateListener.class 1KB
ReaderAddIFrame$DateListener.class 1KB
Operater.class 1KB
BookType.class 1KB
ReaderModiAndDelIFrame$NumberListener.class 955B
ReaderModiAndDelIFrame$TelListener.class 947B
BookModiAndDelIFrame$NumberListener.class 944B
newBookOrderIFrame$NumberListener.class 931B
BookTypeAddIFrame$NumberListener.class 926B
GengGaiMiMa$2.class 920B
ReaderAddIFrame$NumberListener.class 913B
ReaderAddIFrame$TelListener.class 905B
BookAddIFrame$NumberListener.class 902B
MyDocument.class 899B
BookAddIFrame$ISBNkeyListener.class 894B
BookLoginIFrame$1.class 894B
CreatecdIcon.class 890B
BookBackIFrame$readerISBNListenerlostFocus.class 825B
BookTypeModiAndDelIFrame$CloseActionListener.class 823B
MenuActions$ExitAction.class 813B
UserModiAndDelIFrame$CloseActionListener.class 799B
newBookCheckIFrame$CloseActionListener.class 787B
newBookOrderIFrame$CloseActionListener.class 787B
Item.class 775B
共 213 条
- 1
- 2
- 3
邓凌佳
- 粉丝: 76
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- (源码)基于C#和SQL Server的高校教学管理系统.zip
- (源码)基于Spring Boot和ZooKeeper的分布式系统.zip
- (源码)基于ASP.NET的教学资料管理系统.zip
- (源码)基于Windows系统的扫雷游戏.zip
- CPP金融科技之有效前沿相关参考资料
- (源码)基于LLVM框架的代码生成与优化系统.zip
- (源码)基于Arduino的花盆自动化系统.zip
- (源码)基于ZigBee和STM32的智能家居环境监测监控系统.zip
- (源码)基于TensorFlow的多GPU CIFAR10并行训练系统.zip
- (源码)基于C++和Qt框架的游戏工作室服务器管理系统.zip
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0