[6288] in java-interest
java-odbc
daemon@ATHENA.MIT.EDU (VijayMukhi@EWORLD.COM)
Thu Mar 28 15:51:02 1996
Date: Thu, 21 Mar 1996 04:03:13 -0800
Reply-To: Java Interest <JAVA-INTEREST@JAVASOFT.COM>
From: VijayMukhi@EWORLD.COM
To: Multiple recipients of list JAVA-INTEREST
<JAVA-INTEREST@JAVASOFT.COM>
--PART.BOUNDARY.0.499.hp1.online.apple.com.827409790
Content-ID: <0_499_827409790@hp1.online.apple.com.9734>
Content-type: text/plain
To
Java Programmers,
Here are some odbc programs which we have tried out on Windows'95 platform
using C-SDK and JDK.
Visit our site at
http://www.neca.com/~vmis
Please send us your feedback and your suggestions on Java and ODBC.
If you know of sites having Java - ODBC , please tell me about it.
Email me at
vijaymukhi@eworld.com
vmukhi@giasbm01.vsnl.net.in.
Regards,
Vijay Mukhi
--PART.BOUNDARY.0.499.hp1.online.apple.com.827409790
Content-ID: <0_499_827409790@hp1.online.apple.com.9735>
Content-type: text/plain;
name="jodbc.txt"
Content-Transfer-Encoding: quoted-printable
Accessing the Databases from Java
The ODBC programs were tried out in 'C'. We have used Visual C++ (2.1) an=
d created the 'C' application programs (ODBC - 32bit). =
The same programs have been tried out from JAVA. For the java programs we=
have =
=A5 Downloaded the jetconnect software (jetbeta.zip )from http://www.xdb.=
com . (We have worked on Windows '95 platform.)
=A5 Create a directory say aaa and being in it unzip first the jetbeta.zi=
p and thereafter only the jetconnect.zip file . =
=A5set CLASSPATH=3D; =
=A5The java\bin directory should be in the path.
o1.c =
#include <windows.h>
#include <sqlext.h>
int r;
char aa[100];
void * e;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
DbEnv e;
try
{
e =3D DbEnv.SQLAllocEnv();
System.out.println("SQLAllocEnv..."+e);
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
}
}
o2.c =
#include <windows.h>
#include <sqlext.h>
int r;
char aa[100];
void * e;
void * c;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
r=3DSQLAllocConnect(e,&c);
sprintf(aa,"r=3D%d..c=3D%p",r,c) ;
MessageBox(0,aa,"SQLAllocConnect",0);
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
DbEnv e;
DbDbc c;
try
{
e =3D DbEnv.SQLAllocEnv();
System.out.println("SQLAllocEnv..."+e);
c =3D e.SQLAllocConnect();
System.out.println("SQLAllocConnect..."+c);
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
}
}
o3.c =
#include <windows.h>
#include <sql.h>
#include <sqlext.h>
int r;
char aa[100];
void * e;
void * c;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
r=3DSQLAllocConnect(e,&c);
sprintf(aa,"r=3D%d..c=3D%p",r,c) ;
MessageBox(0,aa,"SQLAllocConnect",0);
r=3DSQLConnect(c,"saccess",-3,"",0,"",0);
sprintf(aa,"r=3D%d..",r) ;
MessageBox(0,aa,"SQLConnect",0);
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
boolean i;
DbEnv e;
DbDbc c;
try
{
e =3D DbEnv.SQLAllocEnv();
System.out.println("SQLAllocEnv..."+e);
c =3D e.SQLAllocConnect();
System.out.println("SQLAllocConnect..."+c);
i=3Dc.SQLConnect("sdbase","","");
System.out.println("SQLConnect..."+i);
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
}
}
o4.c =
#include <windows.h>
#include <sqlext.h>
#include <sql.h>
int r,len,len2;
char aa[100],bb[255],ee[512];
void * e;
void * c;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
r=3DSQLAllocConnect(e,&c);
sprintf(aa,"r=3D%d..c=3D%p",r,c) ;
MessageBox(0,aa,"SQLAllocConnect",0);
r=3DSQLDataSources(e,SQL_FETCH_FIRST,bb,255,&len,ee,512,&len2);
sprintf(aa,"r=3D%d bb =3D %s len =3D %d ee =3D %s len2 =3D %d",r,bb,len,=
ee,len2);
MessageBox(0,aa,"SQLDataSources",0);
while((SQLDataSources(e,SQL_FETCH_NEXT,bb,255,&len,ee,512,&len2))!=3DSQL=
_NO_DATA_FOUND)
{
sprintf(aa,"r=3D%d bb =3D %s len =3D %d ee =3D %s len2 =3D %d",r,bb,len=
,ee,len2);
MessageBox(0,aa,"SQLDataSources",0);
}
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
DbEnv e;
DbDbc c;
String g;
DbDataSource d;
try
{
e =3D DbEnv.SQLAllocEnv();
System.out.println("SQLAllocEnv..."+e);
c =3D e.SQLAllocConnect();
System.out.println("SQLAllocConnect..."+c);
d=3De.SQLDataSources(Db.SQL_FETCH_FIRST);
g=3Dd.getDSN();
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
System.out.println("Data Source Name..."+g);
d=3De.SQLDataSources(Db.SQL_FETCH_NEXT);
while(d !=3D null)
{
g=3Dd.getDSN();
System.out.println("Data Source Name..."+g);
d=3De.SQLDataSources(Db.SQL_FETCH_NEXT);
}
}
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
DbEnv e;
DbDbc c;
String g;
String h;
DbDataSource d;
try
{
e =3D DbEnv.SQLAllocEnv();
System.out.println("SQLAllocEnv..."+e);
c =3D e.SQLAllocConnect();
System.out.println("SQLAllocConnect..."+c);
d=3De.SQLDataSources(Db.SQL_FETCH_FIRST);
g=3Dd.getDSN();
h=3Dd.getDescription();
System.out.println("Data Source Name..."+g);
System.out.println("Data Source Description..."+h);
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
d=3De.SQLDataSources(Db.SQL_FETCH_NEXT);
while(d !=3D null)
{
g=3Dd.getDSN();
h=3Dd.getDescription();
System.out.println("Data Source Name..."+g);
System.out.println("Data Source Description..."+h);
d=3De.SQLDataSources(Db.SQL_FETCH_NEXT);
}
}
}
o5.c =
#include <windows.h>
#include <stdio.h>
#include <sqlext.h>
#include <sql.h>
int r,len,len2;
char aa[100],bb[255],cc[255];
void * e;
void * c;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
r=3DSQLAllocConnect(e,&c);
sprintf(aa,"r=3D%d..c=3D%p",r,c) ;
MessageBox(0,aa,"SQLAllocConnect",0);
r=3DSQLDrivers(e,SQL_FETCH_FIRST,bb,255,&len,cc,255,&len2);
sprintf(aa,"r=3D%d bb =3D %s len =3D %d cc =3D %s len2 =3D %d",r,bb,len,=
cc,len2);
MessageBox(0,aa,"SQLDrivers",0);
while((SQLDrivers(e,SQL_FETCH_NEXT,bb,255,&len,cc,255,&len2))!=3DSQL_NO_=
DATA_FOUND)
{
sprintf(aa,"r=3D%d bb =3D %s len =3D %d cc =3D %s len2 =3D %d",r,bb,len,=
cc,len2);
MessageBox(0,aa,"SQLDrivers",0);
}
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
DbEnv e;
DbDbc c;
String g;
String h;
DbDriver d;
try
{
e =3D DbEnv.SQLAllocEnv();
System.out.println("SQLAllocEnv..."+e);
c =3D e.SQLAllocConnect();
System.out.println("SQLAllocConnect..."+c);
d=3De.SQLDrivers(Db.SQL_FETCH_FIRST);
g=3Dd.getDriverDesc();
h=3Dd.getDriverAttributes();
System.out.println("Driver Description..."+g);
System.out.println("Driver Attributes..."+h);
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
d=3De.SQLDrivers(Db.SQL_FETCH_NEXT);
while(d !=3D null)
{
g=3Dd.getDriverDesc();
h=3Dd.getDriverAttributes();
System.out.println("Driver Description..."+g);
System.out.println("Driver Attributes..."+h);
d=3De.SQLDrivers(Db.SQL_FETCH_NEXT);
}
}
}
o6.c =
#include <windows.h>
#include <sqlext.h>
#include <sql.h>
int r;
char aa[100];
void * e;
void * c;
void * s;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
r=3DSQLAllocConnect(e,&c);
sprintf(aa,"r=3D%d..c=3D%p",r,c) ;
MessageBox(0,aa,"SQLAllocConnect",0);
r=3DSQLConnect(c,"saccess",-3,"",-3,"",-3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLConnect",0);
r =3D SQLAllocStmt(c, &s);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLAllocStmt",0);
r =3D SQLExecDirect(s,"Create table aaa ( vno number ,name char (20))", -=
3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLExecDirect",0);
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
DbChar aa;
DbEnv e;
DbDbc c;
DbStmt s;
boolean a;
try
{
e =3D DbEnv.SQLAllocEnv();
c=3De.SQLAllocConnect();
c.SQLConnect("saccess","","");
s =3D c.SQLAllocStmt();
a =3D s.SQLExecDirect("Create table ccc ( vno number ,name char (20))"=
);
System.out.println("Table created ..."+a);
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
}
}
o7.c =
#include <windows.h>
#include <sqlext.h>
#include <sql.h>
int r,ncols, ii,jj, len,err_code,len1,len2,len3;
char aa[100],bb[255],cc[512];
void * e;
void * c;
void * s;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
r=3DSQLAllocConnect(e,&c);
sprintf(aa,"r=3D%d..c=3D%p",r,c) ;
MessageBox(0,aa,"SQLAllocConnect",0);
r=3DSQLConnect(c,"saccess",-3,"",-3,"",-3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLConnect",0);
r =3D SQLAllocStmt(c, &s);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLAllocStmt",0);
r =3D SQLExecDirect(s,"Insert into aaa values( 1001 ,'aaaa')", -3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLExecDirect",0);
r =3D SQLExecDirect(s,"Insert into aaa values( 1002 ,'bbbb')", -3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLExecDirect",0);
r =3D SQLExecDirect(s,"Insert into aaa values( 1003 ,'cccc')", -3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLExecDirect",0);
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
DbChar aa;
DbEnv e;
DbDbc c;
DbStmt s;
boolean a;
try
{
e =3D DbEnv.SQLAllocEnv();
c=3De.SQLAllocConnect();
c.SQLConnect("saccess","","");
s =3D c.SQLAllocStmt();
a =3D s.SQLExecDirect("Insert into bbb values( 1001 ,'aaaa')");
System.out.println("Insert record ..."+a);
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
}
}
o8.c =
#include <windows.h>
#include <stdio.h>
#include <sqlext.h>
#include <sql.h>
int r,ncols, ii,jj, len,err_code,len1,len2,len3;
char aa[100],bb[255],cc[512];
void * e;
void * c;
void * s;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
r=3DSQLAllocConnect(e,&c);
sprintf(aa,"r=3D%d..c=3D%p",r,c) ;
MessageBox(0,aa,"SQLAllocConnect",0);
r=3DSQLConnect(c,"saccess",-3,"",-3,"",-3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLConnect",0);
r =3D SQLAllocStmt(c, &s);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLAllocStmt",0);
r =3D SQLExecDirect(s,"Select * from aaa", -3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLExecDirect",0);
while (SQLFetch(s) !=3D SQL_NO_DATA_FOUND)
{
r =3D SQLGetData(s, 1,SQL_C_CHAR, aa,100, &len);
r =3D SQLGetData(s, 2,SQL_C_CHAR, bb,100, &len);
MessageBox(0,aa,bb,0);
}
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
DbChar aa,bb;
DbEnv e;
DbDbc c;
DbStmt s;
boolean a;
aa =3D new DbChar(100);
bb =3D new DbChar(100);
try
{
e =3D DbEnv.SQLAllocEnv();
c=3De.SQLAllocConnect();
c.SQLConnect("saccess","","");
s =3D c.SQLAllocStmt();
a =3D s.SQLExecDirect("Select * from bbb");
System.out.println("Select..."+a);
while (s.SQLFetch())
{
s.SQLGetData(1,aa);
s.SQLGetData(2,bb);
System.out.println("aa ..." + aa);
System.out.println("bb ...." + bb); =
}
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
}
}
o9.c =
#include <windows.h>
#include <sqlext.h>
#include <sql.h>
int r,n;
char aa[100];
void * e;
void * c;
void * s;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
r=3DSQLAllocConnect(e,&c);
sprintf(aa,"r=3D%d..c=3D%p",r,c) ;
MessageBox(0,aa,"SQLAllocConnect",0);
r=3DSQLConnect(c,"saccess",-3,"",-3,"",-3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLConnect",0);
r=3DSQLAllocStmt(c,&s);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLConnect",0);
r=3DSQLExecDirect(s,"Select * from aaa",-3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLExecDirect",0);
r=3DSQLNumResultCols(s,&n);
sprintf(aa,"Number of cols=3D%d ",n);
MessageBox(0,aa,"SQLNumCols",0);
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
int n;
DbEnv e;
DbDbc c;
DbStmt s;
try
{
e =3D DbEnv.SQLAllocEnv();
c =3D e.SQLAllocConnect();
c.SQLConnect("saccess","","");
s =3D c.SQLAllocStmt();
s.SQLExecDirect("Select * from aaa");
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
n=3Ds.SQLNumResultCols().intValue();
System.out.println("Number of columns"+ n);
}
}
o10.c =
#include <windows.h>
#include <sqlext.h>
#include <sql.h>
int r,n, ii, len;
char aa[100],bb[255],cc[512];
void * e;
void * c;
void * s;
int _stdcall WinMain(void * i, void * j, char * k, int l)
{
r=3DSQLAllocEnv(&e);
sprintf(aa,"r=3D%d..e=3D%p",r,e) ;
MessageBox(0,aa,"SQLAllocEnv",0);
r=3DSQLAllocConnect(e,&c);
sprintf(aa,"r=3D%d..c=3D%p",r,c) ;
MessageBox(0,aa,"SQLAllocConnect",0);
r=3DSQLConnect(c,"saccess",-3,"",-3,"",-3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLConnect",0);
r =3D SQLAllocStmt(c, &s);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLAllocStmt",0);
r =3D SQLExecDirect(s,"Select * from aaa", -3);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLExecDirect",0);
r =3D SQLNumResultCols(s,&n);
sprintf(aa,"r=3D%d ",r);
MessageBox(0,aa,"SQLExecDirect",0);
while (SQLFetch(s) !=3D SQL_NO_DATA_FOUND)
{
for( ii =3D 1; ii <=3D n ; ii++)
{
r =3D SQLGetData(s, ii,SQL_C_CHAR, aa,100, &len);
MessageBox(0,aa,"SQLGetData",0);
}
}
}
zzz.java
import jet.connect.*;
import java.applet.*;
public class zzz extends Applet
{
public void init()
{
DbChar aa;
DbEnv e;
DbDbc c;
DbStmt s;
boolean a;
int n, ii;
aa =3D new DbChar(100);
try
{
e =3D DbEnv.SQLAllocEnv();
c=3De.SQLAllocConnect();
c.SQLConnect("saccess","","");
s =3D c.SQLAllocStmt();
a =3D s.SQLExecDirect("Select * from bbb");
System.out.println("Select..."+a);
n=3Ds.SQLNumResultCols().intValue();
System.out.println("Number of columns .."+n);
while (s.SQLFetch())
{
for( ii =3D 1; ii <=3D n; ii++)
{
s.SQLGetData(ii,aa);
System.out.println("aa ..." + aa);
}
}
}
catch(DbSqlException x)
{
System.out.println(x.getErrorMsg());
return;
}
}
}
Take a coffee break and pass by our Java pageor you can move on to the =
next program in which we have =
used all the above syntaxes and developed a mini-interface for the databa=
ses. =
Spare us a minute and fling your comments, feedback, suggestions et al t=
o us right offhand...Write to us at
vmukhi@giasbm01.vsnl.net.in or
vijaymukhi@eworld.com =
Vijay Mukhi's Computer Institute =
B-13, Everest Building, Tardeo, Bombay 400 034, India. =
http://www.neca.com/~vmis =
e-mail : vmukhi@giasbm01.vsnl.net.in=
--PART.BOUNDARY.0.499.hp1.online.apple.com.827409790--
-----
This message has been forwarded via the JAVA-INTEREST
mailing list. In order to unsubscribe from this list, send a message to
listserv@javasoft.com with the command 'signoff JAVA-INTEREST' in
the message body (not in the subject line).
-----
This message has been forwarded via the JAVA-INTEREST
mailing list. In order to unsubscribe from this list, send a message to
listserv@javasoft.com with the command 'signoff JAVA-INTEREST' in
the message body (not in the subject line).
