Untitled

package exemplu;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class MainApp
 */
@WebServlet("/MainApp")
public class MainApp extends HttpServlet {
	private static final long serialVersionUID = 1L;

	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public MainApp() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		try{
			String url = "jdbc:mysql://localhost:3306/test";
			Statement sql;
			ResultSet rs;
			Connection con = DriverManager.getConnection (url, "root", "root");
			sql = (Statement) con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			rs = sql.executeQuery("select * FROM muzica");

			PrintWriter out=response.getWriter();
			out.println("<html><head><title>Titlu</title></head><body>");
			out.println("<form method='GET' action=''>");
			out.println("<p>id<input type='text' name='id'></p>");
			out.println("<p>tipul<input type='text' name='tip'></p>");
			out.println("<p>producator<input type='text' name='producator'></p>");
			out.println("<p><input type='submit' value='Adauga' name='Adauga'></p>");
			out.println("<p><input type='submit' value='Modifica' name='Modifica'></p>");
			out.println("<p><input type='submit' value='Sterge' name='Sterge'></p>");
			out.println("</form>");
			out.println("<table><tr><th>id</th><th>tip</th><th>producator</th></tr>");

			if(request.getParameter("Adauga")!=null)
			{
				int id=Integer.parseInt(request.getParameter("id"));
				String tip=request.getParameter("tip");
				String producator=request.getParameter("producator");
				String comanda="insert into muzica values("+id+","+tip+"+"+producator+")";
				try{
					sql.executeQuery(comanda);
					rs=sql.executeQuery("select *from muzica");
				}
				catch(SQLException e)
				{
					System.out.println(e);
				}
			}

			if(request.getParameter("Modifica")!=null)
			{
				int id=Integer.parseInt(request.getParameter("id"));
				String tip=request.getParameter("tip");
				String producator=request.getParameter("producator");
				String comanda="update muzica set tip="+tip+",producator="+producator+"where id="+id+"";
				try{
					sql.executeQuery(comanda);
					rs=sql.executeQuery("select *from muzica");
				}
				catch(SQLException e)
				{
					System.out.println(e);
				}
			}
			if(request.getParameter("Sterge")!=null)
			{
				int id=Integer.parseInt(request.getParameter("id"));
				String tip=request.getParameter("tip");
				String producator=request.getParameter("producator");
				String comanda="delete from muzica where id="+id+"";
				try{
					sql.executeQuery(comanda);
					rs=sql.executeQuery("select *from muzica");
				}
				catch(SQLException e)
				{
					System.out.println(e);
				}
			}
			while(rs.next())
				out.println("<tr><td>"+rs.getInt("id")+"</td><td>"+rs.getString("tip")+"</td><td>"+rs.getString("producator")+"</td></tr>");

			out.println("</table></body></html>");

		}
		catch(SQLException ex)
		{
			System.out.println("exceptia"+ex);
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}

}