package fangsoft.testcenter.model;

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

import java.io.IOException;

public class Customer {
	public static boolean login(String userId, String password, Connection con)
			throws IOException, SQLException {

		PreparedStatement ps = null;
		ResultSet result = null;
		String pword = null;
		String sqlString = "select password " + "from customer"
				+ " where name=?";
		ps = con.prepareStatement(sqlString);
		ps.setString(1, userId);
		result = ps.executeQuery();
		if (result.next()) {
			pword = result.getString("password");
		} else
			return false;
		if (pword.equals(password))
			return true;
		else
			return false;
	}
}