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+"
没有合适的资源?快使用搜索试试~ 我知道了~
基于java的图书管理系统(java+mssql).zip
共212个文件
class:112个
jpg:52个
java:31个
0 下载量 149 浏览量
2024-04-22
01:16:38
上传
评论
收藏 3.62MB ZIP 举报
温馨提示
【项目资源】:包含前端、后端、移动开发、操作系统、人工智能、物联网、信息化管理、数据库、硬件开发、大数据、课程资源、音视频、网站开发等各种技术项目的源码。包括STM32、ESP8266、PHP、QT、Linux、iOS、C++、Java、python、web、C#、EDA、proteus、RTOS等项目的源码。【项目质量】:所有源码都经过严格测试,可以直接运行。功能在确认正常工作后才上传。【适用人群】:适用于希望学习不同技术领域的小白或进阶学习者。可作为毕设项目、课程设计、大作业、工程实训或初期项目立项。【附加价值】:项目具有较高的学习借鉴价值,也可直接拿来修改复刻。对于有一定基础或热衷于研究的人来说,可以在这些基础代码上进行修改和扩展,实现其他功能。【沟通交流】:有任何使用上的问题,欢迎随时与博主沟通,博主会及时解答。鼓励下载和使用,并欢迎大家互相学习,共同进步。
资源推荐
资源详情
资源评论
收起资源包目录
基于java的图书管理系统(java+mssql).zip (212个子文件)
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
newBookOrderIFrame$DateListener.class 1KB
newBookCheckIFrame$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
newBookOrderIFrame$CloseActionListener.class 787B
newBookCheckIFrame$CloseActionListener.class 787B
BookSearchIFrame$CloseActionListener.class 775B
共 212 条
- 1
- 2
- 3
资源评论
大黄鸭duck.
- 粉丝: 3063
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 基于Python+opencv的多人脸检测,口罩佩戴检测,单目标跟踪
- 基于Selenium的Java爬虫实战(内含谷歌浏览器Chrom和Chromedriver版本121.0.6148.0)
- 基于C++版本的sort算法,可无缝添加在检测器后进行实时多目标跟踪
- 基于物联网的户外环境监测系统设计.docx
- 基于Selenium的Java爬虫实战(内含谷歌浏览器Chrom和Chromedriver版本121.0.6146.0)
- 1_6、CC2530 查询方式使用定时器.pdf
- 测绘程序设计-五点光滑法曲线拟合
- 基于 C++实现的多特征(色调+边缘+纹理)融合的目标跟踪
- 基于Selenium的Java爬虫实战(内含谷歌浏览器Chrom和Chromedriver版本121.0.6142.0)
- php程序设计课程考核实施方案1.doc
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功