我想弄清楚如何查詢 mysql 數(shù)據(jù)庫(kù)中的特定歌曲。我的想法是通過(guò) ID 查找歌曲,因此如果我傳遞 ID,一首歌曲應(yīng)該出現(xiàn)在瀏覽器窗口中。public class Song {private int id = 0;private String title;private String artist;private String album;private int released;public Song() {}public Song(int id, String title, String artist, String album, int released) { this.id = id; this.title = title; this.artist = artist; this.album = album; this.released = released;}@Id@Column(name = "songID")@GeneratedValue(strategy = GenerationType.IDENTITY)public Integer getId() { return id;}SongWebService.java @GET @Path("/{id}") @Produces({ MediaType.APPLICATION_JSON, MediaType.APPLICATION_XML })public Response getSongById() { Object song = null; try { em.getTransaction().begin(); song = em.createQuery("SELECT s FROM Song s WHERE s.songID = :id", Song.class).getSingleResult(); em.getTransaction().commit(); } catch (NoResultException e) { Response.noContent().build(); } catch (Exception ex) { ex.printStackTrace(); em.getTransaction().rollback(); } finally { em.close(); } return Response.ok(song).build();}
如何查詢 mysql 數(shù)據(jù)庫(kù)中的特定實(shí)體
千萬(wàn)里不及你
2022-12-28 16:11:38