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 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
|
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DataBase extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res) throws IOException, ServletException
{
doPost(req,res);
}
public void doPost(HttpServletRequest req,HttpServletResponse res) throws IOException, ServletException
{
try
{
PrintWriter pw=res.getWriter();
pw.println("Bonjour");
String str="SELECT * FROM Email";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver *.mdb,*.accdb)};DBQ=tech.mdb","","");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(str);
pw.println("Affichage Messages :");
while(rs.next())
{
String vers= rs.getString("vers");
pw.println("vers"+vers);
String objet= rs.getString("objet");
pw.println("objet"+objet);
String contenu= rs.getString("contenu");
pw.println("contenu"+contenu);
}
} // try 1
catch(SQLException e) {System.err.println("SQL Exception trouvée !");}
catch(ClassNotFoundException e) {System.err.println("JdbcOdbc Bridge Driver non trouvé!");}
finally {System.err.println("Fin intèrieure finally");}
} // try 2
catch(Exception ex) {System.out.println("erreur"+ex);}
finally {System.err.println("Fin extèrieure finally");}
System.out.println("Fin");
}
} |
Partager