I've been studying Java courses but don't have a lot of actual coding experience. Just a few simple applets. I'm ready to apply code using Java to connect and query a database. Do I do this the same way I've been doing applets...i.e. write the code in a text editor, the open the DOS prompt and access it, then create an HTML or URL or whatever to display it? Also, all I have is this Lotus Approach database that came w/this computer on Lotus SmartSuite. Will JDBC work with it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
JDBC
- Thread starter dummie2
- Start date
> Do I do this the same way I've been doing applets...i.e. write the code in a text editor, <br><br>Yes<br><br>>the open the DOS prompt and access it, <br><br>Don't know what that means.<br><br>> then create an HTML or URL or whatever to display it? <br><br>No, JDBC will not work from an applet running in a browser. You need to write a Java application. You need to compile the .java file into a .class byte code file using the java compiler. Then you execute the Java Virtual Machine passing it the .class file name from the command line. NOTE: If you have never developed a Java application you need to study up on that. For instance say you had a file named jtest.java then this would be in it.<br><br>import java.io.*;<br>public class JTest<br>{<br> public static void main ( String[] args){<br> System.out.println("Hello World"
;<br> }<br>}<br><br>> all I have is this Lotus Approach database <br>> Will JDBC work with it? <br><br>I don't know anything about 'Lotus Approach'. To connect with any database using JDBC you need a JDBC driver. If you are running in a Windows OS you might have the JDBC to ODBC bridge driver which allows you access to any database that has an ODBC driver registered in Windows for it.<br><br>Hope this helps<br>-pete<br>Good luck<br>-pete
;<br> }<br>}<br><br>> all I have is this Lotus Approach database <br>> Will JDBC work with it? <br><br>I don't know anything about 'Lotus Approach'. To connect with any database using JDBC you need a JDBC driver. If you are running in a Windows OS you might have the JDBC to ODBC bridge driver which allows you access to any database that has an ODBC driver registered in Windows for it.<br><br>Hope this helps<br>-pete<br>Good luck<br>-peteIf you can get a direct JDBC driver, it's preferable.. look around for Lotus drivers for JDBC, or ask Lotus tek-help. If you need help with developing JDBC, let me know.. <p>Liam Morley<br><a href=mailto:lmorley@wpi.edu>lmorley@wpi.edu</a><br><a href=] :: imotic :: website :: [</a><br>"light the deep, and bring silence to the world.<br>
light the world, and bring depth to the silence.
light the world, and bring depth to the silence.
- Status