bankaccount.java.bak

一个jsp+javabean的用户验证。（access数据库

package test;
import java.io.*;
import java.sql.*;

public class BankAccount 
{
	private String sAccountID=" ";
	private String sPin=" ";
	private boolean AccountValidate;		
	Connection connect = null;
	Statement state = null;
	ResultSet result = null;

	
   public void setsAccountID(String sAccountID)
		{
   			System.out.println("Inside setter method"+sAccountID);
			this.sAccountID=sAccountID;
		}
   
	public void setsPin(String sPin)
		{
			this.sPin=sPin;
		}

	public String getsAccountID()
		{
   		return this.sAccountID;
		}

	public String getsPin()
		{
          		return sPin;
		}


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


		
		public boolean AccountValidate()
		{
				boolean  validate=false;
				String user="";
			try{

				sAccountID=getsAccountID();
				sPin=getsPin();		
				System.out.println("Inside VALIDATE method"+sAccountID);
				connect=DriverManager.getConnection("jdbc:odbc:mydatabase","sa","sa");
				String strQuery = "Select * from admin where admin='"+sAccountID+"'"+"and password='"+sPin+"'";
				System.out.println("Query: "+strQuery);
				state = connect.createStatement();
				ResultSet result = state.executeQuery(strQuery);
				while(result.next())
				{
					validate = true;
					user = result.getString(1);
					System.out.println("Inside Result method"+sPinNo+sPin);
          setsAccountID(user);
				}
			}
			catch(Exception e)
			{
				System.out.println("SQL Exception is caught.");	
			}

			return validate;
		}
}