Direct and Lower code:
1 Packagecom.learn.jdbc.chap08;2 3 Importjava.sql.Connection;4 ImportJava.sql.DatabaseMetaData;5 6 ImportCom.learn.jdbc.util.DbUtil;7 8 /**9 * Use meta-data Analysis database--use DatabaseMetaData to get basic information of databaseTen * @authorAdministrator One * A */ - Public classDemo1 { - the Public Static voidMain (string[] args)throwsException { -Dbutil Dbutil =Newdbutil (); -Connection con =Dbutil.getcon (); -DatabaseMetaData DMD = Con.getmetadata ();//get Meta Data +SYSTEM.OUT.PRINTLN ("Database name:" +dmd.getdatabaseproductname ()); -SYSTEM.OUT.PRINTLN ("Database version:" +dmd.getdatabasemajorversion () + "." +dmd.getdatabaseminorversion ()); + A at } -}
1 Packagecom.learn.jdbc.chap08;2 3 Importjava.sql.Connection;4 Importjava.sql.PreparedStatement;5 ImportJava.sql.ResultSetMetaData;6 7 ImportCom.learn.jdbc.util.DbUtil;8 9 /**Ten * Use meta-data Analysis database-use ResultSetMetaData to get information from ResultSet objects One * @authorAdministrator A * - */ - Public classDemo2 { the Public Static voidMain (string[] args)throwsException { -Dbutil Dbutil =Newdbutil (); -Connection con =Dbutil.getcon (); -String sql= "SELECT * from Sp_album_test"; +PreparedStatement pstmt =con.preparestatement (SQL); -ResultSetMetaData RSMD = Pstmt.getmetadata ();//get Meta Data + intnum = Rsmd.getcolumncount ();//get the total number of metadata columns ASYSTEM.OUT.PRINTLN ("Total" +num+ "column"); at for(inti = 1; I <= num; i++) { -System.out.println (Rsmd.getcolumnname (i) + "," +Rsmd.getcolumntypename (i)); - } - } - -}
Using metadata to analyze a database