perchč questo in java non funziona e il successivo in jsp si
import java.awt.*;
import java.sql.*;
//import java.sql.
public class estrai_utenti{
public static void main(String[] args) {
String b;
Connection con;
try {
Class.forName ("oracle.jdbc.driver.OracleDriver");
//DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
//Class.forName("oracle.jdbc.driver.OracleDriver");
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
System.out.println ("Non trovo il driver del database");
}
try {
//Connection con=DriverManager.getConnection("jdbcdbc:fabio");
con=DriverManager.getConnection("jdbc
//Connection con=DriverManager.getConnection("jdbc
// Statement st=con.createStatement();
//ResultSet rs=st.executeQuery("Select nome from AA_PROVA1");
// while(rs.next())
//{
// b=rs.getString(1);
// }
//st.close();
//con.close();
} catch (SQLException e) {
System.out.println("Non riesco a connettermi con il database ");
}
}
}
<%@ page language="java" import="java.sql.*"%>
<HTML>
<HEAD>
<TITLE>Elenco</TITLE>
</HEAD>
<BODY>
<%
Connection con;
Class.forName("oracle.jdbc.driver.OracleDriver");
//try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
//catch (ClassNotFoundException e)
//{
//System.out.println("Impossibile caricare il driver: "+ e);
//}
con=DriverManager.getConnection("jdbc
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("Select nome from AA_PROVA1");
%>
<TABLE>
<TR>
<TD>Nome</TD>
</TR>
<%
while(rs.next())
{
%>
<TR>
<TD><%=rs.getString(1)%></TD>
</TR>
<%
}
st.close();
con.close();
%>
</TABLE>
</BODY>
</HTML>
entra nel catch al punto classforname e driver manager
