import dori.jasper.engine.*;
import dori.jasper.engine.util.*;
import java.sql.*;
import java.util.*;
import dori.jasper.engine.JasperReport;
import java.util.Date;
import java.text.SimpleDateFormat;
import dori.jasper.view.*;
import org.apache.commons.logging.LogFactory;
import com.lowagie.text.DocumentException;
import com.lowagie.text.*;
import dori.jasper.engine.design.*;
import org.apache.commons.digester.Digester;
import org.apache.commons.beanutils.BeanUtils;
public class myreport
{
public void reportName(String strBbmc)
{
JRResultSetDataSource jrds = null;
JasperPrint jasperPrint = null;
Map reportParams = new HashMap();
ResultSet rs = null;
Connection con = null;
Statement stmt = null;
String sql = "select * from bbmc";
try
{
//動態獲取
JasperDesign jasperDesign = JasperManager.loadXmlDesign("./bbmc.jrxml");
JasperReport jasperreport = JasperManager.compileReport(jasperDesign);
//建立連接
ConnectionpoolManager mgr = new ConnectionpoolManager();
mgr.setMonitorThread(520);
mgr.addAlias("jdbcConnecpool","com.microsoft.jdbc.sqlserver.SQLServerDriver","jdbc:microsoft:sqlserver://192.168.45.233:1433;DatabaseName = ysgl ","sa","sa",10,300,520,30,false);
con = DriverManager.getConnection(ConnectionPoolManager.URL_PREFIX+ConnectionPoolManager.getPoolName(),null,null);
stmt = con.creatStatement();
rs = stmt.executeQuery(sql);
jrds = new JRResultSetDataSource(rs);
jasperPrint = JasperFillManager.fillReport(jasperReport,reportParams,jrds);
//調出JasperViewer進行打印預覽
JasperViewer.viewReport(jasperPrint);
}
catch(ClassNotFoundException ee)
{
ee.printStackTrace();
}
catch(SQLException ex)
{
ex.pritStackTrace;
}
catch(JRException e)
{
e.getMessage();
}
}
}