StatementQuestion.java

/*
  required imports
*/
puclic class StatementQuestion {
  Connection cn;
  PreparedStatement ps;
  public StatementQuestion() throws ClassNotFoundException, SQLException{
    cn = DriverManager.getConnection("path", "user", "pass");
    ps = cn.prepareStatement("select `data` from table where id > ?");
  }
  public void printData(int id) throws SQLException {
    ps.setInt(1, id);
    ResultSet rs = ps.executeQuery();
    while(rs.next()) {
      System.out.prinlnt(rs.getInt("data"));
    }
    rs.close();
  }
  public void kill() throws SQLException{
    ps.close();
    cn.close();
  }
}
    

//Usage:
StatementQuestion sq = new StatementQuestion();
sq.printData(5);
sq.printData(10);
sq.kill();