checklogin.java

购物网站

package com;
import java.sql.*;
import java.io.Serializable;
public class CheckLogin implements Serializable
{
	Login log;
	
	private boolean used=false;
	private Connection con;
	PreparedStatement state=null;
	ResultSet result=null;
	
	private String login;
	
	public void setLog(Login log)
	{
		this.log=log;
	}
	
	public String getLogin()
	{
		return this.login;
	}
	
	public void checkLogin()
	{
		try
		{
			con=DBConnection.getConnection();
			state=con.prepareStatement("select * from TABLE_ADMIN where ADMIN_ACCOUNT=? and ADMIN_PASSWORD=?"); 
			state.setString(1,log.getName());
			state.setString(2,log.getPass());
			result=state.executeQuery();
			if(result.next())
			{
				this.login=result.getString(1);
				log.setType(result.getInt("ADMIN_TYPE"));
				log.setState("true");
			}
			else
			{
				log.setState("false");
			}
			result.close();
			state.close();
			con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}

	}
	public void checkAdmin()
	{
		try
		{
			con=DBConnection.getConnection();
			state=con.prepareStatement("select * from TABLE_ADMIN where ADMIN_ACCOUNT=? and ADMIN_PASSWORD=?"); 
			state.setString(1,log.getName());
			state.setString(2,log.getPass());
			result=state.executeQuery();
			if(result.next())
			{
				log.setAdmin("true");
			}
			else
			{
				log.setAdmin("false");
			}
			result.close();
			state.close();
			con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}	
	}
}