import java.sql.*;
import java.util.*;
public class Repositorio {
static ResourceBundle res = ResourceBundle.getBundle("sismail.Res1");
private static boolean DEBUG = false;
// private Connection connection;
private final String driver = res.getString("driver");
private static final String url = res.getString("url");
private static final String user = res.getString("Usuario");
private static final String password = res.getString("senha");
private static Repositorio rep = new Repositorio();
private Repositorio()
{
try {
Class.forName(driver);
}
catch (ClassNotFoundException cex) {
System.out.println(res.getString("nao_achei_o_drive_do"));
//throw new Exception("_Nenhum_driver_dispon");
}
}
public static Connection getConnection() throws SQLException {
Connection connection = null;
try {
connection = DriverManager.getConnection(url, user, password);
}
catch (SQLException sex) {
throw new SQLException(sex.getMessage());
}
return connection;
}
public static void devolveconexao(Connection connection) {
try {
connection.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
}//Fim de Classe
url=jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=hotel
Usuario=sa
senha=
driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
javax.servlet.ServletException: Servlet execution threw an exception
javax.servlet.ServletException: Servlet execution threw an exception
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:484)
Se vc's puderem me ajudar eu agradeço muito!!!! Isso seria para pegar no Banco os dados de login e senha de usuario para uma autenticação.