borrowbooks.java

是一个简单的图书馆管理系统

package com.yourcompany.struts.action;

import java.sql.ResultSet;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.mysql.jdbc.PreparedStatement;
import com.yourcompany.struts.form.*;
import com.yourcompany.struts.Impl.*;
import com.yourcompany.struts.Impl.Impl.ConnDB;


public class BorrowBooks extends Action{

	
public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		Student_BookForm borrowBooks=(Student_BookForm) form;	
		
	
			
		try{ 
   
			if(request.getSession().getAttribute("s_no")!=null)
			{
					    borrowBooks.setS_no((String)request.getSession().getAttribute("s_no"));
					    }
   	//	System.out.println("书的序号:"+bookForm.getBook_no());
   		String book_no=borrowBooks.getBook_no();
   		Impl impl= new Impl(ConnDB.getconn());
    //插入点	
   		impl.updateBook_no(impl.searchB_number(borrowBooks), borrowBooks);
     	borrowBooks.setB_name(impl.ShowB_name(book_no));
   		impl.BorrowBook(borrowBooks);
		}catch(Exception e){
			e.printStackTrace();
		}
		
		finally {
		System.out.print("OK");
		}
		
		return mapping.findForward("suc");
	}
	

}