package com.sanqing.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.sanqing.model.Back;
import com.sanqing.model.BookInfo;
import com.sanqing.model.BookType;
import com.sanqing.model.Borrow;
import com.sanqing.model.Operater;
import com.sanqing.model.Order;
import com.sanqing.model.OrderAndBookInfo;
import com.sanqing.model.Reader;
import com.sanqing.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;";//数据库连接URL
protected static String dbUser = "sa"; //数据库用户名
protected static String dbPwd = "123456"; //数据库密码
private static Connection conn = null; //数据库连接对象
private Dao() { //默认构造函数
try {
if (conn == null) { //如果连接对象为空
Class.forName(dbClassName); //加载驱动类
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);//获得连接对象
}
} 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; //返回null值
} finally {
}
}
private static int executeUpdate(String sql) { //更新方法
try {
if(conn==null) new Dao(); //如果连接对象为空，则重新调用构造方法
return conn.createStatement().executeUpdate(sql);//执行更新
} catch (SQLException e) {
e.printStackTrace();
return -1;
} finally {
}
}
public static void close() {//关闭方法
try {
conn.close();//关闭连接对象
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn = null; //设置连接对象为null值
}
}
/*
* 管理员登录方法
*/
public static Operater check(String name, String password) {
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()) {//如果查询到了记录
operater.setId(rs.getString("id"));//设置操作员编号
operater.setName(rs.getString("name"));//设置操作员用户名
operater.setGrade(rs.getString("admin"));//设置操作员等级
operater.setPassword(rs.getString("password"));//设置管理员密码
}
} 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+")";
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
图书馆管理系统 （java+数据库）
4星 · 超过85%的资源 需积分: 16 44 浏览量
2013-07-06
11:19:46
上传
评论 1
收藏 9.33MB ZIP 举报 
图书馆管理系统 （java+数据库） （608个子文件） 
Dao.class 18KB Dao.class 18KB Dao.class 18KB ReaderModiAndDelIFrame.class 10KB ReaderModiAndDelIFrame.class 10KB ReaderModiAndDelIFrame.class 10KB BookModiAndDelIFrame.class 9KB BookModiAndDelIFrame.class 9KB BookModiAndDelIFrame.class 9KB BookBorrowIFrame.class 8KB BookBorrowIFrame.class 8KB BookBorrowIFrame.class 8KB newBookCheckIFrame.class 8KB newBookCheckIFrame.class 8KB newBookCheckIFrame.class 8KB BookBackIFrame.class 8KB BookBackIFrame.class 8KB BookBackIFrame.class 8KB UserModiAndDelIFrame.class 7KB UserModiAndDelIFrame.class 7KB UserModiAndDelIFrame.class 7KB newBookOrderIFrame.class 7KB newBookOrderIFrame.class 7KB newBookOrderIFrame.class 7KB BookAddIFrame.class 7KB BookAddIFrame.class 7KB BookAddIFrame.class 7KB Library.class 7KB Library.class 7KB Library.class 7KB ReaderAddIFrame.class 6KB ReaderAddIFrame.class 6KB ReaderAddIFrame.class 6KB BookTypeModiAndDelIFrame.class 6KB BookTypeModiAndDelIFrame.class 6KB BookTypeModiAndDelIFrame.class 6KB BookSearchIFrame.class 6KB BookSearchIFrame.class 6KB BookSearchIFrame.class 6KB UserAddIFrame.class 5KB UserAddIFrame.class 5KB UserAddIFrame.class 5KB BookLoginIFrame.class 5KB BookLoginIFrame.class 5KB BookLoginIFrame.class 5KB GengGaiMiMa.class 5KB GengGaiMiMa.class 5KB GengGaiMiMa.class 5KB ReaderModiAndDelIFrame$ModiButtonListener.class 4KB ReaderModiAndDelIFrame$ModiButtonListener.class 4KB ReaderModiAndDelIFrame$ModiButtonListener.class 4KB BookTypeAddIFrame.class 4KB BookTypeAddIFrame.class 4KB BookTypeAddIFrame.class 4KB BookModiAndDelIFrame$UpdateBookActionListener.class 4KB BookModiAndDelIFrame$UpdateBookActionListener.class 4KB BookModiAndDelIFrame$UpdateBookActionListener.class 4KB MenuActions.class 3KB MenuActions.class 3KB MenuActions.class 3KB UserModiAndDelIFrame$3.class 3KB UserModiAndDelIFrame$3.class 3KB UserModiAndDelIFrame$3.class 3KB OrderAndBookInfo.class 3KB OrderAndBookInfo.class 3KB OrderAndBookInfo.class 3KB BookAddIFrame$AddBookActionListener.class 3KB UserAddIFrame$1.class 3KB BookAddIFrame$AddBookActionListener.class 3KB UserAddIFrame$1.class 3KB BookAddIFrame$AddBookActionListener.class 3KB UserAddIFrame$1.class 3KB BookBackIFrame$TableListener.class 3KB BookBackIFrame$TableListener.class 3KB BookBackIFrame$TableListener.class 3KB Reader.class 3KB Reader.class 3KB Reader.class 3KB BookTypeModiAndDelIFrame$ButtonAddListener.class 2KB BookTypeModiAndDelIFrame$ButtonAddListener.class 2KB BookTypeModiAndDelIFrame$ButtonAddListener.class 2KB newBookOrderIFrame$ISBNListener.class 2KB newBookOrderIFrame$ISBNListener.class 2KB newBookOrderIFrame$ISBNListener.class 2KB newBookCheckIFrame$CheckActionListener.class 2KB newBookCheckIFrame$CheckActionListener.class 2KB newBookCheckIFrame$CheckActionListener.class 2KB ReaderModiAndDelIFrame$TableListener.class 2KB ReaderModiAndDelIFrame$TableListener.class 2KB ReaderModiAndDelIFrame$TableListener.class 2KB newBookCheckIFrame$TableListener.class 2KB newBookCheckIFrame$TableListener.class 2KB newBookCheckIFrame$TableListener.class 2KB ReaderModiAndDelIFrame$DelButtonListener.class 2KB ReaderModiAndDelIFrame$DelButtonListener.class 2KB ReaderModiAndDelIFrame$DelButtonListener.class 2KB BookModiAndDelIFrame$TableListener.class 2KB BookModiAndDelIFrame$TableListener.class 2KB BookModiAndDelIFrame$TableListener.class 2KB BookSearchIFrame$1.class 2KB共 608 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
zrd15112015-05-18程序可以运行，值得学习- Keven小卫2013-07-10感觉跟其他的做的图书项目差不多 大同小异啊
苍苍苍2014-10-24确实是和其他项目差不多、。。
