f0c7382c720f001d1622ead12426ea11

实训时做的物流系统

/*******************************************************************************
 * 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);
        while(rs.next()==false){System.out.println("ok");}
        try {
			while (rs.next()) {
				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("sign", "be");
				request.setAttribute("book", book);
				break;
			}
			    request.setAttribute("sign", "be");
			    request.setAttribute("error","对不起，查找失败！");
		} catch (Exception e) {
			System.out.println("select error");
		}
	return mapping.findForward(target);
	}
}