906d0af4740f001d1622ead12426ea11

实训时做的物流系统

/*******************************************************************************
 * Copyright (c) 2005 Eteration A.S. and others. All rights reserved. This
 * program and the accompanying materials are made available under the terms of
 * the Eclipse Public License v1.0 which accompanies this distribution, and is
 * available at http://www.eclipse.org/legal/epl-v10.html
 * 
 * Contributors: Eteration A.S. - initial API and implementation
 ******************************************************************************/
package com.lib.web.struts.action;

import java.io.IOException;
import java.sql.ResultSet;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletException;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;

import com.lib.cls.JDBC;
import com.lib.cls.Server;
import com.lib.biz.DisQuery;
import com.lib.biz.ServerData;
import com.lib.persistence.hibernate.pojo.Book;
import com.lib.web.struts.form.BookForm;

public class DisAddAction extends Action {

	public ActionForward execute(ActionMapping mapping,
									ActionForm form, 
									HttpServletRequest request, 
									HttpServletResponse response)
									throws IOException, ServletException {
		
		
		String target = "success";
		BookForm bf = (BookForm)form;
		String name = bf.getServername();
		String isbn = bf.getBook().getIsbn();
        Server server = ServerData.getInstance().FindServer(name);
        JDBC jdbc = DisQuery.getInstance().SetJDBC(server);
        ResultSet rs = DisQuery.getInstance().Query(jdbc, isbn);
        try {
				while (rs.next()) {
					System.out.println("sign here");
					Book book = new Book();
					book.setIsbn(rs.getString(2));
					book.setAmount(new Integer(rs.getString(20)));
					book.setAuthor(rs.getString(5));
					book.setBookconcern(rs.getString(8));
					book.setBookname(rs.getString(4));
					book.setChecknum(rs.getString(3));
					book.setClassifyname(rs.getString(7));
					book.setClassifynum(rs.getString(6));
					book.setFormat(new Integer(Integer.parseInt(rs.getString(15))));
					book.setLang(rs.getString(14));
					book.setLiteraturesort(rs.getString(12));
					book.setPagenum(new Integer(Integer.parseInt(rs.getString(16))));
					book.setPagespace(rs.getString(17));
					book.setPrice(rs.getString(11));
					book.setPrintadd(rs.getString(9));
					book.setToiweap(rs.getString(13));
					request.setAttribute("book", book);}
		if (rs.next() == false) {
				    request.setAttribute("sign2", "be");
				}else{					
			    request.setAttribute("sign1", "be");
		} catch (Exception e) {
			// TODO: handle exception
		}

	return mapping.findForward(target);
	}
}