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

Can an interface be implemented in the jsp file?

1014

---

Can you disable jsp scripting?

1002

---

Give an example of using your own tags.

988

---

What is the difference between servletcontext and pagecontext?

1046

---

Can I declare a java class in jsp?

1059

---

What is jsp and how it works?

955

---

Can you call jsp from servlet?

952

---

What is difference between java and jsp?

977

---

What is jsp container?

1005

---

How do I run a jsp file in linux?

1024

---

How does a jsp engine work?

980

---

What are the literals used in jsp?

1125

---

Mention some important jsp action tags.

1013

---

Give the use of session object.

1055

---

What is the standard action?

1042

---