import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
public class TestJdbc {
/**
* @param args
*/
public static void main(String[] args) throws Exception{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("url", "root", "pwd");
TestJdbc tj=new TestJdbc();
tj.query(conn, null);
//stm2.executeQuery("describe ")
}
private void query(Connection conn,String sql)throws Exception{
Statement stm=conn.createStatement();
ResultSet rs=stm.executeQuery("show tables");
ResultSetMetaData rsd=rs.getMetaData();
int colN=rsd.getColumnCount();
while(rs.next()){
for(int i=0;i
String colName=rsd.getColumnLabel(i+1);
String tabName=rs.getString(colName);
System.out.println(colName+":"+tabName);
//queryCol(conn,"describe "+tabName);
queryCol(conn,"show full fields from "+tabName+"");
}
}
}
private void queryCol(Connection conn,String sql)throws Exception{
Statement stm=conn.createStatement();
ResultSet rs=stm.executeQuery(sql);
ResultSetMetaData rsd=rs.getMetaData();
int colN=rsd.getColumnCount();
while(rs.next()){
for(int i=0;i
String colName=rsd.getColumnLabel(i+1);
String tabName=rs.getString(colName);
System.out.print(colName+":"+tabName+" ");
}
System.out.println();
}
System.out.println();
}
}
评论:
提交