Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%--
- Connessione
- --%>
- <%@ page import="java.sql.*" %>
- <%
- final String DRIVER="org.postgresql.Driver"; //Nome del driver
- //final String DB_NAME="jdbc:firebirdsql:localhost:C:/Documents and Settings/Utente/Documenti/NetBeansProjects/JSP/database/DBLAVORI.FDB"; //Nome del database completo di percorso
- final String DB_NAME="jdbc:postgresql://localhost:5432/progetto"; //Nome del database completo di percorso
- final String DB_USER="postgres"; // Nome utente
- final String DB_PASSWORD="pollo"; //Password
- Connection con=null; //Riferimento alla connessione
- //Connection con1=null; //Riferimento alla connessione
- try {
- Class.forName(DRIVER); //Carica il driver
- con=DriverManager.getConnection(DB_NAME, DB_USER, DB_PASSWORD); //Effettua la connessione al database
- //con1=DriverManager.getConnection(DB_NAME, DB_USER, DB_PASSWORD); //Effettua la connessione al database
- //out.println("Connessione al server DBMS avvenuta con successo!");
- }
- catch(Exception e) {
- %>
- <%@ page contentType="text/html" pageEncoding="UTF-8"%>
- <!DOCTYPE HTML>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>Connessione</title>
- </head>
- <body>
- <h2>Connessione</h2>
- <div style="text-align:center">
- <h3>
- Impossibile connettersi al server DBMS!
- </h3>
- <br>
- Possibile causa: <%=e.getMessage()%>
- </div>
- </body>
- </html>
- <%
- //con.close();
- // con1.close();
- return;
- }
- %>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement