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;
}
}