PackageThe ;Importjava.sql.Connection;ImportJava.sql.DriverManager;Importjava.sql.PreparedStatement;ImportJava.sql.ResultSet;Importjava.sql.Statement; Public classAa { Public Static voidMain (string[] args)throwsException {String a= "Lianxi";//What database to selectstring[] Q =Newstring[100]; String[] W=Newstring[100]; intT=0; Class.forName ("Com.mysql.jdbc.Driver"); Connection AA= Drivermanager.getconnection ("jdbc:mysql:///" + A + "", "Root", ""); Statement FF=aa.createstatement (); Statement QQ=aa.createstatement (); Statement www=aa.createstatement (); ResultSet g= Ff.executequery ("Show tables");//query How many tables are in this database while(G.next ()) {System.out.println (g.getstring (1)); Q[t]=g.getstring (1);//Assigning a table name to an arrayResultSet u=qq.executequery ("DESC" +q[t]+ "");//look up the columns of this table in an array intL=0; while(U.next ()) {w[l++]=u.getstring (1);//gets the number of columns for this table} ResultSet y=www.executequery ("SELECT * from" +q[t++]+ "");//querying data for this table while(Y.next ()) {//get this table data for(inti = 1; i < l+1; i++) {//The value of the column is the terminating line, to print! System.out.print (y.getstring (i)+ "\ T"); } System.out.println (); }} g.close (); Ff.close (); Aa.close (); }}
Java implementation queries all tabular data in the database