Find Interview Questions for Multicoreware, inc

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

Yield function keeps all single return values and return all at a time as a list
Yield and return both are used for returning the values from function.
Generally yield is used with iterators, So yield will keep all the return values of each iterative call and returns final result at the end of call as List where as return can return one value for each function call.