how to connect jsp page with the db2 database?

Expand|Select|Wrap|Line Numbers

 @ page pageEncoding="UTF-8" %>

<%@page contentType="text/html" %>

<%@page session="false" %>

<%@page import="java.sql.*" %>

<%@page import="java.util.*" %>

<html>

    <head>

        <title>emplolyees firstname</title>

    </head>

    <body>

        <%

         Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();

         Connection con=DriverManager.getConnection("jdbc:db2:sample","","");

         String sql="SELECT firstnme from emp ";

         Statement st=con.createStatement();

         ResultSet rs= st.executeQuery(sql);

         while(rs.next())

          {

             String firstname=rs.getString(1);

       %>

           <h5>

              EMPLOYEES FIRSTNAME ARE :<%= firstname%>

           </h5>

           <br>

       <%

        }

        rs.close();

        rs=null;

        st.close();

        st=null;

        con.close();
 
      %>

      <br>

      <br>

      <b> THE END OF DATA</b>

    </body>

</html>

i did dis but the result is not coming wat is d problem..
error report is :
description:-The requested resource () is not available.

Aug 16 '10 #1

Subscribe Post Reply

1704

Similar topics

Data Link - Can't connect to database

by: Alex Hardin | last post by:

Hey, I'm trying to use the connect to database wizard to connect to a MySQL database on my web server, 66.235.193.45 (I'm actually not sure if that points specifically to my part of the server, if...

.NET Framework

c#e connect to database?

by: John Bailo | last post by:

I just loaded c# express and sql05 express. When I try to connect to the database from c#e nothing happens. I tried "connect to database" and when I click on the menu, it just goes away and...

.NET Framework

Can't Connect to Database Engine

by: mbsparrow | last post by:

I have just installed sql server 2005 Express . The Server is running but I can't connect to the Server in Server Management Studio (on the same machine). I am getting the following message: ...

Microsoft SQL Server

C# Web Service won't connect to database

by: =?Utf-8?B?TmVsc29uIEFuZHLDqQ==?= | last post by:

Dear friends, I'm a Web Services newbie and I have created a simple Web Service that given 3 parameters accesses a database and returns 1 value. When run from Visual Studio 2005, the Webservice...

.NET Framework

Sometimes an error come out "Could not connect to database"..Why??

by: manevolution | last post by:

I've used php mambo and oracle 9 to develop a web-based application..I also used separate server for database and the system..but sometime an error occur to the database connection, its display...

Oracle Database

I can't connect Access database into more form please help me

by: asad56 | last post by:

I am workin with a superstore managment project. I connect Access database with main form . Then it work properly. But now I connect same database with another table or field in another form which is...

Visual Basic 4 / 5 / 6

Connect to database

by: =?Utf-8?B?RGF2ZQ==?= | last post by:

This is kind of a cross forum problem. I am trying to Connect to database by clicking on: Tools Connect To Database Select: Microsoft SQL Server (SqlClient). However, there are no server listed...

C# / C Sharp

cannot connect to database

by: binitarana | last post by:

I have a problem with .net application. We have an application created in VB.Net. It's a client server application. The database is SQL Server 2000. 5-6 clinet machine are accessing the server....

.NET Framework

ASP.NET 2.0 C# WebService Connect to Database

by: Wendi Turner | last post by:

ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005 --------------------------------------------------------------------------------------------------- I have successfully created a...

C# / C Sharp

ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005

by: Wendi Turner | last post by:

ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005 --------------------------------------------------------------------------------------------------- I have successfully created a...

.NET Framework

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA