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
| import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
public class Conn{
public static void main(String[] args){
Connection laConnection;
Statement transmission;
ResultSet leResultat;
try
{
Class.forName("com.mysql.jdbc.Driver");
laConnection = (Connection) DriverManager.getConnection("jdbc:mysql://localhost/application","****","****");
transmission= (Statement) laConnection.createStatement();
leResultat = transmission.executeQuery("select * from produit");
while(leResultat.next())
System.out.println("Id_prod: "+leResultat.getInt("Id_Prod")+"designation: "
+leResultat.getString("designation")+"quantite: "+leResultat.getInt("quantite"));
}
catch
(Exception e)
{
System.out.print("impossible de se connecter à la base");
}
}
} |
Partager