Guest User

Untitled

a guest
May 16th, 2018
26
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.54 KB | None | 0 0
  1. package proiect2;
  2.  
  3. import java.awt.List;
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.util.ArrayList;
  9.  
  10. import javax.swing.JButton;
  11. import javax.swing.JFrame;
  12. import javax.swing.JLabel;
  13. import javax.swing.JOptionPane;
  14. import javax.swing.JTextField;
  15.  
  16. import com.mysql.jdbc.Statement;
  17.  
  18. public class Muzica {
  19.  
  20. private int nr_crt;
  21. private String titlu_piesa;
  22. private String artist;
  23. private int an_aparitie;
  24.  
  25. public Muzica(int nr_crt, String titlu_piesa, String artist, int an_aparitie) {
  26. this.nr_crt=nr_crt;
  27. this.titlu_piesa = titlu_piesa;
  28. this.artist = artist;
  29. this.an_aparitie = an_aparitie;
  30. }
  31.  
  32. public String toString() {
  33. return "Muzica Nr Crt =" + nr_crt + ", Titlul Piesei" + titlu_piesa + ", Aristul " + artist
  34. + ", Anul Apritiei" + an_aparitie + "]";
  35. }
  36.  
  37. public int getNr_crt() {
  38. return nr_crt;
  39. }
  40.  
  41. public void setNr_crt(int nr_crt) {
  42. this.nr_crt = nr_crt;
  43. }
  44.  
  45. public String getTitlu_piesa() {
  46. return titlu_piesa;
  47. }
  48.  
  49. public void setTitlu_piesa(String titlu_piesa) {
  50. this.titlu_piesa = titlu_piesa;
  51. }
  52.  
  53. public String getArtist() {
  54. return artist;
  55. }
  56.  
  57. public void setArtist(String artist) {
  58. this.artist = artist;
  59. }
  60.  
  61. public int getAn_aparitie() {
  62. return an_aparitie;
  63. }
  64.  
  65. public void setAn_aparitie(int an_aparitie) {
  66. this.an_aparitie = an_aparitie;
  67. }
  68.  
  69. public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException{
  70.  
  71. String url="jdbc:mysql://localhost:3306/test";
  72. Statement sql;
  73. ResultSet rs;
  74. Class.forName("com.mysql.jdbc.Driver").newInstance();
  75. Connection con=DriverManager.getConnection(url,"root","root");
  76. sql=(Statement) con.createStatement();
  77. rs=sql.executeQuery("select * from songs");
  78.  
  79. ArrayList<Muzica> melodie=new ArrayList<Muzica>();
  80.  
  81. while (rs.next()){
  82. melodie.add(new Muzica(rs.getInt("nr_crt"), rs.getString("titlu_piesa"), rs.getString("artist"), rs.getInt("an_aparitie")));
  83. }
  84.  
  85. for(int i=0;i<melodie.size();i++)
  86. System.out.println(melodie.get(i).toString());
  87.  
  88. String s = (String)JOptionPane.showInputDialog(null,"Introduceti indicele melodiei:","Input",JOptionPane.QUESTION_MESSAGE,null,null,null);
  89. System.out.println("Indicele introdus este: " + s);
  90.  
  91. try {
  92. int indice = Integer.parseInt(s);
  93. melodie.remove(indice);
  94. } catch (NumberFormatException ex) {
  95. JOptionPane.showMessageDialog(null, "Numar invalid", "Eroare", JOptionPane.ERROR_MESSAGE);
  96. }
  97.  
  98. con.close();
  99. sql.close();
  100. rs.close();
  101. }
  102. }
Add Comment
Please, Sign In to add comment