I want to connect with jsp to oracle,,,plz send me the codes....
<% Connection connection = null; try { // Load the JDBC driver String driverName = "oracle.jdbc.driver.OracleDriver"; Class.forName(driverName); // Create a connection to the database String serverName = "127.0.0.1"; String portNumber = "1521"; String sid = "mydatabase"; String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid; String username = "username"; String password = "password"; connection = DriverManager.getConnection(url, username, password); } catch (ClassNotFoundException e) { // Could not find the database driver } catch (SQLException e) { // Could not connect to the database } %>
<%@ page import="java.sql.*" %> <HTML> <HEAD> <TITLE>Simple JSP/Oracle Query Example <BODY> <% Connection connection = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "bmwm5tt"); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery("SELECT Capacity FROM Engine");
while (resultSet.next()) { int x = resultSet.getInt("Capacity");
} }
catch(Exception exception) { out.println("Exception : " + exception.getMessage() + ""); }
finally { if(connection != null) { try { connection.close(); } catch (Exception ignored) { // ignore }
} }
%>