Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package proiect2;
- import java.awt.List;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.ArrayList;
- import javax.swing.JButton;
- import javax.swing.JFrame;
- import javax.swing.JLabel;
- import javax.swing.JOptionPane;
- import javax.swing.JTextField;
- import com.mysql.jdbc.Statement;
- public class Muzica {
- private int nr_crt;
- private String titlu_piesa;
- private String artist;
- private int an_aparitie;
- public Muzica(int nr_crt, String titlu_piesa, String artist, int an_aparitie) {
- this.nr_crt=nr_crt;
- this.titlu_piesa = titlu_piesa;
- this.artist = artist;
- this.an_aparitie = an_aparitie;
- }
- public String toString() {
- return "Muzica Nr Crt =" + nr_crt + ", Titlul Piesei" + titlu_piesa + ", Aristul " + artist
- + ", Anul Apritiei" + an_aparitie + "]";
- }
- public int getNr_crt() {
- return nr_crt;
- }
- public void setNr_crt(int nr_crt) {
- this.nr_crt = nr_crt;
- }
- public String getTitlu_piesa() {
- return titlu_piesa;
- }
- public void setTitlu_piesa(String titlu_piesa) {
- this.titlu_piesa = titlu_piesa;
- }
- public String getArtist() {
- return artist;
- }
- public void setArtist(String artist) {
- this.artist = artist;
- }
- public int getAn_aparitie() {
- return an_aparitie;
- }
- public void setAn_aparitie(int an_aparitie) {
- this.an_aparitie = an_aparitie;
- }
- public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException{
- String url="jdbc:mysql://localhost:3306/test";
- Statement sql;
- ResultSet rs;
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection con=DriverManager.getConnection(url,"root","root");
- sql=(Statement) con.createStatement();
- rs=sql.executeQuery("select * from songs");
- ArrayList<Muzica> melodie=new ArrayList<Muzica>();
- while (rs.next()){
- melodie.add(new Muzica(rs.getInt("nr_crt"), rs.getString("titlu_piesa"), rs.getString("artist"), rs.getInt("an_aparitie")));
- }
- for(int i=0;i<melodie.size();i++)
- System.out.println(melodie.get(i).toString());
- String s = (String)JOptionPane.showInputDialog(null,"Introduceti indicele melodiei:","Input",JOptionPane.QUESTION_MESSAGE,null,null,null);
- System.out.println("Indicele introdus este: " + s);
- try {
- int indice = Integer.parseInt(s);
- melodie.remove(indice);
- } catch (NumberFormatException ex) {
- JOptionPane.showMessageDialog(null, "Numar invalid", "Eroare", JOptionPane.ERROR_MESSAGE);
- }
- con.close();
- sql.close();
- rs.close();
- }
- }
Add Comment
Please, Sign In to add comment