Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
JSP interact with Fox Pro
Message
From
21/12/2002 21:39:44
Edward See
Magicalogic Consultancy System
Quezon, Philippines
 
 
To
29/08/2002 12:44:42
General information
Forum:
Java
Category:
Other
Miscellaneous
Thread ID:
00695032
Message ID:
00735208
Views:
10
Hi Baron
Merry Xmas
just map ODBC to the directory or .DBC of Foxpro tables
then in jsp
<% @ page import="java.lang.*,java.text.*,java.sql.*,java.util.*"  % >
< %  
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:Foxpro.DBC",null,null);
Statement stmt  = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT customer,terms,date FROM customer");
while ( rs.next() )
{   String customer = rs.getString("customer");
    int terms = rs.getInt("terms");
    java.util.Date date = rs.getDate("date");
    .. display in html using out.print(....);
}
 % >
tell me i f you have problems
i've been doing it for 2 years now

>Does anyone know of a way to get a JSP server to conect with tables in Visual Fox Pro. I would assume there would be a jar file or some drivers needed to create the bridge between the server and Fox Pro. Any Ideas?
>
>I am using Apache Tomcat for a server by the way.
>
>Thanks
Use things, not people. Love people, not things
Previous
Reply
Map
View

Click here to load this message in the networking platform