<%@page contentType="text/html; charset=Cp1251"%>
<%@page import='java.sql.*, javax.sql.*, javax.naming.*, oracle.sql.*, oracle.jdbc.*' %>
<%
request.setCharacterEncoding("Cp1251");

String user = "user";
String password = "pwd";
String database = "dbname";
String server = "192.1.2.4";
String port = "1521";


String url = "jdbc:oracle:thin:@" + server + ":" + port + ":" + database;
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(url, user, password);
conn.setAutoCommit(false);

try {
Statement stmt = conn.createStatement();
String sele = ("select * from users where name='Bob' ");
ResultSet rs = stmt.executeQuery(sele);

int nstr=0;
while (rs.next()) {
nstr++;

}

} finally {
conn.close();
}
%>


</body>
</html>