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
| /**
*
*/
import java.io.*;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import java.util.Vector;
import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;
/**
* @author Admin
*
*/
public class ExecSQL {
//public static Logger logger = Logger.getLogger(ExecSQL.class);
/**
* @param args
* @throws IOException
* @throws ClassNotFoundException
* @throws SQLException
*/
public static void main(String[] args) throws IOException, ClassNotFoundException, SQLException {
// TODO Auto-generated method stub
PropertyConfigurator.configure("properties/log4j.properties");
File prop = new File("properties/config.properties");
FileInputStream fis = new FileInputStream(prop);
Properties properties = new Properties();
properties.load(fis);
String dbUser = properties.getProperty("db.user");
String dbPassword = properties.getProperty("db.password");
String dbHost = properties.getProperty("db.host");
String dbPort = properties.getProperty("db.port");
String dbSid = properties.getProperty("db.sid");
//logger.debug("Arguments : "+args[0]);
SQLQuery query = new SQLQuery(args[0]);
// Connection
Class.forName("oracle.jdbc.driver.OracleDriver");
//Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@"+dbHost+":"+dbPort+":"+dbSid+"", dbUser, dbPassword);//Connexion pour le select
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@172.17.254.83:1521:INFABASE", "IS7FRWK", "IS7FRWK");//Connexion pour le select
System.out.println("dbUser : " + dbUser);
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT F_ID_FLUX, F_CODE_FLUX FROM FDCO_FLUX");
Vector toto = new Vector();
while(rs.next()){
System.out.print("RESULT : "+rs.getString(1));
System.out.println(" - RESULT : "+rs.getString(2));
toto.add("{"+rs.getString(2)+","+rs.getString(1)+"}");
}
st.close();
conn.close();
}
} |
Partager