把数据库文件变成XML文件

来源：互联网发布：武汉java培训机构名单编辑：程序博客网时间：2024/05/01 22:28

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();
       }



    }

}