package com.cqipc.tsj.dao;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import com.cqipc.tsj.model.Back;
import com.cqipc.tsj.model.BookInfo;
import com.cqipc.tsj.model.BookType;
import com.cqipc.tsj.model.Borrow;
import com.cqipc.tsj.model.Operator;
import com.cqipc.tsj.model.Order;
import com.cqipc.tsj.model.Reader;
public class Dao {
protected static String dbClassName = "";
protected static String dbUrl = "";
protected static String dbUser = "";
protected static String dbPwd = "";
private static Connection conn = null;
static {
Properties props = new Properties();
try {
props.load(new FileInputStream("sqlserver.ini"));
dbClassName = props.getProperty("driver");
dbUrl = props.getProperty("url");
dbUser = props.getProperty("userName");
dbPwd = props.getProperty("userPwd");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private Dao() {
try {
if (conn == null) {
Class.forName(dbClassName);
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
public static ResultSet executeQuery(String sql) {
try {
if (conn == null)
new Dao();
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
return null;
} finally {
}
}
public static int executeUpdate(String sql) {
try {
if (conn == null)
new Dao();
return conn.createStatement().executeUpdate(sql);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
return -1;
} finally {
}
}
public static void close() {
try {
conn.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
} finally {
conn = null;
}
}
public static Operator check(String name, String password) {
Operator operator = new Operator();
String sql = "select * from tb_operator where name = '" + name + "' and password = '" + password
+ "' and admin=1";
ResultSet rs = Dao.executeQuery(sql);
try {
while (rs.next()) {
operator.setId(rs.getString("id"));
operator.setName(rs.getString("name"));
operator.setGrade(rs.getString("admin"));
operator.setPassword(rs.getString("password"));
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
Dao.close();
return operator;
}
public static List selectBookCategory() {
// TODO Auto-generated method stub
List list = new ArrayList();
String sql = "select * from tb_bookType";
ResultSet rs = executeQuery(sql);
try {
while (rs.next()) {
BookType type = new BookType();
type.setId(rs.getString("id"));
type.setTypeName(rs.getString("typeName"));
type.setDays(rs.getString("days"));
type.setFK(rs.getString("fk"));
list.add(type);
}
} catch (Exception e) {
// TODO: handle exception
}
Dao.close();
return list;
}
public static BookInfo selectBookInfoByISBN(String isbn) {
BookInfo bookInfo = null;
String sql = "select * from tb_bookInfo where ISBN='" + isbn + "'";
ResultSet rs = executeQuery(sql);
try {
while (rs.next()) {
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"));
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
Dao.close();
return bookInfo;
}
public static List selectBookInfo() {
List list = new ArrayList();
String sql = "select * from tb_bookInfo";
BookInfo bookInfo;
ResultSet rs = executeQuery(sql);
try {
while (rs.next()) {
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) {
// TODO: handle exception
e.printStackTrace();
}
Dao.close();
return list;
}
/*
* 删除图书信息
*/
public static int deleteBook(String ISBN) {
int i = 0;
try {
String sql = "delete from tb_bookInfo where ISBN='" + ISBN + "'";
i = Dao.executeUpdate(sql);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Dao.close();
return i;
}
public static int insertBook(BookInfo bookInfo) {
int i = 0;
// System.out.println(bookInfo.getDate().toString());
try {
String sql = "insert into tb_bookInfo(ISBN,typeId,bookName,writer,translator,publisher,date,price) values('"
+ bookInfo.getISBN() + "','" + bookInfo.getTypeId() + "','" + bookInfo.getBookName() + "','"
+ bookInfo.getWriter() + "','" + bookInfo.getTranslator() + "','" + bookInfo.getPublisher() + "','"
+ new java.sql.Date(bookInfo.getDate().getTime()) + "'," + bookInfo.getPrice() + ")";
// System.out.println(sql);
i = executeUpdate(sql);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
Dao.close();
return i;
}
public static int updateBook(BookInfo bookInfo) {
int i = 0;
try {
String sql = "update tb_bookInfo set ISBN='" + bookInfo.getISBN() + "', typeId='" + bookInfo.getTypeId()
+ "', bookName='" + bookInfo.getBookName() + "', writer='" + bookInfo.getWriter()
+ "', translator='" + bookInfo.getTranslator() + "', publisher='" + bookInfo.getPublisher()
+ "', date='" + new java.sql.Date(bookInfo.getDate().getTime()) + "', price=" + bookInfo.getPrice()
+ " where ISBN='" + bookInfo.getISBN() + "'";
// System.out.println(sql);
i = executeUpdate(sql);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
Dao.close();
return i;
}
/*
* 查找操作员
*/
public static Operator selectOperator(String name) {
Operator operater = new Operator();
String sql = "select * from tb_operator where name='" + name + "'";
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 (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Dao.close();
return operater;
}
public static Operator selectOperator(String name, String password) {
Operator operater = new Operator();
String sql = "select * from tb_operator where name='" + name + "' and password='" + password + "'";
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 (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Dao.close();
return operater;
}
/*
* 更改操作员密码
*/
public static int updateOperator(
基于java的图书管理系统＋sqlserver数据库 （148个子文件） 
Dao.class 18KB ReaderMoidAndDelFrame.class 9KB BookModiAndDelFrame.class 8KB BookBackIFrame.class 7KB BookSearchIFrame.class 6KB BookTypeModiAndDelIFrame.class 6KB ReaderAddIFrame.class 6KB BookAddFrame.class 6KB Library.class 6KB UserModiAndDelIFame.class 5KB BookBorrowIFrame.class 5KB NewBookCheckAccept.class 5KB ReaderMoidAndDelFrame$ModifyReaderListener.class 4KB BookLoginFrame.class 4KB NewBookOrderIFrame.class 4KB ReaderAddIFrame$AddReaderListener.class 4KB BookModiAndDelFrame$UpdateBookActionListener.class 4KB ModifyPass.class 4KB Library$MenuActions.class 3KB BookAddFrame$AddBookActionListener.class 3KB BookTypeAddIFrame.class 3KB UserAddIFrame.class 3KB BookModiAndDelFrame$TableListener.class 3KB Reader.class 3KB NewBookOrderIFrame$AddUserListener.class 3KB BookBorrowIFrame$YesListener.class 3KB ReaderMoidAndDelFrame$TableListener.class 3KB BookTypeModiAndDelIFrame$ButtonAddListener.class 3KB BookBackIFrame$YesListener.class 2KB UserModiAndDelIFame$ModiUserListener.class 2KB BookBorrowIFrame$ISBNFocusListener.class 2KB ModifyPass$1.class 2KB BookInfo.class 2KB BookLoginFrame$BookLoginAction.class 2KB BookSearchIFrame$UpdateBookActionListener.class 2KB BookTypeModiAndDelIFrame$ButtonDelListener.class 2KB ReaderMoidAndDelFrame$DeleteReaderListener.class 2KB UserAddIFrame$AddUserListener.class 2KB UserModiAndDelIFame$DelUserListener.class 2KB Library$1.class 2KB Back.class 2KB BookModiAndDelFrame$DeleteListener.class 2KB NewBookCheckAccept$NoCheckListener.class 2KB NewBookCheckAccept$CheckListener.class 2KB Borrow.class 2KB BookTypeAddIFrame$1.class 2KB NewBookCheckAccept$AllCheckListener.class 2KB BookBackIFrame$TableListener.class 2KB BookTypeModiAndDelIFrame$TableListener.class 2KB Order.class 2KB ExitIFrame.class 2KB UserModiAndDelIFame$TableListener.class 1KB BookAddFrame$ISBNFocusListener.class 1KB ModifyPass$PasswordListener.class 1KB Item.class 1KB BookLoginFrame$BookResetAction.class 1KB NewBookCheckAccept$TableListener.class 1KB Operator.class 1KB BookType.class 1KB MyDocument.class 943B BookLoginFrame$1.class 883B BookLoginFrame$2.class 866B BookLoginFrame$3.class 861B ReaderMoidAndDelFrame$1.class 853B ReaderMoidAndDelFrame$2.class 853B BookTypeModiAndDelIFrame$CloseActionListener.class 833B Library$MenuActions$4.class 825B Library$MenuActions$2.class 822B Library$MenuActions$15.class 822B Library$MenuActions$6.class 820B Library$MenuActions$9.class 819B Library$MenuActions$12.class 819B Library$MenuActions$8.class 819B Library$MenuActions$10.class 819B Library$MenuActions$3.class 818B Library$MenuActions$11.class 817B Library$MenuActions$1.class 816B Library$MenuActions$14.class 816B Library$MenuActions$13.class 813B Library$MenuActions$5.class 813B ReaderAddIFrame$1.class 811B ReaderAddIFrame$2.class 811B Library$MenuActions$7.class 811B ReaderMoidAndDelFrame$3.class 789B UserModiAndDelIFame$1.class 777B BookModiAndDelFrame$1.class 777B NewBookOrderIFrame$1.class 771B NewBookCheckAccept$1.class 771B BookTypeAddIFrame$2.class 765B BookAddFrame$CloseActionListener.class 761B BookBorrowIFrame$1.class 759B BookSearchIFrame$1.class 759B ReaderAddIFrame$3.class 753B BookBackIFrame$1.class 747B UserAddIFrame$1.class 741B ExitIFrame$1.class 733B ExitIFrame$2.class 723B ModifyPass$2.class 723B .classpath 430B sqlserver.ini 141B共 148 条
- 1
- 2
资源评论
