Untitled

package destinatie_grafica;

import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JList;
import javax.swing.JTextField;


public class MyFrame extends JFrame {
	private JTextField txtAdaugare;
	private JButton btnStergere;
	private JList<Object> myList;
	private DefaultListModel<Object> myModel;
    private List<Destinatie> destinatie=new ArrayList<Destinatie>();
	public MyFrame() throws SQLException,ClassNotFoundException,IllegalAccessException,InstantiationException
	{
		super("Statiuni");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setLocation(400,400);
		setSize(400,400);
		getContentPane().setLayout(null);
		txtAdaugare=new JTextField();
		btnStergere=new JButton("Sterge Statiune");
		myModel=new DefaultListModel<>();
		myList=new JList<Object>(myModel);
		txtAdaugare.setBounds(20,10,350,20);
		myList.setBounds(20,30,350,160);
		btnStergere.setBounds(20,200,350,30);
		getContentPane().add(txtAdaugare);
		getContentPane().add(myList);
		getContentPane().add(btnStergere);

		setVisible(true);
		String url="jdbc:mysql://localhost:3306/test";
		Class.forName("com.mysql.jdbc.Driver").newInstance();
		Connection con=DriverManager.getConnection(url,"root","root");
		Statement sql=(Statement)con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		ResultSet rs=sql.executeQuery("select *from destinatie");
		while(rs.next())
		{
			Destinatie d=new Destinatie(rs.getString("tara"),rs.getString("statiune"),rs.getInt("nr_obiective"));
			destinatie.add(d);
		}
		for(Destinatie i:destinatie)
		{
			myModel.addElement(i.toString());
			myList.setModel(myModel);
		}

		 txtAdaugare.addKeyListener(new KeyAdapter() {
			public void keyPressed(KeyEvent e)
			{
				if(e.getKeyCode()==KeyEvent.VK_ENTER)
				{
					String textS=txtAdaugare.getText();
					String[]parti=txtAdaugare.getText().split(",");
					myModel.addElement(textS.toString());
					try
					{
						rs.moveToInsertRow();
						rs.updateString("tara", parti[0]);
						rs.updateString("statiune", parti[1]);
						rs.updateInt("nr_obiective", Integer.parseInt(parti[2]));
						rs.insertRow();
					}catch(SQLException el)
					{
						el.printStackTrace();
					}
				}

			}


	});


	}
}
@WebServlet("/OperatiiJDBC")
public class OperatiiJDBC extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response){
try{
String url = "jdbc:mysql://localhost:3306/test";
Statement sql=null;
ResultSet rs=null;
Class.forName("com.mysql.jdbc.Driver").newInstance ();
Connection con = DriverManager.getConnection(url,"root", "root");
sql = (Statement) con.createStatement();
rs = sql.executeQuery("select * from persoane");
PrintWriter out=response.getWriter();
out.println("<html><head><title>Persoane</title></head><body>");
out.println("<form method='get' action='OperatiiJDBC'>");
out.println("<table align='center' width='50%' cellspacing='5'>");
out.println("<tr><td align='right'>Id</td><td><input type='text' name='txtId'"
+ " size='5'></td></tr>");
out.println("<tr><td align='right'>Nume</td><td><input type='text'"
+ " name='txtNume'></td></tr>");
out.println("<tr><td align='right'>Varsta</td><td><input type='text'"
+ " name='txtVarsta' size='5' maxlength='3'></td></tr>");
out.println("<tr><td colspan='2' align='center'><input type='submit' "
+ " name='btnAdauga' value='Adauga' style='width: 110px; height: 25px;'>");
out.println("<input type='submit' name='btnModifica' value='Modifica' "
+ " style='width: 110px; height: 25px;'>");
out.println("<input type='submit' name='btnSterge' value='Sterge'"
+ " style='width: 110px; height: 25px;'></td></tr>");
out.println("</table></form>"); 30
out.println("<table align='center' width='50%' border='1'>");
out.println("<tr><th>Id</th><th>Nume</th><th>Varsta</th></tr>");
if (request.getParameter("btnAdauga")!=null){
int id=Integer.parseInt(request.getParameter("txtId"));
String nume=request.getParameter("txtNume");
int varsta=Integer.parseInt(request.getParameter("txtVarsta"));
String comanda="insert into persoane values ("+id+",'"+nume+"',"+varsta+")";
try {
sql.executeUpdate(comanda);
rs = sql.executeQuery("select * from persoane");
} catch (SQLException e) {
System.out.println(comanda+"\n"+e);
}
}
if (request.getParameter("btnModifica")!=null){
int id=Integer.parseInt(request.getParameter("txtId"));
String nume=request.getParameter("txtNume");
int varsta=Integer.parseInt(request.getParameter("txtVarsta"));
String comanda="update persoane set nume='"+nume+"', varsta="+varsta
+" where id="+id;
try {
sql.executeUpdate(comanda);
rs = sql.executeQuery("select * from persoane");
} catch (SQLException e) {
System.out.println(comanda+"\n"+e);
}
}