package untitled1;
import java.sql.*;
public class jsp2bean {
private string sample = "start value";
string strdbdtiver="sun.jdbc.odbc.jdbcodbcdriver";
string strconn ="jdbc:odbc:unititled1";
connection conn=null;
resultset rs = null;
//access sample property
public string getsample() {
return sample;
}
//access sample property
public void setsample(string newvalue) {
if (newvalue!=null) {
sample = newvalue;
}
}
public jsp2bean(){
try{
class.forname(strdbdtiver);
}
catch(java.lang.classnotfoundexception e){
system.out.println("database open error : " + e.getmessage());
}
}
public resultset executequery(string strsql){
rs=null;
try{
conn = drivermanager.getconnection(strconn);
statement stmt = conn.createstatement();
rs= stmt.executequery(strsql);
}
catch(java.sql.sqlexception ex){
system.out.println("sql run error : " + ex.getmessage());
}
return rs;
}
}