package cn.nongda.dao.impl;
import cn.nongda.dao.ManagerDao;
import cn.nongda.pojo.dto.BookStatus;
import cn.nongda.pojo.entity.Book;
import cn.nongda.pojo.entity.Category;
import cn.nongda.pojo.entity.Manager;
import cn.nongda.pojo.entity.User;
import cn.nongda.utils.JDBCUtil;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class ManagerDaoImpl implements ManagerDao {
/**
* 跟据账户查询
* @param account
* @return
*/
@Override
public Manager findByAccount(String account) {
ResultSet rs =null;
PreparedStatement pst=null;
Manager manager = null;
Connection conn = JDBCUtil.getconn();
String sql = "select * from manager where account = ?";
try {
pst = conn.prepareStatement(sql);
pst.setString(1,account);
rs = pst.executeQuery();
while (rs.next()){
manager=new Manager();
manager.setId(rs.getInt(1));
manager.setAccount(rs.getString(2));
manager.setPassword(rs.getString(3));
manager.setStatus(rs.getInt(4));
manager.setIdentity(rs.getInt(5));
}
return manager;
} catch (SQLException e) {
throw new RuntimeException(e);
}finally {
JDBCUtil.close(conn,pst,rs);
}
}
@Override
public Manager checkPassword(String account, String password) {
Connection conn=null;
ResultSet rs =null;
PreparedStatement pst=null;
Manager manager = null;
conn = JDBCUtil.getconn();
String sql = "select * from manager where account = ? and password =?";
try {
pst = conn.prepareStatement(sql);
pst.setString(1,account);
pst.setString(2,password);
rs = pst.executeQuery();
while (rs.next()){
manager=new Manager();
manager.setId(rs.getInt(1));
manager.setAccount(rs.getString(2));
manager.setPassword(rs.getString(3));
manager.setStatus(rs.getInt(4));
manager.setIdentity(rs.getInt(5));
}
return manager;
} catch (SQLException e) {
throw new RuntimeException(e);
}finally {
JDBCUtil.close(conn,pst,rs);
}
}
@Override
public void add(String account, String password) {
Connection conn=null;
PreparedStatement pst=null;
conn = JDBCUtil.getconn();
String sql = "insert into manager(account,password) values (?,?)";
try {
pst=conn.prepareStatement(sql);
pst.setString(1,account);
pst.setString(2,password);
pst.executeUpdate();
} catch (SQLException e) {
throw new RuntimeException(e);
}finally {
JDBCUtil.close(conn,pst);
}
}
@Override
public Category findByName(String name) {
Connection conn=null;
ResultSet rs =null;
PreparedStatement pst=null;
Category category = null;
conn = JDBCUtil.getconn();
String sql = "select * from category where name = ?";
try {
pst = conn.prepareStatement(sql);
pst.setString(1,name);
rs = pst.executeQuery();
while (rs.next()){
category=new Category();
category.setId(rs.getInt(1));
category.setName(rs.getString(2));
category.setManagerId(rs.getInt(3));
if (rs.getDate(4) != null) {
category.setCreateTime(rs.getString(4));
} else {
category.setCreateTime(null);
}
if (rs.getDate(5) != null) {
category.setUpdateTime(rs.getString(5));
} else {
category.setUpdateTime(null);
}
}
return category;
} catch (SQLException e) {
throw new RuntimeException(e);
}finally {
JDBCUtil.close(conn,pst,rs);
}
}
@Override
public void addCategory(Category category) {
PreparedStatement pst=null;
Connection conn = JDBCUtil.getconn();
String sql = "insert into category(name,manager_id,create_time,update_time) values (?,?,?,?)";
try {
pst=conn.prepareStatement(sql);
pst.setString(1,category.getName());
System.out.println("Category Name: " + category.getName()); // 调试输出
pst.setInt(2,category.getManagerId());
pst.setDate(3, Date.valueOf(category.getCreateTime()));
pst.setDate(4, Date.valueOf(category.getUpdateTime()));
pst.executeUpdate();
} catch (SQLException e) {
throw new RuntimeException(e);
}finally {
JDBCUtil.close(conn,pst);
}
}
@Override
public Book findBookByName(String bookName) {
ResultSet rs =null;
PreparedStatement pst=null;
Book book =null;
Connection conn = JDBCUtil.getconn();
String sql = "select * from book_message where book_name = ?";
try {
pst = conn.prepareStatement(sql);
pst.setString(1,bookName);
rs = pst.executeQuery();
while (rs.next()){
book = new Book(
rs.getInt(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
rs.getInt(5),
rs.getInt(6),
rs.getInt(7),
rs.getString(8),
rs.getDouble(9),
rs.getString(10),
rs.getString(11));
}
return book;
} catch (SQLException e) {
throw new RuntimeException(e);
}finally {
JDBCUtil.close(conn,pst,rs);
}
}
/**
* 跟据目录名称查找目录id
* @param categoryName
* @return
*/
@Override
public Integer findCategoryId(String categoryName) {
ResultSet rs =null;
PreparedStatement pst=null;
Integer id=null;
Connection conn = JDBCUtil.getconn();
String sql = "select id from category where name = ?";
try {
pst = conn.prepareStatement(sql);
pst.setString(1,categoryName);
rs = pst.executeQuery();
while (rs.next()){
id=rs.getInt(1);
}
return id;
} catch (SQLException e) {
throw new RuntimeException(e);
}finally {
JDBCUtil.close(conn,pst,rs);
}
}
/**
* 添加图书
* @param book
*/
@Override
public void addBook(Book book) {
PreparedStatement pst=null;
Connection conn = JDBCUtil.getconn();
String sql = "insert into book_message" +
"(book_name, auther, introduction, borrow_count, max_count, category_id, publisher, price, create_time, update_time) values (?,?,?,?,?,?,?,?,?,?)";
try {
pst=conn.prepareStatement(sql);
pst.setString(1,book.getBookName());
pst.setString(2,book.getAuther());
pst.setString(3,book.getIntroduction());
pst.setInt(4,book.getBorrowCount());
pst.setInt(5,book.getMaxCount());
if (book.getCategoryId()!=null) {
pst.setInt(6, book.getCategoryId());
}else {
pst.setIn
没有合适的资源?快使用搜索试试~ 我知道了~
book源代码.zip
共109个文件
java:56个
jsp:15个
css:15个
需积分: 0 0 下载量 55 浏览量
2024-05-16
16:30:52
上传
评论
收藏 3.64MB ZIP 举报
温馨提示
book源代码.zip
资源推荐
资源详情
资源评论
收起资源包目录
book源代码.zip (109个子文件)
bookManage.css 8KB
bookManage.css 7KB
bookCategory.css 7KB
myBorrow.css 3KB
main.css 3KB
main.css 3KB
manageUser.css 3KB
login.css 3KB
login.css 3KB
myMessage.css 2KB
borrowHistory.css 2KB
updatePwd.css 2KB
updatePwd.css 2KB
common.css 133B
common.css 133B
mysql-connector-java-8.0.30.jar 2.4MB
gson-2.10.1.jar 277KB
javax.servlet-api-4.0.1.jar 93KB
ManagerDaoImpl.java 27KB
UserDaoImpl.java 9KB
ManagerServiceImpl.java 9KB
User.java 6KB
Book.java 5KB
UserServiceImpl.java 4KB
BookVo.java 4KB
ManagerDao.java 3KB
BorrowBookServlet.java 3KB
UpdateBook.java 3KB
ManagerService.java 3KB
PageUserVo.java 3KB
AddBook.java 3KB
UserVo.java 3KB
ManagerLoginFilter.java 3KB
UpdatePwdServlet.java 2KB
LoginServlet.java 2KB
updatePwdServlet.java 2KB
BorrowHistoryVo.java 2KB
UploadServlet.java 2KB
LoginFilter.java 2KB
UpdateBookServlet.java 2KB
LoginServlet.java 2KB
BorrowVo.java 2KB
RegisterServlet.java 2KB
RegisterServlet.java 2KB
Category.java 2KB
ForgetPwdServlet.java 2KB
ForgetPwdServlet.java 2KB
AddBookServlet.java 2KB
Manager.java 2KB
Result.java 2KB
UserDao.java 2KB
UserService.java 2KB
AddCategoryServlet.java 2KB
FindBookByIdServlet.java 2KB
PageBean.java 2KB
pageBook.java 2KB
FindBookByPageServlet.java 2KB
UpdateMessageServlet.java 2KB
DeleteCategory.java 2KB
DeleteBookServlet.java 2KB
CategoryVo.java 2KB
JDBCUtil.java 2KB
MyBorrowHistoryServlet.java 2KB
UpdateCategoryServlet.java 1KB
MyBorrowServlet.java 1KB
RevertBookServlet.java 1KB
FindCategoryByPageServlet.java 1KB
FindUserByPageServlet.java 1KB
findMessageServlet.java 1KB
StopOrStartUserServlet.java 1KB
BookStatus.java 1KB
GetCategoriesServlet.java 1KB
LogoutServlet.java 1KB
LogoutServlet.java 1KB
bg1.jpg 340KB
bg1.jpg 340KB
img.jpg 35KB
img.jpg 35KB
bookManage.js 21KB
bookCategory.js 10KB
login.js 9KB
login.js 9KB
bookManage.js 8KB
manageUser.js 7KB
myMssage.js 4KB
myBorrow.js 4KB
borrowHistory.js 3KB
main.js 2KB
main.js 2KB
updatePwd.js 2KB
updatePwd.js 2KB
bookManage.jsp 7KB
bookCategory.jsp 3KB
manageUser.jsp 3KB
bookManage.jsp 2KB
myMessage.jsp 2KB
main.jsp 2KB
login.jsp 2KB
login.jsp 2KB
main.jsp 2KB
共 109 条
- 1
- 2
资源评论
记录成长java
- 粉丝: 87
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功