how to connect the back end with Directive tag in jsp ...
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 |
Which directive is used in jsp custom tag?
What are the two ways to include the result of another page?
What are the steps involved in reading data from a form using jsp?
What is jstl jar?
How do I set password expire time period?
How are jsp(java server pages) better than asp(active server pages)?
Explain the steps for creating custom tags in jsp?
What are the types of jstl tags?
Why do we use expression language in jsp?
How to include static files in a jsp?
What program opens a jsp file?
Differentiate between pagecontext.include and jsp:include?