把数据库文件变成XML文件

最新推荐文章于 2023-06-16 09:03:16 发布

大真

最新推荐文章于 2023-06-16 09:03:16 发布

阅读量651

点赞数

文章标签：数据库 xml jdbc import null file

本文链接：https://blog.csdn.net/dazhen520/article/details/1518190

版权

package jdbc;
import java.io. * ;
import java.sql. * ;

public class DBDisplayXmlTest {

     public static void main(String[] args) {
        if (args.length == 0 )
           System.out.println( " 请您输入表名 " );
       Connection con = null ;
       Statement st = null ;
       ResultSet rs = null ;
        try {
            Class.forName( " org.gjt.mm.mysql.Driver " );
            con = DriverManager.getConnection( " jdbc:mysql://127.0.0.1:3309/test " , " root " , " root " );
            st = con.createStatement();
            String str = args[ 0 ];
            st.executeQuery( " select * from " + str);
            rs = st.getResultSet();
            ResultSetMetaData rmd = rs.getMetaData();
             int ii = rmd.getColumnCount();
            File file = new File( " E:/eclipse/JDBCTest/jdbc/ " + args[ 0 ] + " s.xml " );
            BufferedWriter bw = new BufferedWriter( new OutputStreamWriter( new FileOutputStream(file)));
            PrintWriter pw = new PrintWriter(bw);
            System.out.println( " < " + args[ 0 ] + " s " + " > " );
            pw.println( " < " + args[ 0 ] + " s " + " > " );
              while (rs.next())
              {
                  System.out.println( " " + " < " + args[ 0 ] + " > " + " " );
                  pw.println( " " + " < " + args[ 0 ] + " > " + " " );
                   for ( int i = 1 ;i <= ii;i ++ )
                  {
                     int iii = rmd.getColumnType(i);
                      switch (iii)
                        {
                           case Types.INTEGER:System.out.println( " " + " " + " < " + rmd.getColumnName(i) + " > " + " " + rs.getInt(i) + " " + " </ " + rmd.getColumnName(i) + " > " );
                                             pw.println( " " + " " + " < " + rmd.getColumnName(i) + " > " + " " + rs.getInt(i) + " " + " </ " + rmd.getColumnName(i) + " > " );
                                              break ;
                           case Types.VARCHAR:System.out.println( " " + " " + " < " + rmd.getColumnName(i) + " > " + " " + rs.getString(i) + " " + " </ " + rmd.getColumnName(i) + " > " );
                                             pw.println( " " + " " + " < " + rmd.getColumnName(i) + " > " + " " + rs.getString(i) + " " + " </ " + rmd.getColumnName(i) + " > " );
                                              break ;
                           case Types.DOUBLE:System.out.println( " " + " " + " < " + rmd.getColumnName(i) + " > " + " " + rs.getDouble(i) + " " + " </ " + rmd.getColumnName(i) + " > " );
                                            pw.println( " " + " " + " < " + rmd.getColumnName(i) + " > " + " " + rs.getDouble(i) + " " + " </ " + rmd.getColumnName(i) + " > " );
                                             break ;
                        }
                  }
                 System.out.println( " " + " </ " + args[ 0 ] + " > " + " " );
                 pw.println( " " + " </ " + args[ 0 ] + " > " + " " );
                 pw.println();
              }
            System.out.println( " < " + args[ 0 ] + " s " + " /> " );
            pw.println( " </ " + args[ 0 ] + " s " + " > " );
            pw.close();
            bw.close();
        }
         catch (ClassNotFoundException e) {
        e.getMessage();
        e.printStackTrace();
       }
         catch (SQLException e) {
        e.getMessage();
        e.printStackTrace();
       }
         catch (FileNotFoundException e) {
            e.printStackTrace();
       }
         catch (IOException e) {
            e.printStackTrace();
       }



    }

}