1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException{
ResultSet result = null;
Connection conn = null;
Statement state = null;
PrintWriter out = response.getWriter();
String url = "jdbc:postgresql://localhost:5432/intranet";
String user = "monUsername";
String passwd = "monPassword";
try {
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection(url, user, passwd);
state = conn.createStatement();
} catch (ClassNotFoundException e) {
// Je rentre dans ce catch et j'ai le message : java.lang.ClassNotFoundException: org.postgresql.Driver
out.println( e );
} catch (SQLException e) {
out.println( e );
}
if( conn == null )
out.println( "Null connection" );
else
out.println( "Connecter" );
if( state == null )
out.println( "Null statement" );
else
out.println( "State ok" );
} |