public static JasperPrint generateRecapAdressesClients(Date dateDebut, Date dateFin) {
JasperPrint printImprCheques = new JasperPrint();
Connection conn = null;
long start = System.currentTimeMillis();
try {
Map<String, Object> paramFacture = new HashMap<String, Object>();
paramFacture.put("debut", dateDebut);
paramFacture.put("fin", dateFin);
org.hibernate.Session session = CEFXUtil.getSessionFactory().getCurrentSession();
SessionFactoryImplementor sfi = (SessionFactoryImplementor) session.getSessionFactory();
ConnectionProvider cp = sfi.getConnectionProvider();
conn = cp.getConnection();
printImprCheques =
JasperFillManager.fillReport("src/cefx/report/AdresseAnnee.jasper", paramFacture, conn);
} catch (Exception e) {
throw new RuntimeException("Impossible de générer le recap", e);
} finally {
// it's your responsibility to close the connection, don't forget it!
if (conn != null) {
try {
conn.close();
} catch (Exception e) {
}
}
}
return printImprCheques;
}
private void closeConnection() {
try {
if (statement != null) statement.close();
if (connection != null) {
JDBCExceptionReporter.logWarnings(connection.getWarnings());
connection.clearWarnings();
connectionProvider.closeConnection(connection);
connectionProvider.close();
}
} catch (Exception e) {
System.err.println("Could not close connection");
e.printStackTrace();
}
}
private void createConnection() throws SQLException {
connectionProvider = ConnectionProviderFactory.newConnectionProvider(properties);
connection = connectionProvider.getConnection();
if (!connection.getAutoCommit()) {
connection.commit();
connection.setAutoCommit(true);
}
}
public static JasperPrint generateFacture(Integer numFacture) {
Connection conn = null;
JasperPrint printFacture = new JasperPrint();
long start = System.currentTimeMillis();
try {
Map<String, Object> paramFacture = new HashMap<String, Object>();
paramFacture.put("num_commande", numFacture);
org.hibernate.Session session = CEFXUtil.getSessionFactory().getCurrentSession();
SessionFactoryImplementor sfi = (SessionFactoryImplementor) session.getSessionFactory();
ConnectionProvider cp = sfi.getConnectionProvider();
conn = cp.getConnection();
printFacture =
JasperFillManager.fillReport("src/cefx/report/FactureCE.jasper", paramFacture, conn);
// JasperPrint printBDC =
// JasperFillManager.fillReport("src/cefx/report/BonDeCommande.jasper", paramFacture, conn);
} catch (Exception e) {
throw new RuntimeException("Impossible de générer la Facture", e);
// COMMANDE ENREGISTREE MAIS NON IMPRIMEE
} finally {
// it's your responsibility to close the connection, don't forget it!
if (conn != null) {
try {
conn.close();
} catch (Exception e) {
}
}
}
return printFacture;
}
public void readFromDatabase(String catalog, String schema, Mapping mapping) {
this.connectionProvider = settings.getConnectionProvider();
try {
DatabaseCollector collector = readDatabaseSchema(catalog, schema);
createPersistentClasses(collector, mapping); // move this to a different step!
} catch (SQLException e) {
throw settings.getSQLExceptionConverter().convert(e, "Reading from database", null);
} finally {
if (connectionProvider != null) connectionProvider.close();
}
}
/**
* Execute the schema updates
*
* @param script print all DDL to the console
*/
public void execute(boolean script, boolean doUpdate, File out) {
log.info("Running hbm2ddl schema update");
Connection connection = null;
Statement stmt = null;
boolean autoCommitWasEnabled = true;
FileWriter writer = null;
if (script && out != null) {
try {
log.info("Creating filewriter to file : " + out.getAbsolutePath());
writer = new FileWriter(out);
} catch (IOException e) {
log.debug("IOException while creating filewriter");
log.debug(e);
}
}
exceptions.clear();
try {
DatabaseMetadata meta;
try {
log.info("fetching database metadata");
connection = connectionProvider.getConnection();
if (!connection.getAutoCommit()) {
connection.commit();
connection.setAutoCommit(true);
autoCommitWasEnabled = false;
}
meta = new DatabaseMetadata(connection, dialect);
stmt = connection.createStatement();
} catch (SQLException sqle) {
exceptions.add(sqle);
log.error("could not get database metadata", sqle);
throw sqle;
}
log.info("updating schema");
String[] createSQL = configuration.generateSchemaUpdateScript(dialect, meta);
for (int j = 0; j < createSQL.length; j++) {
final String sql = createSQL[j];
try {
if (script) {
System.out.println(sql);
if (writer != null) {
writer.write(sql + ";\n");
}
}
if (doUpdate) {
log.debug(sql);
stmt.executeUpdate(sql);
}
} catch (SQLException e) {
exceptions.add(e);
log.error("Unsuccessful: " + sql);
log.error(e.getMessage());
}
}
if (writer != null) {
writer.close();
}
log.info("schema update complete");
} catch (Exception e) {
exceptions.add(e);
log.error("could not complete schema update", e);
} finally {
try {
if (stmt != null) stmt.close();
if (!autoCommitWasEnabled) connection.setAutoCommit(false);
if (connection != null) connection.close();
if (connectionProvider != null) connectionProvider.close();
} catch (Exception e) {
exceptions.add(e);
log.error("Error closing connection", e);
}
}
}
