Untitled

package muzica;

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 Muzica
 */
@WebServlet("/Muzica")
public class Muzica extends HttpServlet {
	private static final long serialVersionUID = 1L;

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

	public void instrument() throws ClassNotFoundException, SQLException
	{

		String url = "jdbc:mysql://localhost:3306/database";

		Class.forName("com.mysql.jdbc.Driver");
		Connection con = DriverManager.getConnection (url, "admin", "admin");
		Statement sql =  con.createStatement();
		String cmd = "SELECT id, tip, carac FROM muzica";
		ResultSet rs = sql.executeQuery("cmd");
		while(rs.next()){
			//out.println("<tr><td>" + String.valueOf(rs.getInt("id")) + "</td><td>" + String.valueOf(rs.getString("tip")) + "</td><td>" + String.valueOf(rs.getString("carac"))+ "</td></tr>");
			String id = rs.getString("id");
			String tip = rs.getString("tip");
			String carac = rs.getString("carac");
			rs.close();
	         sql.close();
	         con.close();
		}

	}
}
	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		PrintWriter out = response.getWriter();
		out.println("<html><head><title></title><body>");
		out.println("<table border =\"2\">");
		out.println("<tr><th>ID</th><th>Tip</th><th>Caracteristici</th></tr>");
		try {
			instrument();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		/*while(rs.next()){
			out.println("<tr><td>" + String.valueOf(rs.getInt("id")) + "</td><td>" + String.valueOf(rs.getString("tip")) + "</td><td>" + String.valueOf(rs.getString("carac"))+ "</td></tr>");
		}*/


	}

	private void instrument() throws SQLException, ClassNotFoundException {
		// TODO Auto-generated method stub
		String url = "jdbc:mysql://localhost:3306/database";

		Class.forName("com.mysql.jdbc.Driver");
		Connection con = DriverManager.getConnection (url, "admin", "admin");
		Statement sql =  con.createStatement();
		String cmd = "SELECT id, tip, carac FROM muzica";
		ResultSet rs = sql.executeQuery("cmd");
		while(rs.next()){
			//out.println("<tr><td>" + String.valueOf(rs.getInt("id")) + "</td><td>" + String.valueOf(rs.getString("tip")) + "</td><td>" + String.valueOf(rs.getString("carac"))+ "</td></tr>");
			String id = rs.getString("id");
			String tip = rs.getString("tip");
			String carac = rs.getString("carac");
			rs.close();
	         sql.close();
	         con.close();
		}


	}

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

	}

}