Answer Posted / 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”);
%>

Why jsp is used instead of html?

1041

---

What do you mean by jsp directives?

994

---

What are the implicit, internal el jsp objects and their differences from jsp objects?

987

---

Why is jsp used?

891

---

What is the use of?

954

---

What information is needed to create a tcp socket?

917

---

What is an api with example?

1037

---

What are the steps for creating custom tags in jsp?

902

---

What is expression tag in jsp?

897

---

How to disable session in jsp?

982

---

What are directives in jsp?

976

---

Which jsp lifecycle methods can be overridden?

969

---

Can we use javascript with jsp pages?

975

---

Explain the difference between servlet and jsp?

993

---

What is jstl (jsp standard tag library)?

928

---