package mydata;
import java.sql.*;
public class dbconn
{
string sdbdriver="sun.jdbc.odbc.jdbcodbcdriver";
string sconnstr="jdbc:odbc:javadatatest";
connection conn=null;
resultset rs=null;
public dbconn()
{
try{
class.forname(sdbdriver);
}
catch(java.lang.classnotfoundexception e)
{
system.err.println(e.getmessage());
e.printstacktrace();
}
}
public resultset EXECutequery(string squery)
{
try{
conn=drivermanager.getconnection(sconnstr);
statement stmt=conn.createstatement();
rs=stmt.EXECutequery(squery);
}
catch(sqlexception e)
{
system.err.println(e.getmessage());
e.printstacktrace();
}
return rs;
}
public int EXECuteupdate(string squery)
{
int result=0;
try{
conn=drivermanager.getconnnetion(sconnstr);
statement stmt=conn.createstatement();
result=stmt.EXECuteupdate(squery);
}
catch(sqlexception e)
{
system.err.println(e.getmessage());
}
return result;
}
}