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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
// ******************************************
// Code exemple test4Dconn.java
// par Bin Kobayashi
// ******************************************
import java.sql.*;
import java.util.Properties;
import java.text.Format;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.Date;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.io.*;
import java.util.regex.Pattern;
import java.util.regex.Matcher;
public class evenements
{
public static void main(String[] argv)
{
try
{
// préparation de la date
java.text.SimpleDateFormat formatermy = new java.text.SimpleDateFormat("yyyy-MM-dd");
java.text.SimpleDateFormat formater4d = new java.text.SimpleDateFormat("dd/MM/yyyy");
GregorianCalendar datedebut = new java.util.GregorianCalendar();
datedebut.ADD(Calendar.DAY_OF_YEAR, -30);
String startdatemy= formatermy.format(datedebut.getTime());
String startdate4d= formater4d.format(datedebut.getTime());
//connection à 4D
Properties props = new Properties();
props.setProperty("user","");
props.setProperty("password","");
Class.forName("com.fourd.jdbc.DriverImpl");
Driver driver = DriverManager.getDriver("jdbc:4d:127.0.0.1");
Connection conn4 = driver.connect("jdbc:4d:192.168.xxxx:xxxx", props);
// Création du fichier de sortie
FileOutputStream out;
PrintStream p;
out = new FileOutputStream("evenements.sql");
p = new PrintStream( out );
//Préparation de la requette sur 4D
PreparedStatement pstmt = conn4.prepareStatement("select Nr_evenement,personnel,Nr_equipement,date_evenement,code_evenement,magasin from Atelier_evenements where date_evenement>?");
//fromater la date de la requette
String aDateString = startdate4d;
SimpleDateFormat aFormatter = new SimpleDateFormat("dd/MM/yyyy");
Date aDate = aFormatter.parse(aDateString);
pstmt.setDate(1,new java.sql.Date(aDate.getTime()));
// executer la requette 4D
ResultSet rs4 = pstmt.executeQuery();
// Initialisation des chaines
String s1, s2,s3,s4,s5,s6,s7,s8,s9;
// enrichissement du ficher de sortie
p.println ("/*Mysql input file:evenements*/");
p.println ("delete from 4D_evenements where date_evenement>'"+startdatemy+"';" );
p.println("insert into 4D_evenements value ");
BOOLEAN first=true;
while(rs4.next())
{
s1 = rs4.getString("Nr_equipement");
s2 = rs4.getString("date_evenement");
s3 = rs4.getString("code_evenement");
s4 = rs4.getString("personnel");
s5 = rs4.getString("magasin");
s6 = rs4.getString("Nr_evenement");
// verifications sur les chaines
//IF (s6!=NULL) IF ( ! s6.matches("(\\d{4})-(\\d{2})-(\\d{2})")) s6="null";
//s2= s2.replaceAll("\\'","\\\\'");
//s1= s1.replaceAll(" ","_");
//ajouter la virgule
IF ( first==false)
{
p.println(",");
}
else
{
first=false;
}
p.println ("('"+s1+"','"+s2+ "','"+s3+"','"+s4+"','"+s5+"','"+s6+"')");
}
p.println (";");
conn4.close();
p.close();
} catch (Exception e) {System.out.println(e);}
}
} |
