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.sqlserver.jdbc.SQLServerDriver";
protected static String dbUrl = "jdbc:sqlserver://localhost:1433;DatabaseName=db_library";
//+ "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
{
Class.forName(dbClassName);
//System.out.println("加载驱动成功！");
}catch(Exception e){
e.printStackTrace();
System.out.println("加载驱动失败！");
}
try{
conn =DriverManager.getConnection(dbUrl,dbUser,dbPwd);
//System.out.println("连接数据库成功！");
}catch(Exception e)
{
e.printStackTrace();
System.out.print("SQL Server连接失败！");
}
/*
try {
if (conn == null) {
Class.forName(dbClassName);
//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().executeQuery(sql);
//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.
Java图书管理系统源代码 （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 BookBackIFrame$TableListener.class 3KB UserAddIFrame$1.class 3KB newBookOrderIFrame$ButtonAddLisenter.class 3KB Reader.class 3KB newBookOrderIFrame$ISBNListenerlostFocus.class 2KB BookTypeModiAndDelIFrame$ButtonAddListener.class 2KB BookBorrowIFrame$ISBNListenerlostFocus.class 2KB newBookOrderIFrame$ISBNListener.class 2KB newBookCheckIFrame$CheckActionListener.class 2KB ReaderModiAndDelIFrame$TableListener.class 2KB newBookCheckIFrame$TableListener.class 2KB ReaderModiAndDelIFrame$DelButtonListener.class 2KB BookBorrowIFrame$BorrowActionListener.class 2KB UserModiAndDelIFrame$1.class 2KB BookSearchIFrame$1.class 2KB BookModiAndDelIFrame$TableListener.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 BookLoginIFrame$1.class 894B BookAddIFrame$ISBNkeyListener.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共 212 条
- 1
- 2
- 3
资源评论
一个会跳舞的程序员
- 粉丝: 0
最新资源
- VS库存管理系统计算机毕业设计方案论文.doc
- 人工智能技术与机械电子工程领域融合研究.docx
- 关于机电工程技术应用及其自动化问题研究.docx
- 高斯光束参数实验教学软件的开发-软件技术.doc
- web开发工程师面试题(含标准答案).docx
- MegEngine -硬件开发资源
- 华侨城信息化建设必要性分析(终).doc
- C语言：学生管理——学生成绩管理.doc
- 企业信息化咨询方法论.doc
- 项目管理部指标分解与管理方案.doc
- 大数据分析与企业创新.docx
- 嵌入式系统外部设备编程实验.doc
- CAD工程制图键盘快捷命令2010.doc
- 国际金融城起步区通信管道培训资料.doc
- 计算机及信息技术的联用探析.docx
- 《计算机应用基础》课程教学的心得.docx
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
