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 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123
| /*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package mongo;
/**
*
* @author help
*/
import java.awt.Component;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Array;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JFileChooser;
import org.json.simple.JSONObject;
public class json {
public static void main(String[] args) throws InstantiationException, SQLException, IOException
{
JSONObject obj = new JSONObject();
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (IllegalAccessException ex) {
Logger.getLogger(json.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(json.class.getName()).log(Level.SEVERE, null, ex);
}
Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/reseau_social","root","root");
System.out.println("->Connecting to a selected database...");
Statement stmt = connect.createStatement();
/*************************************commune*************************************************/
ResultSet rs1 = stmt.executeQuery( "select id_user,u.nom, u.prenom, u.email, u.mot_de_pass,u.id_commune from user as u " ) ;
ResultSetMetaData resultMeta = rs1.getMetaData();
/*
JFileChooser fileChooser = new JFileChooser();
fileChooser.setDialogTitle("Specify a file to save");
Component parentFrame = null;
int userSelection = fileChooser.showSaveDialog(parentFrame);
if (userSelection == JFileChooser.APPROVE_OPTION) {
File fileToSave = fileChooser.getSelectedFile();
System.out.println("Save as file: " + fileToSave.getAbsolutePath());
*/
File file =new File ("C:\\Users\\help\\Desktop\\user.json") ;
file.createNewFile();
FileWriter writer =new FileWriter(file);
while(rs1.next())
{
// for(int i = 1; i <= resultMeta.getColumnCount(); i++){
// System.out.println("le"+rs1.getObject(2).toString());
obj.put("id_user", rs1.getObject(1).toString()) ;
obj.put("nom", rs1.getObject(2).toString());
obj.put("prenom", rs1.getObject(3).toString()) ;
obj.put("email", rs1.getObject(4).toString());
obj.put("mot_de_pass", rs1.getObject(5).toString()) ;
obj.put("id_commune", rs1.getObject(6).toString());
//System.out.println(obj);
Object jsoncontent = obj;
System.out.println("le"+jsoncontent);
writer.write(jsoncontent.toString()+"\n");
writer.flush();
// writer.close();
} rs1.close();
/**************************************************adress*****************************************/
JSONObject obj1 = new JSONObject();
ResultSet rs2 = stmt.executeQuery( "select * from adress " ) ;
ResultSetMetaData resultMeta2 = rs2.getMetaData();
File file1 =new File ("C:\\Users\\help\\Desktop\\adress.json") ;
file.createNewFile();
FileWriter writer1 =new FileWriter(file1);
while(rs2.next())
{
obj1.put("id_adress", rs2.getObject(1).toString()) ; // for(int i = 1; i <= resultMeta.getColumnCount(); i++){
obj1.put("nom_adress", rs2.getObject(2).toString());
Object jsoncontent1 = obj1;
System.out.println("le"+jsoncontent1);
writer1.write(jsoncontent1.toString()+"\n");
writer1.flush();
} rs2.close(); // writer.close();
/*************************************commune****************************************************************/
JSONObject obj3 = new JSONObject();
ResultSet rs3 = stmt.executeQuery( "select * from commune " ) ;
ResultSetMetaData resultMeta3 = rs3.getMetaData();
File file3 =new File ("C:\\Users\\help\\Desktop\\commune.json") ;
file3.createNewFile();
FileWriter writer3 =new FileWriter(file3);
while(rs3.next())
{
obj3.put("id_commune", rs3.getObject(1).toString()) ; // for(int i = 1; i <= resultMeta.getColumnCount(); i++){
obj3.put("nom_commune", rs3.getObject(2).toString());
obj3.put("id_adress", rs3.getObject(3).toString());
Object jsoncontent3 = obj3;
System.out.println("le"+jsoncontent3);
writer3.write(jsoncontent3.toString()+"\n");
writer3.flush();
} rs3.close(); // writer.close();
}} |
Partager