bankaccounttag.java

J2EE关于JSP,SERVERLET的多个实用例子

//Code for the tag handler:BankAccountTag.java
import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.math.*;
public class BankAccountTag extends TagSupport
{
	protected String sLoanId="";
	Connection connect = null;
	Statement state = null;
	ResultSet result = null;
	public BankAccountTag() throws ClassNotFoundException
	{
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}
	
	public int doStartTag() throws JspTagException
	{
		return EVAL_BODY_INCLUDE;
	}

		public int doEndTag() throws JspTagException
		{
		   try
		   {
				JspWriter out=pageContext.getOut();
				
connect=DriverManager.getConnection("jdbc:odbc:MyDataSource","faculty","");
				
String strQuery = " Select cFirst_name,cLast_name,cAddress,cPhone from Loan_Registration LR,Loan_Details LD where LD.intBal_no_installments<=2 and LD.cLoan_registration_id=LR.cLoan_registration_id " ;
				
				System.out.println("Query: "+strQuery);
				state = connect.createStatement();
				ResultSet result = state.executeQuery(strQuery);
				String sFirstName = null;
				String sLastName = null;
				String sAddress = null;
				String sPhone = null;
				Vector v=new Vector();
				
			while(result.next())
			{
				
				sFirstName = result.getString(1);
				sLastName  = result.getString(2);
				sAddress  = result.getString(3);
				sPhone=result.getString(4);
				v.add(sFirstName);
				v.add(sLastName);	
				v.add(sAddress);
				v.add(sPhone);
				
			}
				for(int I=0;I<v.size();I++)
				{
			    	String str=(String)v.elementAt(I);
					pageContext.getOut().write(str);
					if(I==3)
					{
					pageContext.getOut().write("<BR>");
					}
					pageContext.getOut().write("<BR>");
			   		
				}
				
	       }catch(Exception ioe)
		{
			System.out.println(" Error in getting results"+ioe.toString());
		}
			return EVAL_PAGE;
	}

}