Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.*;
- import javax.servlet.*;
- import javax.servlet.http.*;
- import java.sql.*;
- public class TablaVotos extends HttpServlet {
- private Connection _con = null;
- private Statement _stmt = null;
- private ResultSet _rs = null;
- public TablaVotos() {
- super();
- }
- public void init(ServletConfig cfg) throws ServletException {
- try {
- String url = "jdbc:mysql://localhost/bd_jugadores";
- String username = "root";
- String password = "TheDarkSide";
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- _con = DriverManager.getConnection(url, username, password);
- } catch (Exception e) {
- System.out.println("ERROR EN LA CONEXION");
- e.printStackTrace();
- }
- }
- public void doPost(HttpServletRequest req, HttpServletResponse res)
- throws ServletException, IOException {
- String nombreP = (String) req.getParameter("txt_nombre");
- PrintWriter out = res.getWriter();
- res.setContentType("text/html");
- out.println("<html>");
- out.println("<head>");
- out.println("<title>JDBC</title>");
- out.println("</head>");
- out.println("<body>");
- out.println("<font size=\"10\"><h1>Ejemplo JDBC</h1>");
- out.println("<table border=\"1\">");
- out.println("<tr><td><b>Jugador</b></td><td><b>Votos</b></td></tr>");
- try {
- String nombre;
- int votos;
- _stmt = _con.createStatement();
- _rs = _stmt.executeQuery("SELECT * FROM jugadores");
- while (_rs.next()) {
- nombre = _rs.getString("nombre");
- votos = _rs.getInt("votos");
- out.println("<tr><td>" + nombre + "</td><td>" + votos
- + "</td></tr>");
- }
- _rs.close();
- _stmt.close();
- } catch (Exception e) {
- System.out.println("NO LEE DE LA TABLA");
- e.printStackTrace();
- }
- out.println("</table>");
- out.println("<h3>Muchas gracias " + nombreP
- + " por su visita.</h3></font>");
- out.println("</body>");
- out.println("</html>");
- out.close();
- }
- public void destroy() {
- try {
- _con.close();
- } catch (Exception e) {
- System.out.println("ERROR AL CERRAR LA CONEXION");
- e.printStackTrace();
- }
- super.destroy();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement