asdasdasd

package EjercicioDeInicio;

import java.awt.EventQueue;

import javax.swing.JFrame;
import java.awt.BorderLayout;
import javax.swing.JList;
import javax.swing.JPanel;
import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.JTextField;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.swing.ListSelectionModel;

public class ejercicio {

	private JFrame frame;
	private JTextField texto;
	private JList<String> list;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					ejercicio window = new ejercicio();
					window.frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the application.
	 */
	public ejercicio() {
		initialize();
	}

	/**
	 * Initialize the contents of the frame.
	 */
	private void initialize() {
		frame = new JFrame();
		frame.setBounds(100, 100, 714, 377);
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		frame.getContentPane().setLayout(new BorderLayout(0, 0));

		list = new JList<String>();
		list.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
		list.addMouseListener(new MouseAdapter() {
			@Override
			public void mouseClicked(MouseEvent e) {
				listSelected();
			}
		});
		DefaultListModel<String> model = new DefaultListModel<String>();
		list.setModel(model);

		frame.getContentPane().add(list, BorderLayout.CENTER);

		JPanel panel = new JPanel();
		frame.getContentPane().add(panel, BorderLayout.SOUTH);

		JButton delete = new JButton("Borrar seleccionado");
		delete.addMouseListener(new MouseAdapter() {
			@Override
			public void mouseClicked(MouseEvent arg0) {
				deleteElement();
			}
		});
		panel.add(delete);

		JButton savedisc = new JButton("Guardar en disco");
		savedisc.addMouseListener(new MouseAdapter() {
			@Override
			public void mouseClicked(MouseEvent e) {
				saveDisk();
			}
		});
		savedisc.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
			}
		});
		panel.add(savedisc);

		JButton loaddisc = new JButton("Cargar de disco");
		loaddisc.addMouseListener(new MouseAdapter() {
			@Override
			public void mouseClicked(MouseEvent e) {
				loadDisk();
			}
		});
		panel.add(loaddisc);

		JButton savedb = new JButton("Guardar en base de datos");
		savedb.addMouseListener(new MouseAdapter() {
			@Override
			public void mouseClicked(MouseEvent arg0) {
				saveDB();
			}
		});
		panel.add(savedb);

		JButton loaddb = new JButton("Cargar en base de datos");
		panel.add(loaddb);

		JPanel panel_1 = new JPanel();
		frame.getContentPane().add(panel_1, BorderLayout.WEST);

		texto = new JTextField();
		panel_1.add(texto);
		texto.setColumns(10);

		JButton add = new JButton("A\u00F1adir");
		add.addMouseListener(new MouseAdapter() {
			@Override
			public void mouseClicked(MouseEvent arg0) {
				addElement();
			}
		});
		panel_1.add(add);

		JButton edit = new JButton("Modificar");
		edit.addMouseListener(new MouseAdapter() {
			@Override
			public void mouseClicked(MouseEvent e) {
				modifyElement();
			}
		});
		panel_1.add(edit);
	}

	private void deleteElement() {
		String selectedValue = list.getSelectedValue();
		DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
		model.removeElement(selectedValue);
	}

	private void addElement() {
		String value = texto.getText();
		DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
		model.addElement(value);
	}

	private void listSelected() {
		String selectedValue = list.getSelectedValue();
		texto.setText(selectedValue);
	}

	private void modifyElement() {
		String value = texto.getText();
		DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
		if (list.getSelectedIndex() > -1)
			model.setElementAt(value, list.getSelectedIndex());
	}

	private void saveDisk() {
		FileWriter fw = null;
		PrintWriter pw = null;
		try {
			fw = new FileWriter("fichero.txt");
			pw = new PrintWriter(fw);

			DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
			int size = model.getSize();
			for (int i = 0; i < size; i++) {
				pw.println(model.getElementAt(i));
			}

			/*for (int i = 0; i < 0; i++) {
				pw.println("hola");
			}*/

		} catch (IOException e) {
			System.out.println("Fallo en el acceso al fichero." + e.getMessage());
		} finally {
			try {
				if (fw != null)
					fw.close();
				if (pw != null)
					pw.close();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

	private void loadDisk() {
		FileReader fr = null;
		BufferedReader br = null;
		try {
			fr = new FileReader("fichero.txt");
			br = new BufferedReader(fr);

			DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
			model.removeAllElements();
			String line;
			while ((line = br.readLine()) != null) {
				model.addElement(line);
			}
		} catch (IOException e) {
			System.out.println("Fallo en el acceso al fichero." + e.getMessage());
		} finally {
			try {
				if (fr != null)
					fr.close();
				if (br != null)
					br.close();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

	private void saveDB() {
		String sURL = "jdbc:mysql://localhost:3306/lista";
		String user = "root";
		String pass = "AlumnoDAM";
		String sDriver = "com.mysql.jdbc.Driver";
		Connection con = null;

		try {
			Class.forName(sDriver).newInstance();
			con = DriverManager.getConnection(sURL, user, pass);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InstantiationException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
		int size = model.getSize();
		for (int i = 0; i < size; i++) {
			String query = "INSERT INTO lista (nombre) VALUES (?)";
			PreparedStatement ps = con.prepareStatement(query);
			ps.setString(1, "xxxx");
			ps.executeUpdate();
		}

		con.close();
	}

	public JList<String> getList() {
		return list;
	}
}