goodservice.java

来自「基于J2EE技术的 电子购物商城系统」· Java 代码 · 共 628 行 · 第 1/2 页

		close();
		
		if (isSuccessful == 1)
			return null;
		else
			return errorMsg;
	}
	
	public String removeBook(String userId, String password, String bookId) {
		open();
		
		int isSuccessful = 0;
		String errorMsg = null;
		util.prepareCall("{ call removeBook(?, ?, ?, ?, ?) }");
		util.setString(1, userId);
		util.setString(2, password);
		util.setString(3, bookId);
		util.registerOutParameter(4, OracleTypes.NUMERIC);
		util.registerOutParameter(5, OracleTypes.VARCHAR);
		util.execute();
		isSuccessful = util.getInt(4);
		errorMsg = util.getErrorMsg() + util.getString(5);
		
		close();
		
		if (isSuccessful == 1)
			return null;
		else
			return errorMsg;
	}
	
	public String releaseBook(String userId, String password, String bookId) {
		open();
		
		int isSuccessful = 0;
		String errorMsg = null;
		util.prepareCall("{ call releaseBook(?, ?, ?, ?, ?) }");
		util.setString(1, userId);
		util.setString(2, password);
		util.setString(3, bookId);
		util.registerOutParameter(4, OracleTypes.NUMERIC);
		util.registerOutParameter(5, OracleTypes.VARCHAR);
		util.execute();
		isSuccessful = util.getInt(4);
		errorMsg = util.getErrorMsg() + util.getString(5);
		
		close();
		
		if (isSuccessful == 1)
			return null;
		else
			return errorMsg;
	}
	
	public String encloseBook(String userId, String password, String bookId) {
		open();
		
		int isSuccessful = 0;
		String errorMsg = null;
		util.prepareCall("{ call encloseBook(?, ?, ?, ?, ?) }");
		util.setString(1, userId);
		util.setString(2, password);
		util.setString(3, bookId);
		util.registerOutParameter(4, OracleTypes.NUMERIC);
		util.registerOutParameter(5, OracleTypes.VARCHAR);
		util.execute();
		isSuccessful = util.getInt(4);
		errorMsg = util.getErrorMsg() + util.getString(5);
		
		close();
		
		if (isSuccessful == 1)
			return null;
		else
			return errorMsg;
	}
	
	public String updateBookInfo(String userId, String password, String bookId,
			String bookName, double bookPrice, int bookNum, String[] category,
			String author, String press, int edition, String isbn, String categoryNum) {
		open();
		
		int isSuccessful = 0;
		String errorMsg = null;
		util.prepareCall("{ call updateBookInfo(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }");
		util.setString(1, userId);
		util.setString(2, password);
		util.setString(3, bookId);
		util.setString(4, bookName);
		util.setDouble(5, bookPrice);
		util.setInt(6, bookNum);
		if (category != null) {
			util.setString(7, category[0]);
			util.setString(8, category[1]);		
		}
		util.setString(9, author);
		util.setString(10, press);
		util.setInt(11, edition);
		util.setString(12, isbn);
		util.setString(13, categoryNum);
		util.registerOutParameter(14, OracleTypes.NUMERIC);
		util.registerOutParameter(15, OracleTypes.VARCHAR);
		util.execute();
		isSuccessful = util.getInt(14);
		errorMsg = util.getErrorMsg() + util.getString(15);
		
		close();
		
		if (isSuccessful == 1)
			return null;
		else
			return errorMsg;
	}
	
	public String updateBookStock(String userId, String password, String bookId, int bookNum) {
		open();
		
		int isSuccessful = 0;
		String errorMsg = null;
		util.prepareCall("{ call updateBookStock(?, ?, ?, ?, ?, ?) }");
		util.setString(1, userId);
		util.setString(2, password);
		util.setString(3, bookId);
		util.setInt(4, bookNum);
		util.registerOutParameter(5, OracleTypes.NUMERIC);
		util.registerOutParameter(6, OracleTypes.VARCHAR);
		util.execute();
		isSuccessful = util.getInt(5);
		errorMsg = util.getErrorMsg() + util.getString(6);
		
		close();
		
		if (isSuccessful == 1)
			return null;
		else
			return errorMsg;
	}
	
	public String setBookPrice(String userId, String password, String bookId, double bookPrice) {
		open();
		
		int isSuccessful = 0;
		String errorMsg = null;
		util.prepareCall("{ call setBookPrice(?, ?, ?, ?, ?, ?) }");
		util.setString(1, userId);
		util.setString(2, password);
		util.setString(3, bookId);
		util.setDouble(4, bookPrice);
		util.registerOutParameter(5, OracleTypes.NUMERIC);
		util.registerOutParameter(6, OracleTypes.VARCHAR);
		util.execute();
		isSuccessful = util.getInt(5);
		errorMsg = util.getErrorMsg() + util.getString(6);
		
		close();
		
		if (isSuccessful == 1)
			return null;
		else
			return errorMsg;
	}
	
	public Book getBook(String bookId) {
		Book book = new Book();
		User user = new User();
		open();
		
		util.prepareCall("{ ? = call getBookInfo(?) }");
		util.registerOutParameter(1, OracleTypes.CURSOR);
		util.setString(2, bookId);
		util.execute();
		ResultSet rs = util.getResultSet(1);
		try {
			if(rs.next()) {
				book.setId(rs.getString(1));
				book.setName(rs.getString(2));
				book.setPrice(rs.getDouble(3));
				book.setNumber(rs.getInt(4));
				user.setId(rs.getString(5));
				book.setSaler(user);
				book.setCategory(rs.getString(6), 1);
				book.setCategory(rs.getString(7), 2);
				book.setAuthor(rs.getString(8));
				book.setPress(rs.getString(9));
				book.setEditon((byte)rs.getInt(10));
				book.setId(rs.getString(11));
				book.setCategoryNum(rs.getString(12));
				if (rs.getInt(13) == 0)
					book.setReleased(false);
				else
					book.setReleased();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			close();
		}
		return book;
	}
	
	public ArrayList<Book> getAllBookInfo() {
		open();
		
		util.prepareCall("{ ? = call getAllBookInfo }");
		util.registerOutParameter(1, OracleTypes.CURSOR);
		util.execute();
		ResultSet rs = util.getResultSet(1);
		ArrayList<Book> list = new ArrayList<Book>();
		try {
			while(rs.next()) {
				Book book = new Book();
				User user = new User();
				book.setId(rs.getString(1));
				book.setName(rs.getString(2));
				book.setPrice(rs.getDouble(3));
				book.setNumber(rs.getInt(4));
				user.setId(rs.getString(5));
				book.setSaler(user);
				book.setCategory(rs.getString(6), 1);
				book.setCategory(rs.getString(7), 2);
				book.setAuthor(rs.getString(8));
				book.setPress(rs.getString(9));
				book.setEditon((byte)rs.getInt(10));
				book.setId(rs.getString(11));
				book.setCategoryNum(rs.getString(12));
				
				if (rs.getInt(9) == 1 && book.getNumber() > 0) {
					book.setReleased();
					list.add(book);
				}			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			close();
		}
		return list;
	}
	
	//TODO:getSomeBookInfo
	public ArrayList<Book> getSomeBookInfo() {
		return null;
	}
	
	public String newCategory(String userId, String password, String category, int level) {
		open();
		
		int isSuccessful = 0;
		String errorMsg = null;
		util.prepareCall("{ call newCategory(?, ?, ?, ?, ?, ?) }");
		util.setString(1, userId);
		util.setString(2, password);
		util.setString(3, category);
		util.setInt(4, level);
		util.registerOutParameter(5, OracleTypes.NUMERIC);
		util.registerOutParameter(6, OracleTypes.VARCHAR);
		util.execute();
		isSuccessful = util.getInt(5);
		errorMsg = util.getErrorMsg() + util.getString(6);
		
		close();
		
		if (isSuccessful == 1)
			return null;
		else
			return errorMsg;
	}
	
	public String removeCategory(String userId, String password, String category, int level) {
		open();
		
		int isSuccessful = 0;
		String errorMsg = null;
		util.prepareCall("{ call removeCategory(?, ?, ?, ?, ?, ?) }");
		util.setString(1, userId);
		util.setString(2, password);
		util.setString(3, category);
		util.setInt(4, level);
		util.registerOutParameter(5, OracleTypes.NUMERIC);
		util.registerOutParameter(6, OracleTypes.VARCHAR);
		util.execute();
		isSuccessful = util.getInt(5);
		errorMsg = util.getErrorMsg() + util.getString(6);
		
		close();
		
		if (isSuccessful == 1)
			return null;
		else
			return errorMsg;
	}
	
	public ArrayList<String> getAllCategory(int level) {
		ArrayList<String> list = new ArrayList<String>();
		
		open();
		
		util.prepareCall("{ ? = call getAllCategory(?) }");
		util.registerOutParameter(1, OracleTypes.CURSOR);
		util.setInt(2, level);
		util.execute();
		ResultSet rs = util.getResultSet(1);
		try {
			while(rs.next()) {
				list.add(rs.getString(1));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			close();
		}
		return list;
	}
}