about jsp, jdbc....pls

•

What is DaniWeb IT Discussion Community?

You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 428,386 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,588 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our JSP advertiser: Lunarpages JSP Web Hosting

Thread Tools Display Modes

Views: 473 | Replies: 3

•

Join Date: Apr 2007

Posts: 32

Reputation: push is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

push

Offline

Light Poster

about jsp, jdbc....pls

Jun 3rd, 2008

am tring get value from msaccses database with wher condition but am not get. pls give me an idea to overcome this problum. and pls..help to get data from table based on the dropdownlist vaues wich is in html page. using jsp, jdbc.......pls.....

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
<%@ page import="java.sql.*" %>
<%@page contentType="text/html" %> 
 
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
 
<HTML>
    <HEAD>
        <TITLE>Selecting tableName From a Database</TITLE>
    </HEAD>
 
    <BODY>
        <H1>Selecting tableName From a Database</H1>
 
          <% 
            Int id = request.getValue("s1");            
            Connection connection = DriverManager.getConnection("jdbc:odbc:push1", " ", " ");
 
            Statement statement = connection.createStatement() ;
            ResultSet resultset = statement.executeQuery("select * from T1 where PART_NUMBER =7125") ; 
            //ResultSet resultset = statement.executeQuery("select * from t1 where PART_NUMBER = "+request.getParameter('s1')") ;
            //ResultSet resultset = statement.executeQuery("select * from T1 where PART_NUMBER ='"+id+"'") ;          
            //ResultSet resultset = statement.executeQuery("select * from T1 where PART_NUMBER =id") ;
              ResultSet resultset = statement.executeQuery("select * from T1 where PART_NUMBER ='"+id+"'");      
%>
 
        <TABLE BORDER="1">
            <TR>
                <TH>PART_NUMBER</TH>
                <TH>DESCRIPTION</TH>
                <TH>PRICE</TH>
                            </TR>
            <% while(resultset.next()){ %>
            <TR>
                <TD> <%= resultset.getInt(1) %></td>
                <TD> <%= resultset.getString(2) %></TD>
                <TD> <%= resultset.getInt(3) %></TD>
 
            </TR>
            <% } %>
        </TABLE>
    </BODY>
</HTML>
<%@ page import="java.sql.*" %>
<%@page contentType="text/html" %> 

<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

<HTML>
    <HEAD>
        <TITLE>Selecting tableName From a Database</TITLE>
    </HEAD>

    <BODY>
        <H1>Selecting tableName From a Database</H1>
            
          <% 
            Int id = request.getValue("s1");            
            Connection connection = DriverManager.getConnection("jdbc:odbc:push1", " ", " ");

            Statement statement = connection.createStatement() ;
            ResultSet resultset = statement.executeQuery("select * from T1 where PART_NUMBER =7125") ; 
            //ResultSet resultset = statement.executeQuery("select * from t1 where PART_NUMBER = "+request.getParameter('s1')") ;
            //ResultSet resultset = statement.executeQuery("select * from T1 where PART_NUMBER ='"+id+"'") ;          
            //ResultSet resultset = statement.executeQuery("select * from T1 where PART_NUMBER =id") ;
              ResultSet resultset = statement.executeQuery("select * from T1 where PART_NUMBER ='"+id+"'");      
%>

        <TABLE BORDER="1">
            <TR>
                <TH>PART_NUMBER</TH>
                <TH>DESCRIPTION</TH>
                <TH>PRICE</TH>
                            </TR>
            <% while(resultset.next()){ %>
            <TR>
                <TD> <%= resultset.getInt(1) %></td>
                <TD> <%= resultset.getString(2) %></TD>
                <TD> <%= resultset.getInt(3) %></TD>
                
            </TR>
            <% } %>
        </TABLE>
    </BODY>
</HTML>

Last edited by peter_budo : Jun 3rd, 2008 at 4:20 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Mar 2008

Posts: 117

Reputation: Thirusha is an unknown quantity at this point

Rep Power: 1

Solved Threads: 13

Thirusha

Offline

Junior Poster

Re: about jsp, jdbc....pls

Jun 3rd, 2008

it is not good practice to connect to a database using jsp, rather use a servlet, and there are loads of examples online for connecting to a db using a servlet.

•

Join Date: Apr 2007

Posts: 32

Reputation: push is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

push

Offline

Light Poster

Re: about jsp, jdbc....pls

Jun 3rd, 2008

thanks............

•

Join Date: Nov 2004

Location: Netherlands

Posts: 5,752

Reputation: jwenting is a jewel in the rough

Rep Power: 18

Solved Threads: 199

jwenting

Offline

duckman

Re: about jsp, jdbc....pls

Jun 5th, 2008

and quite apart from that, using the bridge driver is also a VERY bad idea.
It's unstable, old, and poorly written.
Read the documentation, it's not intended to be used as more than a demo (and that a decade ago) of what JDBC is.

As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.