adminoperation.java

该系统实现了网上购物及书店管理

	 * 更新BookType信息
	 * 
	 * @param btb
	 * @return
	 */
	public boolean updateBookType(BookTypeBean btb) {
		try {
			// 创建在Type表中更新BookType记录的Statement对象
			preparedStatement = connection
					.prepareStatement("update Type set Display=? where TypeId=?");
			// 设置Statement对象的第一个参数
			preparedStatement.setString(1, btb.getDisplay());
			// 设置Statement对象的第二个参数
			preparedStatement.setInt(2, btb.getTypeId());
			// 执行更新操作
			int flag = preparedStatement.executeUpdate();
			if (flag == 0) {
				return false;
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
			return false;
		}
		return true;
	}

	/**
	 * 增加图书信息
	 * 
	 * @param bb
	 * @return
	 */
	public boolean insertBooks(BookBean bb) {
		try {
			// 创建插入图书信息的Statement对象
			preparedStatement = connection
					.prepareStatement("insert into information (BookName,BookPenster,BookCompany,BookSynopsis,BookStorage,BookSell,BookDate,BookPrice,BookType,bookImage,BookStep) values(?,?,?,?,?,?,?,?,?,?,?)");
			// 设置Statement对象的第一个参数
			preparedStatement.setString(1, bb.getBookName());
			// 设置Statement对象的第二个参数
			preparedStatement.setString(2, bb.getBookPenster());
			// 设置Statement对象的第三个参数
			preparedStatement.setString(3, bb.getBookCompany());
			// 设置Statement对象的第四个参数
			preparedStatement.setString(4, bb.getBookSynopsis());
			// 设置Statement对象的第五个参数
			preparedStatement.setInt(5, bb.getBookStorage());
			// 设置Statement对象的第六个参数
			preparedStatement.setInt(6, bb.getBookSell());
			// 设置Statement对象的第七个参数
			preparedStatement.setDate(7, new java.sql.Date(new java.util.Date()
					.getTime()));
			// 设置Statement对象的第八个参数
			preparedStatement.setInt(8, bb.getBookPrice());
			// 设置Statement对象的第九个参数
			preparedStatement.setInt(9, Integer.parseInt(bb.getBookType()));
			// 设置Statement对象的第十个参数
			preparedStatement.setString(10, bb.getBookImage());
			// 设置Statement对象的第十一个参数
			preparedStatement.setInt(11, bb.getBookStep());
			// 执行更新操作
			int flag = preparedStatement.executeUpdate();
			if (flag == 0) {
				return false;
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
			return false;
		}
		return true;
	}

	/**
	 * 取得某条图书信息
	 * 
	 * @param bookId
	 * @return
	 */
	public BookBean getBookBean(int bookId) {
		BookBean bbean = new BookBean();
		// 查询某条图书信息的SQL语句
		String sql = "select * from information where BookId=?";
		try {
			// 创建preparedStatement对象
			preparedStatement = connection.prepareStatement(sql);
			// 设置Statement对象的第一个参数的值
			preparedStatement.setInt(1, bookId);
			// 执行查询
			resultSet = preparedStatement.executeQuery();
			// 根据查询结果封装成BookBean对象
			while (resultSet.next()) {
				bbean.setBookCompany(resultSet.getString("BookCompany"));
				bbean.setBookCount(1);
				bbean.setBookData(resultSet.getDate("BookDate"));
				bbean.setBookId(bookId);
				bbean.setBookImage(resultSet.getString("BookImage"));
				bbean.setBookName(resultSet.getString("BookName"));
				bbean.setBookPenster(resultSet.getString("BookPenster"));
				bbean.setBookPrice(resultSet.getInt("BookPrice"));
				bbean.setBookSell(resultSet.getInt("BookSell"));
				bbean.setBookStep(resultSet.getInt("BookStep"));
				bbean.setBookStorage(resultSet.getInt("BookStorage"));
				bbean.setBookSynopsis(resultSet.getString("BookSynopsis"));
				bbean.setBookType(this.queryType(""
						+ resultSet.getInt("BookType")));
				bbean.setBookAllPrice(bbean.getBookPrice());
			}
		}

		catch (SQLException ex) {
			ex.printStackTrace();
			return null;
		}
		return bbean;
	}

	/**
	 * 根据typeID查询其对应的类型值
	 * 
	 * @param typeId
	 * @return
	 */
	public String queryType(String typeId) {
		try {
			// 创建相应的Statement对象
			java.sql.PreparedStatement prepar1 = connection
					.prepareStatement("select Display from Type where TypeId=?");
			// 设置Statement对象的第一个参数
			prepar1.setInt(1, Integer.parseInt(typeId));
			// 执行查询取得查询结果
			ResultSet res1 = prepar1.executeQuery();
			res1.next();
			return res1.getString("Display");
		} catch (SQLException ex) {

			return null;
		}
	}

	/**
	 * 返回书籍信息列表
	 * 
	 * @param count
	 * @param page
	 * @return
	 */
	public ArrayList getBooksList(int count, int page) {
		ArrayList list = new ArrayList();
		try {
			// 调用查询书籍的存储过程
			callableStatement = connection
					.prepareCall("{call proc_books_page (?,?,?)}");
			// 设置Statement对象的相关参数
			callableStatement.setInt(1, page);
			callableStatement.setInt(2, count);
			// 设置Statement对象的输入参数类型
			callableStatement.registerOutParameter(3, Types.INTEGER);
			// 执行查询
			resultSet = callableStatement.executeQuery();
			// 将查询结果放置到一个链表中保存
			while (resultSet.next()) {
				BookBean kb = new BookBean();
				kb.setBookId(resultSet.getInt(1));
				kb.setBookName(resultSet.getString(2));
				kb.setBookPenster(resultSet.getString(3));
				kb.setBookCompany(resultSet.getString(4));
				kb.setBookSynopsis(resultSet.getString(5));
				kb.setBookStorage(resultSet.getInt(6));
				kb.setBookSell(resultSet.getInt(7));
				kb.setBookData(resultSet.getDate(8));
				kb.setBookPrice(resultSet.getInt(9));
				kb.setBookType(resultSet.getInt(10) + "");
				kb.setBookImage(resultSet.getString(11));
				kb.setBookStep(resultSet.getInt(12));
				list.add(kb);
			}
			pagecount = callableStatement.getInt(3);
		} catch (SQLException ex) {
			System.out.println("服务器异常发生在 getBooksList()");
			ex.printStackTrace();
		}
		return list;
	}

	/**
	 * 取得定单列表
	 * 
	 * @param count
	 * @param page
	 * @return
	 */
	public ArrayList getOrderList(int count, int page) {
		ArrayList list = new ArrayList();
		try {
			// 调用查询所有定单的存储过程
			callableStatement = connection
					.prepareCall("{call proc_order_page (?,?,?)}");
			// 设置存储过程的相应参数
			callableStatement.setInt(1, page);
			callableStatement.setInt(2, count);
			// 设置存储过程输出参数的类型
			callableStatement.registerOutParameter(3, Types.INTEGER);
			// 执行查询
			resultSet = callableStatement.executeQuery();
			// 处理查询结果
			while (resultSet.next()) {
				OrderFormBean ob = new OrderFormBean();
				ob.setOrderId(resultSet.getInt(1));
				ob.setUserId(resultSet.getInt(2));
				ob.setBookId(resultSet.getInt(3));
				ob.setAmount(resultSet.getInt(4));
				ob.setOrderData(resultSet.getString(5));
				ob.setMoney(resultSet.getInt(6));
				list.add(ob);
			}
			pagecount = callableStatement.getInt(3);
		} catch (SQLException ex) {
			System.out.println("服务器异常发生在 getBooksList()");
			ex.printStackTrace();
		}
		return list;
	}

	/**
	 * 改变Admin的密码信息
	 * 
	 * @param admin
	 * @return
	 */
	public boolean changeAdminPwd(AdminBean admin) {
		try {
			// 创建更新admin密码的Statement对象
			preparedStatement = connection
					.prepareStatement("update admin set UserPwd=? where userId=?");
			// 设置其相应的参数
			preparedStatement.setString(1, admin.getUserPwd());
			preparedStatement.setInt(2, admin.getUserId());
			// 执行更新操作
			int flag = preparedStatement.executeUpdate();
			if (flag == 0) {
				return false;
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
			return false;
		}
		return true;
	}

	/**
	 * 关闭与数据库的所有连接
	 */
	public void Close() {
		try {
			if (resultSet != null) {
				// 关闭ResultSet对象
				resultSet.close();
			}
			if (preparedStatement != null) {
				// 关闭PreparedStatemnt对象
				preparedStatement.close();
			}
			if (connection != null) {
				// 关闭Connection对象
				connection.close();
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
		}

	}

}