Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package fr.bastiencedric.window;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.ResultSetMetaData;
- public class Main {
- public static void main(String[] args) {
- try {
- String url = "jdbc:mysql://localhost:3306/mrbs";
- String user = "root";
- String passwd = "";
- Connection conn = DriverManager.getConnection(url, user, passwd);
- System.out.println("Connexion effectuée ");
- java.sql.Statement state = conn.createStatement();
- ResultSet result = state.executeQuery("SELECT * FROM mrbs_users");
- //On récupère les MetaData
- ResultSetMetaData resultMeta = result.getMetaData();
- System.out.println("il y a"+resultMeta.getColumnCount()+"\n colonnes dans cette table ");
- System.out.println("\n**********************************");
- //On affiche le nom des colonnes
- for(int i = 1; i <= resultMeta.getColumnCount(); i++)
- System.out.print("\t" + resultMeta.getColumnName(i).toUpperCase() + "\t *");
- System.out.println("\n**********************************");
- while(result.next()){// La méthode next() permet de positionner l'objet sur la ligne suivante de la liste de résultats
- for(int i = 1; i <= resultMeta.getColumnCount(); i++)
- System.out.print("\t" + result.getObject(i).toString() + "\t |");
- System.out.println("\n---------------------------------");
- }
- result.close();
- state.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement