checkaccount.java

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

import java.sql.*;

public class CheckAccount
{
	private String account;
	private String pin;
	
	public void setAccount(String temp)
	{
		account=temp;
	}
	public String getAccount()
	{
		return account;
	}
	public void setPin(String temp)
	{
		pin=temp;
	}
	public String getPin()
	{
		return pin;
	}
	
	public boolean accountValidate()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:MyDatabase","faculty","");
			Statement sta=con.createStatement();
			ResultSet rs=sta.executeQuery("Select cpin_no from login where cAccount_id='" + account + "'");
			rs.next();
			if (rs.getString(1).trim().equals(pin.trim()))
			{
				return true;
			}
		}
		catch (Exception e)
		{
			System.out.println(e);
		}
		return false;
		
	}
}