Achei esse artigo aqui no site pra conectar ao mysql mas não tô conseguindo:
http://www.guj.com.br/articles/7
meu codigo tá assim:
package classes;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conn {
public Connection conectar() {
String url = "jdbc:mysql://localhost/listagem?user=root&password=";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url);
return conn;
} catch (SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
System.err.println("SQLState: " + ex.getSQLState());
System.err.println("VendorError: " + ex.getErrorCode());
return null;
} catch (Exception e) {
System.err.println("Problemas ao tentar conectar com o banco de dados");
return null;
}
}
}
o index:
<%@ page language="java" import="java.sql.*" %>
<%@ page language="java" import="classes.Conn" %>
<%
Conn conex = new Conn();
Connection conn = conex.conectar();
//cria o statment e realiza a consulta
Statement st = conn.createStatement();
String sql = "SELECT * FROM cadastros";
ResultSet rs = st.executeQuery(sql);
while (rs.next()) {
out.println( "<tr><td>" + rs.getString(2) + "</td><td>" + rs.getString(3) + "</td><td>.</td></tr>"); //mostra o campo 1
}
%>
Está dando erro no Statement: Statement st = conn.createStatement();
