stocker resultat d'un select
bonjour a tous.
je voudrais pouvoir stocker le resultat d'une requete dans un fichier text mais je n'y arrive pas je travaille avec java.
voici le code :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
psRequete=connection.prepareStatement(requete,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
//requete est la variable qui contient mon select
resRequete =psRequete.executeQuery();
if(resRequete.first()){
FileOutputStream fos = new FileOutputStream("c://fichier.txt");
fos.close();
BufferedWriter scriptlist=new BufferedWriter(new FileWriter(liste[count]));
PrintWriter p=new PrintWriter(scriptlist);
// voici la ou je charge le fichier txt
do{ p.println(resRequete.getString("arretN.age")+"|"+resRequete.getString("dev")+"|"+
resRequete.getString("ncp")+"|"+resRequete.getString("clc")+"|"+resRequete.getString("nom[1,20]")+"|"+
resRequete.getString("pre[1,15]")+"|"+resRequete.getString("dco")+"|"+resRequete.getString("ddm")+"|"+
resRequete.getString("arr")+"|"+resRequete.getString("sde")+"|"+resRequete.getString("arretN.aut")+"|"+
resRequete.getString("mvtcm")+"|"+resRequete.getString("mvtcm_1")+"|"+resRequete.getString("mvtcm_2")+"|"+
resRequete.getString("mvtdm")+"|"+resRequete.getString("mvtdm_1")+"|"+resRequete.getString("mvtdm_2")+"|"+
resRequete.getString("agiom_1")+"|"+resRequete.getString("agiom_2")+"|"+resRequete.getString("ges")+"|"+
resRequete.getString("lib1"));
}while(resRequete.next());
} |
voici l'erreur console :
Code:
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
| java.sql.SQLException: No such column name
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxResultSet.findColumn(IfxResultSet.java:615)
at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java:756)
at logiquemetier.Traitement_scriptsql.processquerystat(Traitement_scriptsql.java:276)
at mainpackage.ArreteFrame.actionPerformed(ArreteFrame.java:303)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source) |
