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
|
try {
Connection connection = null;
String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
String serverName = "10.133.0.25";
String portNumber = "1521";
String sid = "fin";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber +":" + sid;
String username = "DEVRTO";
String password = "DEVRTO";
connection = DriverManager.getConnection(url, username, password);
Statement instruction = connection.createStatement();
String sql = " select exercice,cloture from exercice ";
String année ="";
ResultSet resultat1 = instruction.executeQuery(sql);
while (resultat1 .next()) {
année = resultat1.getString("cloture");
if (année.equals("non"))
{
JOptionPane ddd = new JOptionPane();
ddd.showMessageDialog(null,"<html><font color=#0033FF>doit cloture avant la creation " ,"ERREUR",JOptionPane.INFORMATION_MESSAGE);
break;
}
}
}
catch (ClassNotFoundException e1) {
e1.printStackTrace();
} catch(SQLException sqle){
JOptionPane ddd = new JOptionPane();
ddd.showMessageDialog(null, "<html><font color=#0033FF>"+sqle.getMessage()+" " ,"ERREUR",JOptionPane.INFORMATION_MESSAGE);
} |
Partager