Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect the back end with Directive tag in jsp ...
- 1 Answers
- 3893 Views
- I also Faced
- E-Mail Answers
Answer / lovly
A Connection to a database can be established from a jsp page by writing the code to establish a connection using a jsp scriptlets.
<%@ page language=”java” contentType=”text/html”
import=”java.sql.*,java.sql.Statement %>
<%
//load the Oracle JDBC driver or any other driver for a specific
vendor
Class.forName(”sun.jdbc.odbc.JdbcOdbcDriver”);
//open a connection to the “scott” database or other database which you have created. You should provide the username and password as part of this connection string. Here the username and password are scott and tiger.
Connection con=
DriverManager.getConnection(”jdbc:odbc:scott”,”scott”,”tiger”);
//create a statement object for sending SQL queries
Statement stmt = con.createStatement();
//place query results in a ResultSet object
//To get all projects of a particular project leader.
ResultSet res = stmt.executeQuery(” select * from employee”);
String ename=null;
%>
Further then you can use the resultset object “res” to read data in the following way.
<%
while(res.next())
{
ename=res.getString(”ename”);
%>
| Is This Answer Correct ? | 1 Yes | 0 No |
Why are jsp pages the preferred api for creating a web-based client program?
What are jsp elements?
How do I perform browser redirection from a jsp page?
What is meant by session management?
Why should we not configure jsp standard tags in web.xml?
What are the components that make up a tag library in jsp?
How do we catch exception and process it using jstl?
Mention the implicit objects in a jsp.
when we will use the SendRedirect method instead of forward.
What happens when a page is statically included in another jsp page?
Explain the difference between jspwriter and servlet printwriter in jsp?
How can we avoid direct access of jsp pages from client browser?
ASP 
