JSP (Tomcat) Oracle Connection
tomcat.jpg OJDBC.JAR herunterladen:

ojdbc14.jar

Datei kopieren und zu Tomcat lib einfügen.(Tomcat 6 --> lib, Tomcat 5.5 --> common --> lib)

Tomcat neu Start
als JSP Datei speichern

<%@ page import="java.sql.*" %>

<HTML>
<HEAD>
<TITLE>JSP/Oracle Connection</TITLE>
</HEAD>
<BODY>
<h1>Tomcat Oracle</h1>
<%

String Spalte;

Connection connection = null;
try
{
 Class.forName("oracle.jdbc.driver.OracleDriver");
 // bsp: server (localhost), port (1521), sid (orcl)
 connection = DriverManager.getConnection("jdbc:oracle:thin:@server:port:sid", "user", "password");
 Statement sqlStatement = connection.createStatement();
 ResultSet sqlResult = sqlStatement.executeQuery("SELECT SPALTENAME FROM TABELLENAME");

 while (sqlResult.next())
 {
      Spalte = sqlResult.getString("SPALTENAME");
      out.println(Spalte + "<br />");

 }
 sqlResult.close();
 sqlStatement.close();
}

catch(Exception exception)
{
 out.println("Exception : " + exception.getMessage() + "");
}

finally
{
 if(connection != null)
 {
   connection.close();
 }
}

%>
</BODY>
</HTML>

       

Kopieren