package example;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class ConnexionBD
{
public static void main(String[] args)
{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String connectionString= null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
try
{connectionString ="jdbc:sqlserver:CSS;database=Bilan Prospectif";}
catch (Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}
conn = DriverManager.getConnection(connectionString);
stmt = conn.createStatement();
// ENTREPRISES SYNTHESE_ENTREPRISE MARCHE_SYNTHESE_ENTREPRISE
rs = stmt.executeQuery("SELECT MARCHE_SYNTHESE_ENTREPRISE FROM SYNTHESE_ENTREPRISE");
while (rs.next())
{
String contact = rs.getString("MARCHE_SYNTHESE_ENTREPRISE");
System.out.println(contact);
}
}
catch (Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
Partager