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

How do I save a jsp file?

916

---

What is difference between custom jsp tags and beans?

917

---

What are jsp and servlets?

875

---

How to make a “new line in html” in jsp?

886

---

What is a tag file in jsp?

871

---

When the destroy method of the jsp's are called?

835

---

What is client scripting?

897

---

Is jsp static or dynamic?

919

---

Is jsp better than servlet?

852

---

When destroy method of jsp is called?

879

---

List down the major differences between the jsp custom tags and java beans.

796

---

Explain the difference between servlet and jsp?

931

---

What is the include directive?

901

---

Explain some jsp life-cycle methods that can be overridden.

823

---

What is the difference between a jspwriter and a servlet printwriter?

896

---