当前位置：首页 > Java

JAVA如何查询科目

2026-03-25 16:00:40Java

查询科目的方法

在JAVA中查询科目可以通过多种方式实现，具体取决于数据存储的方式和查询需求。以下是几种常见的方法：

使用JDBC查询数据库

如果科目信息存储在关系型数据库中，可以通过JDBC连接数据库并执行SQL查询。以下是一个简单的示例代码：

String url = "jdbc:mysql://localhost:3306/school";
String username = "root";
String password = "password";

try (Connection connection = DriverManager.getConnection(url, username, password)) {
    String sql = "SELECT * FROM subjects WHERE subject_name = ?";
    PreparedStatement statement = connection.prepareStatement(sql);
    statement.setString(1, "Math");

    ResultSet resultSet = statement.executeQuery();
    while (resultSet.next()) {
        System.out.println("Subject ID: " + resultSet.getInt("subject_id"));
        System.out.println("Subject Name: " + resultSet.getString("subject_name"));
    }
} catch (SQLException e) {
    e.printStackTrace();
}

使用JPA/Hibernate进行查询

JAVA如何查询科目

对于使用ORM框架的应用，可以通过JPA或Hibernate查询科目信息：

@Entity
@Table(name = "subjects")
public class Subject {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;

    // getters and setters
}

// 查询代码
EntityManagerFactory emf = Persistence.createEntityManagerFactory("school");
EntityManager em = emf.createEntityManager();

TypedQuery<Subject> query = em.createQuery(
    "SELECT s FROM Subject s WHERE s.name = :name", Subject.class);
query.setParameter("name", "Math");
List<Subject> subjects = query.getResultList();

subjects.forEach(subject -> {
    System.out.println("Subject ID: " + subject.getId());
    System.out.println("Subject Name: " + subject.getName());
});

em.close();
emf.close();

使用内存数据结构查询

如果科目数据存储在内存中的集合里，可以直接遍历集合进行查询：

JAVA如何查询科目

List<Subject> subjects = Arrays.asList(
    new Subject(1, "Math"),
    new Subject(2, "Science"),
    new Subject(3, "History")
);

String searchName = "Science";
Subject foundSubject = subjects.stream()
    .filter(subject -> subject.getName().equals(searchName))
    .findFirst()
    .orElse(null);

if (foundSubject != null) {
    System.out.println("Found subject: " + foundSubject.getName());
}

使用Spring Data JPA查询

在Spring Boot应用中，可以通过Spring Data JPA的Repository接口简化查询：

public interface SubjectRepository extends JpaRepository<Subject, Long> {
    Subject findByName(String name);
    List<Subject> findByNameContaining(String keyword);
}

// 在服务层使用
@Autowired
private SubjectRepository subjectRepository;

public void findSubject(String name) {
    Subject subject = subjectRepository.findByName(name);
    if (subject != null) {
        System.out.println("Found subject: " + subject.getName());
    }
}

注意事项