Results 1 to 4 of 4

Thread: Jdbc

  1. #1
    Junior Member
    Join Date
    Dec 2007
    Answers
    3

    Jdbc

    is it possible to use type1 driver in web application?

    if so give me an example....


  2. #2
    Junior Member
    Join Date
    Dec 2007
    Answers
    5

    Re: Jdbc

    Hello ,
    Geek members ,hai!.

    Please send me the interview Q&A
    forsolving java programs .


  3. #3

    Re: Jdbc

    Yes you can use Type1 Driver in Web Applications

    the example is following:-
    Make a database in MS Access or in MS Excel and use it as a database

    suppose u have made a table say "Table1" in MS Access database say "db1" and DSN is "MyAccess" then this programme will help you

    <&#37;@ page import="java.sql.*" %>
    <html>
    <body>
    <%
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection conn=DriverManager.getConnection("jdbcdbc:MyAccess");

    Statement stmt=conn.createStatement();
    ResultSet result=stmt.executeQuery("select * from Table1");
    while(result.next())
    {
    out.println(result.getType(Column-name)+..............)
    }
    %>
    </body>
    </html>


  4. #4
    Expert Member
    Join Date
    May 2009
    Answers
    1,374

    Re: Jdbc

    Hi Nikhil,

    u r absolutely right.........
    Type 1 driver can be used in web application.
    The example is good.......
    Regards,
    riju


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact