1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package fr.descartes.trombinoscope.tests;
import java.io.FileInputStream;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.dbunit.DBTestCase;
import org.dbunit.PropertiesBasedJdbcDatabaseTester;
import org.dbunit.dataset.IDataSet;
import org.dbunit.dataset.xml.FlatXmlDataSet;
/**
* Classe pour tester la base de données
* @author Leticia
*/
public class BDTests extends DBTestCase{
/*Pour etablir un systeme de log*/
final static Logger logger = Logger.getLogger("tests connexion BD");
@Override
protected IDataSet getDataSet() throws Exception {
return new FlatXmlDataSet(new FileInputStream("bd/dataset.xml"));
}
public void testConnexion(){
logger.log(Level.INFO, "Debut de tests de la connexion a la base de donnees");
System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_DRIVER_CLASS,
"com.mysql.jdbc.Driver");
logger.log(Level.INFO, "Driver OK");
System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_CONNECTION_URL,
"jdbc:mysql://localhost:5432/trombinoscopedata");
System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_USERNAME,
"root");
System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_PASSWORD,
"");
logger.log(Level.INFO, "Connection effective");
logger.log(Level.INFO, "Fin des tests de la connexion a la base de donnees");
}
} |
