loanaccount1.java

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

//Code the Bean component:LoanAccount1.java
import java.io.*;
import java.sql.*;
import java.util.*;

public class LoanAccount1
{
	private String sLoanId="";
	Connection connect = null;
	Statement state = null;
	ResultSet result = null;
		public void setsLoanId(String sLoanId)
		{
			this.sLoanId=sLoanId;
		}

		public String getsLoanId()
		{
			return sLoanId;
		}

	public LoanAccount1() throws ClassNotFoundException
	{
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}
	

		public Vector getResults()
		{
			Vector v=new Vector();
			try{

	sLoanId=getsLoanId();
	System.out.println("sLoanId: "+sLoanId);
	connect=DriverManager.getConnection("jdbc:odbc:MyDataSource","faculty","");
	String strQuery = " Select mLoan_amount,mLoan_amount_repaid,mBalance,intBal_no_installments from Loan_Details where cLoan_id='"+sLoanId+"' " ;
			System.out.println("Query: "+strQuery);
			state = connect.createStatement();
			
			ResultSet result = state.executeQuery(strQuery);

			String sLoanAmount ="";
			String sLoanRepaid = "";
			String sBalance = "";
			int iInstallments = 0;
			while(result.next())
			{
				sLoanAmount  = result.getString(1);
				sLoanRepaid = result.getString(2);
				sBalance=result.getString(3);
				iInstallments =result.getInt(4);
				String sInstallments=iInstallments+"";
				v.add(sLoanAmount);
				v.add(sLoanRepaid);
				v.add(sBalance);
				v.add(sInstallments);
				
			}
				System.out.println("The Result Vector"+v);
			}
			catch(SQLException e)
			{
			   System.out.println("Exception caught"+e.getMessage());				
			}

			return v;
		}
}