userdao.java

用java编的用到

package djr.dao;

import java.sql.*;
import djr.dto.UserDTO;

public class UserDAO extends CommonDAO
{

	/** 查询指定用户在数据库中是否存在*/
	public boolean findUser(UserDTO userDTO, Connection conn)
	{
		String sql = "select userid,password,email from userinfo "
				+ "where userid='" + userDTO.getUserid() + "' "
				+ "and password='" + userDTO.getPassword() + "'";

		ResultSet rs = null;
		try
		{
			rs = execSelect(sql, conn);

			if (rs.next())
			{ // 用户存在时
				// 将用户邮箱地址设置到用户类中
				userDTO.setEmail(rs.getString("email"));
				return true;
			}

		}
		catch (SQLException e)
		{
			e.printStackTrace();
		}
		finally
		{
			close(null, rs);
		}

		return false;
	}
}