JSP (Tomcat) Oracle Connection
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> |