基于Jsp的图书管理系统—后台管理1毕业设计(3)

CREATE TABLE `student` (

`stuNo` varchar(50) NOT NULL,

`stuName` varchar(50) NOT NULL default '', `stuPassword` varchar(50) NOT NULL default '', `stuAge` int(3) default NULL,

`stuSex` varchar(50) default NULL, `stuClass` varchar(50) default NULL,

`stuDepartment` varchar(50) default NULL, `stuPermitted` varchar(50) default '是', PRIMARY KEY (`stuNo`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

4.2 主要页面设计

该图书管理系统的主要页面有：

1．登录页面（学生登录和管理员登录） 2．学生操作页面

3．学生查询图书操作页面 4．学生查看借阅记录操作页面 5．学生退出系统页面 6．管理员操作页面

7．管理员图书管理操作页面 8. 管理员用户管理操作页面 9. 管理员借书管理操作页面 10. 管理员还书管理操作页面 11. 管理员退出系统页面

4.3 主要代码

1.管理员登录的代码

package cn.hebau.library.dao.impl;

public class ManagerDaoMysqlImpl implements ManagerDao {

Connection conn = new DbConnection().getConnetion(); PreparedStatement pstmt = null;

public int loginCheck(Manager manager) { int result = 0;

String sql = \; try {

}

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, manager.getMgName()); pstmt.setString(2, manager.getMgPassword()); ResultSet rs = pstmt.executeQuery(); if(rs.next()){ result = rs.getInt(\); }

} catch (SQLException e) { e.printStackTrace(); }

return result;

}

2.查询借书记录，借书，还书。 package cn.hebau.library.dao.impl;

public class BorrowDaoMysqlImpl implements BorrowDao {

Connection conn = new DbConnection().getConnetion(); PreparedStatement pstmt = null;

public List SelectAll(String StuNo) { String sql = \; List borrowed = new ArrayList (); try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, StuNo); ResultSet rs = pstmt.executeQuery();

while(rs.next()){ Borrow bw = new Borrow(); bw.setBorrowId(rs.getInt(\)); bw.setBookNo(rs.getString(\)); bw.setStuNo(rs.getString(\));

bw.setBorrowTime(rs.getString(\)); bw.setReturnTime(rs.getString(\)); borrowed.add(bw);

}

}

} catch (SQLException e) { e.printStackTrace(); }finally{ if(pstmt!=null) try { pstmt.close(); } catch (SQLException e) { e.printStackTrace(); } }

return borrowed;

public boolean check(String bookNo) { String sql = \ from borrow_book where bookNo=?\; boolean flag = true; try { }

pstmt = conn.prepareStatement(sql); pstmt.setString(1, bookNo); ResultSet rs = pstmt.executeQuery(); if(rs.next()){ flag = false; }

} catch (SQLException e) { e.printStackTrace(); }

return flag;

public void insert(Borrow borrow) { String sql = \

(bookNo,stuNo,borrowTime,returnTime) values(?,?,?,?)\;

}

try {

pstmt = conn.prepareStatement(sql); pstmt.setString(1, borrow.getBookNo()); pstmt.setString(2, borrow.getStuNo()); pstmt.setString(3, borrow.getBorrowTime()); pstmt.setString(4, borrow.getReturnTime()); pstmt.execute();

} catch (SQLException e) { e.printStackTrace(); }finally{ }

if(pstmt!=null) try {

pstmt.close(); } catch (SQLException e) { e.printStackTrace(); }

if(conn!=null)

try { conn.close();

} catch (SQLException e) { e.printStackTrace(); }

public List SelectAll() {

String sql = \;

List borrowed = new ArrayList (); try { pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery();

while(rs.next()){ Borrow bw = new Borrow(); bw.setBorrowId(rs.getInt(\));

}

bw.setBookNo(rs.getString(\));

bw.setStuNo(rs.getString(\)); bw.setBorrowTime(rs.getString(\)); bw.setReturnTime(rs.getString(\)); borrowed.add(bw); }

} catch (SQLException e) { e.printStackTrace(); }finally{ if(pstmt!=null)

try { pstmt.close();

} catch (SQLException e) {

e.printStackTrace(); } }

return borrowed;

public boolean delete(String bookNo, String stuNo) { String sql = \; boolean flag = false; try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, stuNo); pstmt.setString(2, bookNo); int row = pstmt.executeUpdate();

if(row==1) flag=true;

} catch (SQLException e) { e.printStackTrace(); }finally{

if(pstmt!=null) try { pstmt.close();