bankaccounttag.java

JSP学习的好东东

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","user1","");
				
			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;
	}

}