package database;
import java.sql.*;
public class sqlbean {
public String query_statement;
public ResultSet result=null;
public Connection conn;

public void setQuerystatement(String query_statement)
{
    this.query_statement=query_statement;
}

public void setConnection(String driverName ,String jdbcURL,
     String username,String passwd) throws Exception
{
    Connection conn1;
    Class.forName(driverName);
    conn1=DriverManager.getConnection(jdbcURL, username, passwd);
    conn1.setAutoCommit(false);
    this.conn = conn1;
}

public ResultSet getResult()
{
    try
    {
     PreparedStatement select_stm=conn.prepareStatement(query_statement,
       java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
     result=select_stm.executeQuery();
    }
    catch(Exception e)
    {
     System.out.println(e);
    }
    return result;
}
}