mysql语句---从创建到使用

1.

2.

3

4

5.

7.=============+========

8.

9.在java中查询表的列名和类型：

ResultSet rs; String sql= "select * from test";st = conn.prepareStatement(sql);rs= st.executeQuery();ResultSetMetaData tableData = rs.getMetaData();//i从1开始。不是从0for(int i=1; i<=tableData.getColumnCount(); i++) {//label是别名System.out.print( tableData.getColumnLabel(i) + "\t" );//那么列名System.out.print( tableData.getColumnName(i) + "\t" );//列的类型System.out.println( tableData.getColumnTypeName(i) );}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}