Пример #1
0
 public static Address randomAddress() {
   Address a = create(Address.class);
   a.setAddressee(randomize(ADDRESSEE));
   if (rand.nextBoolean()) {
     a.setAddressLine1(randomize(ADDRESS));
     a.setAddressLine2("");
   } else {
     a.setAddressLine1("");
     a.setAddressLine2(randomize(ADDRESS));
   }
   a.setCity(randomize(CITY));
   a.setPostalCode(generateKey(5));
   a.setState(randomize(STATE));
   return (a);
 }
  public User getUser(MySqlHelper helper, String userName, String password) {
    User user = new User();
    String query =
        "select * "
            + "from login u inner join address a on u.UserId = a.UserId "
            + "inner join personalinfo p on a.AddressId = p.AddressId "
            + "where Email=? and Password= ?";
    System.out.println(query);
    System.out.println("u=" + userName + " p=" + password);
    try {
      java.sql.PreparedStatement loginPreparedStatement =
          helper.conn.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);
      loginPreparedStatement.setString(1, userName);
      loginPreparedStatement.setString(2, password);
      ResultSet rs = loginPreparedStatement.executeQuery();
      while (rs.next()) {
        user.setFirstName(rs.getString("FirstName"));
        user.setLastName(rs.getString("LastName"));
        user.setUserType(Integer.toString(rs.getInt("UserTypeId")));
        user.setEmail(rs.getString("Email"));

        Address address = new Address();
        address.setAddressLine1(rs.getString("AddressLine1"));
        address.setAddressLine2(rs.getString("AddressLine2"));
        address.setCity(rs.getString("City"));
        address.setState(rs.getString("State"));
        address.setZipCode(rs.getString("ZipCode"));
        address.setLattitude(rs.getString("Lattitude"));
        address.setLongitude(rs.getString("Longitude"));

        user.setAddress(address);

        user.setPhoneNumber(rs.getString("PhoneNumber"));
      }
    } catch (Exception ex) {
      ex.printStackTrace();
    }
    return user;
  }
Пример #3
0
  public static void main(String[] args) {

    Student student = new Student();
    student.setName("Jeff");

    Address homeAddress = new Address();
    homeAddress.setAddressType(AddressType.HOME);
    homeAddress.setAddressLine1("101 Fifth St.");
    homeAddress.setAddressLine2("Suite 3a");
    homeAddress.setCity("St. Charles");
    homeAddress.setState("MO");
    homeAddress.setPostalCode("63303");

    Set addresses = new HashSet();
    addresses.add(homeAddress);

    student.setAddresses(addresses);

    Instructor instructor = new Instructor();
    instructor.setFirstName("John");
    instructor.setLastName("Smith");
    instructor.setInstructorName(instructor.getFirstName(), instructor.getLastName());

    Instructor instructor2 = new Instructor();
    instructor2.setFirstName("Ron");
    instructor2.setLastName("Regan");
    instructor2.setInstructorName(instructor.getFirstName(), instructor.getLastName());

    Course java = new Course();
    java.setCourseName("CSP 443 Advanced Java");
    java.setCreditHours(3.0f);
    java.setInstructor(instructor);

    Course cSharp = new Course();
    cSharp.setCourseName("CSP 233 Beginning C#");
    cSharp.setCreditHours(5.0f);
    java.setInstructor(instructor2);

    Course algebra = new Course();
    algebra.setCourseName("Beginners Algebra");
    algebra.setCreditHours(3.0f);
    algebra.setInstructor(instructor2);

    Course computer = new Course();
    computer.setCourseName("Intro to Computer Science");
    computer.setCreditHours(4.5f);
    computer.setInstructor(instructor);

    Rating rate = new Rating();
    rate.setCourse(java, 8.5d);

    Rating rate2 = new Rating();
    rate2.setCourse(cSharp, 9.0d);

    Rating rate3 = new Rating();
    rate3.setCourse(algebra, 7.0);

    Rating rate4 = new Rating();
    rate4.setCourse(computer, 8.0);

    Set courses = new HashSet();
    courses.add(java);
    courses.add(cSharp);
    courses.add(computer);
    courses.add(algebra);

    student.setCourses(courses);

    Set instructors = new HashSet();
    instructors.add(instructor);
    instructors.add(instructor2);

    instructor.setInstructors(instructors);

    Grade javaGrade = new Grade(student, java, 3.459f);
    Grade cSharpGrade = new Grade(student, cSharp, 3.975f);
    Grade algebraGrade = new Grade(student, algebra, 3.5f);
    Grade computerGrade = new Grade(student, computer, 3.0f);

    Session session = HibernateUtilities.getSessionFactory().openSession();
    session.beginTransaction();

    session.save(student);
    session.save(javaGrade);
    session.save(cSharpGrade);
    session.save(algebraGrade);
    session.save(computerGrade);

    session.getTransaction().commit();
    session.close();

    double result = GradebookBusinessLogic.calculateCumulativeGPA(student);

    System.out.println(student.getName() + " Cumulative Grade: " + result);
    System.out.println(instructor.getInstructorName() + ":" + rate4.getRate());
    System.out.println(instructor2.getInstructorName() + ";" + rate3.getRate());
  }