public Employee findByUserId(String userId)
{
String sql = "select * from employee where userid = @userid";
SqlParameter param = makeParameter("@userid", userId);
SqlDataReader reader = null;
Employee employee = null;
try
{
reader = accessor.select(sql, param);
if (reader.Read())
{
employee = new Employee();
employee.EmployeeNo = (String) read(reader, "employeeNo");
employee.EmployeeName = (String) read(reader, "employeeName");
employee.Sex = Boolean.Parse(read(reader, "sex").ToString());
employee.TelNo = (String) read(reader, "telNo");
employee.UserId = (String) read(reader, "userId");
return employee;
}
}
finally
{
closeReader(reader);
}
return employee;
}
public Employee findByEmployeeNo(String employeeNo)
{
String sql = "select * from employee where employeeno = @employeeno";
SqlParameter param = makeParameter("@employeeno", employeeNo);
SqlDataReader reader = null;
Employee employee = null;
try
{
reader = accessor.select(sql, param);
if (reader.Read())
{
employee = new Employee();
employee.EmployeeNo = reader["employeeNo"].ToString();
employee.EmployeeName = reader["employeeName"].ToString();
employee.Sex = Boolean.Parse(reader["sex"].ToString());
employee.TelNo = reader["telNo"].ToString();
employee.UserId = reader["userId"].ToString();
return employee;
}
}
finally
{
closeReader(reader);
}
return employee;
}
