QuestionAsk Questions?
sanatankumar
I want to connect with jsp to oracle,,,plz send me the codes....
View Answers
June 28, 2011 at 1:06 PM
<%
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
}
%>
August 15, 2012 at 12:12 PM
<%@ 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 }
} }
%>