Jump to content
JasperReports Library 7.0 is now available ×

john.ambat

Members
  • Posts

    1
  • Joined

  • Last visited

john.ambat's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. I am doing a student project using java swing/mysql and jasper reports. I did the follwing: 1. created a mysql database dis 2. created JDBC connection. 3.created a report , farmer_details, using jaspersoft ireport designer. 4.connected the report using the following java swing code using the following code i am getting the Jasper report(without passing parameters to sql query). ========================================================================= private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { try{ JasperDesign jd=JRXmlLoader.load("/home/john/NetBeansProjects/dis/reports/farmer_details.jrxml"); String sql="select * from farmers where farmer_id=1"; JRDesignQuery newQuery= new JRDesignQuery(); newQuery.setText(sql); jd.setQuery(newQuery); JasperReport jr=JasperCompileManager.compileReport(jd); JasperPrint jp=JasperFillManager.fillReport(jr, null, conn); JasperViewer.viewReport(jp); }catch(Exception e){ } } ============================================================================ 5. I would like to pass farmer_id as a parameter to the Jasper report from Java swing in the above listed code. please help me john simon
×
×
  • Create New...