passlogic.java

购物网站

package com;
import java.sql.*;
import java.io.Serializable;
public class PassLogic implements Serializable
{
	Password password;
	
	private boolean used=false;
	private Connection con;
	PreparedStatement state=null;
	ResultSet result=null;
	
	
	public void setPassword(Password password)
	{
		this.password=password;
	}
	
	public void checkPass()
	{
		try
		{
			con=DBConnection.getConnection();
			state=con.prepareStatement("select * from TABLE_ADMIN where ADMIN_ACCOUNT=? and ADMIN_PASSWORD=?"); 
			state.setString(1,password.getName());
			state.setString(2,password.getPass());
			result=state.executeQuery();
			if(result.next())
			{
				password.setState("true");
			}
			else
			{
				password.setState("false");
			}
			result.close();
			state.close();
			con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}

	}
	public void ModifyPass()
	{
		try
		{
			con=DBConnection.getConnection();
			state=con.prepareStatement("update TABLE_ADMIN set ADMIN_PASSWORD=? where ADMIN_ACCOUNT=?"); 
			state.setString(1,password.getPass2());
			state.setString(2,password.getName());
			result=state.executeQuery();
			if(result.next())
			{
				password.setState("true");
			}
			else
			{
				password.setState("false");
			}
			result.close();
			state.close();
			con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}	
	}
}