Boa tarde,
Gostaria de saber porque não funciona quando chamo o método ConnectionMysql.getConnection() dentro do meu código JSP. Mas funciona quando faço a conexão dentro do JSP via DriverManager.getConnection.
Obrigado.
Código JSP
<html>
<%@ page import = "java.sql.*,java.util.*,br.com.denis.jdbc.modelo.*,br.com.denis.jdbc.dao.*,br.com.denis.jdbc.*"%>
<%
Connection conex = ConnectionMysql.getConnection();
if(conex == null){
out.println("nulo");
}else{
out.println("ok");
}
Class.forName("com.mysql.jdbc.Driver").newInstance();
conex = DriverManager.getConnection("jdbc:mysql://localhost/estudos","root","123");
if(conex == null){
out.println("nulo1");
}else{
out.println("ok1");
}
%>
</html>
classe ConnectionMysql
package br.com.denis.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionMysql {
public static Connection conn = null;
public static Connection getConnection() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost/estudos","root","123");
return conn;
}
public static void closeConnection() {
if (conn != null) {
try {
System.out.println("fechando banco");
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}