dmanager.java

java sql jsp javabean

package com.gc.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.gc.impl.IManager;

public class DManager implements IManager{
	private Connection con = null;
	private PreparedStatement pre = null;
	private ResultSet rs = null;
	
	public boolean isManager(String maccount, String mpassword) {
		boolean manager = false;
		try
		{
			dao d = new dao();
			this.con = d.getCon();
			if(con != null)
			{
				pre = con.prepareStatement("select * from Manager where MAccount='"+maccount+"' and MPassword='"+mpassword+"'");
				rs = pre.executeQuery();
				while(rs.next())
				{
					manager = true;
				}
			}
			rs.close();
			pre.close();
			con.close();
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return manager;
	}
}