example of well-written jdbc code

public Employee getEmployee(int id) throws SQLException{Employee employee=null;String sql="SELECT * FORM EMPLOYEE WHERE EMPLOYEE_NUMBER=?";Connection conn=null;PreparedStatement ps=null;ResultSet rs=null;try{    conn=dataSource.getConnection();  ps=conn.prepareStatement(sql);  ps.setInt(1,id);  rs=ps.executeQuery();    while(rs.next())  {    employee=new Employee();employee.setId(rs.getInt("ID"));    employee.setEmployeeNumber(rs.getInt("EMPLOYEE_NUMBER"));    employee.setFirstName(rs.getString("FIRST_NAME");    employee.setLastName(rs.getString("LAST_NAME"));    employee.setTitle(rs.getString("TITLE"));     }} finally{ try{      if(rs!=null) rs.close();  } finally{    try{        if(ps!=null) ps.close();    } finally{    if(conn!=null) conn.close();  }  }}return employee;}